Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
385.44 ms
(93.68%)
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
  6739
  133294
  149261
  172267
  172555
  182221
  182504
  191509
  205520
  219172
  233517
  282542
  288045
  309223
  335993
  361679
  382200
  382448
  382579
  383672
  384562
  386344
  386904
  388127
  388150
  389893
  389911
  391493
  391561
  391940
  391978
  392043
  392508
  392721
  392817
  392906
  393987
  396130
  397014
  397130
  397185
  397529
  397663
  397739
  398302
  398331
  398384
  398828
  399163
  400102
  400672
  401048
  401660
  402032
  403134
  404470
  404608
  407339
  408723
  411212
  411744
  412237
  414043
  416933
  476073
  525039
  533569
  546254
  555058
  621824
  636628
  638145
  640451
  648618
  651955
  659452
  685416
  696593
  707166
  714086
  716715
  718118
  725627
  726333
  726369
  728295
  731200
  732815
  735914
  739584
  741582
  742831
  743799
  749187
  751702
  755935
  757456
  759156
  763560
  770267
  772744
  773447
  777044
  781598
  783548
  788923
  795733
  798771
  806847
  810234
  810607
  811937
  813337
  827923
  827924
  827929
  827944
  827947
  827964
  827983
]
15.29 ms
(3.72%)
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
  755935
  773447
  735914
  739584
  638145
  806847
  810607
  718118
  795733
  133294
  182504
  393987
  392906
  392508
  335993
  389911
  386904
  388150
  397529
  397185
  397663
  400672
  407339
  408723
  412237
  827947
  827983
  827964
  827944
  707166
  716715
  636628
  783548
  810234
  757456
  621824
  411212
  414043
  6739
  233517
  391493
  392043
  397014
  309223
  382579
  401048
  714086
  555058
  788923
  391940
  205520
  383672
  533569
  525039
  546254
  685416
  781598
  811937
  726369
  728295
  741582
  751702
  742831
  743799
  763560
  640451
  219172
  777044
  749187
  726333
  732815
  772744
  798771
  813337
  386344
  149261
  172267
  172555
  288045
  361679
  382200
  382448
  388127
  396130
  397130
  398331
  400102
  399163
  401660
  404608
  416933
  827929
  827924
  827923
  731200
  770267
  759156
  725627
  391978
  402032
  182221
  191509
  398302
  398384
  282542
  384562
  389893
  398828
  403134
  411744
  391561
  392721
  392817
  397739
  404470
  476073
  648618
  659452
  651955
  696593
]
2.99 ms
(0.73%)
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
  6739
  133294
  149261
  172267
  172555
  182221
  182504
  191509
  205520
  219172
  233517
  282542
  288045
  309223
  335993
  361679
  382200
  382448
  382579
  383672
  384562
  386344
  386904
  388127
  388150
  389893
  389911
  391493
  391561
  391940
  391978
  392043
  392508
  392721
  392817
  392906
  393987
  396130
  397014
  397130
  397185
  397529
  397663
  397739
  398302
  398331
  398384
  398828
  399163
  400102
  400672
  401048
  401660
  402032
  403134
  404470
  404608
  407339
  408723
  411212
  411744
  412237
  414043
  416933
  476073
  525039
  533569
  546254
  555058
  621824
  636628
  638145
  640451
  648618
  651955
  659452
  685416
  696593
  707166
  714086
  716715
  718118
  725627
  726333
  726369
  728295
  731200
  732815
  735914
  739584
  741582
  742831
  743799
  749187
  751702
  755935
  757456
  759156
  763560
  770267
  772744
  773447
  777044
  781598
  783548
  788923
  795733
  798771
  806847
  810234
  810607
  811937
  813337
  827923
  827924
  827929
  827944
  827947
  827964
  827983
]
2.19 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard extreme"
]
2.09 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard хардкор"
]
1.86 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard хардкор"
]

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.