Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.42 ms
(84.56%)
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
  382363
  383556
  393424
  399346
  402081
  407756
  416870
  442747
  448068
  487917
  515234
  526768
  544484
  562064
  563857
  565332
  572727
  579668
  586585
  591726
  592582
  594223
  595511
  599747
  600204
  611933
  620983
  624394
  632022
  663425
  663442
  665378
  667013
  669336
  675370
  675382
  678783
  682523
  683745
  684571
  685767
  694160
  694447
  694533
  694585
  695913
  696309
  698045
  699650
  703137
  703142
  706931
  707265
  708801
  708803
  710960
  712723
  715083
  716076
  716168
  716244
  717645
  717681
  717764
  717814
  718689
  720583
  720667
  720776
  720816
  721368
  721439
  722099
  722596
  723675
  724824
  725165
  725648
  725676
  726476
  727400
  727526
  727748
  730071
  730381
  732387
  735564
  735796
  735821
  735849
  740536
  741647
  741649
  742194
  743127
  743224
  744572
  745738
  747604
  748142
  748235
  748681
  754141
  755406
  759581
  760222
  788194
  788579
  790369
  793636
  807551
  809705
  813343
  813914
  814073
  821725
  823493
  823630
  825822
  827942
]
13.19 ms
(8.82%)
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
  825822
  383556
  382363
  399346
  813914
  814073
  821725
  823630
  823493
  827942
  563857
  572727
  544484
  663425
  665378
  675382
  678783
  683745
  694585
  696309
  708803
  716076
  717814
  720667
  669336
  675370
  685767
  694160
  694533
  695913
  703142
  717645
  717764
  721368
  663442
  682523
  684571
  694447
  706931
  708801
  712723
  716168
  718689
  720583
  720816
  721439
  722099
  722596
  579668
  600204
  624394
  586585
  599747
  788579
  730381
  735796
  735849
  743127
  744572
  747604
  760222
  790369
  809705
  724824
  735564
  748142
  723675
  727748
  741647
  745738
  748681
  725648
  725676
  735821
  740536
  725165
  742194
  743224
  754141
  759581
  611933
  698045
  707265
  710960
  715083
  717681
  788194
  793636
  813343
  402081
  393424
  720776
  726476
  407756
  416870
  442747
  526768
  562064
  667013
  716244
  591726
  620983
  592582
  594223
  595511
  727526
  730071
  741649
  748235
  727400
  755406
  732387
  632022
  699650
  703137
  807551
  448068
  487917
  515234
  565332
]
3.39 ms
(2.27%)
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
  382363
  383556
  393424
  399346
  402081
  407756
  416870
  442747
  448068
  487917
  515234
  526768
  544484
  562064
  563857
  565332
  572727
  579668
  586585
  591726
  592582
  594223
  595511
  599747
  600204
  611933
  620983
  624394
  632022
  663425
  663442
  665378
  667013
  669336
  675370
  675382
  678783
  682523
  683745
  684571
  685767
  694160
  694447
  694533
  694585
  695913
  696309
  698045
  699650
  703137
  703142
  706931
  707265
  708801
  708803
  710960
  712723
  715083
  716076
  716168
  716244
  717645
  717681
  717764
  717814
  718689
  720583
  720667
  720776
  720816
  721368
  721439
  722099
  722596
  723675
  724824
  725165
  725648
  725676
  726476
  727400
  727526
  727748
  730071
  730381
  732387
  735564
  735796
  735821
  735849
  740536
  741647
  741649
  742194
  743127
  743224
  744572
  745738
  747604
  748142
  748235
  748681
  754141
  755406
  759581
  760222
  788194
  788579
  790369
  793636
  807551
  809705
  813343
  813914
  814073
  821725
  823493
  823630
  825822
  827942
]
1.67 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young big pussy"
]
1.63 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young большие pussy"
]
1.59 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young большие pussy"
]

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.