Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.41 ms
(85.61%)
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
  418548
  418799
  419173
  420426
  447518
  453043
  463515
  474403
  486860
  497720
  501287
  501979
  509621
  511288
  514810
  527194
  529792
  538407
  542345
  545477
  555076
  555101
  555110
  559178
  563320
  564452
  570701
  574068
  581104
  584234
  584825
  588143
  590209
  592034
  595459
  600204
  600669
  600730
  602789
  603287
  604363
  609381
  610322
  612703
  616442
  617783
  618770
  624196
  628181
  630507
  631538
  631976
  632965
  634229
  646927
  647085
  654919
  655186
  662144
  666850
  668523
  670952
  673833
  674815
  681958
  684695
  685714
  695901
  699225
  700715
  703370
  707501
  715152
  717157
  717986
  718810
  719957
  721096
  721773
  722101
  723369
  724475
  738834
  741785
  744790
  751118
  755108
  758483
  759673
  759926
  761619
  762327
  763182
  764441
  764528
  766223
  767982
  768615
  768902
  770958
  771045
  779951
  786182
  787442
  790126
  791409
  791543
  792700
  794458
  794851
  795142
  799476
  800314
  801316
  802003
  805005
  805536
  809310
  810996
  813192
]
13.47 ms
(7.99%)
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
  768615
  768902
  770958
  741785
  771045
  761619
  766223
  602789
  699225
  721096
  779951
  787442
  792700
  800314
  801316
  805536
  810996
  813192
  447518
  418799
  685714
  486860
  529792
  559178
  666850
  418548
  419173
  538407
  511288
  497720
  545477
  555101
  570701
  723369
  662144
  703370
  655186
  668523
  700715
  707501
  717157
  721773
  595459
  603287
  609381
  628181
  632965
  600204
  616442
  618770
  631538
  790126
  794458
  794851
  799476
  805005
  744790
  764441
  786182
  791409
  791543
  795142
  724475
  755108
  762327
  764528
  759673
  759926
  763182
  767982
  738834
  751118
  758483
  715152
  802003
  809310
  592034
  420426
  463515
  453043
  501287
  501979
  509621
  527194
  514810
  474403
  563320
  564452
  574068
  584234
  581104
  542345
  674815
  718810
  646927
  654919
  670952
  673833
  684695
  695901
  719957
  722101
  647085
  681958
  717986
  555076
  555110
  584825
  590209
  600669
  604363
  612703
  617783
  624196
  630507
  631976
  610322
  634229
  600730
  588143
]
3.38 ms
(2.00%)
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
  418548
  418799
  419173
  420426
  447518
  453043
  463515
  474403
  486860
  497720
  501287
  501979
  509621
  511288
  514810
  527194
  529792
  538407
  542345
  545477
  555076
  555101
  555110
  559178
  563320
  564452
  570701
  574068
  581104
  584234
  584825
  588143
  590209
  592034
  595459
  600204
  600669
  600730
  602789
  603287
  604363
  609381
  610322
  612703
  616442
  617783
  618770
  624196
  628181
  630507
  631538
  631976
  632965
  634229
  646927
  647085
  654919
  655186
  662144
  666850
  668523
  670952
  673833
  674815
  681958
  684695
  685714
  695901
  699225
  700715
  703370
  707501
  715152
  717157
  717986
  718810
  719957
  721096
  721773
  722101
  723369
  724475
  738834
  741785
  744790
  751118
  755108
  758483
  759673
  759926
  761619
  762327
  763182
  764441
  764528
  766223
  767982
  768615
  768902
  770958
  771045
  779951
  786182
  787442
  790126
  791409
  791543
  792700
  794458
  794851
  795142
  799476
  800314
  801316
  802003
  805005
  805536
  809310
  810996
  813192
]
2.12 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum extreme"
]
2.03 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum хардкор"
]
1.61 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum хардкор"
]

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.