Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.01 ms
(88.72%)
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
  470592
  495020
  522531
  525423
  535635
  535637
  538032
  539367
  539613
  539914
  540962
  543668
  546732
  554364
  581220
  586507
  587546
  592661
  595963
  599233
  599294
  600010
  602355
  602491
  602685
  607435
  608232
  609194
  610118
  611694
  615994
  616446
  618980
  619673
  622240
  622279
  623972
  624922
  625092
  625760
  625978
  626192
  627663
  628130
  629518
  630661
  631322
  631350
  632483
  633690
  636114
  636400
  638439
  638954
  641125
  643644
  658496
  660248
  670738
  678261
  678465
  680370
  685317
  687443
  689219
  691405
  698340
  698481
  698811
  698914
  701202
  702340
  705485
  706597
  707069
  712642
  713414
  716311
  717806
  718614
  728611
  730832
  730966
  730984
  731155
  731913
  734308
  735270
  735917
  736580
  736939
  737859
  738721
  739303
  743478
  743501
  745198
  747751
  748983
  750238
  751962
  755143
  757227
  759032
  760251
  764501
  766142
  768751
  775133
  778454
  778477
  779195
  799726
  801664
  805246
  809965
  828231
]
9.27 ms
(5.52%)
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
  622279
  626192
  629518
  632483
  633690
  586507
  587546
  607435
  608232
  615994
  618980
  636114
  636400
  595963
  599294
  611694
  616446
  627663
  638954
  641125
  619673
  643644
  778477
  805246
  780455
  801664
  730832
  730966
  735270
  736580
  750238
  757227
  728611
  730984
  734308
  736939
  737859
  739303
  743478
  743501
  751962
  745198
  747751
  764501
  731913
  735917
  748983
  755143
  731155
  738721
  766142
  610118
  628130
  630661
  631322
  631350
  698811
  701202
  702340
  705485
  712642
  713414
  716311
  717806
  775133
  778454
  779195
  470592
  685317
  718614
  638439
  706597
  525423
  535635
  535637
  687443
  602491
  824820
  689219
  539914
  543668
  707069
  691405
  680370
  625092
  625978
  799726
  760251
  609194
  698481
  698914
  623972
  539367
  538032
  540962
  678465
  581220
  592661
  600010
  599233
  602355
  660248
  678261
  622240
  495020
  670738
  554364
  759032
  698340
  546732
  624922
  768751
  539613
  658496
  673919
  625760
  602685
  809965
  828231
  522531
]
2.72 ms
(1.62%)
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
  470592
  495020
  522531
  525423
  535635
  535637
  538032
  539367
  539613
  539914
  540962
  543668
  546732
  554364
  581220
  586507
  587546
  592661
  595963
  599233
  599294
  600010
  602355
  602491
  602685
  607435
  608232
  609194
  610118
  611694
  615994
  616446
  618980
  619673
  622240
  622279
  623972
  624922
  625092
  625760
  625978
  626192
  627663
  628130
  629518
  630661
  631322
  631350
  632483
  633690
  636114
  636400
  638439
  638954
  641125
  643644
  658496
  660248
  670738
  678261
  678465
  680370
  685317
  687443
  689219
  691405
  698340
  698481
  698811
  698914
  701202
  702340
  705485
  706597
  707069
  712642
  713414
  716311
  717806
  718614
  728611
  730832
  730966
  730984
  731155
  731913
  734308
  735270
  735917
  736580
  736939
  737859
  738721
  739303
  743478
  743501
  745198
  747751
  748983
  750238
  751962
  755143
  757227
  759032
  760251
  764501
  766142
  768751
  775133
  778454
  778477
  779195
  799726
  801664
  805246
  809965
  828231
]
1.89 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "любители-любители"
]
1.75 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск любительск"
]
1.75 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.94%)
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.