Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.57 ms
(84.90%)
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
  102043
  102334
  383325
  384238
  385953
  386024
  387777
  387946
  389234
  389570
  393095
  395145
  399876
  400055
  400964
  401218
  410324
  416200
  416784
  417324
  417783
  418028
  418689
  419211
  421260
  429563
  430436
  434392
  434971
  435452
  435496
  435731
  440680
  442702
  442720
  443241
  447039
  448108
  449880
  457368
  458206
  458209
  461755
  462222
  464646
  467110
  467111
  468525
  472257
  472768
  473500
  475481
  475994
  479016
  479703
  483570
  483573
  484797
  485175
  486181
  488931
  496285
  496310
  501329
  502900
  508450
  512534
  513669
  514071
  518976
  520734
  520739
  523361
  536927
  540381
  556181
  575197
  584576
  586460
  589544
  599781
  601074
  601181
  604498
  604526
  604583
  614053
  622285
  649867
  651083
  651094
  667278
  668961
  710872
  716140
  719938
  720667
  724536
  729890
  729937
  729940
  737717
  754170
  758557
  770524
  775532
  787738
  792587
  792817
  796241
  804370
  807362
  808786
  810455
  815658
  815812
  816218
  821739
  822298
  823396
]
11.82 ms
(7.93%)
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
  651094
  719938
  508450
  443241
  485175
  417783
  410324
  448108
  484797
  457368
  668961
  716140
  807362
  792587
  808786
  754170
  418028
  435452
  440680
  449880
  395145
  421260
  479703
  651083
  584576
  724536
  416784
  435496
  514071
  429563
  496285
  386024
  385953
  435731
  473500
  815658
  472257
  520734
  821739
  540381
  442702
  384238
  387777
  418689
  667278
  823396
  483573
  729937
  102043
  496310
  416200
  720667
  710872
  599781
  601074
  622285
  604498
  604583
  729890
  419211
  486181
  614053
  770524
  729940
  796241
  447039
  737717
  810455
  816218
  556181
  389570
  400055
  501329
  775532
  468525
  479016
  417324
  387946
  458206
  512534
  536927
  758557
  472768
  399876
  518976
  520739
  601181
  430436
  649867
  586460
  383325
  401218
  488931
  461755
  393095
  464646
  483570
  102334
  389234
  467110
  523361
  787738
  604526
  792817
  475481
  458209
  462222
  815812
  804370
  442720
  434971
  513669
  400964
  575197
  589544
  434392
  822298
  467111
  475994
  502900
]
2.77 ms
(1.86%)
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
  102043
  102334
  383325
  384238
  385953
  386024
  387777
  387946
  389234
  389570
  393095
  395145
  399876
  400055
  400964
  401218
  410324
  416200
  416784
  417324
  417783
  418028
  418689
  419211
  421260
  429563
  430436
  434392
  434971
  435452
  435496
  435731
  440680
  442702
  442720
  443241
  447039
  448108
  449880
  457368
  458206
  458209
  461755
  462222
  464646
  467110
  467111
  468525
  472257
  472768
  473500
  475481
  475994
  479016
  479703
  483570
  483573
  484797
  485175
  486181
  488931
  496285
  496310
  501329
  502900
  508450
  512534
  513669
  514071
  518976
  520734
  520739
  523361
  536927
  540381
  556181
  575197
  584576
  586460
  589544
  599781
  601074
  601181
  604498
  604526
  604583
  614053
  622285
  649867
  651083
  651094
  667278
  668961
  710872
  716140
  719938
  720667
  724536
  729890
  729937
  729940
  737717
  754170
  758557
  770524
  775532
  787738
  792587
  792817
  796241
  804370
  807362
  808786
  810455
  815658
  815812
  816218
  821739
  822298
  823396
]
2.02 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс чернокожая"
]
1.96 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс чернокожая"
]
1.93 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.