Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.37 ms
(85.19%)
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
  187851
  209664
  282481
  373768
  388537
  390360
  390776
  395707
  400990
  405687
  406982
  409165
  414342
  417682
  418952
  419565
  420358
  421833
  422909
  423503
  424219
  425499
  431643
  432997
  438067
  438852
  439256
  439601
  439653
  443092
  443716
  445828
  447327
  447337
  448840
  450338
  451149
  451266
  451756
  453877
  454802
  457248
  457469
  460046
  460451
  461312
  464719
  466841
  468110
  469472
  469612
  469751
  469756
  470175
  470198
  470745
  470985
  473507
  475916
  477366
  477875
  479095
  479684
  479738
  479816
  481926
  482383
  482916
  484620
  489309
  490897
  495421
  508200
  508883
  509636
  510884
  511810
  513334
  516078
  522020
  523740
  523975
  525679
  526833
  529998
  531105
  534636
  551268
  560902
  563438
  565479
  572238
  577513
  584105
  598178
  603775
  604298
  626179
  632283
  657776
  663929
  675589
  676088
  677676
  699526
  701222
  720582
  737082
  748242
  771339
  773346
  779903
  782148
  786276
  789197
  794699
  802549
  804461
  807953
  813257
]
17.68 ms
(8.89%)
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
  508883
  420358
  373768
  439601
  657776
  701222
  495421
  477875
  438067
  534636
  479684
  604298
  443092
  720582
  464719
  484620
  675589
  510884
  470175
  508200
  422909
  406982
  470198
  477366
  748242
  551268
  419565
  565479
  418952
  603775
  417682
  789197
  523975
  447337
  405687
  773346
  479095
  490897
  475916
  804461
  457469
  737082
  481926
  424219
  432997
  461312
  513334
  469472
  577513
  598178
  209664
  779903
  526833
  423503
  563438
  516078
  460046
  450338
  813257
  390360
  677676
  489309
  584105
  482916
  699526
  451266
  282481
  390776
  676088
  632283
  482383
  572238
  473507
  454802
  425499
  460451
  421833
  431643
  626179
  786276
  794699
  771339
  802549
  560902
  470985
  414342
  439256
  470745
  439653
  479816
  443716
  469756
  529998
  409165
  451149
  187851
  448840
  438852
  457248
  523740
  663929
  400990
  469612
  511810
  525679
  466841
  522020
  782148
  395707
  479738
  447327
  509636
  807953
  469751
  531105
  451756
  445828
  388537
  468110
  453877
]
4.06 ms
(2.04%)
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
  187851
  209664
  282481
  373768
  388537
  390360
  390776
  395707
  400990
  405687
  406982
  409165
  414342
  417682
  418952
  419565
  420358
  421833
  422909
  423503
  424219
  425499
  431643
  432997
  438067
  438852
  439256
  439601
  439653
  443092
  443716
  445828
  447327
  447337
  448840
  450338
  451149
  451266
  451756
  453877
  454802
  457248
  457469
  460046
  460451
  461312
  464719
  466841
  468110
  469472
  469612
  469751
  469756
  470175
  470198
  470745
  470985
  473507
  475916
  477366
  477875
  479095
  479684
  479738
  479816
  481926
  482383
  482916
  484620
  489309
  490897
  495421
  508200
  508883
  509636
  510884
  511810
  513334
  516078
  522020
  523740
  523975
  525679
  526833
  529998
  531105
  534636
  551268
  560902
  563438
  565479
  572238
  577513
  584105
  598178
  603775
  604298
  626179
  632283
  657776
  663929
  675589
  676088
  677676
  699526
  701222
  720582
  737082
  748242
  771339
  773346
  779903
  782148
  786276
  789197
  794699
  802549
  804461
  807953
  813257
]
2.15 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет парню дилдо"
]
2.07 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс парен дилд"
]
1.67 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.