Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.42 ms
(83.35%)
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
  6651
  7051
  7329
  32999
  66907
  95586
  102892
  183634
  187723
  188009
  229361
  233512
  237362
  285923
  319863
  325867
  366010
  377323
  382439
  382802
  385138
  385314
  385999
  386189
  386212
  387856
  388200
  388888
  390525
  391077
  391635
  391656
  393580
  395714
  396110
  397075
  397288
  397412
  397867
  397901
  398387
  398545
  398557
  398885
  400486
  400592
  400820
  401189
  401491
  402226
  402700
  405749
  406587
  408245
  408532
  411215
  411468
  411615
  412273
  414319
  415300
  415786
  416969
  417808
  418058
  418072
  418837
  420853
  420886
  421618
  421849
  424296
  424556
  425279
  428512
  432304
  439791
  440263
  440963
  441419
  441453
  441530
  443695
  443735
  443901
  443905
  444942
  447335
  448524
  457228
  458704
  459061
  459843
  460773
  461318
  465915
  466198
  466244
  468399
  470424
  475901
  484342
  487338
  487389
  489881
  492346
  496524
  503499
  521816
  521885
  555912
  563127
  573918
  603807
  717469
  723230
  728240
  728445
  788284
  789552
]
15.66 ms
(10.49%)
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
  487338
  382439
  441453
  397412
  391635
  459061
  728445
  183634
  603807
  397867
  468399
  325867
  402700
  460773
  7051
  388888
  401491
  417808
  789552
  385138
  386212
  391656
  385999
  385314
  393580
  412273
  366010
  444942
  377323
  391077
  397075
  398387
  421618
  408532
  458704
  448524
  398885
  418058
  400486
  470424
  395714
  421849
  411468
  439791
  420886
  466198
  443905
  102892
  6651
  388200
  441419
  440263
  492346
  461318
  424296
  319863
  32999
  398545
  496524
  573918
  555912
  563127
  788284
  387856
  443695
  424556
  466244
  484342
  285923
  400592
  401189
  406587
  416969
  521816
  475901
  411215
  428512
  400820
  382802
  717469
  95586
  420853
  418837
  408245
  521885
  386189
  397901
  411615
  415786
  229361
  390525
  425279
  418072
  440963
  487389
  489881
  728240
  723230
  187723
  432304
  443735
  397288
  402226
  237362
  457228
  465915
  414319
  459843
  503499
  233512
  441530
  405749
  447335
  188009
  66907
  7329
  396110
  398557
  415300
  443901
]
2.41 ms
(1.61%)
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
  6651
  7051
  7329
  32999
  66907
  95586
  102892
  183634
  187723
  188009
  229361
  233512
  237362
  285923
  319863
  325867
  366010
  377323
  382439
  382802
  385138
  385314
  385999
  386189
  386212
  387856
  388200
  388888
  390525
  391077
  391635
  391656
  393580
  395714
  396110
  397075
  397288
  397412
  397867
  397901
  398387
  398545
  398557
  398885
  400486
  400592
  400820
  401189
  401491
  402226
  402700
  405749
  406587
  408245
  408532
  411215
  411468
  411615
  412273
  414319
  415300
  415786
  416969
  417808
  418058
  418072
  418837
  420853
  420886
  421618
  421849
  424296
  424556
  425279
  428512
  432304
  439791
  440263
  440963
  441419
  441453
  441530
  443695
  443735
  443901
  443905
  444942
  447335
  448524
  457228
  458704
  459061
  459843
  460773
  461318
  465915
  466198
  466244
  468399
  470424
  475901
  484342
  487338
  487389
  489881
  492346
  496524
  503499
  521816
  521885
  555912
  563127
  573918
  603807
  717469
  723230
  728240
  728445
  788284
  789552
]
2.06 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анальный секс парню"
]
1.63 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал парен"
]
1.62 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.98%)
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.