Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.39 ms
(83.99%)
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
  2658
  34452
  132583
  188266
  234067
  263917
  311393
  373803
  391511
  397837
  401751
  403293
  404777
  413522
  415505
  419421
  422348
  427033
  438033
  439733
  446011
  453666
  456276
  459156
  461188
  462286
  462958
  462968
  465071
  470226
  472094
  473980
  474006
  475772
  476535
  483971
  484409
  488459
  490766
  490768
  491742
  493337
  493858
  495425
  497974
  498936
  499526
  502110
  503768
  504745
  505166
  506112
  506143
  506807
  509005
  512202
  512821
  515806
  517528
  519993
  521779
  523653
  524457
  525650
  525963
  526925
  528400
  529138
  535255
  535510
  536865
  540638
  555812
  556072
  558829
  561033
  565348
  568096
  569253
  569419
  570196
  570491
  570666
  573007
  573910
  576725
  577409
  578026
  581188
  581705
  586424
  588896
  593068
  594036
  600487
  601677
  603029
  605984
  606518
  620786
  621438
  624762
  636434
  637438
  643315
  644345
  644356
  662594
  666509
  675795
  676911
  703370
  719756
  723234
  745980
  762632
  773324
  789114
  798877
  813901
]
15.98 ms
(9.91%)
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
  465071
  556072
  573007
  568096
  569419
  588896
  600487
  505166
  498936
  403293
  666509
  723234
  703370
  719756
  789114
  762632
  132583
  391511
  263917
  813901
  397837
  234067
  506143
  577409
  676911
  540638
  524457
  570666
  570491
  621438
  603029
  636434
  419421
  462958
  438033
  495425
  512821
  499526
  586424
  509005
  523653
  526925
  606518
  188266
  373803
  483971
  578026
  593068
  525963
  415505
  570196
  462968
  504745
  675795
  561033
  745980
  798877
  773324
  413522
  476535
  506112
  506807
  528400
  535255
  439733
  473980
  404777
  422348
  475772
  470226
  497974
  573910
  643315
  644356
  459156
  472094
  474006
  502110
  490768
  490766
  601677
  519993
  620786
  503768
  521779
  536865
  517528
  569253
  662594
  555812
  605984
  637438
  594036
  484409
  515806
  558829
  34452
  529138
  446011
  581188
  2658
  401751
  461188
  493858
  624762
  456276
  453666
  525650
  576725
  462286
  488459
  535510
  565348
  581705
  644345
  493337
  491742
  311393
  512202
  427033
]
2.94 ms
(1.83%)
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
  2658
  34452
  132583
  188266
  234067
  263917
  311393
  373803
  391511
  397837
  401751
  403293
  404777
  413522
  415505
  419421
  422348
  427033
  438033
  439733
  446011
  453666
  456276
  459156
  461188
  462286
  462958
  462968
  465071
  470226
  472094
  473980
  474006
  475772
  476535
  483971
  484409
  488459
  490766
  490768
  491742
  493337
  493858
  495425
  497974
  498936
  499526
  502110
  503768
  504745
  505166
  506112
  506143
  506807
  509005
  512202
  512821
  515806
  517528
  519993
  521779
  523653
  524457
  525650
  525963
  526925
  528400
  529138
  535255
  535510
  536865
  540638
  555812
  556072
  558829
  561033
  565348
  568096
  569253
  569419
  570196
  570491
  570666
  573007
  573910
  576725
  577409
  578026
  581188
  581705
  586424
  588896
  593068
  594036
  600487
  601677
  603029
  605984
  606518
  620786
  621438
  624762
  636434
  637438
  643315
  644345
  644356
  662594
  666509
  675795
  676911
  703370
  719756
  723234
  745980
  762632
  773324
  789114
  798877
  813901
]
1.98 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "публично в рот"
]
1.75 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на в улиц рот"
]
1.45 ms
(0.90%)
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.