Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.91 ms
(85.43%)
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
  38908
  79479
  229210
  389295
  390288
  396041
  398413
  398842
  401336
  401575
  453393
  458524
  469810
  503235
  507261
  535726
  539164
  542331
  548256
  552642
  552648
  557237
  559015
  560936
  564896
  565991
  583393
  585237
  587689
  590369
  604539
  604928
  605685
  605899
  607448
  615307
  616585
  619003
  620938
  623748
  628075
  629813
  635011
  637504
  638160
  641767
  648898
  648917
  652298
  654819
  655124
  655346
  655977
  656068
  658692
  659502
  659569
  659584
  663883
  665605
  678823
  679084
  682606
  685019
  686059
  692845
  694128
  696024
  696366
  697153
  698491
  701690
  709074
  709506
  712501
  714419
  715608
  720090
  720104
  724107
  727721
  731738
  732701
  732838
  734700
  736687
  736840
  739256
  744366
  749564
  749835
  750747
  754366
  755416
  758681
  759580
  764078
  765518
  765645
  765751
  765762
  773330
  774727
  776909
  779378
  779436
  779748
  780284
  781601
  783009
  790335
  791222
  799325
  800748
  802250
  802342
  803770
  804680
  808016
  808298
]
12.69 ms
(8.48%)
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
  619003
  736687
  389295
  458524
  759580
  765762
  638160
  654819
  604539
  800748
  779748
  739256
  736840
  803770
  698491
  390288
  396041
  557237
  564896
  712501
  659569
  696024
  697153
  583393
  731738
  744366
  701690
  715608
  655124
  615307
  641767
  401575
  542331
  552648
  648917
  659502
  685019
  720104
  709074
  587689
  590369
  605685
  635011
  637504
  605899
  780284
  808298
  776909
  724107
  732701
  734700
  773330
  749835
  469810
  539164
  620938
  758681
  560936
  648898
  656068
  665605
  686059
  682606
  696366
  709506
  652298
  655977
  548256
  552642
  604928
  616585
  623748
  607448
  628075
  629813
  791222
  781601
  783009
  790335
  804680
  727721
  764078
  765518
  799325
  802250
  802342
  754366
  755416
  749564
  732838
  774727
  779378
  808016
  398413
  401336
  453393
  535726
  765751
  398842
  694128
  678823
  750747
  779436
  79479
  565991
  38908
  559015
  655346
  585237
  765645
  714419
  229210
  659584
  503235
  507261
  663883
  658692
  692845
  720090
  679084
]
2.36 ms
(1.57%)
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
  38908
  79479
  229210
  389295
  390288
  396041
  398413
  398842
  401336
  401575
  453393
  458524
  469810
  503235
  507261
  535726
  539164
  542331
  548256
  552642
  552648
  557237
  559015
  560936
  564896
  565991
  583393
  585237
  587689
  590369
  604539
  604928
  605685
  605899
  607448
  615307
  616585
  619003
  620938
  623748
  628075
  629813
  635011
  637504
  638160
  641767
  648898
  648917
  652298
  654819
  655124
  655346
  655977
  656068
  658692
  659502
  659569
  659584
  663883
  665605
  678823
  679084
  682606
  685019
  686059
  692845
  694128
  696024
  696366
  697153
  698491
  701690
  709074
  709506
  712501
  714419
  715608
  720090
  720104
  724107
  727721
  731738
  732701
  732838
  734700
  736687
  736840
  739256
  744366
  749564
  749835
  750747
  754366
  755416
  758681
  759580
  764078
  765518
  765645
  765751
  765762
  773330
  774727
  776909
  779378
  779436
  779748
  780284
  781601
  783009
  790335
  791222
  799325
  800748
  802250
  802342
  803770
  804680
  808016
  808298
]
2.02 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "смотрим порно и траха%…"
]
1.68 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "смотр порн секс"
]
1.59 ms
(1.06%)
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.