Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.42 ms
(87.62%)
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
  114360
  140181
  156525
  383744
  384527
  384793
  388591
  390363
  394103
  394243
  396983
  401119
  407177
  408000
  415722
  417303
  417634
  419843
  445565
  445928
  447850
  448584
  453843
  454785
  456952
  462546
  470340
  484832
  487173
  488352
  492061
  495750
  502119
  502435
  502441
  507814
  511515
  512319
  521235
  534778
  538406
  539013
  547082
  549397
  550285
  551149
  552008
  552898
  563986
  576371
  580710
  581001
  583688
  585159
  593622
  593672
  593853
  593858
  593883
  594774
  596604
  601958
  613001
  617664
  624866
  625532
  628185
  630908
  641757
  650810
  650818
  651940
  652202
  652577
  653740
  654269
  659305
  663467
  663482
  663493
  665123
  665182
  667290
  669430
  670513
  674330
  676907
  677587
  693410
  693772
  703212
  706933
  711286
  712823
  714086
  717631
  723592
  724410
  728370
  729536
  730098
  730914
  731801
  734825
  737098
  737728
  741203
  742834
  745999
  747249
  748552
  748999
  750809
  753257
  776892
  780774
  796970
  807677
  808167
  825500
]
15.09 ms
(7.25%)
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
  613001
  594774
  593883
  741203
  731801
  750809
  734825
  453843
  484832
  114360
  156525
  447850
  445928
  521235
  550285
  651940
  652202
  677587
  654269
  659305
  676907
  706933
  712823
  714086
  717631
  650810
  665123
  630908
  807677
  729536
  748999
  753257
  737728
  745999
  748552
  808167
  470340
  492061
  487173
  538406
  140181
  384527
  625532
  384793
  723592
  825500
  534778
  495750
  547082
  551149
  669430
  670513
  617664
  593858
  776892
  747249
  711286
  780774
  415722
  454785
  419843
  796970
  401119
  693410
  593853
  552008
  653740
  390363
  663482
  641757
  394103
  383744
  552898
  511515
  549397
  663467
  585159
  388591
  408000
  417303
  456952
  502119
  539013
  580710
  583688
  576371
  581001
  667290
  674330
  693772
  624866
  593622
  596604
  724410
  448584
  462546
  488352
  502435
  417634
  394243
  396983
  407177
  507814
  502441
  512319
  665182
  650818
  652577
  703212
  663493
  563986
  628185
  593672
  601958
  730914
  737098
  728370
  730098
  742834
  445565
]
3.40 ms
(1.64%)
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
  114360
  140181
  156525
  383744
  384527
  384793
  388591
  390363
  394103
  394243
  396983
  401119
  407177
  408000
  415722
  417303
  417634
  419843
  445565
  445928
  447850
  448584
  453843
  454785
  456952
  462546
  470340
  484832
  487173
  488352
  492061
  495750
  502119
  502435
  502441
  507814
  511515
  512319
  521235
  534778
  538406
  539013
  547082
  549397
  550285
  551149
  552008
  552898
  563986
  576371
  580710
  581001
  583688
  585159
  593622
  593672
  593853
  593858
  593883
  594774
  596604
  601958
  613001
  617664
  624866
  625532
  628185
  630908
  641757
  650810
  650818
  651940
  652202
  652577
  653740
  654269
  659305
  663467
  663482
  663493
  665123
  665182
  667290
  669430
  670513
  674330
  676907
  677587
  693410
  693772
  703212
  706933
  711286
  712823
  714086
  717631
  723592
  724410
  728370
  729536
  730098
  730914
  731801
  734825
  737098
  737728
  741203
  742834
  745999
  747249
  748552
  748999
  750809
  753257
  776892
  780774
  796970
  807677
  808167
  825500
]
2.17 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens sex"
]
1.88 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens секс"
]
1.68 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens секс"
]

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.