Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.06 ms
(84.81%)
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
  91954
  188507
  386271
  387931
  396094
  396352
  396699
  399705
  399722
  409948
  417390
  417904
  423349
  423350
  429729
  430283
  430493
  434492
  435471
  435515
  445182
  449679
  450224
  452601
  461048
  464147
  465575
  465605
  468467
  473461
  477464
  478640
  482727
  485325
  491447
  494289
  496380
  498626
  502921
  503423
  505100
  512029
  519084
  529202
  529954
  530503
  530536
  530696
  534027
  534378
  535793
  537235
  537671
  538106
  544409
  545478
  545611
  550063
  550207
  551082
  556406
  565507
  571230
  571751
  576980
  581831
  583080
  586207
  590850
  592229
  599922
  601347
  601578
  601625
  602946
  603737
  604025
  604537
  606727
  611345
  612726
  614993
  615839
  615898
  615989
  616328
  630592
  630916
  632291
  632579
  633825
  634189
  636564
  641977
  642060
  643112
  644059
  647313
  647361
  650459
  675009
  678970
  681301
  693987
  719427
  720257
  725599
  725622
  733193
  737709
  738419
  744448
  770402
  786463
  793757
  796997
  806036
  807708
  820917
]
18.12 ms
(9.42%)
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
  465605
  737709
  434492
  534027
  530696
  550207
  675009
  601347
  599922
  530536
  614993
  387931
  91954
  828298
  535793
  744448
  396094
  450224
  468467
  571751
  612726
  601625
  643112
  611345
  632291
  423349
  409948
  529202
  386271
  188507
  396699
  399705
  417904
  430283
  449679
  505100
  503423
  464147
  544409
  565507
  581831
  583080
  604025
  644059
  807708
  733193
  770402
  725599
  725622
  399722
  465575
  496380
  423350
  429729
  435471
  435515
  461048
  477464
  478640
  512029
  537671
  534378
  519084
  494289
  529954
  571230
  550063
  556406
  576980
  650459
  681301
  720257
  647313
  678970
  647361
  719427
  551082
  592229
  586207
  606727
  615839
  630592
  634189
  636564
  642060
  590850
  615898
  616328
  641977
  806036
  793757
  603737
  604537
  630916
  786463
  796997
  473461
  396352
  445182
  417390
  430493
  485325
  502921
  491447
  452601
  482727
  530503
  498626
  602946
  538106
  693987
  738419
  537235
  820917
  545478
  615989
  633825
  545611
  601578
  632579
]
2.96 ms
(1.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.65 ms
(1.38%)
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
  91954
  188507
  386271
  387931
  396094
  396352
  396699
  399705
  399722
  409948
  417390
  417904
  423349
  423350
  429729
  430283
  430493
  434492
  435471
  435515
  445182
  449679
  450224
  452601
  461048
  464147
  465575
  465605
  468467
  473461
  477464
  478640
  482727
  485325
  491447
  494289
  496380
  498626
  502921
  503423
  505100
  512029
  519084
  529202
  529954
  530503
  530536
  530696
  534027
  534378
  535793
  537235
  537671
  538106
  544409
  545478
  545611
  550063
  550207
  551082
  556406
  565507
  571230
  571751
  576980
  581831
  583080
  586207
  590850
  592229
  599922
  601347
  601578
  601625
  602946
  603737
  604025
  604537
  606727
  611345
  612726
  614993
  615839
  615898
  615989
  616328
  630592
  630916
  632291
  632579
  633825
  634189
  636564
  641977
  642060
  643112
  644059
  647313
  647361
  650459
  675009
  678970
  681301
  693987
  719427
  720257
  725599
  725622
  733193
  737709
  738419
  744448
  770402
  786463
  793757
  796997
  806036
  807708
  820917
]
2.08 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass bbc"
]
1.86 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп bbc"
]
1.53 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп bbc"
]

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.