Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.07 ms
(85.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
  3335
  221091
  301977
  386329
  386408
  391908
  396903
  405423
  413643
  426111
  435645
  458346
  470593
  470667
  478541
  479706
  507809
  508723
  516083
  528149
  528583
  530286
  532715
  533523
  536544
  537001
  543360
  543421
  545077
  545085
  546675
  547946
  547983
  552005
  552008
  554811
  554816
  557937
  557945
  561046
  563407
  566451
  579077
  581552
  583446
  587263
  592373
  593857
  593885
  603244
  603544
  605583
  606471
  608331
  616688
  622086
  622110
  624985
  624998
  628184
  631329
  632250
  633179
  634305
  635787
  635856
  642524
  649087
  649208
  649276
  651317
  651420
  651886
  653175
  653593
  653854
  654276
  671243
  675936
  675953
  676283
  677081
  677584
  692463
  694027
  694346
  709411
  710263
  710407
  711013
  719808
  725335
  729266
  731113
  732690
  738936
  742691
  745917
  747159
  750741
  768227
  771965
  773528
  773948
  782468
  784322
  784850
  786153
  792480
  793629
  795151
  799233
  801533
  802953
  805819
  813050
  824498
  826217
  827104
  827106
]
15.42 ms
(8.59%)
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
  676283
  813050
  827106
  710263
  545077
  725335
  729266
  773528
  710407
  795151
  631329
  543360
  552008
  649087
  771965
  435645
  557937
  675936
  587263
  532715
  583446
  651886
  386329
  802953
  675953
  719808
  603544
  547946
  545085
  554816
  552005
  692463
  3335
  826217
  563407
  547983
  530286
  533523
  528583
  799233
  824498
  731113
  386408
  738936
  742691
  546675
  750741
  508723
  677081
  653854
  793629
  554811
  561046
  671243
  651317
  616688
  624998
  628184
  624985
  528149
  557945
  634305
  413643
  566451
  593857
  635856
  732690
  507809
  581552
  603244
  470593
  221091
  654276
  622086
  632250
  768227
  711013
  543421
  405423
  579077
  784322
  792480
  827104
  537001
  649208
  709411
  608331
  786153
  773948
  745917
  470667
  426111
  478541
  391908
  479706
  458346
  396903
  801533
  805819
  536544
  651420
  694027
  694346
  649276
  653175
  677584
  653593
  593885
  633179
  642524
  605583
  606471
  635787
  622110
  592373
  784850
  747159
  516083
  301977
  782468
]
2.70 ms
(1.51%)
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
  3335
  221091
  301977
  386329
  386408
  391908
  396903
  405423
  413643
  426111
  435645
  458346
  470593
  470667
  478541
  479706
  507809
  508723
  516083
  528149
  528583
  530286
  532715
  533523
  536544
  537001
  543360
  543421
  545077
  545085
  546675
  547946
  547983
  552005
  552008
  554811
  554816
  557937
  557945
  561046
  563407
  566451
  579077
  581552
  583446
  587263
  592373
  593857
  593885
  603244
  603544
  605583
  606471
  608331
  616688
  622086
  622110
  624985
  624998
  628184
  631329
  632250
  633179
  634305
  635787
  635856
  642524
  649087
  649208
  649276
  651317
  651420
  651886
  653175
  653593
  653854
  654276
  671243
  675936
  675953
  676283
  677081
  677584
  692463
  694027
  694346
  709411
  710263
  710407
  711013
  719808
  725335
  729266
  731113
  732690
  738936
  742691
  745917
  747159
  750741
  768227
  771965
  773528
  773948
  782468
  784322
  784850
  786153
  792480
  793629
  795151
  799233
  801533
  802953
  805819
  813050
  824498
  826217
  827104
  827106
]
2.32 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.26 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome amateur"
]
1.94 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро любительск"
]
1.71 ms
(0.95%)
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.