Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.03 ms
(84.67%)
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
  21323
  80900
  172685
  192943
  197300
  233889
  326300
  366050
  384864
  394191
  396470
  400337
  401439
  401613
  401898
  401909
  407529
  407533
  407876
  408983
  409532
  413123
  415845
  419012
  421552
  427296
  428804
  430392
  436476
  444671
  444926
  446111
  448095
  448309
  450812
  452094
  452630
  455954
  459556
  460134
  460417
  460501
  462455
  464903
  466353
  467083
  469246
  469989
  470980
  472073
  473803
  473932
  474412
  476297
  477098
  478161
  479703
  479944
  480273
  485582
  487639
  491788
  507875
  511570
  515521
  522490
  524011
  526382
  526985
  531899
  538576
  542778
  544448
  548727
  549334
  553430
  558389
  562010
  566283
  568142
  568925
  571558
  572573
  573103
  573678
  584609
  595096
  606081
  606890
  619413
  622664
  626217
  631435
  634474
  643485
  658763
  659682
  669644
  677691
  693137
  714738
  717053
  727605
  745818
  761056
  768486
  770494
  772249
  772552
  783996
  787748
  789637
  789697
  794126
  794609
  797496
  798275
  804323
  806763
  809566
]
16.31 ms
(10.15%)
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
  745818
  531899
  460134
  572573
  658763
  626217
  797496
  473803
  428804
  408983
  619413
  511570
  787748
  515521
  806763
  401613
  473932
  476297
  427296
  444671
  419012
  549334
  669644
  409532
  459556
  727605
  172685
  394191
  568142
  631435
  479944
  415845
  448309
  479703
  783996
  789637
  772249
  772552
  634474
  526985
  430392
  573678
  794609
  491788
  553430
  714738
  192943
  326300
  197300
  460417
  584609
  401898
  401439
  469246
  464903
  573103
  717053
  693137
  770494
  526382
  622664
  448095
  659682
  809566
  768486
  460501
  485582
  466353
  477098
  233889
  401909
  80900
  452094
  522490
  568925
  384864
  21323
  538576
  571558
  677691
  566283
  798275
  396470
  407529
  407876
  436476
  524011
  794126
  804323
  400337
  480273
  562010
  452630
  462455
  455954
  548727
  450812
  469989
  470980
  467083
  606890
  761056
  789697
  444926
  413123
  544448
  487639
  542778
  606081
  643485
  595096
  478161
  472073
  366050
  407533
  507875
  558389
  446111
  421552
  474412
]
2.19 ms
(1.36%)
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
  21323
  80900
  172685
  192943
  197300
  233889
  326300
  366050
  384864
  394191
  396470
  400337
  401439
  401613
  401898
  401909
  407529
  407533
  407876
  408983
  409532
  413123
  415845
  419012
  421552
  427296
  428804
  430392
  436476
  444671
  444926
  446111
  448095
  448309
  450812
  452094
  452630
  455954
  459556
  460134
  460417
  460501
  462455
  464903
  466353
  467083
  469246
  469989
  470980
  472073
  473803
  473932
  474412
  476297
  477098
  478161
  479703
  479944
  480273
  485582
  487639
  491788
  507875
  511570
  515521
  522490
  524011
  526382
  526985
  531899
  538576
  542778
  544448
  548727
  549334
  553430
  558389
  562010
  566283
  568142
  568925
  571558
  572573
  573103
  573678
  584609
  595096
  606081
  606890
  619413
  622664
  626217
  631435
  634474
  643485
  658763
  659682
  669644
  677691
  693137
  714738
  717053
  727605
  745818
  761056
  768486
  770494
  772249
  772552
  783996
  787748
  789637
  789697
  794126
  794609
  797496
  798275
  804323
  806763
  809566
]
1.92 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сиськ секс"
]
1.41 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сиськи трах"
]
1.35 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.