Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.23 ms
(84.30%)
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
  450126
  456950
  474431
  516144
  528494
  530096
  532295
  539235
  545114
  558724
  568462
  585595
  595027
  596820
  606930
  613879
  619442
  623877
  628917
  630657
  632074
  675335
  677586
  695843
  699957
  705054
  707229
  707283
  707415
  713509
  714163
  715097
  715951
  716951
  717229
  719242
  720255
  725134
  725439
  725446
  726102
  726371
  730225
  730686
  733316
  734326
  734553
  736112
  737466
  737533
  738307
  738334
  739646
  740799
  741937
  747420
  748579
  749168
  753525
  756402
  757311
  762647
  762661
  763373
  763558
  764961
  765025
  765933
  767483
  767720
  767919
  769257
  769350
  769422
  769610
  769688
  770071
  771281
  772379
  774023
  774101
  776299
  776879
  777998
  778912
  779320
  780027
  780508
  782885
  783515
  784060
  787576
  790790
  791145
  791942
  792042
  793374
  793905
  795492
  795751
  796119
  797299
  797938
  798766
  799065
  800108
  800111
  800238
  802211
  802900
  805267
  808258
  808464
  817754
  818452
  818623
  818689
  818711
  821084
  826734
]
13.21 ms
(8.82%)
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
  798766
  802211
  730225
  734553
  740799
  749168
  757311
  769257
  799065
  805267
  725134
  726102
  726371
  748579
  765933
  769610
  725446
  737466
  767919
  730686
  733316
  762647
  762661
  763558
  767720
  770071
  772379
  747420
  753525
  707415
  714163
  717229
  719242
  791942
  793905
  795751
  797299
  808258
  456950
  826734
  818689
  818711
  818452
  818623
  821084
  817754
  450126
  474431
  530096
  516144
  528494
  539235
  532295
  558724
  568462
  545114
  677586
  707283
  713509
  695843
  699957
  705054
  707229
  715951
  716951
  720255
  675335
  715097
  613879
  630657
  632074
  619442
  585595
  595027
  596820
  606930
  623877
  778912
  782885
  783515
  784060
  790790
  791145
  792042
  795492
  776299
  777998
  779320
  780027
  780508
  797938
  800108
  800238
  802900
  808464
  725439
  737533
  738334
  764961
  767483
  769422
  771281
  774023
  774101
  787576
  793374
  796119
  800111
  739646
  741937
  763373
  734326
  736112
  738307
  769688
  756402
  765025
  769350
  628917
  776879
]
2.61 ms
(1.74%)
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
  450126
  456950
  474431
  516144
  528494
  530096
  532295
  539235
  545114
  558724
  568462
  585595
  595027
  596820
  606930
  613879
  619442
  623877
  628917
  630657
  632074
  675335
  677586
  695843
  699957
  705054
  707229
  707283
  707415
  713509
  714163
  715097
  715951
  716951
  717229
  719242
  720255
  725134
  725439
  725446
  726102
  726371
  730225
  730686
  733316
  734326
  734553
  736112
  737466
  737533
  738307
  738334
  739646
  740799
  741937
  747420
  748579
  749168
  753525
  756402
  757311
  762647
  762661
  763373
  763558
  764961
  765025
  765933
  767483
  767720
  767919
  769257
  769350
  769422
  769610
  769688
  770071
  771281
  772379
  774023
  774101
  776299
  776879
  777998
  778912
  779320
  780027
  780508
  782885
  783515
  784060
  787576
  790790
  791145
  791942
  792042
  793374
  793905
  795492
  795751
  796119
  797299
  797938
  798766
  799065
  800108
  800111
  800238
  802211
  802900
  805267
  808258
  808464
  817754
  818452
  818623
  818689
  818711
  821084
  826734
]
2.05 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "load"
]
2.00 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "load"
]
1.71 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "load"
]

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.