Query Metrics

7 Database Queries
7 Different statements
180.98 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
154.11 ms
(85.15%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  6937
  120432
  120497
  384762
  394136
  396730
  397808
  398651
  406406
  406933
  409862
  412725
  415005
  415963
  422330
  426557
  435225
  436314
  464857
  465613
  468603
  470053
  474294
  477618
  491606
  501541
  514145
  515506
  525679
  531283
  538818
  540056
  541377
  551202
  553722
  560952
  561807
  563870
  565491
  567122
  568034
  568068
  568210
  569894
  576590
  596198
  603603
  605850
  609899
  617031
  620196
  628258
  629194
  637133
  637721
  638585
  649105
  649536
  650039
  656804
  662042
  664781
  666858
  671660
  674452
  687432
  690450
  695908
  699624
  702162
  702268
  703973
  719022
  721302
  721443
  721876
  723167
  724169
  724366
  725146
  729644
  739460
  740373
  745341
  750187
  751585
  753638
  754512
  756719
  765302
  766910
  769747
  770541
  772804
  779711
  784740
  785051
  786454
  788133
  788826
  788859
  790069
  791572
  792175
  795893
  797178
  797505
  798495
  806676
  815053
  815137
  815168
  815495
  815606
  815774
  815991
  817276
  823092
  824864
  824915
]
15.66 ms
(8.65%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  474294
  551202
  721443
  637721
  772804
  786454
  409862
  435225
  468603
  514145
  525679
  491606
  384762
  815991
  815168
  540056
  531283
  719022
  560952
  406933
  394136
  815774
  815495
  538818
  568034
  568210
  569894
  666858
  703973
  721876
  638585
  596198
  779711
  795893
  754512
  120432
  477618
  662042
  725146
  769747
  398651
  120497
  815137
  823092
  561807
  553722
  541377
  649105
  674452
  687432
  690450
  656804
  671660
  699624
  723167
  567122
  605850
  620196
  603603
  609899
  628258
  788826
  791572
  792175
  788859
  790069
  729644
  740373
  797178
  797505
  750187
  751585
  765302
  766910
  724366
  739460
  753638
  770541
  745341
  756719
  617031
  784740
  798495
  515506
  470053
  568068
  695908
  702162
  637133
  788133
  785051
  6937
  396730
  406406
  412725
  815053
  824915
  815606
  817276
  824864
  501541
  563870
  649536
  650039
  664781
  576590
  806676
  724169
  629194
  702268
  721302
  397808
  415005
  426557
  415963
  464857
  565491
  422330
  436314
  465613
]
3.51 ms
(1.94%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  6937
  120432
  120497
  384762
  394136
  396730
  397808
  398651
  406406
  406933
  409862
  412725
  415005
  415963
  422330
  426557
  435225
  436314
  464857
  465613
  468603
  470053
  474294
  477618
  491606
  501541
  514145
  515506
  525679
  531283
  538818
  540056
  541377
  551202
  553722
  560952
  561807
  563870
  565491
  567122
  568034
  568068
  568210
  569894
  576590
  596198
  603603
  605850
  609899
  617031
  620196
  628258
  629194
  637133
  637721
  638585
  649105
  649536
  650039
  656804
  662042
  664781
  666858
  671660
  674452
  687432
  690450
  695908
  699624
  702162
  702268
  703973
  719022
  721302
  721443
  721876
  723167
  724169
  724366
  725146
  729644
  739460
  740373
  745341
  750187
  751585
  753638
  754512
  756719
  765302
  766910
  769747
  770541
  772804
  779711
  784740
  785051
  786454
  788133
  788826
  788859
  790069
  791572
  792175
  795893
  797178
  797505
  798495
  806676
  815053
  815137
  815168
  815495
  815606
  815774
  815991
  817276
  823092
  824864
  824915
]
2.44 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal sport"
]
2.02 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал спортивная"
]
1.52 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал спортивная"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.