Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.83 ms
(83.36%)
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
  402190
  416613
  425948
  437368
  438532
  439103
  439362
  443432
  449161
  449930
  451044
  452810
  457486
  458678
  466639
  469221
  470405
  471764
  479867
  485472
  488817
  495467
  505139
  505386
  509921
  521682
  522169
  528657
  530679
  538309
  541541
  542097
  547482
  550925
  553964
  557333
  557347
  564227
  568864
  573188
  574664
  577520
  580848
  583431
  583689
  584590
  586876
  587307
  588436
  588464
  592794
  594136
  602467
  605566
  605874
  607520
  619636
  621503
  622982
  623280
  628095
  630420
  644510
  663158
  667045
  671044
  673257
  679491
  689010
  689065
  692728
  697627
  709693
  714203
  735504
  736024
  736561
  738081
  739142
  745088
  751285
  751692
  752246
  752706
  754902
  758335
  760220
  760558
  769023
  770216
  772240
  774878
  776031
  776527
  779295
  783036
  783053
  785606
  786005
  787477
  791206
  791445
  793923
  795380
  796266
  797010
  807173
  807244
  807902
  808331
  808796
  808962
  812058
  812612
  813199
  814459
  816126
  821790
  823137
  827847
]
15.46 ms
(10.16%)
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
  451044
  505386
  577520
  630420
  752706
  709693
  469221
  823137
  530679
  816126
  787477
  796266
  808962
  758335
  812612
  760220
  797010
  402190
  416613
  449930
  538309
  522169
  574664
  667045
  553964
  586876
  588436
  808331
  437368
  466639
  495467
  521682
  628095
  550925
  663158
  689065
  679491
  592794
  588464
  619636
  594136
  607520
  776031
  783036
  807173
  774878
  793923
  772240
  808796
  813199
  736561
  760558
  623280
  644510
  783053
  791206
  812058
  438532
  568864
  587307
  605874
  770216
  439362
  443432
  458678
  471764
  528657
  505139
  485472
  547482
  564227
  573188
  671044
  557347
  692728
  752246
  689010
  827847
  479867
  779295
  751285
  439103
  814459
  457486
  449161
  541541
  580848
  673257
  714203
  776527
  785606
  791445
  807902
  745088
  751692
  736024
  754902
  786005
  807244
  470405
  583689
  542097
  584590
  602467
  425948
  452810
  509921
  557333
  605566
  488817
  821790
  583431
  697627
  621503
  622982
  795380
  769023
  735504
  738081
  739142
]
2.48 ms
(1.63%)
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
  402190
  416613
  425948
  437368
  438532
  439103
  439362
  443432
  449161
  449930
  451044
  452810
  457486
  458678
  466639
  469221
  470405
  471764
  479867
  485472
  488817
  495467
  505139
  505386
  509921
  521682
  522169
  528657
  530679
  538309
  541541
  542097
  547482
  550925
  553964
  557333
  557347
  564227
  568864
  573188
  574664
  577520
  580848
  583431
  583689
  584590
  586876
  587307
  588436
  588464
  592794
  594136
  602467
  605566
  605874
  607520
  619636
  621503
  622982
  623280
  628095
  630420
  644510
  663158
  667045
  671044
  673257
  679491
  689010
  689065
  692728
  697627
  709693
  714203
  735504
  736024
  736561
  738081
  739142
  745088
  751285
  751692
  752246
  752706
  754902
  758335
  760220
  760558
  769023
  770216
  772240
  774878
  776031
  776527
  779295
  783036
  783053
  785606
  786005
  787477
  791206
  791445
  793923
  795380
  796266
  797010
  807173
  807244
  807902
  808331
  808796
  808962
  812058
  812612
  813199
  814459
  816126
  821790
  823137
  827847
]
2.14 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding dildo girl"
]
1.77 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding дилд девушк"
]
1.61 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding дилд девушк"
]

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.