Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.28 ms
(82.45%)
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
  79388
  137159
  369353
  380962
  382089
  383976
  387347
  389730
  391771
  397403
  410967
  418249
  418773
  424009
  425730
  426723
  427620
  438686
  440819
  441806
  449412
  463604
  464068
  465671
  466862
  468897
  470990
  477357
  478141
  479573
  484336
  485478
  485892
  490752
  495581
  495787
  496420
  505877
  507010
  507810
  511965
  511996
  513374
  520935
  521050
  526387
  529957
  537757
  539977
  540720
  541930
  546089
  553164
  554294
  554953
  557833
  558145
  562219
  563029
  563673
  564366
  565007
  565601
  567544
  571874
  572712
  573512
  579515
  583958
  585067
  585625
  588916
  589938
  590307
  603114
  605225
  607494
  620060
  641171
  642962
  643399
  649936
  656208
  677847
  694373
  699277
  700037
  701257
  704180
  707549
  716253
  718862
  723720
  730741
  734028
  747240
  750494
  764189
  767431
  768197
  768869
  770173
  775725
  778521
  779774
  781028
  785422
  786291
  788306
  791424
  793577
  795415
  796973
  798820
  801653
  803591
  805124
  805693
  812662
  812713
]
16.06 ms
(9.93%)
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
  513374
  449412
  565007
  567544
  677847
  607494
  812662
  465671
  418773
  490752
  507810
  563029
  438686
  511965
  563673
  590307
  571874
  572712
  747240
  137159
  718862
  585625
  588916
  424009
  418249
  427620
  781028
  466862
  554294
  468897
  505877
  496420
  521050
  383976
  788306
  767431
  387347
  511996
  79388
  478141
  564366
  425730
  441806
  520935
  380962
  382089
  389730
  397403
  426723
  410967
  585067
  470990
  495581
  539977
  526387
  540720
  463604
  562219
  565601
  579515
  541930
  546089
  557833
  558145
  694373
  699277
  701257
  704180
  707549
  649936
  656208
  700037
  553164
  554953
  573512
  583958
  589938
  620060
  643399
  603114
  642962
  775725
  779774
  785422
  801653
  803591
  805124
  805693
  786291
  791424
  795415
  798820
  734028
  723720
  750494
  768869
  770173
  730741
  764189
  768197
  605225
  641171
  716253
  778521
  793577
  796973
  812713
  464068
  391771
  529957
  485478
  477357
  507010
  369353
  440819
  479573
  484336
  485892
  495787
  537757
]
4.55 ms
(2.82%)
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
  79388
  137159
  369353
  380962
  382089
  383976
  387347
  389730
  391771
  397403
  410967
  418249
  418773
  424009
  425730
  426723
  427620
  438686
  440819
  441806
  449412
  463604
  464068
  465671
  466862
  468897
  470990
  477357
  478141
  479573
  484336
  485478
  485892
  490752
  495581
  495787
  496420
  505877
  507010
  507810
  511965
  511996
  513374
  520935
  521050
  526387
  529957
  537757
  539977
  540720
  541930
  546089
  553164
  554294
  554953
  557833
  558145
  562219
  563029
  563673
  564366
  565007
  565601
  567544
  571874
  572712
  573512
  579515
  583958
  585067
  585625
  588916
  589938
  590307
  603114
  605225
  607494
  620060
  641171
  642962
  643399
  649936
  656208
  677847
  694373
  699277
  700037
  701257
  704180
  707549
  716253
  718862
  723720
  730741
  734028
  747240
  750494
  764189
  767431
  768197
  768869
  770173
  775725
  778521
  779774
  781028
  785422
  786291
  788306
  791424
  793577
  795415
  796973
  798820
  801653
  803591
  805124
  805693
  812662
  812713
]
2.25 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жену в своем"
]
2.05 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен в сво"
]
1.84 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен в сво"
]
1.63 ms
(1.01%)
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.