Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.57 ms
(88.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
  388506
  396687
  416293
  418460
  420130
  420597
  428793
  438428
  447384
  448774
  449908
  459400
  484934
  491125
  492435
  492478
  496661
  505348
  520401
  522994
  528848
  529453
  529498
  533153
  537044
  537459
  549502
  555505
  556546
  558163
  562158
  568034
  570391
  577269
  587433
  587437
  595739
  602179
  606675
  607235
  610171
  617796
  619667
  621051
  629596
  631620
  632750
  632860
  634729
  638441
  641330
  641465
  642271
  643400
  661590
  664318
  664816
  665854
  666834
  668696
  668809
  670813
  671559
  682763
  683840
  692681
  693384
  700852
  712188
  713145
  714563
  715168
  717137
  722248
  724845
  733020
  737307
  750711
  750877
  751835
  753485
  758277
  758621
  760595
  763569
  765605
  767401
  768538
  768650
  769438
  769860
  769885
  770237
  779560
  780703
  787785
  788456
  791341
  792796
  795061
  797878
  798824
  801804
  802251
  803807
  803822
  804617
  805364
  807403
  807869
  808335
  808457
  808980
  811334
  812036
  812048
  812317
  813909
  816718
  819157
]
12.50 ms
(6.83%)
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
  767401
  753485
  758277
  700852
  717137
  788456
  388506
  819157
  670813
  587433
  780703
  803822
  750711
  768650
  763569
  492435
  813909
  562158
  760595
  555505
  665854
  666834
  682763
  692681
  693384
  632750
  610171
  638441
  642271
  602179
  607235
  805364
  801804
  617796
  491125
  816718
  568034
  671559
  722248
  714563
  712188
  587437
  758621
  787785
  505348
  537459
  634729
  420130
  556546
  577269
  769438
  418460
  448774
  492478
  713145
  632860
  643400
  795061
  797878
  812317
  765605
  769885
  733020
  769860
  737307
  664318
  595739
  768538
  803807
  807869
  396687
  522994
  664816
  631620
  621051
  798824
  804617
  484934
  537044
  520401
  770237
  428793
  447384
  496661
  529453
  533153
  570391
  661590
  668696
  619667
  791341
  724845
  751835
  641330
  641465
  802251
  420597
  449908
  438428
  459400
  529498
  558163
  715168
  683840
  549502
  606675
  629596
  779560
  808335
  808457
  812036
  812048
  792796
  811334
  750877
  807403
  808980
  416293
  528848
  668809
]
2.53 ms
(1.38%)
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
  388506
  396687
  416293
  418460
  420130
  420597
  428793
  438428
  447384
  448774
  449908
  459400
  484934
  491125
  492435
  492478
  496661
  505348
  520401
  522994
  528848
  529453
  529498
  533153
  537044
  537459
  549502
  555505
  556546
  558163
  562158
  568034
  570391
  577269
  587433
  587437
  595739
  602179
  606675
  607235
  610171
  617796
  619667
  621051
  629596
  631620
  632750
  632860
  634729
  638441
  641330
  641465
  642271
  643400
  661590
  664318
  664816
  665854
  666834
  668696
  668809
  670813
  671559
  682763
  683840
  692681
  693384
  700852
  712188
  713145
  714563
  715168
  717137
  722248
  724845
  733020
  737307
  750711
  750877
  751835
  753485
  758277
  758621
  760595
  763569
  765605
  767401
  768538
  768650
  769438
  769860
  769885
  770237
  779560
  780703
  787785
  788456
  791341
  792796
  795061
  797878
  798824
  801804
  802251
  803807
  803822
  804617
  805364
  807403
  807869
  808335
  808457
  808980
  811334
  812036
  812048
  812317
  813909
  816718
  819157
]
1.84 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits play"
]
1.82 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ play"
]
1.51 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сиськ play"
]

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.