Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.78 ms
(85.20%)
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
  8005
  110884
  192943
  213604
  306045
  341608
  385590
  389553
  389875
  393050
  394713
  395141
  395411
  396018
  396273
  396336
  396745
  399410
  399727
  405242
  412506
  414609
  415718
  419109
  423676
  425035
  429040
  432887
  437227
  438971
  442015
  445278
  449342
  453612
  453790
  453898
  458588
  459574
  459586
  460076
  461020
  461796
  461918
  462169
  462281
  464600
  467376
  468753
  468794
  469423
  470395
  470863
  471385
  472383
  472720
  473064
  475343
  475352
  478917
  482782
  483900
  483944
  487436
  492440
  493987
  497575
  500085
  509264
  511126
  514700
  515742
  521957
  524768
  527467
  538211
  539515
  544830
  545014
  545598
  546039
  547082
  549865
  551175
  552143
  564071
  564652
  565432
  565479
  567359
  567755
  570258
  571268
  574541
  593858
  594231
  595741
  601691
  622123
  622582
  650842
  652122
  668141
  681140
  689565
  691616
  694660
  699802
  703391
  715526
  725096
  731684
  737125
  747017
  750062
  761123
  773761
  775811
  809510
  810189
  814809
]
15.48 ms
(8.98%)
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
  703391
  8005
  509264
  438971
  527467
  437227
  514700
  478917
  432887
  459574
  483900
  594231
  396745
  552143
  694660
  622582
  773761
  306045
  442015
  461020
  538211
  487436
  192943
  396018
  445278
  482782
  471385
  689565
  545598
  809510
  731684
  747017
  715526
  415718
  394713
  405242
  461796
  521957
  468794
  461918
  539515
  493987
  567359
  593858
  393050
  396273
  462281
  468753
  472383
  467376
  110884
  564071
  571268
  650842
  652122
  681140
  691616
  545014
  564652
  595741
  737125
  725096
  761123
  699802
  475343
  213604
  429040
  425035
  449342
  459586
  460076
  453790
  458588
  469423
  547082
  549865
  668141
  565479
  601691
  453898
  462169
  470863
  472720
  464600
  511126
  497575
  524768
  515742
  395141
  341608
  396336
  453612
  565432
  570258
  551175
  567755
  574541
  544830
  622123
  810189
  750062
  775811
  399410
  423676
  385590
  395411
  389553
  389875
  399727
  414609
  419109
  412506
  814809
  492440
  470395
  473064
  483944
  500085
  475352
  546039
]
2.98 ms
(1.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
  8005
  110884
  192943
  213604
  306045
  341608
  385590
  389553
  389875
  393050
  394713
  395141
  395411
  396018
  396273
  396336
  396745
  399410
  399727
  405242
  412506
  414609
  415718
  419109
  423676
  425035
  429040
  432887
  437227
  438971
  442015
  445278
  449342
  453612
  453790
  453898
  458588
  459574
  459586
  460076
  461020
  461796
  461918
  462169
  462281
  464600
  467376
  468753
  468794
  469423
  470395
  470863
  471385
  472383
  472720
  473064
  475343
  475352
  478917
  482782
  483900
  483944
  487436
  492440
  493987
  497575
  500085
  509264
  511126
  514700
  515742
  521957
  524768
  527467
  538211
  539515
  544830
  545014
  545598
  546039
  547082
  549865
  551175
  552143
  564071
  564652
  565432
  565479
  567359
  567755
  570258
  571268
  574541
  593858
  594231
  595741
  601691
  622123
  622582
  650842
  652122
  668141
  681140
  689565
  691616
  694660
  699802
  703391
  715526
  725096
  731684
  737125
  747017
  750062
  761123
  773761
  775811
  809510
  810189
  814809
]
2.17 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с двумя членами"
]
1.75 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "двум член"
]
1.42 ms
(0.82%)
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.