Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.84 ms
(88.90%)
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
  391762
  398874
  400004
  400716
  410741
  417154
  422415
  432897
  450951
  454534
  460763
  469768
  487973
  513511
  514910
  535993
  539276
  540975
  549020
  563303
  564184
  568531
  574211
  577919
  578535
  584260
  588928
  594289
  594615
  600696
  604311
  604371
  608233
  609289
  616457
  619171
  622562
  623289
  623825
  625745
  625965
  628801
  628909
  629167
  634045
  655132
  655279
  656590
  659956
  660340
  661673
  661950
  684404
  696100
  700379
  706454
  709223
  711672
  712393
  713877
  714070
  716603
  718685
  719303
  720085
  724091
  724346
  725032
  728151
  728360
  728372
  728407
  734973
  739403
  739800
  740089
  740883
  745069
  746090
  750100
  751213
  751925
  756670
  757535
  761764
  761814
  762917
  765406
  765449
  766883
  767090
  767269
  769043
  773678
  774251
  775712
  776042
  779979
  781136
  781355
  783144
  785510
  785553
  788779
  788846
  788857
  789901
  791418
  792733
  795303
  796196
  796916
  798639
  799446
  799830
  800975
  804376
  817280
  826153
  827588
]
9.03 ms
(5.29%)
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
  792733
  724091
  728372
  766883
  728151
  728360
  728407
  774251
  739800
  756670
  761814
  762917
  739403
  740089
  746090
  718685
  776042
  785510
  804376
  422415
  400716
  535993
  398874
  450951
  568531
  619171
  410741
  540975
  712393
  696100
  594289
  660340
  800975
  391762
  417154
  826153
  817280
  827588
  513511
  549020
  700379
  716603
  720085
  719303
  574211
  577919
  779979
  781136
  783144
  785553
  796196
  796916
  775712
  781355
  789901
  791418
  795303
  798639
  745069
  751213
  757535
  740883
  750100
  609289
  469768
  578535
  656590
  661673
  655279
  655132
  659956
  684404
  709223
  711672
  714070
  622562
  625965
  628801
  628909
  634045
  594615
  600696
  588928
  623825
  629167
  751925
  563303
  706454
  604371
  799446
  799830
  725032
  432897
  454534
  400004
  460763
  514910
  539276
  564184
  584260
  661950
  713877
  608233
  616457
  625745
  788846
  788857
  761764
  724346
  734973
  765449
  769043
  765406
  767269
  767090
  773678
  604311
  623289
  788779
  487973
]
2.64 ms
(1.55%)
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
  391762
  398874
  400004
  400716
  410741
  417154
  422415
  432897
  450951
  454534
  460763
  469768
  487973
  513511
  514910
  535993
  539276
  540975
  549020
  563303
  564184
  568531
  574211
  577919
  578535
  584260
  588928
  594289
  594615
  600696
  604311
  604371
  608233
  609289
  616457
  619171
  622562
  623289
  623825
  625745
  625965
  628801
  628909
  629167
  634045
  655132
  655279
  656590
  659956
  660340
  661673
  661950
  684404
  696100
  700379
  706454
  709223
  711672
  712393
  713877
  714070
  716603
  718685
  719303
  720085
  724091
  724346
  725032
  728151
  728360
  728372
  728407
  734973
  739403
  739800
  740089
  740883
  745069
  746090
  750100
  751213
  751925
  756670
  757535
  761764
  761814
  762917
  765406
  765449
  766883
  767090
  767269
  769043
  773678
  774251
  775712
  776042
  779979
  781136
  781355
  783144
  785510
  785553
  788779
  788846
  788857
  789901
  791418
  792733
  795303
  796196
  796916
  798639
  799446
  799830
  800975
  804376
  817280
  826153
  827588
]
2.12 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie teen amateur"
]
1.83 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie teen любительск"
]
1.80 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie 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.