Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.35 ms
(84.16%)
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
  24243
  31941
  97747
  409083
  409085
  418566
  426480
  432708
  433904
  434801
  440526
  442644
  442645
  442650
  442704
  446690
  448282
  451089
  454533
  454537
  455433
  455471
  456633
  456635
  457774
  458791
  459470
  459472
  461394
  461788
  465219
  470411
  475209
  475814
  482917
  490162
  493311
  495172
  499695
  500182
  509077
  509549
  510157
  510570
  512997
  517599
  523136
  523552
  530937
  535300
  542980
  553185
  554123
  554234
  554372
  554707
  558658
  559090
  580666
  586390
  588267
  589486
  591380
  594566
  596736
  601243
  602807
  609761
  615721
  620121
  624907
  628358
  629739
  667246
  668467
  670825
  671411
  671886
  672357
  672369
  677503
  679281
  683260
  683300
  690726
  702350
  702375
  711362
  714602
  718908
  723764
  726289
  736388
  738675
  738754
  740694
  751360
  751381
  751384
  751390
  753733
  754759
  754896
  757003
  758401
  759138
  765980
  796971
  800139
  804265
  805624
  811852
  811896
  811900
  811905
  813645
  818813
  820134
  823918
  826443
]
14.20 ms
(9.31%)
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
  601243
  451089
  594566
  482917
  448282
  461394
  461788
  517599
  499695
  409083
  434801
  458791
  554234
  591380
  586390
  620121
  455471
  493311
  580666
  510157
  805624
  24243
  465219
  677503
  679281
  726289
  804265
  690726
  446690
  558658
  542980
  554123
  432708
  510570
  740694
  459472
  475209
  589486
  523552
  409085
  702350
  490162
  672357
  615721
  530937
  495172
  624907
  751381
  440526
  553185
  668467
  667246
  97747
  442645
  442650
  509077
  702375
  31941
  454533
  683300
  559090
  588267
  418566
  442644
  535300
  738754
  609761
  820134
  754896
  509549
  433904
  818813
  718908
  671411
  796971
  765980
  711362
  813645
  554707
  602807
  811905
  811852
  751384
  811896
  500182
  442704
  457774
  470411
  512997
  823918
  683260
  670825
  714602
  628358
  800139
  754759
  596736
  811900
  736388
  753733
  723764
  738675
  751360
  757003
  456635
  523136
  456633
  826443
  672369
  426480
  455433
  629739
  759138
  751390
  758401
  459470
  475814
  554372
  671886
  454537
]
3.40 ms
(2.23%)
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
  24243
  31941
  97747
  409083
  409085
  418566
  426480
  432708
  433904
  434801
  440526
  442644
  442645
  442650
  442704
  446690
  448282
  451089
  454533
  454537
  455433
  455471
  456633
  456635
  457774
  458791
  459470
  459472
  461394
  461788
  465219
  470411
  475209
  475814
  482917
  490162
  493311
  495172
  499695
  500182
  509077
  509549
  510157
  510570
  512997
  517599
  523136
  523552
  530937
  535300
  542980
  553185
  554123
  554234
  554372
  554707
  558658
  559090
  580666
  586390
  588267
  589486
  591380
  594566
  596736
  601243
  602807
  609761
  615721
  620121
  624907
  628358
  629739
  667246
  668467
  670825
  671411
  671886
  672357
  672369
  677503
  679281
  683260
  683300
  690726
  702350
  702375
  711362
  714602
  718908
  723764
  726289
  736388
  738675
  738754
  740694
  751360
  751381
  751384
  751390
  753733
  754759
  754896
  757003
  758401
  759138
  765980
  796971
  800139
  804265
  805624
  811852
  811896
  811900
  811905
  813645
  818813
  820134
  823918
  826443
]
1.72 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden bathroom"
]
1.67 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт ван"
]
1.52 ms
(1.00%)
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.