Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.78 ms
(86.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
  540054
  540055
  540075
  540104
  540113
  540117
  540120
  540121
  540127
  540136
  540140
  540156
  540675
  541194
  541856
  542180
  542427
  543678
  544228
  544231
  546314
  547406
  547410
  547442
  549522
  553695
  554706
  554708
  554709
  554734
  554735
  555261
  555406
  555438
  557411
  560900
  561035
  561043
  561768
  567496
  579472
  582505
  584399
  585208
  600668
  605248
  607305
  615830
  621320
  627858
  628374
  630519
  630522
  631439
  632282
  632649
  633181
  633780
  634133
  634363
  640856
  642025
  643112
  649447
  650711
  653691
  666360
  667450
  669538
  670806
  673935
  673944
  674952
  678144
  686154
  687778
  691846
  693930
  693934
  703735
  711695
  715621
  717990
  722075
  732865
  734846
  737801
  740265
  740374
  743689
  743996
  743997
  744568
  749025
  749097
  757218
  769445
  790112
  793510
  798755
  798772
  801819
  802084
  808277
  814166
  814221
  814224
  817881
  819424
  819807
  825342
  825824
  825968
  826186
  826297
  826321
  826724
  827188
  827681
  828836
]
10.23 ms
(6.67%)
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
  678144
  643112
  540136
  802084
  740374
  743997
  757218
  749097
  607305
  737801
  825968
  827188
  717990
  808277
  732865
  826297
  540156
  553695
  667450
  582505
  627858
  631439
  541856
  674952
  630522
  826724
  817881
  540120
  547410
  691846
  722075
  693934
  634133
  640856
  793510
  734846
  628374
  826186
  819807
  828836
  540140
  703735
  579472
  633181
  798772
  632282
  814221
  693930
  743689
  827681
  540054
  561043
  650711
  686154
  555261
  555406
  801819
  798755
  621320
  814166
  549522
  544231
  554709
  743996
  744568
  540121
  541194
  561035
  543678
  711695
  615830
  634363
  740265
  632649
  642025
  814224
  554735
  584399
  544228
  561768
  673944
  669538
  585208
  769445
  749025
  540055
  540104
  540117
  567496
  547442
  666360
  670806
  555438
  557411
  630519
  605248
  790112
  633780
  825824
  819424
  825342
  826321
  540127
  540075
  540113
  540675
  554706
  542427
  560900
  542180
  554708
  554734
  653691
  687778
  649447
  673935
  715621
  546314
  547406
  600668
]
3.18 ms
(2.07%)
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
  540054
  540055
  540075
  540104
  540113
  540117
  540120
  540121
  540127
  540136
  540140
  540156
  540675
  541194
  541856
  542180
  542427
  543678
  544228
  544231
  546314
  547406
  547410
  547442
  549522
  553695
  554706
  554708
  554709
  554734
  554735
  555261
  555406
  555438
  557411
  560900
  561035
  561043
  561768
  567496
  579472
  582505
  584399
  585208
  600668
  605248
  607305
  615830
  621320
  627858
  628374
  630519
  630522
  631439
  632282
  632649
  633181
  633780
  634133
  634363
  640856
  642025
  643112
  649447
  650711
  653691
  666360
  667450
  669538
  670806
  673935
  673944
  674952
  678144
  686154
  687778
  691846
  693930
  693934
  703735
  711695
  715621
  717990
  722075
  732865
  734846
  737801
  740265
  740374
  743689
  743996
  743997
  744568
  749025
  749097
  757218
  769445
  790112
  793510
  798755
  798772
  801819
  802084
  808277
  814166
  814221
  814224
  817881
  819424
  819807
  825342
  825824
  825968
  826186
  826297
  826321
  826724
  827188
  827681
  828836
]
2.02 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl pissing"
]
1.94 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк pissing"
]
1.76 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк pissing"
]

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.