Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.82 ms
(83.17%)
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
  406652
  458277
  484056
  514875
  541064
  541301
  545004
  548909
  550968
  555411
  556200
  563949
  566762
  567514
  576460
  576471
  577649
  580873
  600942
  606134
  607988
  610470
  623068
  627153
  627567
  629565
  629750
  640034
  640073
  647111
  657158
  661962
  662914
  664503
  668105
  676610
  677157
  677424
  679274
  679674
  682370
  683080
  684874
  686107
  701180
  702855
  707238
  709886
  710663
  713061
  714791
  715538
  717151
  718359
  724004
  725446
  730808
  734265
  735679
  736310
  739321
  741122
  744759
  748028
  748311
  753195
  755443
  758345
  760148
  763878
  769137
  771413
  772672
  773053
  777422
  777992
  778509
  781108
  782297
  782583
  783102
  784123
  786390
  786858
  787124
  792943
  792978
  793213
  794110
  795366
  796580
  798674
  801788
  802003
  802141
  803194
  804981
  806681
  807887
  810081
  810114
  810801
  810957
  812015
  812106
  813928
  816756
  819106
  819838
  823442
  824122
  824157
  825086
  825348
  827138
  827500
  827539
  827983
]
14.75 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
  802003
  406652
  824122
  825348
  827138
  827500
  827539
  816756
  813928
  819106
  819838
  823442
  825086
  827983
  824157
  458277
  484056
  514875
  567514
  541301
  556200
  576460
  576471
  580873
  541064
  545004
  548909
  550968
  555411
  563949
  566762
  661962
  676610
  682370
  683080
  686107
  709886
  714791
  715538
  718359
  647111
  657158
  677157
  684874
  702855
  707238
  710663
  713061
  717151
  662914
  664503
  668105
  677424
  679274
  679674
  701180
  577649
  606134
  623068
  629565
  640034
  610470
  629750
  640073
  600942
  607988
  627153
  627567
  640866
  777422
  777992
  778509
  781108
  784123
  787124
  792943
  796580
  798674
  801788
  803194
  810801
  812015
  782583
  783102
  786390
  792978
  795366
  802141
  810081
  812106
  736310
  741122
  748028
  748311
  753195
  758345
  763878
  769137
  771413
  772672
  782297
  786858
  793213
  794110
  804981
  806681
  807887
  810114
  810957
  730808
  734265
  735679
  739321
  744759
  755443
  760148
  773053
  773295
  724004
  725446
]
2.92 ms
(1.96%)
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
  406652
  458277
  484056
  514875
  541064
  541301
  545004
  548909
  550968
  555411
  556200
  563949
  566762
  567514
  576460
  576471
  577649
  580873
  600942
  606134
  607988
  610470
  623068
  627153
  627567
  629565
  629750
  640034
  640073
  647111
  657158
  661962
  662914
  664503
  668105
  676610
  677157
  677424
  679274
  679674
  682370
  683080
  684874
  686107
  701180
  702855
  707238
  709886
  710663
  713061
  714791
  715538
  717151
  718359
  724004
  725446
  730808
  734265
  735679
  736310
  739321
  741122
  744759
  748028
  748311
  753195
  755443
  758345
  760148
  763878
  769137
  771413
  772672
  773053
  777422
  777992
  778509
  781108
  782297
  782583
  783102
  784123
  786390
  786858
  787124
  792943
  792978
  793213
  794110
  795366
  796580
  798674
  801788
  802003
  802141
  803194
  804981
  806681
  807887
  810081
  810114
  810801
  810957
  812015
  812106
  813928
  816756
  819106
  819838
  823442
  824122
  824157
  825086
  825348
  827138
  827500
  827539
  827983
]
2.22 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum masturbation"
]
1.95 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum мастурбац"
]
1.62 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum мастурбац"
]
1.61 ms
(1.08%)
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.