Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.38 ms
(88.97%)
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
  390212
  391921
  391943
  416683
  417408
  418411
  420886
  421488
  424556
  429330
  435547
  437059
  441610
  443555
  445187
  445426
  447549
  448846
  449847
  450630
  452302
  454647
  459111
  460301
  461437
  461454
  462854
  463863
  463897
  463906
  463917
  463938
  464247
  464550
  469756
  470278
  470330
  470458
  470856
  471688
  472111
  473193
  473387
  475806
  476737
  478901
  479483
  480008
  482076
  485546
  488421
  496448
  496818
  497613
  503477
  504450
  505452
  505626
  510631
  510855
  511721
  512014
  513701
  517204
  517431
  517663
  518619
  519309
  520542
  520853
  521089
  522024
  522219
  524754
  526050
  526555
  528223
  528862
  529557
  530001
  531780
  534528
  537051
  541274
  548158
  555091
  556331
  563438
  570130
  576916
  580236
  580239
  589029
  590498
  595483
  598141
  616013
  620220
  623681
  652852
  672890
  677677
  678571
  679102
  711074
  712633
  722623
  730011
  742281
  745556
  761842
  765268
  770410
  771591
  778607
  791127
  807011
  809782
  814984
  825751
]
14.16 ms
(6.83%)
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
  459111
  462854
  463906
  463938
  417408
  443555
  445187
  460301
  461437
  476737
  479483
  482076
  416683
  424556
  448846
  463897
  464550
  470856
  471688
  421488
  449847
  464247
  472111
  512014
  505626
  511721
  518619
  522024
  526050
  485546
  496448
  517663
  623681
  595483
  473387
  390212
  480008
  513701
  524754
  814984
  534528
  478901
  522219
  521089
  589029
  450630
  470278
  470458
  391943
  429330
  435547
  469756
  517204
  528862
  503477
  520853
  496818
  497613
  510631
  504450
  771591
  391921
  526555
  563438
  570130
  580236
  711074
  576916
  616013
  473193
  454647
  463863
  470330
  418411
  447549
  452302
  461454
  463917
  420886
  530001
  488421
  517431
  505452
  510855
  519309
  529557
  520542
  445426
  672890
  791127
  441610
  825751
  537051
  528223
  531780
  541274
  556331
  555091
  580239
  712633
  652852
  679102
  677677
  678571
  722623
  548158
  590498
  598141
  620220
  778607
  809782
  765268
  807011
  742281
  730011
  745556
  761842
  770410
  437059
  475806
]
2.50 ms
(1.20%)
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
  390212
  391921
  391943
  416683
  417408
  418411
  420886
  421488
  424556
  429330
  435547
  437059
  441610
  443555
  445187
  445426
  447549
  448846
  449847
  450630
  452302
  454647
  459111
  460301
  461437
  461454
  462854
  463863
  463897
  463906
  463917
  463938
  464247
  464550
  469756
  470278
  470330
  470458
  470856
  471688
  472111
  473193
  473387
  475806
  476737
  478901
  479483
  480008
  482076
  485546
  488421
  496448
  496818
  497613
  503477
  504450
  505452
  505626
  510631
  510855
  511721
  512014
  513701
  517204
  517431
  517663
  518619
  519309
  520542
  520853
  521089
  522024
  522219
  524754
  526050
  526555
  528223
  528862
  529557
  530001
  531780
  534528
  537051
  541274
  548158
  555091
  556331
  563438
  570130
  576916
  580236
  580239
  589029
  590498
  595483
  598141
  616013
  620220
  623681
  652852
  672890
  677677
  678571
  679102
  711074
  712633
  722623
  730011
  742281
  745556
  761842
  765268
  770410
  771591
  778607
  791127
  807011
  809782
  814984
  825751
]
1.66 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал toys русск"
]
1.45 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал toys русск"
]
1.44 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal toys russian"
]

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.