Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.26 ms
(88.82%)
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
  6813
  27847
  147897
  187956
  282465
  384518
  398733
  485644
  518911
  530297
  535725
  557328
  564543
  584391
  590655
  593595
  597132
  598479
  599281
  604169
  606767
  613523
  623273
  624279
  629341
  629735
  630392
  630408
  636469
  643461
  643589
  643605
  643664
  648199
  649580
  650066
  651752
  654409
  655265
  656295
  656562
  656599
  656622
  674848
  680236
  680268
  682991
  684630
  690443
  691190
  692646
  694437
  694592
  696232
  698554
  702941
  703297
  704958
  707133
  714888
  717258
  720130
  721562
  721890
  723667
  725556
  726260
  727503
  731228
  731274
  733233
  734970
  739164
  742534
  748487
  750283
  750286
  754584
  760742
  761587
  764239
  766608
  766768
  773268
  773734
  775377
  776981
  778084
  778644
  779665
  782964
  783372
  783386
  788557
  788982
  790900
  791402
  791415
  791521
  791860
  792946
  793872
  794142
  794385
  794855
  794889
  795680
  797130
  798696
  798811
  800313
  800439
  801285
  805641
  805706
  806858
  810415
  813944
  821704
  827835
]
12.10 ms
(5.90%)
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
  750286
  766768
  783386
  739164
  748487
  773268
  764239
  726260
  734970
  742534
  750283
  754584
  766608
  773734
  606767
  717258
  779665
  788557
  788982
  791860
  810415
  723667
  727503
  733233
  794142
  794855
  704958
  147897
  6813
  384518
  187956
  282465
  27847
  398733
  821704
  813944
  827835
  485644
  535725
  518911
  530297
  584391
  656295
  656599
  680236
  694437
  698554
  703297
  707133
  648199
  650066
  680268
  684630
  690443
  692646
  702941
  714888
  720130
  649580
  651752
  654409
  655265
  656562
  656622
  674848
  682991
  691190
  694592
  696232
  721562
  721890
  557328
  564543
  598479
  599281
  613523
  629341
  643605
  643461
  590655
  597132
  624279
  629735
  630408
  643664
  593595
  604169
  623273
  630392
  636469
  643589
  775377
  778084
  778644
  791415
  793872
  798811
  776981
  782964
  790900
  794385
  794889
  795680
  798696
  800313
  800439
  801285
  805641
  725556
  731228
  731274
  760742
  761587
  783372
  791402
  791521
  792946
  797130
  805706
  806858
]
4.15 ms
(2.02%)
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
  6813
  27847
  147897
  187956
  282465
  384518
  398733
  485644
  518911
  530297
  535725
  557328
  564543
  584391
  590655
  593595
  597132
  598479
  599281
  604169
  606767
  613523
  623273
  624279
  629341
  629735
  630392
  630408
  636469
  643461
  643589
  643605
  643664
  648199
  649580
  650066
  651752
  654409
  655265
  656295
  656562
  656599
  656622
  674848
  680236
  680268
  682991
  684630
  690443
  691190
  692646
  694437
  694592
  696232
  698554
  702941
  703297
  704958
  707133
  714888
  717258
  720130
  721562
  721890
  723667
  725556
  726260
  727503
  731228
  731274
  733233
  734970
  739164
  742534
  748487
  750283
  750286
  754584
  760742
  761587
  764239
  766608
  766768
  773268
  773734
  775377
  776981
  778084
  778644
  779665
  782964
  783372
  783386
  788557
  788982
  790900
  791402
  791415
  791521
  791860
  792946
  793872
  794142
  794385
  794855
  794889
  795680
  797130
  798696
  798811
  800313
  800439
  801285
  805641
  805706
  806858
  810415
  813944
  821704
  827835
]
1.80 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал с большими жопам%…"
]
1.64 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал большая большие жоп"
]
1.56 ms
(0.76%)
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.