Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.08 ms
(82.64%)
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
  382083
  413095
  415496
  423260
  429272
  446260
  447955
  455841
  458414
  462689
  476387
  492239
  492679
  501865
  504546
  508818
  508841
  513304
  516261
  520629
  532753
  533760
  536687
  536766
  536789
  539938
  545521
  559868
  564443
  564597
  565279
  566158
  569453
  575094
  575210
  575514
  575734
  576058
  576380
  576415
  579668
  589268
  589484
  591077
  594173
  594929
  597061
  598646
  605338
  611565
  611933
  612207
  612946
  615796
  620912
  621054
  622540
  628090
  633733
  634510
  638985
  644078
  644956
  645905
  647850
  651872
  664274
  665027
  671832
  673371
  680141
  696690
  705713
  714761
  715722
  717745
  718236
  719143
  720001
  720384
  721556
  722596
  725564
  726789
  728174
  729864
  730261
  730369
  731416
  732420
  732425
  735821
  735846
  736400
  737416
  741966
  742031
  744628
  745401
  746423
  747558
  747604
  747855
  749116
  754141
  755252
  756521
  757098
  758986
  760034
  763349
  765710
  766851
  775018
  785021
  786768
  786998
  804751
  811742
  826327
]
18.80 ms
(11.33%)
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
  539938
  533760
  564443
  647850
  628090
  634510
  638985
  605338
  447955
  423260
  413095
  559868
  680141
  705713
  720001
  645905
  651872
  714761
  721556
  664274
  696690
  717745
  621054
  597061
  620912
  622540
  785021
  811742
  786768
  745401
  749116
  757098
  763349
  729864
  730261
  756521
  728174
  735846
  726789
  730369
  736400
  737416
  747558
  747855
  755252
  731416
  744628
  746423
  719143
  775018
  786998
  382083
  429272
  415496
  458414
  576058
  565279
  569453
  575210
  545521
  564597
  594929
  594173
  462689
  476387
  513304
  516261
  504546
  492679
  501865
  492239
  508818
  508841
  591077
  532753
  536766
  536687
  536789
  633733
  598646
  644956
  826327
  520629
  566158
  665027
  671832
  718236
  673371
  720384
  722596
  579668
  611565
  589268
  612207
  612946
  615796
  644078
  804751
  747604
  758986
  760034
  765710
  766851
  732425
  741966
  742031
  725564
  732420
  735821
  754141
  611933
  715722
  589484
  455841
  446260
  575094
  575514
  576415
  576380
  575734
]
2.92 ms
(1.76%)
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
  382083
  413095
  415496
  423260
  429272
  446260
  447955
  455841
  458414
  462689
  476387
  492239
  492679
  501865
  504546
  508818
  508841
  513304
  516261
  520629
  532753
  533760
  536687
  536766
  536789
  539938
  545521
  559868
  564443
  564597
  565279
  566158
  569453
  575094
  575210
  575514
  575734
  576058
  576380
  576415
  579668
  589268
  589484
  591077
  594173
  594929
  597061
  598646
  605338
  611565
  611933
  612207
  612946
  615796
  620912
  621054
  622540
  628090
  633733
  634510
  638985
  644078
  644956
  645905
  647850
  651872
  664274
  665027
  671832
  673371
  680141
  696690
  705713
  714761
  715722
  717745
  718236
  719143
  720001
  720384
  721556
  722596
  725564
  726789
  728174
  729864
  730261
  730369
  731416
  732420
  732425
  735821
  735846
  736400
  737416
  741966
  742031
  744628
  745401
  746423
  747558
  747604
  747855
  749116
  754141
  755252
  756521
  757098
  758986
  760034
  763349
  765710
  766851
  775018
  785021
  786768
  786998
  804751
  811742
  826327
]
1.97 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг старый"
]
1.82 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кастинг с дедушкой"
]
1.69 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг старый"
]
1.59 ms
(0.96%)
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.