Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.43 ms
(85.51%)
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
  395662
  398206
  412330
  415878
  420774
  423382
  424614
  439071
  439187
  440706
  441041
  445977
  446508
  465497
  465667
  465990
  466909
  471666
  473317
  475768
  478986
  478987
  481960
  488769
  490397
  490402
  493882
  499059
  513258
  514254
  514339
  516242
  517513
  522231
  528537
  529356
  530996
  538332
  539355
  546541
  548169
  551873
  555964
  558736
  559412
  560409
  561960
  561979
  563036
  568113
  577735
  578148
  578149
  579856
  586167
  586360
  587235
  587313
  589234
  589335
  589936
  591548
  594115
  594363
  595434
  595581
  596189
  596778
  600700
  600799
  602627
  603365
  604412
  604721
  607673
  611474
  615983
  625924
  627452
  636059
  639661
  643380
  670266
  679677
  681486
  700471
  707757
  710836
  714226
  724954
  740694
  742318
  744948
  749063
  749935
  750473
  751609
  778866
  779862
  782411
  785561
  789746
  791385
  794202
  794240
  794248
  795832
  798605
  801569
  801795
  803606
  804434
  807244
  807830
  809617
  811797
  811876
  812542
  817875
]
16.12 ms
(9.22%)
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
  670266
  679677
  681486
  700471
  707757
  710836
  548169
  555964
  561960
  561979
  563036
  577735
  578148
  595581
  603365
  604721
  587313
  589936
  591548
  595434
  596778
  598065
  600700
  602627
  604412
  611474
  615983
  636059
  586167
  586360
  589234
  594115
  594363
  596189
  607673
  639661
  643380
  589335
  600799
  778866
  785561
  794240
  801569
  811797
  811876
  812542
  779862
  794202
  798605
  809617
  724954
  740694
  750473
  789746
  795832
  803606
  749935
  749063
  742318
  751609
  744948
  625924
  627452
  714226
  782411
  791385
  794248
  801795
  804434
  807244
  807830
  398206
  440706
  475768
  395662
  465667
  478986
  423382
  473317
  499059
  488769
  513258
  514339
  516242
  490397
  560409
  559412
  587235
  412330
  424614
  420774
  439071
  439187
  441041
  415878
  817875
  465497
  466909
  445977
  446508
  465990
  478987
  481960
  490402
  522231
  514254
  539355
  517513
  529356
  530996
  538332
  528537
  471666
  493882
  546541
  551873
  558736
  568113
  578149
  579856
]
2.62 ms
(1.50%)
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
  395662
  398206
  412330
  415878
  420774
  423382
  424614
  439071
  439187
  440706
  441041
  445977
  446508
  465497
  465667
  465990
  466909
  471666
  473317
  475768
  478986
  478987
  481960
  488769
  490397
  490402
  493882
  499059
  513258
  514254
  514339
  516242
  517513
  522231
  528537
  529356
  530996
  538332
  539355
  546541
  548169
  551873
  555964
  558736
  559412
  560409
  561960
  561979
  563036
  568113
  577735
  578148
  578149
  579856
  586167
  586360
  587235
  587313
  589234
  589335
  589936
  591548
  594115
  594363
  595434
  595581
  596189
  596778
  600700
  600799
  602627
  603365
  604412
  604721
  607673
  611474
  615983
  625924
  627452
  636059
  639661
  643380
  670266
  679677
  681486
  700471
  707757
  710836
  714226
  724954
  740694
  742318
  744948
  749063
  749935
  750473
  751609
  778866
  779862
  782411
  785561
  789746
  791385
  794202
  794240
  794248
  795832
  798605
  801569
  801795
  803606
  804434
  807244
  807830
  809617
  811797
  811876
  812542
  817875
]
1.97 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam shower solo"
]
1.74 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер shower соло"
]
1.62 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.27 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер shower соло"
]

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.