Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.36 ms
(84.14%)
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
  423511
  436841
  436938
  439441
  439442
  440947
  443468
  443955
  444337
  455573
  460325
  464589
  465153
  469402
  469693
  480471
  483310
  487987
  491350
  496617
  500531
  501985
  508641
  509290
  512528
  517493
  527739
  537371
  549656
  553610
  564122
  573149
  588389
  590761
  595226
  603406
  604861
  605510
  609783
  612287
  613319
  629833
  667459
  670891
  672807
  674124
  687942
  710377
  710462
  712540
  716935
  718393
  724475
  725027
  725467
  725478
  726179
  727393
  728255
  733123
  735461
  735581
  736285
  736893
  738626
  739178
  740869
  741785
  746161
  750381
  751517
  751661
  759607
  759723
  759762
  759906
  759917
  760530
  762448
  764250
  764518
  765552
  766041
  768028
  769426
  769452
  769467
  770185
  773271
  775274
  775860
  776582
  777570
  779424
  782483
  783425
  787614
  791006
  793766
  793830
  794106
  794161
  795687
  795998
  796009
  796160
  796893
  797392
  799037
  800970
  803960
  804329
  806083
  807846
  810472
  811019
  814378
  823927
  824810
  825672
]
14.49 ms
(8.75%)
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
  469402
  549656
  718393
  672807
  687942
  667459
  674124
  716935
  605510
  782483
  787614
  793830
  795687
  775860
  783425
  759917
  769426
  795998
  799037
  725478
  726179
  735461
  736285
  759723
  770185
  727393
  735581
  738626
  751661
  759906
  765552
  768028
  769467
  741785
  736893
  751517
  775274
  791006
  796893
  804329
  806083
  440947
  443955
  469693
  436938
  537371
  527739
  483310
  465153
  491350
  500531
  512528
  517493
  508641
  564122
  595226
  612287
  613319
  609783
  444337
  460325
  509290
  712540
  423511
  439441
  439442
  825672
  814378
  824810
  823927
  480471
  464589
  455573
  487987
  496617
  501985
  573149
  670891
  710377
  710462
  553610
  590761
  629833
  604861
  588389
  779424
  793766
  794106
  776582
  794161
  796009
  800970
  740869
  746161
  750381
  766041
  769452
  803960
  810472
  811019
  724475
  725027
  725467
  759762
  733123
  760530
  728255
  739178
  762448
  764250
  764518
  773271
  759607
  603406
  777570
  796160
  797392
  807846
  436841
  443468
]
4.61 ms
(2.78%)
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
  423511
  436841
  436938
  439441
  439442
  440947
  443468
  443955
  444337
  455573
  460325
  464589
  465153
  469402
  469693
  480471
  483310
  487987
  491350
  496617
  500531
  501985
  508641
  509290
  512528
  517493
  527739
  537371
  549656
  553610
  564122
  573149
  588389
  590761
  595226
  603406
  604861
  605510
  609783
  612287
  613319
  629833
  667459
  670891
  672807
  674124
  687942
  710377
  710462
  712540
  716935
  718393
  724475
  725027
  725467
  725478
  726179
  727393
  728255
  733123
  735461
  735581
  736285
  736893
  738626
  739178
  740869
  741785
  746161
  750381
  751517
  751661
  759607
  759723
  759762
  759906
  759917
  760530
  762448
  764250
  764518
  765552
  766041
  768028
  769426
  769452
  769467
  770185
  773271
  775274
  775860
  776582
  777570
  779424
  782483
  783425
  787614
  791006
  793766
  793830
  794106
  794161
  795687
  795998
  796009
  796160
  796893
  797392
  799037
  800970
  803960
  804329
  806083
  807846
  810472
  811019
  814378
  823927
  824810
  825672
]
1.96 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum milf"
]
1.88 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum milf"
]
1.71 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum milf"
]
1.60 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.