Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.59 ms
(90.31%)
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
  391302
  395449
  400969
  411508
  420403
  424207
  426525
  432702
  433398
  435275
  435657
  437320
  438714
  442444
  444163
  444196
  445709
  446916
  447687
  448400
  450765
  453428
  453778
  453896
  455021
  455588
  457557
  459529
  460379
  461251
  463227
  464423
  464475
  466285
  467682
  470399
  475005
  476609
  477409
  477420
  477992
  478749
  478764
  484007
  488929
  494539
  496805
  497493
  499154
  503713
  508677
  512343
  514763
  514769
  514775
  516671
  517362
  518024
  518245
  521361
  522841
  532832
  536260
  543970
  546098
  553256
  557111
  557529
  565879
  566701
  572210
  572261
  574251
  584689
  585761
  591901
  592799
  623756
  628812
  636575
  655505
  674266
  674590
  681802
  696526
  698199
  700635
  703503
  709798
  709894
  712617
  727153
  737955
  743033
  743670
  748120
  759361
  761101
  761307
  766181
  766365
  768175
  772859
  776241
  777897
  780469
  787882
  793626
  794177
  801055
  808251
  811545
  817989
  818392
  823554
  823724
  825278
  825889
  826753
  827580
]
12.65 ms
(5.30%)
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
  453778
  450765
  478764
  512343
  467682
  478749
  400969
  514769
  395449
  411508
  444163
  459529
  464475
  470399
  446916
  518024
  584689
  543970
  553256
  565879
  420403
  424207
  435657
  447687
  477420
  503713
  484007
  514775
  521361
  536260
  546098
  709798
  623756
  636575
  826753
  825889
  494539
  766181
  737955
  761101
  761307
  827580
  811545
  743033
  768175
  488929
  499154
  391302
  463227
  794177
  681802
  426525
  432702
  442444
  437320
  445709
  455021
  464423
  516671
  522841
  518245
  572261
  438714
  455588
  466285
  475005
  477409
  477992
  433398
  435275
  460379
  461251
  476609
  444196
  457557
  453428
  453896
  517362
  497493
  508677
  514763
  532832
  496805
  572210
  574251
  709894
  655505
  674266
  712617
  674590
  696526
  700635
  557111
  566701
  585761
  591901
  628812
  592799
  776241
  743670
  772859
  698199
  703503
  823724
  823554
  818392
  448400
  801055
  793626
  808251
  766365
  787882
  817989
  825278
  557529
  777897
  780469
  727153
  748120
  759361
]
2.99 ms
(1.25%)
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
  391302
  395449
  400969
  411508
  420403
  424207
  426525
  432702
  433398
  435275
  435657
  437320
  438714
  442444
  444163
  444196
  445709
  446916
  447687
  448400
  450765
  453428
  453778
  453896
  455021
  455588
  457557
  459529
  460379
  461251
  463227
  464423
  464475
  466285
  467682
  470399
  475005
  476609
  477409
  477420
  477992
  478749
  478764
  484007
  488929
  494539
  496805
  497493
  499154
  503713
  508677
  512343
  514763
  514769
  514775
  516671
  517362
  518024
  518245
  521361
  522841
  532832
  536260
  543970
  546098
  553256
  557111
  557529
  565879
  566701
  572210
  572261
  574251
  584689
  585761
  591901
  592799
  623756
  628812
  636575
  655505
  674266
  674590
  681802
  696526
  698199
  700635
  703503
  709798
  709894
  712617
  727153
  737955
  743033
  743670
  748120
  759361
  761101
  761307
  766181
  766365
  768175
  772859
  776241
  777897
  780469
  787882
  793626
  794177
  801055
  808251
  811545
  817989
  818392
  823554
  823724
  825278
  825889
  826753
  827580
]
2.11 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск спящ"
]
1.97 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur sleeping"
]
1.87 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.65%)
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.