Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.12 ms
(80.79%)
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
  31218
  31245
  67555
  69611
  73143
  91954
  262435
  311005
  382045
  384147
  385073
  392632
  393063
  393145
  395389
  395459
  396217
  396546
  396572
  399062
  399222
  411913
  419656
  421350
  424179
  425113
  431911
  432975
  435742
  436020
  447703
  453762
  456250
  456522
  457198
  457895
  459986
  460076
  463386
  463991
  464347
  465616
  466703
  468349
  468350
  473316
  474605
  475177
  475369
  478609
  479519
  479528
  480032
  480083
  480966
  481217
  481445
  481618
  482362
  482950
  483767
  485855
  486820
  488529
  488684
  493755
  494313
  495003
  495858
  498305
  500377
  501048
  503442
  504347
  505883
  507008
  508243
  508650
  508666
  509264
  511652
  513685
  514028
  514931
  516136
  518182
  519598
  519810
  522190
  524824
  525714
  526346
  529961
  531973
  532200
  533269
  534430
  534601
  536944
  538396
  541203
  541320
  543123
  545303
  546355
  548991
  593132
  602067
  619829
  653326
  658162
  688458
  688768
  697607
  711130
  719772
  732494
  737360
  746385
  757300
]
19.71 ms
(13.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
  719772
  73143
  483767
  538396
  91954
  488684
  262435
  501048
  419656
  464347
  311005
  453762
  67555
  474605
  507008
  519810
  431911
  485855
  495003
  508666
  447703
  495858
  533269
  396546
  513685
  697607
  711130
  732494
  31218
  384147
  463991
  396217
  435742
  475177
  509264
  503442
  399222
  498305
  526346
  508243
  488529
  436020
  411913
  466703
  463386
  481618
  522190
  524824
  511652
  532200
  494313
  482362
  31245
  514028
  525714
  508650
  688458
  653326
  658162
  393145
  456250
  480966
  457895
  534601
  543123
  479519
  688768
  518182
  757300
  602067
  514931
  545303
  432975
  421350
  548991
  504347
  385073
  480083
  593132
  619829
  69611
  392632
  475369
  460076
  479528
  468349
  481445
  465616
  486820
  395389
  457198
  424179
  478609
  395459
  480032
  456522
  519598
  493755
  500377
  505883
  425113
  516136
  746385
  382045
  399062
  459986
  468350
  481217
  482950
  531973
  529961
  534430
  536944
  541320
  546355
  541203
  737360
  396572
  473316
  393063
]
2.10 ms
(1.39%)
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
  31218
  31245
  67555
  69611
  73143
  91954
  262435
  311005
  382045
  384147
  385073
  392632
  393063
  393145
  395389
  395459
  396217
  396546
  396572
  399062
  399222
  411913
  419656
  421350
  424179
  425113
  431911
  432975
  435742
  436020
  447703
  453762
  456250
  456522
  457198
  457895
  459986
  460076
  463386
  463991
  464347
  465616
  466703
  468349
  468350
  473316
  474605
  475177
  475369
  478609
  479519
  479528
  480032
  480083
  480966
  481217
  481445
  481618
  482362
  482950
  483767
  485855
  486820
  488529
  488684
  493755
  494313
  495003
  495858
  498305
  500377
  501048
  503442
  504347
  505883
  507008
  508243
  508650
  508666
  509264
  511652
  513685
  514028
  514931
  516136
  518182
  519598
  519810
  522190
  524824
  525714
  526346
  529961
  531973
  532200
  533269
  534430
  534601
  536944
  538396
  541203
  541320
  543123
  545303
  546355
  548991
  593132
  602067
  619829
  653326
  658162
  688458
  688768
  697607
  711130
  719772
  732494
  737360
  746385
  757300
]
1.93 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐÇð░ð║ð¥ð╝ Ðü ð▒ð¥ð╗ÐîÐêð©ð╝ ÐàðÁÐÇð¥ð╝ÔÔǪ"
]
1.88 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак большой большие член"
]
1.57 ms
(1.04%)
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.