Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.83 ms
(82.77%)
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
  96872
  327421
  383335
  383439
  385318
  391477
  395738
  398528
  402963
  411897
  417217
  421954
  422235
  424797
  425131
  430348
  438324
  439667
  442661
  443842
  443941
  445199
  450099
  450198
  454887
  455411
  462424
  464443
  464861
  465329
  466872
  467426
  468828
  470389
  470632
  472910
  476332
  479985
  484485
  484970
  486588
  489721
  490191
  490394
  490679
  491962
  493118
  494437
  502814
  502882
  503481
  504459
  505814
  506760
  509292
  511529
  512607
  514736
  515416
  517567
  518006
  518877
  519251
  521355
  521741
  523019
  523908
  524934
  525017
  525089
  526421
  526646
  530726
  533331
  538282
  539495
  542597
  545060
  545372
  546966
  549217
  549238
  550467
  552817
  563540
  579557
  580993
  602018
  615728
  616996
  617167
  620320
  628332
  634138
  652010
  668949
  688333
  700812
  709540
  714166
  717943
  718461
  724678
  726940
  731156
  733365
  734090
  743813
  745980
  755173
  761169
  764186
  782989
  792904
  793835
  796155
  797340
  802065
  802434
  804524
]
21.17 ms
(12.10%)
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
  422235
  464443
  796155
  411897
  438324
  96872
  518877
  688333
  530726
  472910
  398528
  505814
  443842
  494437
  542597
  430348
  503481
  490679
  563540
  439667
  443941
  465329
  417217
  450099
  782989
  709540
  402963
  620320
  602018
  518006
  391477
  462424
  761169
  764186
  395738
  484485
  519251
  524934
  425131
  476332
  652010
  484970
  634138
  517567
  525089
  455411
  579557
  792904
  383439
  468828
  525017
  526421
  489721
  668949
  552817
  486588
  442661
  539495
  580993
  745980
  755173
  504459
  424797
  464861
  514736
  327421
  515416
  545372
  523908
  454887
  802065
  726940
  797340
  445199
  538282
  717943
  724678
  731156
  466872
  502814
  526646
  521355
  421954
  615728
  470632
  512607
  470389
  549238
  743813
  628332
  546966
  523019
  700812
  617167
  493118
  550467
  714166
  718461
  549217
  802434
  734090
  733365
  616996
  383335
  450198
  533331
  793835
  804524
  502882
  545060
  385318
  490394
  490191
  511529
  506760
  491962
  509292
  521741
  467426
  479985
]
2.33 ms
(1.33%)
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
  96872
  327421
  383335
  383439
  385318
  391477
  395738
  398528
  402963
  411897
  417217
  421954
  422235
  424797
  425131
  430348
  438324
  439667
  442661
  443842
  443941
  445199
  450099
  450198
  454887
  455411
  462424
  464443
  464861
  465329
  466872
  467426
  468828
  470389
  470632
  472910
  476332
  479985
  484485
  484970
  486588
  489721
  490191
  490394
  490679
  491962
  493118
  494437
  502814
  502882
  503481
  504459
  505814
  506760
  509292
  511529
  512607
  514736
  515416
  517567
  518006
  518877
  519251
  521355
  521741
  523019
  523908
  524934
  525017
  525089
  526421
  526646
  530726
  533331
  538282
  539495
  542597
  545060
  545372
  546966
  549217
  549238
  550467
  552817
  563540
  579557
  580993
  602018
  615728
  616996
  617167
  620320
  628332
  634138
  652010
  668949
  688333
  700812
  709540
  714166
  717943
  718461
  724678
  726940
  731156
  733365
  734090
  743813
  745980
  755173
  761169
  764186
  782989
  792904
  793835
  796155
  797340
  802065
  802434
  804524
]
1.90 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелых ебут в рот"
]
1.84 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин секс в рот"
]
1.35 ms
(0.77%)
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.