Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.43 ms
(88.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
  24087
  24158
  148408
  325804
  383726
  412616
  415787
  422168
  423318
  426480
  426510
  439732
  439779
  445204
  450803
  458053
  460327
  462198
  469641
  486960
  489325
  500911
  504927
  506518
  506770
  512688
  515685
  517790
  523370
  523412
  524669
  528215
  538970
  541094
  543794
  543956
  547252
  553478
  560678
  561454
  563075
  578642
  579472
  580480
  580642
  600863
  608771
  609968
  612904
  618861
  619140
  621628
  646169
  650711
  650723
  666087
  666360
  666914
  668135
  670839
  701938
  703689
  704599
  720543
  726156
  727322
  739684
  744764
  750988
  759019
  769538
  771145
  780371
  782770
  787092
  788031
  789285
  789639
  790275
  791477
  794107
  795346
  800634
  801701
  803301
  803874
  804274
  808277
  810029
  811864
  812276
  813856
  816841
  817803
  818111
  818193
  818813
  818914
  819807
  820134
  820321
  823820
  823891
  824385
  824462
  824479
  825922
  825990
  826201
  826210
  826678
  826679
  827025
  827085
  828472
  828520
  828582
  828688
  828705
  828803
]
13.53 ms
(6.27%)
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
  504927
  423318
  426480
  426510
  458053
  462198
  524669
  506518
  506770
  541094
  561454
  563075
  670839
  578642
  580480
  580642
  609968
  619140
  800634
  450803
  415787
  445204
  538970
  515685
  528215
  523370
  469641
  826201
  823891
  823820
  826210
  780371
  744764
  808277
  726156
  512688
  547252
  621628
  460327
  412616
  825990
  818914
  828582
  543956
  789639
  794107
  827085
  148408
  325804
  818193
  826678
  827025
  824385
  825922
  650711
  720543
  791477
  801701
  804274
  812276
  759019
  803301
  739684
  790275
  813856
  824479
  646169
  704599
  810029
  787092
  523412
  500911
  543794
  553478
  600863
  618861
  612904
  422168
  439732
  489325
  486960
  517790
  820134
  789285
  727322
  608771
  439779
  816841
  818111
  820321
  826679
  817803
  819807
  824462
  828803
  828520
  828472
  828688
  828705
  666360
  666087
  579472
  782770
  795346
  788031
  771145
  769538
  24158
  818813
  666914
  803874
  750988
  811864
  24087
  668135
  383726
  560678
  650723
  701938
  703689
]
3.65 ms
(1.69%)
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
  24087
  24158
  148408
  325804
  383726
  412616
  415787
  422168
  423318
  426480
  426510
  439732
  439779
  445204
  450803
  458053
  460327
  462198
  469641
  486960
  489325
  500911
  504927
  506518
  506770
  512688
  515685
  517790
  523370
  523412
  524669
  528215
  538970
  541094
  543794
  543956
  547252
  553478
  560678
  561454
  563075
  578642
  579472
  580480
  580642
  600863
  608771
  609968
  612904
  618861
  619140
  621628
  646169
  650711
  650723
  666087
  666360
  666914
  668135
  670839
  701938
  703689
  704599
  720543
  726156
  727322
  739684
  744764
  750988
  759019
  769538
  771145
  780371
  782770
  787092
  788031
  789285
  789639
  790275
  791477
  794107
  795346
  800634
  801701
  803301
  803874
  804274
  808277
  810029
  811864
  812276
  813856
  816841
  817803
  818111
  818193
  818813
  818914
  819807
  820134
  820321
  823820
  823891
  824385
  824462
  824479
  825922
  825990
  826201
  826210
  826678
  826679
  827025
  827085
  828472
  828520
  828582
  828688
  828705
  828803
]
1.95 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в туалете жену"
]
1.93 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "туалет жен"
]
1.79 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "туалет жен"
]
1.58 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.