Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.00 ms
(85.84%)
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
  121057
  330414
  398123
  398972
  403487
  403690
  407782
  411848
  417340
  420340
  420793
  426514
  427220
  428317
  428537
  428709
  432399
  434837
  435754
  435940
  438427
  439727
  440819
  443626
  444163
  444957
  445832
  447612
  452191
  452194
  452219
  452262
  452330
  452347
  452815
  453429
  453475
  453619
  453954
  454477
  454539
  454973
  455380
  455586
  458622
  458625
  459859
  460358
  460814
  460980
  463214
  463978
  464098
  464347
  468157
  468978
  469183
  473459
  473473
  473482
  475292
  475942
  476067
  479769
  483209
  485230
  488525
  496083
  496091
  499759
  505790
  508423
  509761
  509984
  512474
  512960
  517814
  518770
  522736
  524358
  530430
  536441
  540461
  544806
  550597
  572204
  588018
  607438
  612450
  645626
  659974
  660464
  664437
  682259
  695387
  696984
  702331
  725500
  732782
  736289
  737452
  737552
  739888
  741441
  750765
  750881
  756640
  756870
  758264
  765578
  765758
  769209
  775268
  776488
  780006
  784239
  788825
  797943
  809084
  814497
]
12.04 ms
(8.01%)
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
  475942
  417340
  453619
  769209
  758264
  784239
  475292
  499759
  736289
  750765
  447612
  428537
  440819
  434837
  427220
  454477
  464098
  476067
  452330
  468978
  530430
  572204
  550597
  588018
  696984
  439727
  452262
  454973
  460358
  330414
  398123
  403487
  426514
  444163
  814497
  452347
  454539
  473459
  452219
  459859
  460980
  485230
  445832
  473482
  518770
  536441
  505790
  517814
  464347
  479769
  544806
  659974
  664437
  682259
  695387
  660464
  645626
  607438
  780006
  737452
  756870
  797943
  809084
  732782
  725500
  765578
  737552
  756640
  739888
  750881
  612450
  702331
  776488
  788825
  432399
  452191
  455380
  403690
  411848
  428317
  452815
  420793
  453429
  453475
  512474
  483209
  488525
  121057
  438427
  428709
  444957
  420340
  443626
  455586
  458622
  463978
  453954
  468157
  458625
  473473
  508423
  540461
  460814
  469183
  775268
  741441
  765758
  407782
  435940
  463214
  398972
  452194
  435754
  496083
  509984
  512960
  496091
  509761
  522736
  524358
]
2.30 ms
(1.53%)
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
  121057
  330414
  398123
  398972
  403487
  403690
  407782
  411848
  417340
  420340
  420793
  426514
  427220
  428317
  428537
  428709
  432399
  434837
  435754
  435940
  438427
  439727
  440819
  443626
  444163
  444957
  445832
  447612
  452191
  452194
  452219
  452262
  452330
  452347
  452815
  453429
  453475
  453619
  453954
  454477
  454539
  454973
  455380
  455586
  458622
  458625
  459859
  460358
  460814
  460980
  463214
  463978
  464098
  464347
  468157
  468978
  469183
  473459
  473473
  473482
  475292
  475942
  476067
  479769
  483209
  485230
  488525
  496083
  496091
  499759
  505790
  508423
  509761
  509984
  512474
  512960
  517814
  518770
  522736
  524358
  530430
  536441
  540461
  544806
  550597
  572204
  588018
  607438
  612450
  645626
  659974
  660464
  664437
  682259
  695387
  696984
  702331
  725500
  732782
  736289
  737452
  737552
  739888
  741441
  750765
  750881
  756640
  756870
  758264
  765578
  765758
  769209
  775268
  776488
  780006
  784239
  788825
  797943
  809084
  814497
]
2.19 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "огромной жопы"
]
1.67 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромная жоп"
]
1.48 ms
(0.98%)
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.