Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
198.36 ms
(88.73%)
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
  229024
  233198
  233517
  365839
  387013
  387868
  388284
  391089
  391487
  391909
  394138
  420730
  424146
  427006
  427053
  431608
  432417
  443950
  444236
  471576
  474074
  475908
  479130
  479146
  495189
  509519
  512777
  531554
  533659
  533742
  533752
  533758
  533763
  533778
  539374
  543619
  543696
  543703
  543724
  546685
  555787
  557661
  558926
  561255
  566481
  579124
  590391
  590420
  591210
  598463
  603744
  617625
  624647
  655492
  668082
  673908
  674292
  686397
  688954
  689225
  694175
  694633
  695786
  701400
  705083
  712226
  712610
  712952
  713989
  714560
  715410
  716013
  720658
  723904
  727587
  731197
  736185
  737028
  739956
  742919
  743508
  745637
  747429
  749769
  752742
  756627
  757737
  757774
  761675
  764104
  764634
  764668
  764774
  768290
  768463
  768491
  778279
  778608
  778657
  780854
  784313
  787990
  789643
  790255
  791918
  792521
  793195
  799840
  799847
  799909
  799910
  803231
  803235
  803236
  803240
  804846
  810178
]
15.05 ms
(6.73%)
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
  791918
  598463
  391909
  495189
  443950
  391089
  533659
  555787
  803240
  694175
  233517
  533758
  799840
  792521
  705083
  737028
  474074
  713989
  712952
  764668
  431608
  674292
  427006
  712226
  731197
  391487
  787990
  804846
  695786
  723904
  749769
  387868
  768491
  747429
  761675
  793195
  539374
  531554
  688954
  388284
  715410
  810178
  752742
  754183
  727587
  764774
  617625
  432417
  475908
  712610
  756627
  624647
  731666
  673908
  803236
  509519
  233198
  694633
  716013
  739956
  764634
  799847
  745637
  757737
  394138
  427053
  603744
  471576
  566481
  387013
  479130
  229024
  420730
  720658
  591210
  751981
  365839
  533742
  479146
  557661
  543696
  655492
  590391
  789643
  790255
  764104
  778608
  668082
  424146
  444236
  533763
  780854
  803231
  778279
  803235
  512777
  533778
  533752
  543703
  543724
  561255
  543619
  546685
  558926
  689225
  686397
  579124
  590420
  784313
  778657
  799910
  742919
  799909
  757774
  768290
  743508
  768463
  736185
  701400
  714560
]
2.82 ms
(1.26%)
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
  229024
  233198
  233517
  365839
  387013
  387868
  388284
  391089
  391487
  391909
  394138
  420730
  424146
  427006
  427053
  431608
  432417
  443950
  444236
  471576
  474074
  475908
  479130
  479146
  495189
  509519
  512777
  531554
  533659
  533742
  533752
  533758
  533763
  533778
  539374
  543619
  543696
  543703
  543724
  546685
  555787
  557661
  558926
  561255
  566481
  579124
  590391
  590420
  591210
  598463
  603744
  617625
  624647
  655492
  668082
  673908
  674292
  686397
  688954
  689225
  694175
  694633
  695786
  701400
  705083
  712226
  712610
  712952
  713989
  714560
  715410
  716013
  720658
  723904
  727587
  731197
  736185
  737028
  739956
  742919
  743508
  745637
  747429
  749769
  752742
  756627
  757737
  757774
  761675
  764104
  764634
  764668
  764774
  768290
  768463
  768491
  778279
  778608
  778657
  780854
  784313
  787990
  789643
  790255
  791918
  792521
  793195
  799840
  799847
  799909
  799910
  803231
  803235
  803236
  803240
  804846
  810178
]
1.94 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен русск"
]
1.94 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife russian"
]
1.52 ms
(0.68%)
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.