Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.67 ms
(86.31%)
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
  524969
  538865
  538892
  538945
  541313
  541651
  542493
  542500
  543475
  544274
  544325
  546447
  548297
  549767
  556597
  556842
  561033
  561615
  562838
  563133
  563137
  563139
  563198
  563213
  563221
  563383
  563423
  563445
  566673
  567396
  568362
  571241
  573392
  574222
  576625
  576647
  576651
  576676
  576694
  577370
  580258
  580852
  581119
  581269
  583882
  589640
  589700
  589747
  592463
  592494
  593236
  593447
  593820
  595842
  598058
  598373
  600712
  605305
  615741
  615744
  619082
  619468
  619482
  620142
  620156
  621312
  621322
  622372
  624154
  624790
  624792
  628312
  633161
  644280
  644331
  644639
  648204
  648256
  649498
  649560
  650494
  651210
  651684
  652876
  669566
  670107
  671734
  672117
  672745
  677706
  681059
  690902
  694203
  694563
  695249
  695276
  695613
  695626
  697368
  697369
  697790
  698550
  703048
  703511
  706611
  707306
  708422
  711903
  711907
  716409
  717859
  719873
  724241
  727828
  731305
  734493
  744294
  748471
  789844
  808093
]
16.54 ms
(8.77%)
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
  581269
  563221
  576625
  576676
  576694
  580258
  690902
  707306
  648204
  648256
  649498
  711903
  670107
  562838
  577370
  592463
  619082
  589747
  615741
  605305
  619468
  628312
  589640
  624154
  615744
  621312
  644280
  644639
  581119
  697790
  593820
  624792
  538945
  556597
  556842
  567396
  583882
  542500
  544274
  574222
  561615
  563445
  649560
  650494
  695276
  716409
  677706
  694563
  697369
  706611
  717859
  719873
  671734
  695249
  708422
  561033
  563137
  563213
  563423
  598058
  622372
  620142
  595842
  620156
  593236
  619482
  789844
  808093
  727828
  734493
  698550
  568362
  563198
  524969
  538865
  538892
  541313
  573392
  580852
  563383
  566673
  542493
  544325
  563139
  651210
  651684
  652876
  669566
  672117
  681059
  672745
  694203
  695613
  695626
  703048
  711907
  697368
  576647
  598373
  589700
  592494
  593447
  633161
  600712
  621322
  744294
  724241
  731305
  748471
  624790
  644331
  703511
  548297
  546447
  541651
  543475
  549767
  576651
  563133
  571241
]
3.32 ms
(1.76%)
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
  524969
  538865
  538892
  538945
  541313
  541651
  542493
  542500
  543475
  544274
  544325
  546447
  548297
  549767
  556597
  556842
  561033
  561615
  562838
  563133
  563137
  563139
  563198
  563213
  563221
  563383
  563423
  563445
  566673
  567396
  568362
  571241
  573392
  574222
  576625
  576647
  576651
  576676
  576694
  577370
  580258
  580852
  581119
  581269
  583882
  589640
  589700
  589747
  592463
  592494
  593236
  593447
  593820
  595842
  598058
  598373
  600712
  605305
  615741
  615744
  619082
  619468
  619482
  620142
  620156
  621312
  621322
  622372
  624154
  624790
  624792
  628312
  633161
  644280
  644331
  644639
  648204
  648256
  649498
  649560
  650494
  651210
  651684
  652876
  669566
  670107
  671734
  672117
  672745
  677706
  681059
  690902
  694203
  694563
  695249
  695276
  695613
  695626
  697368
  697369
  697790
  698550
  703048
  703511
  706611
  707306
  708422
  711903
  711907
  716409
  717859
  719873
  724241
  727828
  731305
  734493
  744294
  748471
  789844
  808093
]
1.67 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ретро зрелой"
]
1.50 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр зрелая женщин"
]
1.43 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.72%)
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.