Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.75 ms
(87.75%)
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
  405156
  462785
  488925
  495210
  496136
  501080
  506413
  526978
  533582
  533826
  534917
  538738
  538758
  542000
  545078
  547119
  548394
  549443
  549995
  552713
  555429
  556913
  557444
  558979
  567500
  576158
  576424
  579306
  580998
  581285
  583779
  585293
  587121
  590306
  592151
  605058
  606813
  620707
  622020
  626202
  627672
  627833
  632792
  633217
  635640
  639345
  639525
  639881
  644906
  646727
  648485
  649840
  659328
  661316
  661327
  661330
  661358
  661373
  661378
  661381
  661575
  668403
  669868
  671088
  671098
  672357
  680741
  687751
  692435
  692686
  695647
  695654
  695660
  695682
  695814
  695962
  696019
  696385
  697088
  702359
  705104
  706067
  719876
  719893
  721899
  721956
  726931
  728278
  744011
  746633
  768969
  769931
  770246
  773468
  779605
  780142
  780155
  780627
  780666
  782119
  788892
  789035
  789345
  789632
  790098
  791472
  793044
  798751
  799723
  800469
  802915
  802922
  803948
  810598
  812217
  812240
  828042
  828123
  828269
]
14.26 ms
(7.00%)
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
  605058
  556913
  555429
  462785
  405156
  659328
  719893
  547119
  661330
  538738
  549443
  627672
  697088
  495210
  590306
  661575
  587121
  812217
  793044
  769931
  770246
  803948
  661378
  768969
  702359
  828042
  639881
  812240
  790098
  810598
  488925
  501080
  526978
  695647
  719876
  626202
  828269
  695814
  798751
  789035
  639345
  779605
  576158
  558979
  552713
  567500
  671098
  669868
  695682
  620707
  622020
  780155
  789345
  726931
  533582
  579306
  671088
  583779
  632792
  746633
  828156
  548394
  506413
  649840
  661358
  695654
  549995
  635640
  606813
  802915
  802922
  780142
  791472
  680741
  828123
  661327
  696019
  706067
  695660
  692686
  695962
  580998
  799723
  627833
  788892
  644906
  538758
  496136
  533826
  534917
  557444
  542000
  581285
  661381
  687751
  648485
  661316
  661373
  672357
  692435
  705104
  721956
  646727
  668403
  696385
  545078
  576424
  585293
  633217
  639525
  592151
  780627
  780666
  782119
  789632
  800469
  744011
  728278
  773468
  721899
]
2.80 ms
(1.38%)
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
  405156
  462785
  488925
  495210
  496136
  501080
  506413
  526978
  533582
  533826
  534917
  538738
  538758
  542000
  545078
  547119
  548394
  549443
  549995
  552713
  555429
  556913
  557444
  558979
  567500
  576158
  576424
  579306
  580998
  581285
  583779
  585293
  587121
  590306
  592151
  605058
  606813
  620707
  622020
  626202
  627672
  627833
  632792
  633217
  635640
  639345
  639525
  639881
  644906
  646727
  648485
  649840
  659328
  661316
  661327
  661330
  661358
  661373
  661378
  661381
  661575
  668403
  669868
  671088
  671098
  672357
  680741
  687751
  692435
  692686
  695647
  695654
  695660
  695682
  695814
  695962
  696019
  696385
  697088
  702359
  705104
  706067
  719876
  719893
  721899
  721956
  726931
  728278
  744011
  746633
  768969
  769931
  770246
  773468
  779605
  780142
  780155
  780627
  780666
  782119
  788892
  789035
  789345
  789632
  790098
  791472
  793044
  798751
  799723
  800469
  802915
  802922
  803948
  810598
  812217
  812240
  828042
  828123
  828269
]
2.12 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "улиц ххх"
]
2.10 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "улица ххх"
]
1.95 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.85%)
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.