Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.38 ms
(83.41%)
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
  460573
  462065
  463202
  494030
  505924
  509410
  511821
  515015
  515541
  516229
  523725
  528500
  529164
  533797
  542291
  542342
  543288
  543801
  544310
  544359
  544506
  544595
  544832
  545901
  546411
  546510
  546661
  547277
  547400
  548175
  548234
  548373
  550574
  551576
  552393
  552654
  554156
  554540
  555063
  556625
  557413
  558655
  559625
  560108
  560482
  560988
  562600
  562624
  563081
  563157
  564283
  564403
  564625
  565040
  565869
  566030
  566723
  566914
  568000
  569209
  570036
  570167
  570211
  570225
  570656
  572136
  572396
  572733
  573349
  573827
  573850
  575679
  576081
  576248
  577570
  578810
  581146
  581177
  581376
  583306
  583662
  584149
  588621
  589986
  592936
  601508
  603819
  645621
  648202
  651521
  654333
  654465
  654836
  655082
  655406
  655704
  655716
  656681
  656713
  656732
  656783
  657056
  657422
  657631
  659828
  660475
  662573
  662874
  666763
  669226
  671780
  671782
  673368
  680622
  680854
  682519
  682654
  686002
  688266
  690748
]
12.25 ms
(8.86%)
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
  523725
  529164
  505924
  509410
  515015
  515541
  533797
  511821
  516229
  528500
  460573
  462065
  463202
  494030
  543288
  544506
  544832
  548175
  548234
  557413
  558655
  560108
  562624
  568000
  569209
  570036
  570167
  570225
  575679
  581146
  581177
  581376
  583306
  584149
  542291
  542342
  543801
  544310
  547277
  551576
  556625
  560482
  564283
  564625
  566723
  566914
  570656
  572733
  573850
  576248
  577570
  578810
  544359
  546411
  546661
  547400
  548373
  552393
  554156
  555063
  562600
  563081
  566030
  572136
  572396
  654465
  655704
  655716
  657056
  660475
  662874
  666763
  680854
  682654
  686002
  648202
  655082
  656681
  656732
  657631
  659828
  673368
  680622
  682519
  688266
  690748
  645621
  651521
  654333
  654836
  655406
  656713
  656783
  657422
  662573
  669226
  671780
  671782
  544595
  545901
  546510
  550574
  552654
  554540
  559625
  560988
  563157
  564403
  565040
  565869
  570211
  573349
  573827
  576081
  583662
  588621
  589986
  592936
  601508
  603819
]
3.39 ms
(2.45%)
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
  460573
  462065
  463202
  494030
  505924
  509410
  511821
  515015
  515541
  516229
  523725
  528500
  529164
  533797
  542291
  542342
  543288
  543801
  544310
  544359
  544506
  544595
  544832
  545901
  546411
  546510
  546661
  547277
  547400
  548175
  548234
  548373
  550574
  551576
  552393
  552654
  554156
  554540
  555063
  556625
  557413
  558655
  559625
  560108
  560482
  560988
  562600
  562624
  563081
  563157
  564283
  564403
  564625
  565040
  565869
  566030
  566723
  566914
  568000
  569209
  570036
  570167
  570211
  570225
  570656
  572136
  572396
  572733
  573349
  573827
  573850
  575679
  576081
  576248
  577570
  578810
  581146
  581177
  581376
  583306
  583662
  584149
  588621
  589986
  592936
  601508
  603819
  645621
  648202
  651521
  654333
  654465
  654836
  655082
  655406
  655704
  655716
  656681
  656713
  656732
  656783
  657056
  657422
  657631
  659828
  660475
  662573
  662874
  666763
  669226
  671780
  671782
  673368
  680622
  680854
  682519
  682654
  686002
  688266
  690748
]
2.14 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "боку"
]
1.75 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бок"
]
1.74 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.22%)
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.