Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.32 ms
(87.37%)
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
  3869
  149406
  218622
  397083
  397094
  398601
  406928
  409946
  422121
  458352
  463596
  477561
  487570
  496698
  507651
  526486
  528397
  528623
  528723
  531323
  532557
  534054
  534659
  534875
  534892
  535209
  536167
  536960
  536988
  537562
  538272
  538339
  538441
  542202
  543059
  543073
  544358
  546331
  546505
  546549
  547346
  547676
  549975
  551695
  556781
  559129
  559857
  564270
  565229
  566944
  567981
  569650
  569795
  569809
  570314
  572140
  580525
  581628
  582874
  583033
  587282
  587318
  587975
  593036
  595177
  595232
  595354
  595390
  595464
  597623
  597770
  600426
  601567
  601574
  601735
  606835
  616964
  629903
  649757
  650871
  652053
  653369
  654818
  655116
  655345
  656444
  656468
  657375
  657443
  657590
  657641
  657681
  657808
  657920
  658092
  658301
  658322
  658400
  658512
  658906
  659151
  659795
  659829
  664583
  667576
  667605
  667850
  675051
  700158
  720628
  724735
  724829
  747041
  749428
  763916
  763940
  783121
  813569
  813950
  814308
]
13.47 ms
(7.12%)
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
  572140
  549975
  601574
  528397
  583033
  664583
  397094
  422121
  458352
  526486
  528623
  547346
  658906
  657590
  657681
  658322
  659829
  565229
  587282
  601735
  747041
  763916
  218622
  409946
  813569
  814308
  496698
  534892
  536960
  537562
  538339
  543059
  546331
  580525
  569809
  567981
  569650
  650871
  656468
  658301
  654818
  656444
  657808
  658092
  569795
  600426
  601567
  724735
  749428
  763940
  700158
  3869
  398601
  406928
  507651
  528723
  149406
  397083
  813950
  463596
  477561
  532557
  534054
  534875
  536167
  538441
  531323
  534659
  535209
  536988
  538272
  487570
  559129
  570314
  581628
  543073
  546505
  551695
  559857
  566944
  542202
  544358
  564270
  657443
  657920
  658400
  667576
  667605
  649757
  652053
  653369
  655345
  657375
  658512
  659795
  675051
  720628
  655116
  657641
  659151
  667850
  546549
  547676
  556781
  582874
  593036
  597623
  587318
  595390
  616964
  595177
  595232
  597770
  629903
  587975
  595354
  595464
  606835
  783121
  724829
]
2.88 ms
(1.52%)
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
  3869
  149406
  218622
  397083
  397094
  398601
  406928
  409946
  422121
  458352
  463596
  477561
  487570
  496698
  507651
  526486
  528397
  528623
  528723
  531323
  532557
  534054
  534659
  534875
  534892
  535209
  536167
  536960
  536988
  537562
  538272
  538339
  538441
  542202
  543059
  543073
  544358
  546331
  546505
  546549
  547346
  547676
  549975
  551695
  556781
  559129
  559857
  564270
  565229
  566944
  567981
  569650
  569795
  569809
  570314
  572140
  580525
  581628
  582874
  583033
  587282
  587318
  587975
  593036
  595177
  595232
  595354
  595390
  595464
  597623
  597770
  600426
  601567
  601574
  601735
  606835
  616964
  629903
  649757
  650871
  652053
  653369
  654818
  655116
  655345
  656444
  656468
  657375
  657443
  657590
  657641
  657681
  657808
  657920
  658092
  658301
  658322
  658400
  658512
  658906
  659151
  659795
  659829
  664583
  667576
  667605
  667850
  675051
  700158
  720628
  724735
  724829
  747041
  749428
  763916
  763940
  783121
  813569
  813950
  814308
]
2.17 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скачет"
]
2.07 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хорошо скачет"
]
1.73 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.84%)
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.