Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.85 ms
(78.55%)
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
  392415
  393355
  394698
  394764
  394771
  394786
  394808
  394845
  395132
  395147
  401935
  402049
  402123
  402869
  403294
  403363
  403404
  403495
  404361
  404364
  406800
  408994
  409596
  410324
  413993
  413995
  414029
  414036
  415693
  416066
  419417
  419429
  422733
  425633
  426382
  427897
  427898
  428003
  428878
  429405
  432813
  434608
  444411
  444440
  444456
  444482
  444740
  445539
  445540
  445553
  445554
  445581
  445588
  445748
  445955
  446333
  446756
  446945
  447104
  448689
  448692
  448694
  448731
  448838
  448847
  448871
  449011
  450254
  451990
  452190
  452748
  453314
  453439
  453755
  454591
  454599
  454605
  454620
  454657
  454662
  454765
  454911
  454925
  455193
  458001
  458538
  459297
  460148
  462398
  462483
  464704
  464861
  465012
  469554
  472469
  472493
  477224
  478484
  480503
  485561
  486288
  486647
  486701
  500898
  501567
  503577
  503598
  505018
  505813
  505822
  516397
  527997
  528406
  540484
  564777
  566317
  573938
  586433
  587200
  638360
]
20.43 ms
(13.73%)
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
  446333
  446756
  486647
  500898
  503598
  393355
  403404
  446945
  395132
  486288
  501567
  527997
  402049
  419429
  448689
  452190
  453314
  454911
  445540
  448692
  586433
  445748
  394845
  448731
  394698
  403363
  408994
  415693
  428878
  462398
  445588
  505822
  573938
  444740
  469554
  394808
  402869
  404361
  404364
  414036
  429405
  445554
  453439
  458538
  450254
  448871
  454591
  454605
  454657
  459297
  460148
  478484
  587200
  638360
  403495
  406800
  444411
  454620
  416066
  445955
  503577
  462483
  505018
  434608
  425633
  428003
  413993
  464861
  505813
  447104
  448847
  394764
  394771
  392415
  444440
  413995
  432813
  448838
  455193
  452748
  454599
  465012
  445553
  449011
  453755
  454662
  480503
  409596
  445581
  448694
  414029
  454765
  477224
  401935
  410324
  422733
  426382
  444456
  472493
  427898
  485561
  394786
  402123
  427897
  458001
  454925
  516397
  540484
  464704
  564777
  566317
  419417
  451990
  395147
  472469
  444482
  445539
  403294
  486701
  528406
]
3.26 ms
(2.19%)
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
  392415
  393355
  394698
  394764
  394771
  394786
  394808
  394845
  395132
  395147
  401935
  402049
  402123
  402869
  403294
  403363
  403404
  403495
  404361
  404364
  406800
  408994
  409596
  410324
  413993
  413995
  414029
  414036
  415693
  416066
  419417
  419429
  422733
  425633
  426382
  427897
  427898
  428003
  428878
  429405
  432813
  434608
  444411
  444440
  444456
  444482
  444740
  445539
  445540
  445553
  445554
  445581
  445588
  445748
  445955
  446333
  446756
  446945
  447104
  448689
  448692
  448694
  448731
  448838
  448847
  448871
  449011
  450254
  451990
  452190
  452748
  453314
  453439
  453755
  454591
  454599
  454605
  454620
  454657
  454662
  454765
  454911
  454925
  455193
  458001
  458538
  459297
  460148
  462398
  462483
  464704
  464861
  465012
  469554
  472469
  472493
  477224
  478484
  480503
  485561
  486288
  486647
  486701
  500898
  501567
  503577
  503598
  505018
  505813
  505822
  516397
  527997
  528406
  540484
  564777
  566317
  573938
  586433
  587200
  638360
]
2.60 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bangbros boy"
]
2.14 ms
(1.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bangbros парен"
]
1.70 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bangbros парен"
]

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.