Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.69 ms
(82.18%)
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
  420109
  429742
  470101
  470142
  508945
  509005
  514120
  515300
  520460
  521791
  522427
  522920
  527390
  527721
  527867
  528578
  529339
  534568
  537194
  537248
  538793
  542420
  542542
  542559
  543161
  544488
  545262
  546419
  548833
  551038
  552525
  553495
  555930
  556213
  556552
  557165
  557382
  561283
  561454
  561937
  562045
  563705
  568042
  568174
  569117
  569549
  571130
  572827
  572968
  576199
  576340
  577056
  577603
  578128
  578438
  579350
  580982
  581348
  581989
  584809
  584833
  585767
  586378
  586426
  586700
  586763
  590382
  590727
  590753
  592824
  592841
  593792
  594415
  596514
  597182
  598346
  598365
  599735
  600581
  600851
  601213
  602698
  603142
  604093
  605459
  605855
  606165
  608173
  610314
  610716
  612346
  612581
  612614
  612801
  612933
  613878
  616754
  617863
  620072
  620750
  622264
  624884
  625008
  625088
  625283
  629764
  634246
  643194
  652558
  652940
  659775
  660860
  663389
  664777
  665325
  680746
  683595
  684996
  686207
  713651
]
18.67 ms
(11.57%)
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
  509005
  521791
  522427
  527390
  534568
  537248
  538793
  508945
  528578
  529339
  537194
  542542
  542559
  546419
  561454
  571130
  576199
  576340
  577056
  580982
  584833
  544488
  545262
  548833
  557165
  557382
  561937
  562045
  569117
  572827
  578128
  579350
  542420
  563705
  577603
  578438
  581989
  584809
  680746
  684996
  686207
  652558
  652940
  664777
  665325
  659775
  660860
  551038
  553495
  555930
  556213
  556552
  561283
  568174
  569549
  572968
  581348
  585767
  592824
  592841
  593792
  594415
  598365
  600851
  601213
  605855
  608173
  613878
  622264
  586426
  586700
  590382
  598346
  612614
  620072
  624884
  597182
  603142
  604093
  605459
  610716
  643194
  590727
  590753
  596514
  600581
  616754
  617863
  625008
  625283
  602698
  612346
  612581
  612933
  625088
  634246
  470142
  470101
  552525
  683595
  713651
  620750
  420109
  522920
  527721
  514120
  527867
  606165
  629764
  586378
  515300
  543161
  568042
  663389
  612801
  586763
  599735
  429742
  520460
  610314
]
2.30 ms
(1.42%)
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
  420109
  429742
  470101
  470142
  508945
  509005
  514120
  515300
  520460
  521791
  522427
  522920
  527390
  527721
  527867
  528578
  529339
  534568
  537194
  537248
  538793
  542420
  542542
  542559
  543161
  544488
  545262
  546419
  548833
  551038
  552525
  553495
  555930
  556213
  556552
  557165
  557382
  561283
  561454
  561937
  562045
  563705
  568042
  568174
  569117
  569549
  571130
  572827
  572968
  576199
  576340
  577056
  577603
  578128
  578438
  579350
  580982
  581348
  581989
  584809
  584833
  585767
  586378
  586426
  586700
  586763
  590382
  590727
  590753
  592824
  592841
  593792
  594415
  596514
  597182
  598346
  598365
  599735
  600581
  600851
  601213
  602698
  603142
  604093
  605459
  605855
  606165
  608173
  610314
  610716
  612346
  612581
  612614
  612801
  612933
  613878
  616754
  617863
  620072
  620750
  622264
  624884
  625008
  625088
  625283
  629764
  634246
  643194
  652558
  652940
  659775
  660860
  663389
  664777
  665325
  680746
  683595
  684996
  686207
  713651
]
2.10 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сосет с яйцами"
]
1.99 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сосет яйц"
]
1.79 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.