Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.05 ms
(82.90%)
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
  366354
  381917
  384030
  392028
  398655
  400497
  400498
  413161
  415636
  418747
  421836
  421851
  421868
  421918
  426515
  434251
  437965
  439770
  439780
  439791
  440894
  446293
  447296
  452620
  453230
  455357
  455406
  455428
  455523
  456926
  457444
  457542
  457572
  458942
  459946
  460348
  464679
  466005
  467801
  468896
  473866
  477453
  477614
  483983
  489249
  492199
  494809
  499295
  501028
  501506
  503993
  510761
  512577
  514610
  517059
  519838
  520889
  521410
  524486
  524499
  526026
  527060
  528128
  528777
  529907
  533874
  533880
  533920
  535433
  535446
  544834
  552071
  556966
  558461
  558883
  561345
  563570
  566107
  566128
  578678
  580866
  584192
  586398
  589634
  590987
  591033
  591453
  592386
  592840
  600829
  609227
  617277
  625089
  639788
  642162
  642290
  642331
  668139
  697002
  705327
  705346
  711685
  726538
  726546
  736137
  768844
  770947
  787719
  790874
  790882
  791730
  796105
  796566
  797756
  798059
  803428
  804677
  809502
  810297
  818142
]
21.74 ms
(11.93%)
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
  483983
  503993
  521410
  566107
  711685
  552071
  556966
  600829
  642290
  768844
  770947
  705327
  797756
  455357
  466005
  456926
  421851
  494809
  492199
  426515
  459946
  810297
  467801
  421918
  524486
  413161
  578678
  400498
  787719
  589634
  591033
  563570
  418747
  439780
  558883
  561345
  668139
  398655
  586398
  439770
  439791
  818142
  384030
  381917
  415636
  440894
  434251
  477614
  452620
  455523
  457572
  460348
  533920
  499295
  524499
  526026
  527060
  528128
  580866
  705346
  584192
  590987
  617277
  642162
  609227
  591453
  592386
  625089
  639788
  642331
  592840
  790882
  790874
  791730
  796105
  804677
  809502
  796566
  726538
  736137
  726546
  697002
  803428
  392028
  457542
  421836
  468896
  437965
  458942
  447296
  455406
  455428
  477453
  520889
  529907
  514610
  519838
  489249
  512577
  533874
  528777
  535433
  535446
  558461
  501506
  533880
  798059
  366354
  453230
  446293
  464679
  501028
  510761
  566128
  473866
  400497
  544834
  457444
  421868
  517059
]
2.34 ms
(1.29%)
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
  366354
  381917
  384030
  392028
  398655
  400497
  400498
  413161
  415636
  418747
  421836
  421851
  421868
  421918
  426515
  434251
  437965
  439770
  439780
  439791
  440894
  446293
  447296
  452620
  453230
  455357
  455406
  455428
  455523
  456926
  457444
  457542
  457572
  458942
  459946
  460348
  464679
  466005
  467801
  468896
  473866
  477453
  477614
  483983
  489249
  492199
  494809
  499295
  501028
  501506
  503993
  510761
  512577
  514610
  517059
  519838
  520889
  521410
  524486
  524499
  526026
  527060
  528128
  528777
  529907
  533874
  533880
  533920
  535433
  535446
  544834
  552071
  556966
  558461
  558883
  561345
  563570
  566107
  566128
  578678
  580866
  584192
  586398
  589634
  590987
  591033
  591453
  592386
  592840
  600829
  609227
  617277
  625089
  639788
  642162
  642290
  642331
  668139
  697002
  705327
  705346
  711685
  726538
  726546
  736137
  768844
  770947
  787719
  790874
  790882
  791730
  796105
  796566
  797756
  798059
  803428
  804677
  809502
  810297
  818142
]
2.00 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass kitchen"
]
1.66 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп кухн"
]
1.50 ms
(0.82%)
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.