Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.37 ms
(86.24%)
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
  325984
  386166
  387515
  393326
  394154
  395825
  400954
  413418
  416652
  417491
  418534
  418866
  421369
  421423
  428851
  429384
  429909
  429961
  430366
  433123
  433202
  436132
  440016
  441111
  447519
  447987
  451594
  456567
  480260
  489888
  492351
  511862
  513313
  518466
  521182
  530026
  532727
  532882
  534596
  536266
  537958
  544835
  546417
  548723
  564303
  594343
  594375
  597457
  597815
  598539
  598674
  598760
  620901
  628089
  632302
  633316
  633637
  637128
  641562
  641569
  641950
  642781
  654086
  659414
  663181
  666562
  666875
  668372
  674328
  674980
  678125
  680161
  680172
  686712
  700674
  701012
  702981
  705809
  713022
  717895
  718696
  718702
  719937
  722522
  725149
  725173
  730692
  731683
  731830
  733845
  733905
  734281
  735990
  738826
  740704
  741548
  746314
  748547
  749012
  750691
  752592
  752677
  756082
  775563
  776286
  776956
  777575
  777950
  778393
  778836
  778850
  787563
  788248
  788497
  791532
  794702
  797390
  805230
  816933
  818377
]
16.23 ms
(8.36%)
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
  701012
  395825
  518466
  400954
  429909
  433123
  418534
  433202
  440016
  447987
  532727
  544835
  628089
  731683
  436132
  421369
  430366
  447519
  417491
  513313
  666875
  598760
  530026
  393326
  532882
  641569
  597457
  641562
  791532
  749012
  731830
  752592
  674328
  778850
  386166
  441111
  416652
  421423
  428851
  534596
  492351
  805230
  738826
  394154
  387515
  413418
  429961
  429384
  818377
  451594
  521182
  537958
  511862
  654086
  659414
  663181
  680161
  680172
  686712
  705809
  717895
  666562
  718696
  722522
  548723
  598674
  637128
  598539
  597815
  620901
  594343
  633316
  642781
  788248
  730692
  740704
  794702
  741548
  748547
  733905
  752677
  725149
  725173
  733845
  750691
  756082
  632302
  633637
  718702
  719937
  778393
  788497
  418866
  325984
  480260
  456567
  489888
  536266
  674980
  678125
  641950
  816933
  546417
  564303
  700674
  702981
  713022
  668372
  594375
  775563
  778836
  797390
  776286
  776956
  777575
  777950
  787563
  734281
  735990
  746314
]
3.14 ms
(1.62%)
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
  325984
  386166
  387515
  393326
  394154
  395825
  400954
  413418
  416652
  417491
  418534
  418866
  421369
  421423
  428851
  429384
  429909
  429961
  430366
  433123
  433202
  436132
  440016
  441111
  447519
  447987
  451594
  456567
  480260
  489888
  492351
  511862
  513313
  518466
  521182
  530026
  532727
  532882
  534596
  536266
  537958
  544835
  546417
  548723
  564303
  594343
  594375
  597457
  597815
  598539
  598674
  598760
  620901
  628089
  632302
  633316
  633637
  637128
  641562
  641569
  641950
  642781
  654086
  659414
  663181
  666562
  666875
  668372
  674328
  674980
  678125
  680161
  680172
  686712
  700674
  701012
  702981
  705809
  713022
  717895
  718696
  718702
  719937
  722522
  725149
  725173
  730692
  731683
  731830
  733845
  733905
  734281
  735990
  738826
  740704
  741548
  746314
  748547
  749012
  750691
  752592
  752677
  756082
  775563
  776286
  776956
  777575
  777950
  778393
  778836
  778850
  787563
  788248
  788497
  791532
  794702
  797390
  805230
  816933
  818377
]
2.10 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hole teen"
]
1.99 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дырк teen"
]
1.68 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дырк teen"
]

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.