Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.77 ms
(87.24%)
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
  70131
  188240
  191343
  233179
  311007
  369353
  382993
  385386
  385528
  385826
  385991
  386576
  387951
  388333
  390150
  390851
  391427
  391980
  393245
  396865
  398231
  398551
  398560
  398564
  398567
  407790
  409945
  411628
  411631
  411723
  411769
  411794
  429239
  443681
  444117
  448619
  450122
  450156
  450183
  451606
  452185
  454408
  455872
  459764
  462104
  466789
  466823
  466903
  466983
  467032
  467095
  467239
  469360
  469387
  472650
  472696
  474393
  474876
  475298
  477208
  477645
  480490
  485210
  488311
  491109
  499274
  500905
  500938
  502028
  503801
  506846
  507691
  508162
  510925
  514885
  515074
  515699
  517081
  517238
  517835
  525494
  526099
  529778
  539338
  540668
  544744
  545897
  551926
  554326
  554897
  559059
  559115
  561534
  563164
  579382
  581854
  588403
  599732
  599735
  603342
  603378
  614382
  618410
  624865
  643071
  664956
  665195
  667684
  724290
  738310
  738314
  738324
  739174
  743767
  745444
  760176
  781978
  788721
  794785
  812526
]
14.56 ms
(7.27%)
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
  738310
  739174
  738314
  745444
  724290
  743767
  409945
  70131
  191343
  398551
  467239
  469360
  485210
  448619
  451606
  452185
  474393
  454408
  472650
  603342
  387951
  472696
  233179
  466823
  474876
  391980
  411723
  429239
  398560
  411769
  500938
  529778
  467095
  385528
  382993
  388333
  391427
  398231
  444117
  450183
  466903
  455872
  503801
  499274
  554326
  581854
  588403
  393245
  477645
  450122
  475298
  517238
  385826
  385991
  390851
  396865
  398567
  488311
  510925
  540668
  526099
  507691
  551926
  545897
  579382
  664956
  665195
  667684
  643071
  599732
  599735
  781978
  788721
  812526
  760176
  738324
  794785
  398564
  385386
  390150
  491109
  411628
  443681
  515699
  563164
  517081
  559115
  386576
  188240
  311007
  369353
  411631
  411794
  450156
  459764
  466789
  480490
  525494
  539338
  517835
  502028
  506846
  500905
  508162
  514885
  515074
  462104
  466983
  467032
  469387
  477208
  544744
  561534
  554897
  559059
  624865
  603378
  614382
  618410
  407790
]
3.47 ms
(1.73%)
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
  70131
  188240
  191343
  233179
  311007
  369353
  382993
  385386
  385528
  385826
  385991
  386576
  387951
  388333
  390150
  390851
  391427
  391980
  393245
  396865
  398231
  398551
  398560
  398564
  398567
  407790
  409945
  411628
  411631
  411723
  411769
  411794
  429239
  443681
  444117
  448619
  450122
  450156
  450183
  451606
  452185
  454408
  455872
  459764
  462104
  466789
  466823
  466903
  466983
  467032
  467095
  467239
  469360
  469387
  472650
  472696
  474393
  474876
  475298
  477208
  477645
  480490
  485210
  488311
  491109
  499274
  500905
  500938
  502028
  503801
  506846
  507691
  508162
  510925
  514885
  515074
  515699
  517081
  517238
  517835
  525494
  526099
  529778
  539338
  540668
  544744
  545897
  551926
  554326
  554897
  559059
  559115
  561534
  563164
  579382
  581854
  588403
  599732
  599735
  603342
  603378
  614382
  618410
  624865
  643071
  664956
  665195
  667684
  724290
  738310
  738314
  738324
  739174
  743767
  745444
  760176
  781978
  788721
  794785
  812526
]
2.05 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старухи в порн"
]
2.02 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бабушк в порн"
]
1.79 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.