Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.50 ms
(88.83%)
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
  124519
  204778
  240689
  397063
  407159
  412789
  458948
  497623
  535734
  560612
  596245
  601516
  614063
  614185
  614386
  616591
  624413
  627052
  628300
  633571
  633908
  642554
  645962
  646401
  653514
  658480
  671062
  671653
  673126
  673813
  677039
  679402
  681024
  684320
  688405
  690963
  693660
  701530
  702154
  703111
  709412
  712208
  712813
  713042
  713363
  714772
  715069
  716743
  717759
  721024
  722356
  724681
  726176
  726641
  727448
  728675
  728762
  730539
  732499
  732871
  733535
  733944
  734990
  738842
  741056
  744188
  746409
  746452
  746949
  747618
  748340
  748679
  753281
  754630
  755277
  758851
  759383
  764632
  764835
  764918
  765273
  765366
  765797
  767091
  769833
  770866
  773734
  773852
  777022
  777820
  778132
  778424
  779032
  779634
  779694
  780026
  780159
  781156
  782023
  783494
  783563
  783813
  784684
  786515
  786702
  786765
  789210
  790176
  791155
  793324
  794366
  797143
  798241
  799381
  800741
  801398
  801913
  803803
  804705
  811849
]
9.32 ms
(5.61%)
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
  779694
  811849
  716743
  645962
  780026
  801913
  770866
  746409
  703111
  712208
  721024
  653514
  673813
  701530
  709412
  560612
  628300
  624413
  614386
  777022
  777820
  784684
  799381
  779634
  786765
  797143
  758851
  732499
  746452
  755277
  759383
  764632
  773852
  726641
  765797
  712813
  778132
  793324
  458948
  497623
  646401
  671653
  690963
  642554
  789210
  791155
  794366
  801398
  754630
  803803
  724681
  726176
  728762
  746949
  764835
  764918
  730539
  732871
  733535
  728675
  738842
  767091
  773734
  627052
  717759
  778424
  780159
  124519
  397063
  679402
  714772
  677039
  596245
  783563
  783813
  798241
  804705
  747618
  753281
  765273
  727448
  744188
  765366
  733944
  741056
  748679
  734990
  748340
  769833
  204778
  240689
  407159
  412789
  535734
  681024
  684320
  713363
  658480
  688405
  671062
  673126
  693660
  702154
  713042
  715069
  722356
  614063
  614185
  616591
  633571
  601516
  633908
  779032
  781156
  782023
  786515
  786702
  800741
  783494
  790176
]
2.81 ms
(1.69%)
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
  124519
  204778
  240689
  397063
  407159
  412789
  458948
  497623
  535734
  560612
  596245
  601516
  614063
  614185
  614386
  616591
  624413
  627052
  628300
  633571
  633908
  642554
  645962
  646401
  653514
  658480
  671062
  671653
  673126
  673813
  677039
  679402
  681024
  684320
  688405
  690963
  693660
  701530
  702154
  703111
  709412
  712208
  712813
  713042
  713363
  714772
  715069
  716743
  717759
  721024
  722356
  724681
  726176
  726641
  727448
  728675
  728762
  730539
  732499
  732871
  733535
  733944
  734990
  738842
  741056
  744188
  746409
  746452
  746949
  747618
  748340
  748679
  753281
  754630
  755277
  758851
  759383
  764632
  764835
  764918
  765273
  765366
  765797
  767091
  769833
  770866
  773734
  773852
  777022
  777820
  778132
  778424
  779032
  779634
  779694
  780026
  780159
  781156
  782023
  783494
  783563
  783813
  784684
  786515
  786702
  786765
  789210
  790176
  791155
  793324
  794366
  797143
  798241
  799381
  800741
  801398
  801913
  803803
  804705
  811849
]
1.85 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс любов"
]
1.75 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс люб"
]
1.46 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.82%)
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.