Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.12 ms
(85.44%)
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
  387320
  387915
  394685
  398497
  400818
  406705
  406976
  407773
  411401
  415221
  417011
  419051
  421795
  423628
  427251
  428767
  428855
  429741
  432731
  433351
  433917
  440032
  440441
  440927
  441448
  441943
  442629
  443408
  443998
  445404
  445464
  447204
  448542
  448837
  449225
  451960
  452025
  452088
  452415
  452579
  452772
  453243
  454110
  454430
  454701
  455025
  455935
  457289
  458336
  458908
  459259
  459910
  460179
  460187
  464018
  465457
  466185
  466786
  467957
  469373
  469386
  470966
  471073
  471442
  471770
  473435
  474194
  475681
  476732
  477099
  478993
  480645
  483983
  484399
  485242
  485949
  486688
  486917
  489301
  489947
  491989
  493316
  497213
  503481
  505955
  506301
  507884
  508337
  515051
  517074
  518325
  518585
  520204
  521358
  526571
  532101
  534670
  544485
  549850
  565034
  565703
  574756
  579213
  584607
  616049
  622856
  645837
  673612
  694507
  707475
  709612
  712789
  726879
  734734
  757228
  783212
  804527
  810297
  811110
  819028
]
12.12 ms
(7.96%)
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
  433917
  400818
  440441
  442629
  460187
  469373
  455025
  457289
  460179
  406705
  452772
  520204
  429741
  478993
  473435
  518325
  819028
  449225
  707475
  757228
  505955
  506301
  565703
  712789
  394685
  452025
  470966
  486917
  411401
  515051
  534670
  441448
  427251
  451960
  453243
  419051
  475681
  544485
  726879
  432731
  464018
  503481
  579213
  734734
  477099
  532101
  485949
  454110
  474194
  508337
  526571
  455935
  459910
  476732
  521358
  616049
  447204
  489301
  491989
  497213
  440032
  480645
  448542
  454430
  471442
  486688
  471073
  458336
  465457
  493316
  517074
  387915
  406976
  407773
  445464
  673612
  415221
  443408
  445404
  428855
  440927
  398497
  484399
  574756
  810297
  441943
  417011
  423628
  428767
  483983
  448837
  452415
  459259
  622856
  421795
  466185
  443998
  452088
  694507
  709612
  565034
  584607
  804527
  811110
  507884
  485242
  549850
  433351
  387320
  467957
  452579
  518585
  469386
  489947
  458908
  466786
  471770
  454701
  645837
  783212
]
2.72 ms
(1.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.18 ms
(1.43%)
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
  387320
  387915
  394685
  398497
  400818
  406705
  406976
  407773
  411401
  415221
  417011
  419051
  421795
  423628
  427251
  428767
  428855
  429741
  432731
  433351
  433917
  440032
  440441
  440927
  441448
  441943
  442629
  443408
  443998
  445404
  445464
  447204
  448542
  448837
  449225
  451960
  452025
  452088
  452415
  452579
  452772
  453243
  454110
  454430
  454701
  455025
  455935
  457289
  458336
  458908
  459259
  459910
  460179
  460187
  464018
  465457
  466185
  466786
  467957
  469373
  469386
  470966
  471073
  471442
  471770
  473435
  474194
  475681
  476732
  477099
  478993
  480645
  483983
  484399
  485242
  485949
  486688
  486917
  489301
  489947
  491989
  493316
  497213
  503481
  505955
  506301
  507884
  508337
  515051
  517074
  518325
  518585
  520204
  521358
  526571
  532101
  534670
  544485
  549850
  565034
  565703
  574756
  579213
  584607
  616049
  622856
  645837
  673612
  694507
  707475
  709612
  712789
  726879
  734734
  757228
  783212
  804527
  810297
  811110
  819028
]
1.87 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ðÂðÁð¢Ðëð©ð¢Ðï ð│ð¥ð╗ÐïðÁ Ðü Ðçð╗ðÁð¢ð¥ðÔǪ"
]
1.66 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женщин голые член"
]
1.62 ms
(1.06%)
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.