Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.69 ms
(81.31%)
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
  282542
  358410
  382942
  384310
  388578
  389593
  390827
  391289
  392999
  393407
  393581
  396079
  396190
  397807
  398901
  401807
  402439
  405411
  407516
  407570
  407765
  409597
  412521
  415468
  415875
  417062
  417548
  418046
  420174
  421377
  424258
  426395
  426682
  428114
  428840
  431390
  434674
  434906
  435638
  435744
  436020
  436335
  437302
  438576
  440880
  443915
  445256
  446934
  447612
  448321
  448710
  453504
  454406
  455715
  456004
  457912
  458101
  458370
  458478
  458594
  458663
  462770
  462979
  462983
  465157
  465446
  465873
  466258
  467791
  468175
  469106
  469783
  472860
  472960
  473800
  474802
  474817
  477477
  480365
  481000
  481088
  481263
  481509
  482031
  482573
  483815
  487860
  489014
  490541
  491159
  492373
  494896
  495276
  496046
  499388
  501334
  504240
  504411
  509159
  510110
  510474
  512424
  515688
  519122
  521650
  522517
  527618
  553992
  557670
  561679
  563299
  587865
  609958
  660389
  701516
  728308
  728371
  733287
  793701
  801065
]
17.94 ms
(11.99%)
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
  438576
  458478
  462770
  481263
  424258
  462983
  417062
  481000
  437302
  527618
  491159
  501334
  504240
  483815
  492373
  522517
  482573
  418046
  474817
  391289
  426395
  563299
  701516
  793701
  733287
  448710
  390827
  434674
  455715
  515688
  402439
  282542
  458663
  609958
  553992
  405411
  426682
  407765
  504411
  393407
  388578
  436020
  458594
  467791
  389593
  462979
  496046
  489014
  561679
  396190
  481509
  448321
  409597
  398901
  660389
  382942
  393581
  458101
  495276
  415468
  510110
  454406
  587865
  453504
  415875
  358410
  728371
  728308
  469106
  401807
  384310
  396079
  457912
  477477
  465157
  472860
  417548
  407570
  420174
  469783
  468175
  474802
  481088
  407516
  480365
  445256
  521650
  519122
  392999
  397807
  440880
  458370
  456004
  509159
  490541
  801065
  443915
  436335
  472960
  435638
  494896
  499388
  512424
  487860
  447612
  428114
  431390
  412521
  435744
  473800
  510474
  465446
  557670
  465873
  421377
  428840
  434906
  466258
  482031
  446934
]
2.49 ms
(1.66%)
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
  282542
  358410
  382942
  384310
  388578
  389593
  390827
  391289
  392999
  393407
  393581
  396079
  396190
  397807
  398901
  401807
  402439
  405411
  407516
  407570
  407765
  409597
  412521
  415468
  415875
  417062
  417548
  418046
  420174
  421377
  424258
  426395
  426682
  428114
  428840
  431390
  434674
  434906
  435638
  435744
  436020
  436335
  437302
  438576
  440880
  443915
  445256
  446934
  447612
  448321
  448710
  453504
  454406
  455715
  456004
  457912
  458101
  458370
  458478
  458594
  458663
  462770
  462979
  462983
  465157
  465446
  465873
  466258
  467791
  468175
  469106
  469783
  472860
  472960
  473800
  474802
  474817
  477477
  480365
  481000
  481088
  481263
  481509
  482031
  482573
  483815
  487860
  489014
  490541
  491159
  492373
  494896
  495276
  496046
  499388
  501334
  504240
  504411
  509159
  510110
  510474
  512424
  515688
  519122
  521650
  522517
  527618
  553992
  557670
  561679
  563299
  587865
  609958
  660389
  701516
  728308
  728371
  733287
  793701
  801065
]
2.14 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "попу парня"
]
1.87 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп парен"
]
1.79 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.17%)
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.