Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.31 ms
(87.21%)
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
  383164
  415589
  416527
  416697
  417328
  433434
  437330
  443819
  454075
  461040
  462962
  463204
  471110
  481116
  482306
  484431
  484954
  485133
  487930
  496284
  497497
  503851
  504282
  505290
  505311
  506785
  507851
  508189
  510550
  511370
  514219
  514404
  515523
  516764
  517187
  517766
  518243
  521448
  523348
  528500
  533623
  536633
  537098
  537285
  538669
  539737
  540362
  542364
  543808
  544202
  544587
  544789
  546808
  547653
  549272
  550495
  551763
  552046
  553620
  553989
  555296
  555915
  559173
  559895
  562611
  563007
  563882
  564646
  564743
  565095
  565886
  566688
  569949
  573108
  574450
  576706
  577180
  579493
  581347
  586510
  590377
  590887
  591345
  591868
  592869
  595255
  595377
  596437
  599831
  600981
  601868
  603932
  604023
  604381
  605289
  605306
  605505
  611033
  617961
  621645
  623362
  623876
  625414
  628273
  630400
  630576
  632291
  633423
  634400
  637101
  647212
  650007
  653252
  664659
  665887
  681797
  685926
  691241
  691717
]
16.72 ms
(8.04%)
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
  537098
  514404
  485133
  591345
  543808
  596437
  590887
  510550
  565095
  653252
  632291
  461040
  515523
  521448
  484954
  559173
  574450
  533623
  433434
  383164
  549272
  544587
  546808
  443819
  544202
  576706
  605306
  621645
  508189
  517187
  518243
  590377
  555915
  573108
  551763
  604381
  503851
  628273
  637101
  516764
  590749
  623362
  511370
  539737
  564743
  481116
  691717
  536633
  625414
  579493
  633423
  664659
  462962
  592869
  538669
  540362
  562611
  581347
  417328
  564646
  566688
  565886
  634400
  563007
  603932
  623876
  437330
  569949
  577180
  691241
  415589
  496284
  553989
  665887
  553620
  605289
  559895
  542364
  611033
  595377
  487930
  507851
  685926
  505311
  650007
  630400
  471110
  514219
  550495
  454075
  505290
  528500
  544789
  555296
  595255
  601868
  605505
  463204
  552046
  600981
  586510
  497497
  482306
  523348
  591868
  630576
  506785
  504282
  537285
  681797
  416697
  517766
  604023
  599831
  484431
  416527
  547653
  647212
  563882
  617961
]
2.48 ms
(1.19%)
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
  383164
  415589
  416527
  416697
  417328
  433434
  437330
  443819
  454075
  461040
  462962
  463204
  471110
  481116
  482306
  484431
  484954
  485133
  487930
  496284
  497497
  503851
  504282
  505290
  505311
  506785
  507851
  508189
  510550
  511370
  514219
  514404
  515523
  516764
  517187
  517766
  518243
  521448
  523348
  528500
  533623
  536633
  537098
  537285
  538669
  539737
  540362
  542364
  543808
  544202
  544587
  544789
  546808
  547653
  549272
  550495
  551763
  552046
  553620
  553989
  555296
  555915
  559173
  559895
  562611
  563007
  563882
  564646
  564743
  565095
  565886
  566688
  569949
  573108
  574450
  576706
  577180
  579493
  581347
  586510
  590377
  590887
  591345
  591868
  592869
  595255
  595377
  596437
  599831
  600981
  601868
  603932
  604023
  604381
  605289
  605306
  605505
  611033
  617961
  621645
  623362
  623876
  625414
  628273
  630400
  630576
  632291
  633423
  634400
  637101
  647212
  650007
  653252
  664659
  665887
  681797
  685926
  691241
  691717
]
2.09 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "рукой трахает"
]
1.95 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рук секс"
]
1.77 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рук секс"
]
1.59 ms
(0.77%)
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.