Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.00 ms
(85.51%)
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
  21397
  58516
  79898
  194224
  238994
  278764
  279212
  322900
  372986
  382212
  385478
  388583
  391315
  392678
  397828
  401814
  405249
  405584
  407487
  409174
  411055
  411377
  413560
  424268
  429643
  451584
  455600
  456327
  458584
  462320
  462576
  469900
  470153
  471188
  471365
  473613
  487710
  491388
  492274
  493124
  497284
  499414
  500252
  503323
  504355
  506425
  506492
  542108
  560340
  563672
  568723
  584661
  592566
  597172
  599759
  602774
  608092
  611611
  615800
  617780
  623265
  625069
  630279
  635752
  640868
  640877
  644885
  650346
  650358
  651142
  667140
  667447
  672402
  673097
  688172
  689672
  694362
  702488
  719471
  719486
  721266
  721810
  722046
  725364
  725760
  727018
  729816
  730419
  731445
  736950
  743764
  748134
  750030
  753645
  761620
  762629
  764597
  765806
  772789
  778011
  778200
  779334
  785978
  787727
  789922
  791363
  792608
  796531
  798977
  798980
  798981
  798984
  799005
  802612
  817480
  818746
  820426
  820535
  821740
  826882
]
12.79 ms
(7.49%)
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
  382212
  372986
  667447
  731445
  640877
  826882
  743764
  560340
  470153
  462576
  765806
  597172
  650358
  798981
  748134
  762629
  471365
  21397
  730419
  689672
  79898
  672402
  725760
  388583
  694362
  322900
  506425
  58516
  409174
  725364
  729816
  778011
  608092
  411377
  798984
  802612
  791363
  753645
  750030
  635752
  278764
  615800
  820426
  821740
  722046
  736950
  761620
  779334
  796531
  719486
  798980
  787727
  424268
  778200
  630279
  592566
  789922
  623265
  617780
  451584
  817480
  500252
  640868
  238994
  497284
  407487
  584661
  644885
  405249
  563672
  491388
  772789
  764597
  391315
  194224
  456327
  792608
  504355
  611611
  785978
  385478
  411055
  413560
  820535
  799005
  798977
  279212
  818746
  673097
  492274
  506492
  721266
  599759
  702488
  651142
  727018
  487710
  499414
  392678
  473613
  397828
  405584
  719471
  429643
  458584
  542108
  602774
  401814
  462320
  471188
  469900
  503323
  455600
  688172
  721810
  568723
  625069
  493124
  650346
  667140
]
4.87 ms
(2.85%)
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
  21397
  58516
  79898
  194224
  238994
  278764
  279212
  322900
  372986
  382212
  385478
  388583
  391315
  392678
  397828
  401814
  405249
  405584
  407487
  409174
  411055
  411377
  413560
  424268
  429643
  451584
  455600
  456327
  458584
  462320
  462576
  469900
  470153
  471188
  471365
  473613
  487710
  491388
  492274
  493124
  497284
  499414
  500252
  503323
  504355
  506425
  506492
  542108
  560340
  563672
  568723
  584661
  592566
  597172
  599759
  602774
  608092
  611611
  615800
  617780
  623265
  625069
  630279
  635752
  640868
  640877
  644885
  650346
  650358
  651142
  667140
  667447
  672402
  673097
  688172
  689672
  694362
  702488
  719471
  719486
  721266
  721810
  722046
  725364
  725760
  727018
  729816
  730419
  731445
  736950
  743764
  748134
  750030
  753645
  761620
  762629
  764597
  765806
  772789
  778011
  778200
  779334
  785978
  787727
  789922
  791363
  792608
  796531
  798977
  798980
  798981
  798984
  799005
  802612
  817480
  818746
  820426
  820535
  821740
  826882
]
1.94 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс в автобус машин русс"
]
1.78 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет в автобусе русс%…"
]
1.73 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.96%)
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.