Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.03 ms
(55.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
147.87 ms
(38.50%)
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
  4450
  80916
  86358
  191601
  312476
  386050
  397599
  398517
  401211
  401384
  407127
  420118
  420749
  423483
  433354
  435215
  440856
  448182
  455003
  457581
  459704
  463007
  463402
  475506
  479438
  483423
  483470
  488433
  494798
  497161
  500601
  505739
  506924
  506945
  506948
  507215
  512422
  517457
  517990
  521726
  531448
  532283
  532284
  542777
  547028
  547581
  548425
  550795
  550805
  551522
  552449
  556656
  557168
  563680
  565111
  566559
  567993
  575312
  575328
  578218
  589605
  590852
  592987
  595026
  606396
  608900
  615935
  618912
  620339
  620402
  626244
  626395
  636256
  639654
  646257
  653522
  673420
  677119
  695678
  701503
  708435
  709751
  710127
  710486
  713919
  715865
  722375
  728464
  738844
  738845
  740139
  740627
  744094
  744681
  745328
  750395
  752521
  756017
  757132
  758247
  760881
  768297
  771656
  783507
  787790
  793831
  797308
  797859
  798958
  798963
  798966
  798970
  798976
  801026
  803938
  804990
  810327
  811635
  813772
]
15.38 ms
(4.00%)
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
  677119
  636256
  798958
  783507
  738844
  455003
  532283
  752521
  86358
  80916
  548425
  563680
  606396
  710486
  709751
  757132
  475506
  550795
  423483
  708435
  567993
  618912
  740627
  435215
  551522
  566559
  547028
  615935
  592987
  542777
  531448
  575328
  608900
  557168
  463402
  798952
  768297
  550805
  565111
  407127
  744094
  713919
  715865
  810327
  532284
  620339
  787790
  488433
  506948
  547581
  797308
  578218
  798976
  804990
  750395
  517990
  771656
  575312
  738845
  556656
  744681
  803938
  386050
  401384
  507215
  756017
  745328
  420118
  457581
  448182
  521726
  673420
  590852
  797859
  798966
  397599
  512422
  695678
  793831
  479438
  483423
  728464
  760881
  595026
  398517
  440856
  646257
  710127
  639654
  758247
  552449
  722375
  620402
  626244
  589605
  463007
  740139
  500601
  433354
  459704
  653522
  801026
  813772
  401211
  497161
  420749
  798963
  4450
  626395
  505739
  312476
  517457
  506924
  701503
  798970
  811635
  494798
  506945
  191601
  483470
]
2.81 ms
(0.73%)
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
  4450
  80916
  86358
  191601
  312476
  386050
  397599
  398517
  401211
  401384
  407127
  420118
  420749
  423483
  433354
  435215
  440856
  448182
  455003
  457581
  459704
  463007
  463402
  475506
  479438
  483423
  483470
  488433
  494798
  497161
  500601
  505739
  506924
  506945
  506948
  507215
  512422
  517457
  517990
  521726
  531448
  532283
  532284
  542777
  547028
  547581
  548425
  550795
  550805
  551522
  552449
  556656
  557168
  563680
  565111
  566559
  567993
  575312
  575328
  578218
  589605
  590852
  592987
  595026
  606396
  608900
  615935
  618912
  620339
  620402
  626244
  626395
  636256
  639654
  646257
  653522
  673420
  677119
  695678
  701503
  708435
  709751
  710127
  710486
  713919
  715865
  722375
  728464
  738844
  738845
  740139
  740627
  744094
  744681
  745328
  750395
  752521
  756017
  757132
  758247
  760881
  768297
  771656
  783507
  787790
  793831
  797308
  797859
  798958
  798963
  798966
  798970
  798976
  801026
  803938
  804990
  810327
  811635
  813772
]
2.14 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "между титек кончают"
]
2.13 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межд сиськ сперм"
]
1.74 ms
(0.45%)
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.