Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.45 ms
(87.88%)
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
  91891
  384853
  386915
  387080
  392623
  398784
  399195
  400210
  400894
  402034
  408940
  409759
  428484
  428966
  436644
  443127
  451518
  454907
  459600
  466704
  467792
  473023
  492808
  504208
  510640
  512650
  515734
  516143
  547566
  548295
  550549
  552161
  552192
  552696
  556899
  559907
  566366
  566574
  569763
  569847
  570004
  570218
  570301
  570454
  571885
  571887
  571893
  571922
  573647
  573708
  577570
  578033
  579236
  580361
  581600
  583612
  590441
  594267
  594339
  595777
  596507
  597553
  598533
  598592
  600063
  603105
  611754
  611924
  614445
  617968
  622858
  626239
  637189
  653552
  655601
  670373
  672492
  672891
  674327
  676769
  676974
  679354
  680493
  680650
  686585
  693032
  693883
  693962
  695826
  708718
  714297
  716534
  723504
  723820
  728260
  732060
  740758
  746555
  750710
  751332
  753155
  755897
  764719
  766219
  769070
  770436
  775112
  775384
  778915
  786513
  793630
  801232
  803658
  804053
  804825
  807541
  809299
  810725
  818582
  821443
]
12.93 ms
(6.91%)
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
  552161
  556899
  566366
  569847
  570004
  570454
  577570
  547566
  548295
  550549
  552696
  559907
  570218
  570301
  571885
  571893
  571922
  573708
  578033
  579236
  580361
  581600
  583612
  672891
  676974
  653552
  655601
  672492
  674327
  676769
  680493
  693032
  693962
  695826
  714297
  670373
  679354
  680650
  686585
  693883
  708718
  716534
  552192
  566574
  569763
  571887
  573647
  590441
  594339
  617968
  637189
  597553
  611754
  611924
  614445
  622858
  594267
  598533
  600063
  603105
  595777
  596507
  626239
  775384
  807541
  801232
  809299
  750710
  751332
  769070
  793630
  803658
  804825
  810725
  732060
  766219
  723820
  755897
  746555
  728260
  740758
  753155
  764719
  770436
  723504
  775112
  778915
  786513
  804053
  466704
  387080
  392623
  400210
  400894
  408940
  409759
  428966
  436644
  386915
  398784
  454907
  459600
  467792
  473023
  402034
  451518
  510640
  515734
  516143
  492808
  512650
  598592
  504208
  384853
  91891
  399195
  428484
  443127
  818582
  821443
]
3.24 ms
(1.73%)
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
  91891
  384853
  386915
  387080
  392623
  398784
  399195
  400210
  400894
  402034
  408940
  409759
  428484
  428966
  436644
  443127
  451518
  454907
  459600
  466704
  467792
  473023
  492808
  504208
  510640
  512650
  515734
  516143
  547566
  548295
  550549
  552161
  552192
  552696
  556899
  559907
  566366
  566574
  569763
  569847
  570004
  570218
  570301
  570454
  571885
  571887
  571893
  571922
  573647
  573708
  577570
  578033
  579236
  580361
  581600
  583612
  590441
  594267
  594339
  595777
  596507
  597553
  598533
  598592
  600063
  603105
  611754
  611924
  614445
  617968
  622858
  626239
  637189
  653552
  655601
  670373
  672492
  672891
  674327
  676769
  676974
  679354
  680493
  680650
  686585
  693032
  693883
  693962
  695826
  708718
  714297
  716534
  723504
  723820
  728260
  732060
  740758
  746555
  750710
  751332
  753155
  755897
  764719
  766219
  769070
  770436
  775112
  775384
  778915
  786513
  793630
  801232
  803658
  804053
  804825
  807541
  809299
  810725
  818582
  821443
]
1.89 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny hot"
]
1.63 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые hot"
]
1.62 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые hot"
]

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.