Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.78 ms
(84.86%)
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
  6666
  108018
  321410
  384853
  387174
  391258
  395227
  396575
  396585
  396797
  397945
  398204
  398998
  399516
  410956
  411257
  416041
  418897
  419078
  424655
  428296
  428759
  428772
  431629
  432169
  435348
  436302
  443828
  444546
  448198
  449575
  451449
  454363
  455477
  456405
  456588
  457012
  457313
  458915
  459073
  459436
  459624
  459993
  460123
  461565
  462726
  463302
  465874
  471386
  471985
  473236
  473633
  474713
  475929
  477645
  479681
  479742
  481006
  483714
  484054
  487610
  488855
  489902
  490653
  496135
  496992
  500008
  500984
  502209
  508805
  510179
  512011
  514618
  516223
  516564
  517110
  517854
  518421
  521748
  523137
  526011
  527349
  528506
  538202
  542489
  546310
  552070
  552696
  554117
  558847
  559155
  562496
  562736
  562792
  568959
  569854
  570528
  570656
  572116
  574618
  580044
  583320
  586692
  595969
  598439
  600208
  600619
  600629
  601504
  603072
  610469
  610493
  650881
  650976
  654836
  655611
  664804
  735373
  813007
  814010
]
17.83 ms
(8.91%)
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
  436302
  456588
  459624
  496135
  559155
  562496
  518421
  384853
  395227
  391258
  396797
  431629
  418897
  455477
  457313
  459073
  474713
  517110
  523137
  479681
  562736
  574618
  387174
  397945
  398998
  449575
  459436
  463302
  396585
  435348
  477645
  479742
  443828
  461565
  465874
  471386
  473236
  411257
  462726
  489902
  490653
  516564
  512011
  475929
  481006
  500984
  459993
  471985
  521748
  526011
  814010
  568959
  650881
  664804
  655611
  546310
  554117
  580044
  601504
  610469
  610493
  600629
  600208
  600619
  735373
  813007
  496992
  6666
  432169
  586692
  595969
  321410
  456405
  444546
  517854
  514618
  399516
  419078
  428772
  424655
  428296
  428759
  448198
  487610
  460123
  508805
  502209
  516223
  451449
  458915
  473633
  454363
  488855
  528506
  527349
  538202
  500008
  510179
  558847
  598439
  396575
  398204
  410956
  484054
  552070
  569854
  570528
  570656
  583320
  552696
  654836
  572116
  108018
  416041
  542489
  562792
  650976
  603072
  483714
  457012
]
4.05 ms
(2.03%)
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
  6666
  108018
  321410
  384853
  387174
  391258
  395227
  396575
  396585
  396797
  397945
  398204
  398998
  399516
  410956
  411257
  416041
  418897
  419078
  424655
  428296
  428759
  428772
  431629
  432169
  435348
  436302
  443828
  444546
  448198
  449575
  451449
  454363
  455477
  456405
  456588
  457012
  457313
  458915
  459073
  459436
  459624
  459993
  460123
  461565
  462726
  463302
  465874
  471386
  471985
  473236
  473633
  474713
  475929
  477645
  479681
  479742
  481006
  483714
  484054
  487610
  488855
  489902
  490653
  496135
  496992
  500008
  500984
  502209
  508805
  510179
  512011
  514618
  516223
  516564
  517110
  517854
  518421
  521748
  523137
  526011
  527349
  528506
  538202
  542489
  546310
  552070
  552696
  554117
  558847
  559155
  562496
  562736
  562792
  568959
  569854
  570528
  570656
  572116
  574618
  580044
  583320
  586692
  595969
  598439
  600208
  600619
  600629
  601504
  603072
  610469
  610493
  650881
  650976
  654836
  655611
  664804
  735373
  813007
  814010
]
2.42 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.34 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "девки с большими членами"
]
1.85 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девк большой большие член"
]
1.80 ms
(0.90%)
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.