Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.26 ms
(81.36%)
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
  187643
  381942
  392079
  401404
  401961
  405852
  409577
  409694
  411054
  438567
  446926
  447019
  447021
  465724
  468249
  469068
  473502
  491099
  491225
  492404
  492439
  492441
  509176
  514450
  515804
  529740
  530126
  530405
  530856
  531373
  531787
  531997
  532454
  532806
  535117
  535818
  536321
  536468
  536493
  536567
  536720
  537827
  538721
  539647
  542723
  543940
  544236
  546046
  546084
  548049
  550499
  550534
  551843
  556763
  559342
  561494
  563563
  567564
  568213
  569370
  569376
  576772
  578202
  578712
  581651
  582452
  583992
  645704
  646084
  648453
  648649
  649437
  650064
  650608
  652992
  653028
  655926
  656801
  661580
  664230
  664573
  666070
  666091
  666114
  667350
  668700
  669915
  680933
  687325
  698156
  698575
  709519
  710374
  711624
  814182
  819628
  819808
  823780
  824531
  824634
  824685
  824837
  825324
  825333
  825340
  825365
  825437
  825789
  826601
  826698
  826701
  826703
  827143
  827183
  827184
  827287
  827502
  827693
  827724
]
16.69 ms
(11.39%)
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
  187643
  392079
  381942
  401961
  401404
  405852
  438567
  411054
  409577
  409694
  814182
  825437
  825789
  826601
  826701
  826703
  826698
  819808
  825324
  825333
  827143
  827184
  827183
  827287
  827724
  827502
  827693
  823780
  824531
  824634
  825365
  819628
  824685
  824837
  825340
  447021
  468249
  473502
  492404
  492441
  446926
  491225
  447019
  491099
  492439
  509176
  514450
  530405
  535117
  537827
  529740
  530126
  530856
  531997
  532806
  536493
  538721
  515804
  531373
  532454
  535818
  536321
  536468
  536567
  536720
  539647
  531787
  465724
  469068
  544236
  569370
  581651
  582452
  583992
  542723
  543940
  546084
  546559
  550499
  550534
  551843
  559342
  563563
  568213
  576772
  578202
  578712
  548049
  567564
  645704
  648649
  650064
  650608
  653028
  666070
  666114
  668700
  669915
  710374
  711624
  648453
  656801
  667350
  687325
  698156
  709519
  646084
  649437
  652992
  655926
  661580
  664230
  664573
  666091
  680933
  698575
  546046
  556763
  561494
  569376
]
2.84 ms
(1.94%)
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
  187643
  381942
  392079
  401404
  401961
  405852
  409577
  409694
  411054
  438567
  446926
  447019
  447021
  465724
  468249
  469068
  473502
  491099
  491225
  492404
  492439
  492441
  509176
  514450
  515804
  529740
  530126
  530405
  530856
  531373
  531787
  531997
  532454
  532806
  535117
  535818
  536321
  536468
  536493
  536567
  536720
  537827
  538721
  539647
  542723
  543940
  544236
  546046
  546084
  548049
  550499
  550534
  551843
  556763
  559342
  561494
  563563
  567564
  568213
  569370
  569376
  576772
  578202
  578712
  581651
  582452
  583992
  645704
  646084
  648453
  648649
  649437
  650064
  650608
  652992
  653028
  655926
  656801
  661580
  664230
  664573
  666070
  666091
  666114
  667350
  668700
  669915
  680933
  687325
  698156
  698575
  709519
  710374
  711624
  814182
  819628
  819808
  823780
  824531
  824634
  824685
  824837
  825324
  825333
  825340
  825365
  825437
  825789
  826601
  826698
  826701
  826703
  827143
  827183
  827184
  827287
  827502
  827693
  827724
]
2.24 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло толстушка"
]
2.08 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло полная"
]
1.64 ms
(1.12%)
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.