Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.52 ms
(86.30%)
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
  392739
  394433
  395523
  398747
  411346
  533491
  562997
  563083
  563185
  565648
  568343
  577174
  657776
  675359
  680619
  686620
  689079
  689369
  698958
  700611
  708259
  709346
  711650
  712321
  712642
  712669
  713438
  714750
  714888
  714908
  714966
  716460
  716586
  717927
  718119
  718967
  719246
  720517
  721392
  721754
  723565
  725588
  726568
  728919
  729255
  729662
  730998
  731399
  734081
  734173
  735518
  736575
  737944
  739555
  740974
  742723
  743011
  744160
  747251
  749416
  749760
  750305
  750396
  753732
  754990
  756325
  757848
  758200
  760989
  761278
  765305
  771685
  777159
  777675
  779533
  781496
  781650
  781710
  781747
  789350
  792523
  794598
  794603
  795046
  795299
  795475
  796001
  796044
  797150
  798676
  798888
  799253
  801269
  801436
  803080
  804431
  804500
  805713
  806166
  809968
  811562
  814303
  817567
  817692
  818510
  819661
  819851
  819929
  820736
  823591
  823637
  824057
  824350
  824451
  825261
  825277
  825296
  825825
  826996
]
14.22 ms
(7.99%)
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
  562997
  577174
  714966
  689079
  714888
  719246
  563185
  794598
  811562
  779533
  795046
  804431
  743011
  731399
  734081
  739555
  747251
  756325
  750305
  760989
  737944
  740974
  750396
  771685
  777159
  798888
  395523
  804500
  729255
  714750
  392739
  394433
  723565
  824350
  712669
  686620
  714908
  720517
  675359
  711650
  718967
  798676
  794603
  801269
  806166
  789350
  728919
  725588
  744160
  712642
  713438
  779805
  819929
  712321
  777675
  799253
  809968
  753732
  761278
  796001
  735518
  734173
  749760
  765305
  781650
  398747
  823637
  826996
  817567
  818510
  819661
  823591
  825296
  819851
  820736
  824057
  825261
  825825
  533491
  563083
  565648
  568343
  708259
  721392
  680619
  698958
  657776
  689369
  716460
  717927
  781710
  781496
  781747
  801436
  754990
  795299
  805713
  730998
  736575
  758200
  742723
  757848
  726568
  700611
  709346
  716586
  718119
  721754
  792523
  795475
  797150
  817692
  749416
  729662
  411346
  814303
  824451
  825277
  796044
  803080
]
3.22 ms
(1.81%)
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
  392739
  394433
  395523
  398747
  411346
  533491
  562997
  563083
  563185
  565648
  568343
  577174
  657776
  675359
  680619
  686620
  689079
  689369
  698958
  700611
  708259
  709346
  711650
  712321
  712642
  712669
  713438
  714750
  714888
  714908
  714966
  716460
  716586
  717927
  718119
  718967
  719246
  720517
  721392
  721754
  723565
  725588
  726568
  728919
  729255
  729662
  730998
  731399
  734081
  734173
  735518
  736575
  737944
  739555
  740974
  742723
  743011
  744160
  747251
  749416
  749760
  750305
  750396
  753732
  754990
  756325
  757848
  758200
  760989
  761278
  765305
  771685
  777159
  777675
  779533
  781496
  781650
  781710
  781747
  789350
  792523
  794598
  794603
  795046
  795299
  795475
  796001
  796044
  797150
  798676
  798888
  799253
  801269
  801436
  803080
  804431
  804500
  805713
  806166
  809968
  811562
  814303
  817567
  817692
  818510
  819661
  819851
  819929
  820736
  823591
  823637
  824057
  824350
  824451
  825261
  825277
  825296
  825825
  826996
]
1.93 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс stepson"
]
1.83 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck stepson"
]
1.61 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс stepson"
]
1.57 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.