Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.73 ms
(85.44%)
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
  87974
  88591
  154133
  154512
  154535
  154972
  290366
  340635
  375135
  382207
  384117
  384397
  387026
  389541
  391992
  392848
  395252
  398078
  401353
  401367
  402631
  412149
  412814
  416036
  416230
  416659
  416699
  416708
  419167
  427132
  437926
  442548
  453221
  467112
  467636
  469737
  471132
  476656
  478489
  483684
  485661
  487414
  490128
  491642
  498720
  499872
  505356
  506105
  511278
  513794
  516640
  524678
  526179
  530428
  530698
  531579
  531822
  531850
  531856
  535959
  540680
  547475
  552704
  561019
  562503
  567561
  569258
  574377
  575844
  576533
  580130
  580782
  580832
  581645
  585680
  586994
  587306
  589185
  609887
  609890
  616454
  656856
  660369
  660380
  666854
  670210
  670356
  671008
  671038
  672944
  672952
  705119
  707571
  712268
  718701
  718772
  734214
  748287
  752627
  752679
  752713
  782057
  788027
  788118
  788863
  788908
  791039
  792370
  792712
  796640
  796647
  796703
  798599
  799695
  803534
  806834
  807112
  807569
  810761
  811700
]
18.49 ms
(9.25%)
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
  792712
  806834
  290366
  416036
  442548
  796640
  478489
  437926
  154512
  712268
  586994
  581645
  792370
  416659
  487414
  453221
  524678
  788118
  416708
  491642
  531579
  552704
  587306
  609890
  506105
  791039
  389541
  398078
  412149
  656856
  788027
  810761
  384117
  401353
  531822
  531856
  530428
  531850
  576533
  705119
  670210
  707571
  609887
  799695
  807569
  811700
  752713
  748287
  752627
  807112
  375135
  154535
  395252
  498720
  535959
  562503
  511278
  569258
  469737
  505356
  387026
  391992
  427132
  734214
  384397
  154133
  154972
  382207
  88591
  467112
  540680
  516640
  526179
  513794
  483684
  567561
  340635
  575844
  392848
  402631
  401367
  476656
  485661
  530698
  467636
  547475
  574377
  561019
  580782
  580832
  660380
  672944
  718772
  660369
  670356
  671008
  672952
  666854
  671038
  718701
  580130
  585680
  589185
  616454
  782057
  796703
  798599
  796647
  803534
  752679
  788863
  788908
  87974
  499872
  412814
  416230
  416699
  419167
  490128
  471132
]
3.44 ms
(1.72%)
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
  87974
  88591
  154133
  154512
  154535
  154972
  290366
  340635
  375135
  382207
  384117
  384397
  387026
  389541
  391992
  392848
  395252
  398078
  401353
  401367
  402631
  412149
  412814
  416036
  416230
  416659
  416699
  416708
  419167
  427132
  437926
  442548
  453221
  467112
  467636
  469737
  471132
  476656
  478489
  483684
  485661
  487414
  490128
  491642
  498720
  499872
  505356
  506105
  511278
  513794
  516640
  524678
  526179
  530428
  530698
  531579
  531822
  531850
  531856
  535959
  540680
  547475
  552704
  561019
  562503
  567561
  569258
  574377
  575844
  576533
  580130
  580782
  580832
  581645
  585680
  586994
  587306
  589185
  609887
  609890
  616454
  656856
  660369
  660380
  666854
  670210
  670356
  671008
  671038
  672944
  672952
  705119
  707571
  712268
  718701
  718772
  734214
  748287
  752627
  752679
  752713
  782057
  788027
  788118
  788863
  788908
  791039
  792370
  792712
  796640
  796647
  796703
  798599
  799695
  803534
  806834
  807112
  807569
  810761
  811700
]
1.89 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls dildo"
]
1.87 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк дилд"
]
1.77 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк дилд"
]
1.63 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.