Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.56 ms
(81.98%)
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
  386178
  388116
  393452
  396317
  397811
  398184
  407429
  407653
  407716
  408188
  418932
  419422
  423982
  426127
  426404
  428192
  429824
  438109
  439638
  439766
  439779
  443142
  443664
  447244
  447574
  448995
  453001
  453469
  453781
  454059
  454407
  455026
  458312
  462897
  463910
  467628
  469371
  470287
  472078
  473989
  479993
  480819
  481191
  481798
  485535
  486964
  490210
  494912
  496112
  496259
  497006
  501996
  507989
  512562
  517922
  518351
  518948
  519277
  520911
  521118
  523731
  527794
  531919
  532444
  532939
  535707
  541294
  542742
  557058
  557254
  566539
  567666
  573964
  574443
  575714
  576293
  588494
  592890
  598973
  599549
  602724
  614088
  620208
  628667
  635167
  635998
  636235
  638165
  640304
  647951
  664579
  689943
  693635
  696414
  707526
  711700
  718684
  721461
  723616
  724852
  725565
  728084
  740258
  745744
  745946
  750831
  753707
  765812
  771952
  774935
  777668
  781255
  784662
  791981
  793077
  803306
  813266
  817949
  823774
]
16.37 ms
(11.04%)
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
  725565
  455026
  535707
  463910
  542742
  473989
  467628
  462897
  523731
  497006
  501996
  527794
  447244
  745946
  520911
  393452
  429824
  664579
  628667
  531919
  567666
  479993
  518948
  532939
  426404
  481798
  784662
  512562
  481191
  573964
  439638
  496259
  386178
  541294
  454059
  635998
  439779
  418932
  472078
  507989
  453469
  419422
  453781
  458312
  532444
  494912
  408188
  707526
  647951
  793077
  728084
  438109
  557058
  490210
  443142
  447574
  521118
  696414
  779276
  765812
  635167
  781255
  423982
  638165
  693635
  426127
  517922
  518351
  486964
  602724
  496112
  592890
  428192
  576293
  598973
  398184
  439766
  575714
  470287
  740258
  823774
  723616
  407653
  407429
  689943
  443664
  711700
  620208
  599549
  614088
  750831
  448995
  519277
  588494
  771952
  777668
  453001
  745744
  388116
  480819
  469371
  724852
  803306
  791981
  566539
  721461
  397811
  407716
  485535
  454407
  574443
  774935
  557254
  817949
  718684
  813266
  753707
  636235
  396317
  640304
]
3.09 ms
(2.08%)
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
  386178
  388116
  393452
  396317
  397811
  398184
  407429
  407653
  407716
  408188
  418932
  419422
  423982
  426127
  426404
  428192
  429824
  438109
  439638
  439766
  439779
  443142
  443664
  447244
  447574
  448995
  453001
  453469
  453781
  454059
  454407
  455026
  458312
  462897
  463910
  467628
  469371
  470287
  472078
  473989
  479993
  480819
  481191
  481798
  485535
  486964
  490210
  494912
  496112
  496259
  497006
  501996
  507989
  512562
  517922
  518351
  518948
  519277
  520911
  521118
  523731
  527794
  531919
  532444
  532939
  535707
  541294
  542742
  557058
  557254
  566539
  567666
  573964
  574443
  575714
  576293
  588494
  592890
  598973
  599549
  602724
  614088
  620208
  628667
  635167
  635998
  636235
  638165
  640304
  647951
  664579
  689943
  693635
  696414
  707526
  711700
  718684
  721461
  723616
  724852
  725565
  728084
  740258
  745744
  745946
  750831
  753707
  765812
  771952
  774935
  777668
  781255
  784662
  791981
  793077
  803306
  813266
  817949
  823774
]
2.28 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трахнул сисястую в ванной"
]
1.93 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс большие сиськ ван"
]
1.39 ms
(0.94%)
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.