Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.56 ms
(79.46%)
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
  114767
  382630
  396534
  407812
  417473
  420155
  422666
  449885
  486730
  513919
  515945
  516950
  519934
  520531
  524271
  524783
  527001
  528847
  535533
  537008
  541177
  541239
  542652
  543243
  545028
  546425
  549410
  553489
  554153
  558010
  563533
  563731
  565921
  565973
  566675
  567097
  568117
  568280
  568452
  569031
  569198
  569994
  571684
  571762
  571827
  574191
  574451
  576009
  576705
  577393
  577422
  577642
  578057
  578124
  578400
  578418
  580288
  580695
  580802
  580821
  581972
  582787
  583860
  584244
  584667
  584698
  585646
  586448
  587813
  589256
  590164
  590948
  591160
  592450
  592457
  592481
  593543
  593750
  594126
  596107
  596445
  599213
  599243
  601269
  601602
  601838
  603019
  603273
  603330
  603905
  604156
  606759
  606863
  607711
  608124
  612026
  615433
  615554
  615728
  620151
  621661
  628348
  629898
  634633
  634861
  645878
  645937
  649949
  650259
  663938
  670285
  671707
  672110
  672771
  689338
  689376
  690406
  813946
  814335
  814958
]
24.16 ms
(14.26%)
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
  543243
  549410
  568117
  574191
  580695
  580821
  690406
  671707
  649949
  689376
  565921
  567097
  574451
  590164
  592450
  594126
  601602
  607711
  604156
  615433
  587813
  593543
  599213
  593750
  599243
  620151
  634861
  603330
  629898
  396534
  524271
  558010
  541239
  571762
  527001
  577393
  569198
  571827
  581972
  584667
  645937
  606759
  114767
  417473
  563731
  554153
  634633
  585646
  382630
  407812
  814335
  814958
  513919
  524783
  535533
  520531
  528847
  537008
  486730
  545028
  565973
  566675
  571684
  584244
  563533
  577642
  578418
  582787
  584698
  541177
  542652
  553489
  576009
  576705
  578400
  650259
  672110
  689338
  670285
  645878
  663938
  672771
  546425
  568452
  569031
  569994
  577422
  578057
  578124
  580288
  583860
  592457
  592481
  601838
  603273
  590948
  596107
  615728
  591160
  596445
  601269
  603019
  612026
  586448
  589256
  603905
  606863
  608124
  615554
  621661
  628348
  422666
  420155
  449885
  515945
  516950
  519934
  813946
  568280
  580802
]
3.44 ms
(2.03%)
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
  114767
  382630
  396534
  407812
  417473
  420155
  422666
  449885
  486730
  513919
  515945
  516950
  519934
  520531
  524271
  524783
  527001
  528847
  535533
  537008
  541177
  541239
  542652
  543243
  545028
  546425
  549410
  553489
  554153
  558010
  563533
  563731
  565921
  565973
  566675
  567097
  568117
  568280
  568452
  569031
  569198
  569994
  571684
  571762
  571827
  574191
  574451
  576009
  576705
  577393
  577422
  577642
  578057
  578124
  578400
  578418
  580288
  580695
  580802
  580821
  581972
  582787
  583860
  584244
  584667
  584698
  585646
  586448
  587813
  589256
  590164
  590948
  591160
  592450
  592457
  592481
  593543
  593750
  594126
  596107
  596445
  599213
  599243
  601269
  601602
  601838
  603019
  603273
  603330
  603905
  604156
  606759
  606863
  607711
  608124
  612026
  615433
  615554
  615728
  620151
  621661
  628348
  629898
  634633
  634861
  645878
  645937
  649949
  650259
  663938
  670285
  671707
  672110
  672771
  689338
  689376
  690406
  813946
  814335
  814958
]
1.92 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скачет милф"
]
1.87 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скачет милфа"
]
1.78 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скачет милф"
]
1.62 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.