Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.91 ms
(86.59%)
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
  140007
  391656
  401648
  403258
  408611
  415774
  417370
  422003
  424061
  441490
  441749
  447032
  458130
  468272
  473721
  486209
  488243
  489276
  495032
  533528
  536824
  546294
  547402
  557203
  557712
  588419
  590415
  591923
  599363
  606072
  610366
  616183
  617496
  623403
  626121
  629547
  631490
  631551
  636655
  638720
  641038
  645728
  650526
  655192
  663720
  664410
  675789
  687126
  690165
  693495
  697592
  698809
  703328
  703764
  704355
  707741
  714012
  718139
  719347
  720089
  724250
  724820
  724889
  725483
  726932
  727008
  727046
  730036
  731350
  733284
  737300
  740261
  740757
  740911
  746374
  747260
  747435
  750407
  753565
  756785
  757459
  757521
  758753
  762827
  763087
  764889
  765434
  773430
  774590
  777731
  777998
  778207
  778438
  779124
  779150
  779254
  782379
  783019
  783129
  787263
  787769
  788363
  791530
  791627
  792437
  792469
  792635
  792803
  793068
  793104
  794067
  794935
  794938
  797473
  801282
  801502
  803274
  812558
]
10.04 ms
(6.40%)
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
  557712
  546294
  707741
  718139
  650526
  675789
  697592
  655192
  693495
  703764
  606072
  626121
  610366
  623403
  629547
  631490
  631551
  638720
  792803
  725483
  740911
  758753
  767421
  793068
  794067
  794935
  794938
  803274
  724250
  747435
  753565
  773430
  747260
  756785
  733284
  762827
  765434
  641038
  778438
  783129
  787769
  403258
  401648
  441749
  408611
  441490
  489276
  533528
  536824
  663720
  792635
  777998
  801282
  730036
  750407
  757521
  763087
  740757
  757459
  415774
  417370
  488243
  557203
  591923
  422003
  447032
  468272
  495032
  590415
  791627
  391656
  424061
  458130
  140007
  473721
  486209
  547402
  714012
  645728
  704355
  720089
  664410
  687126
  690165
  703328
  719347
  588419
  616183
  636655
  617496
  599363
  774590
  779124
  779150
  779254
  791530
  792437
  792469
  793104
  782379
  783019
  801502
  812558
  724889
  746374
  787263
  797473
  726932
  764889
  727008
  737300
  766525
  740261
  724820
  727046
  731350
  698809
  777731
  778207
  788363
]
2.89 ms
(1.84%)
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
  140007
  391656
  401648
  403258
  408611
  415774
  417370
  422003
  424061
  441490
  441749
  447032
  458130
  468272
  473721
  486209
  488243
  489276
  495032
  533528
  536824
  546294
  547402
  557203
  557712
  588419
  590415
  591923
  599363
  606072
  610366
  616183
  617496
  623403
  626121
  629547
  631490
  631551
  636655
  638720
  641038
  645728
  650526
  655192
  663720
  664410
  675789
  687126
  690165
  693495
  697592
  698809
  703328
  703764
  704355
  707741
  714012
  718139
  719347
  720089
  724250
  724820
  724889
  725483
  726932
  727008
  727046
  730036
  731350
  733284
  737300
  740261
  740757
  740911
  746374
  747260
  747435
  750407
  753565
  756785
  757459
  757521
  758753
  762827
  763087
  764889
  765434
  773430
  774590
  777731
  777998
  778207
  778438
  779124
  779150
  779254
  782379
  783019
  783129
  787263
  787769
  788363
  791530
  791627
  792437
  792469
  792635
  792803
  793068
  793104
  794067
  794935
  794938
  797473
  801282
  801502
  803274
  812558
]
2.16 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тугие задницы"
]
2.12 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "туг жоп"
]
1.80 ms
(1.14%)
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.