Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.27 ms
(82.65%)
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
  427084
  439695
  459734
  461461
  461820
  462331
  462537
  476520
  483126
  484227
  495565
  502657
  504524
  512148
  522991
  523598
  527537
  527610
  527989
  533435
  535399
  548825
  555726
  559581
  561243
  562821
  564098
  566260
  567164
  567251
  575853
  576560
  577654
  578435
  578547
  578587
  579881
  580326
  585227
  586248
  601419
  605002
  613785
  615443
  616637
  616858
  618926
  619384
  638903
  641521
  650369
  655485
  671350
  696374
  703648
  708923
  723040
  732016
  732786
  735511
  738268
  744682
  748359
  753927
  756072
  756518
  758065
  763748
  764790
  765001
  765195
  766887
  766959
  769359
  769702
  776310
  777143
  777498
  777589
  777691
  778008
  779084
  781029
  781348
  781626
  782089
  782486
  782659
  784434
  787964
  788100
  789307
  789478
  790819
  791017
  791317
  791556
  791574
  791689
  791942
  792355
  793026
  793931
  793979
  796179
  797678
  800466
  803211
  804301
  806263
  807661
  808695
  817879
  819764
  821669
  823670
  825865
]
14.36 ms
(9.78%)
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
  461820
  462331
  427084
  461461
  462537
  439695
  522991
  523598
  735511
  777498
  821669
  819764
  823670
  825865
  527610
  533435
  527537
  535399
  562821
  548825
  555726
  564098
  567164
  671350
  696374
  703648
  650369
  723040
  655485
  577654
  641521
  613785
  585227
  601419
  616637
  616858
  780457
  788100
  790819
  791556
  792355
  793931
  793979
  797678
  803211
  777589
  777691
  778008
  779084
  781348
  791017
  804301
  753927
  766959
  769359
  784434
  789478
  791317
  791574
  800466
  806263
  807661
  732016
  748359
  764790
  765001
  765195
  766887
  738268
  756518
  769702
  744682
  758065
  763748
  768119
  620715
  638903
  777143
  781029
  781626
  782486
  787964
  789307
  791689
  791942
  793026
  796179
  808695
  619384
  566260
  618926
  459734
  476520
  527989
  575853
  559581
  580326
  578587
  579881
  615443
  502657
  483126
  484227
  495565
  512148
  504524
  578435
  561243
  708923
  567251
  576560
  578547
  586248
  605002
  782089
  776310
  732786
  756072
  782659
  817879
]
3.17 ms
(2.16%)
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
  427084
  439695
  459734
  461461
  461820
  462331
  462537
  476520
  483126
  484227
  495565
  502657
  504524
  512148
  522991
  523598
  527537
  527610
  527989
  533435
  535399
  548825
  555726
  559581
  561243
  562821
  564098
  566260
  567164
  567251
  575853
  576560
  577654
  578435
  578547
  578587
  579881
  580326
  585227
  586248
  601419
  605002
  613785
  615443
  616637
  616858
  618926
  619384
  638903
  641521
  650369
  655485
  671350
  696374
  703648
  708923
  723040
  732016
  732786
  735511
  738268
  744682
  748359
  753927
  756072
  756518
  758065
  763748
  764790
  765001
  765195
  766887
  766959
  769359
  769702
  776310
  777143
  777498
  777589
  777691
  778008
  779084
  781029
  781348
  781626
  782089
  782486
  782659
  784434
  787964
  788100
  789307
  789478
  790819
  791017
  791317
  791556
  791574
  791689
  791942
  792355
  793026
  793931
  793979
  796179
  797678
  800466
  803211
  804301
  806263
  807661
  808695
  817879
  819764
  821669
  823670
  825865
]
2.35 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pigtails pov"
]
2.11 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "косичк пов"
]
1.90 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.07%)
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.