Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.86 ms
(84.50%)
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
  12309
  39285
  70150
  81173
  310945
  340242
  382818
  383971
  386650
  387195
  389743
  391032
  391491
  392872
  398977
  417283
  418717
  419223
  419927
  422302
  435799
  436418
  438764
  459776
  469388
  478524
  485640
  494164
  503034
  514126
  529339
  544317
  554225
  556552
  561243
  575303
  581744
  584997
  589034
  590266
  593181
  595634
  595695
  606101
  623656
  626489
  626495
  627635
  628681
  648169
  670801
  675536
  678187
  686583
  692967
  703662
  709244
  715746
  716597
  716650
  719130
  719775
  723127
  723131
  723287
  729270
  734424
  743633
  745572
  756258
  761639
  762635
  762638
  763228
  763457
  764555
  765734
  767398
  768358
  768807
  769668
  769859
  771516
  771568
  771710
  772258
  774711
  778671
  778739
  779037
  779997
  780925
  782011
  782941
  783223
  783760
  783763
  786421
  789768
  791702
  791705
  792493
  793397
  793693
  793747
  793766
  795005
  798163
  798251
  798339
  798636
  799488
  803038
  804220
  810592
  813306
  814022
  814311
  814368
  819728
]
14.02 ms
(9.41%)
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
  799488
  723287
  595634
  589034
  798636
  745572
  392872
  419927
  503034
  626489
  791705
  765734
  709244
  419223
  435799
  438764
  391032
  469388
  398977
  814368
  623656
  715746
  792493
  386650
  340242
  798163
  793747
  791702
  769668
  763457
  819728
  814311
  764555
  719775
  529339
  310945
  575303
  590266
  734424
  762635
  780925
  793397
  648169
  581744
  556552
  436418
  81173
  814022
  675536
  703662
  70150
  391491
  686583
  778671
  12309
  478524
  692967
  593181
  789768
  793693
  798251
  803038
  743633
  761639
  779997
  782011
  783223
  804220
  813306
  418717
  670801
  389743
  756258
  810592
  771568
  729270
  606101
  716597
  768807
  771710
  382818
  387195
  584997
  786421
  544317
  769859
  459776
  595695
  762638
  627635
  494164
  793766
  774711
  798339
  719130
  39285
  716650
  628681
  779037
  422302
  783763
  723127
  768358
  772258
  771516
  783760
  514126
  723131
  626495
  554225
  795005
  763228
  767398
  485640
  561243
  678187
  782941
  778739
  417283
  383971
]
2.39 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
  12309
  39285
  70150
  81173
  310945
  340242
  382818
  383971
  386650
  387195
  389743
  391032
  391491
  392872
  398977
  417283
  418717
  419223
  419927
  422302
  435799
  436418
  438764
  459776
  469388
  478524
  485640
  494164
  503034
  514126
  529339
  544317
  554225
  556552
  561243
  575303
  581744
  584997
  589034
  590266
  593181
  595634
  595695
  606101
  623656
  626489
  626495
  627635
  628681
  648169
  670801
  675536
  678187
  686583
  692967
  703662
  709244
  715746
  716597
  716650
  719130
  719775
  723127
  723131
  723287
  729270
  734424
  743633
  745572
  756258
  761639
  762635
  762638
  763228
  763457
  764555
  765734
  767398
  768358
  768807
  769668
  769859
  771516
  771568
  771710
  772258
  774711
  778671
  778739
  779037
  779997
  780925
  782011
  782941
  783223
  783760
  783763
  786421
  789768
  791702
  791705
  792493
  793397
  793693
  793747
  793766
  795005
  798163
  798251
  798339
  798636
  799488
  803038
  804220
  810592
  813306
  814022
  814311
  814368
  819728
]
1.91 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "глубокий минет сперма"
]
1.69 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глубокийминет минет оральн секс сперм"
]
1.58 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.00%)
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.