Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.81 ms
(89.34%)
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
  401688
  412677
  415311
  421389
  438460
  438655
  442800
  467923
  468601
  488179
  495489
  495617
  497909
  505540
  510919
  516373
  516388
  525139
  543215
  543330
  544057
  553210
  553441
  556085
  557050
  557709
  564496
  567675
  579218
  581514
  586752
  589904
  590806
  594601
  596778
  599515
  602022
  602159
  606601
  613109
  616072
  619854
  620825
  620992
  628682
  630239
  631129
  637186
  658796
  684895
  700016
  704067
  706024
  727561
  728472
  736308
  740575
  740897
  742696
  746748
  747291
  748266
  748282
  749596
  751308
  751322
  751329
  752619
  753120
  759308
  765182
  767416
  767722
  768517
  769328
  769370
  771886
  772979
  773050
  773283
  773313
  774310
  774850
  776824
  777851
  778815
  779765
  783391
  783912
  784651
  784958
  785225
  785816
  785979
  786066
  786987
  787373
  787520
  787524
  788140
  789770
  789803
  791130
  791301
  791484
  793110
  795544
  796384
  802243
  802267
  803880
  805450
  806398
  807070
  807341
  810532
  811816
  812378
  813206
  813369
]
14.18 ms
(6.18%)
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
  619854
  628682
  630239
  637186
  589904
  606601
  620825
  586752
  590806
  594601
  613109
  620992
  599515
  602159
  778815
  779765
  785225
  785816
  788140
  802243
  802267
  806398
  807341
  810532
  813369
  776824
  784958
  789770
  791130
  791301
  805450
  740897
  769328
  772979
  773283
  784651
  786066
  787373
  787520
  787524
  789803
  791484
  793110
  796384
  807070
  812378
  813206
  727561
  728472
  736308
  748266
  767722
  773050
  749596
  753120
  765182
  768517
  773313
  774310
  747291
  748282
  751322
  759308
  767416
  771886
  740575
  742696
  746748
  751308
  751329
  752619
  769370
  602022
  616072
  631129
  700016
  706024
  774850
  777851
  783391
  783912
  785979
  795544
  803880
  811816
  415311
  438460
  412677
  442800
  488179
  516373
  543215
  564496
  557050
  467923
  421389
  525139
  658796
  786987
  544057
  468601
  495617
  401688
  438655
  510919
  505540
  495489
  497909
  516388
  543330
  553441
  567675
  684895
  704067
  553210
  556085
  557709
  579218
  581514
  596778
]
2.25 ms
(0.98%)
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
  401688
  412677
  415311
  421389
  438460
  438655
  442800
  467923
  468601
  488179
  495489
  495617
  497909
  505540
  510919
  516373
  516388
  525139
  543215
  543330
  544057
  553210
  553441
  556085
  557050
  557709
  564496
  567675
  579218
  581514
  586752
  589904
  590806
  594601
  596778
  599515
  602022
  602159
  606601
  613109
  616072
  619854
  620825
  620992
  628682
  630239
  631129
  637186
  658796
  684895
  700016
  704067
  706024
  727561
  728472
  736308
  740575
  740897
  742696
  746748
  747291
  748266
  748282
  749596
  751308
  751322
  751329
  752619
  753120
  759308
  765182
  767416
  767722
  768517
  769328
  769370
  771886
  772979
  773050
  773283
  773313
  774310
  774850
  776824
  777851
  778815
  779765
  783391
  783912
  784651
  784958
  785225
  785816
  785979
  786066
  786987
  787373
  787520
  787524
  788140
  789770
  789803
  791130
  791301
  791484
  793110
  795544
  796384
  802243
  802267
  803880
  805450
  806398
  807070
  807341
  810532
  811816
  812378
  813206
  813369
]
2.18 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "orgasm solo masturbation"
]
2.02 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "orgasm соло мастурбац"
]
1.91 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "orgasm соло мастурбац"
]
1.88 ms
(0.82%)
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.