Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.09 ms
(81.28%)
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
  191179
  400491
  415834
  416680
  418145
  420839
  432359
  432929
  440749
  445721
  448773
  460535
  467569
  478642
  480417
  480848
  481144
  485512
  485527
  485666
  486136
  490753
  490996
  491299
  497560
  502464
  515538
  516655
  517564
  521927
  525700
  530431
  531189
  534019
  534201
  540267
  542063
  542213
  550288
  552733
  575591
  576535
  580160
  580174
  580180
  580183
  588529
  590328
  596226
  597903
  600995
  602293
  603601
  619166
  621733
  623211
  626755
  627498
  633734
  637882
  642359
  645167
  652758
  652905
  653009
  654256
  669201
  669239
  680584
  687248
  692378
  698124
  698915
  699225
  709937
  712374
  712409
  716303
  718811
  723361
  724640
  726818
  726861
  727959
  728354
  728463
  731224
  731615
  733651
  736470
  739792
  740009
  761686
  761777
  762199
  765096
  769046
  773421
  774221
  777738
  778637
  784661
  785794
  786756
  789837
  791416
  791729
  793453
  794214
  794877
  797043
  797750
  800960
  807347
  808849
  809121
  809729
  810270
  816371
]
16.62 ms
(11.34%)
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
  816371
  480848
  467569
  534019
  502464
  516655
  485666
  550288
  576535
  580160
  580174
  652758
  580183
  627498
  727959
  480417
  415834
  491299
  525700
  521927
  575591
  603601
  800960
  761686
  769046
  810270
  420839
  481144
  490996
  602293
  797750
  736470
  485512
  191179
  485527
  490753
  531189
  534201
  580180
  542213
  460535
  416680
  418145
  497560
  530431
  652905
  645167
  723361
  626755
  793453
  791729
  724640
  728354
  765096
  726861
  773421
  540267
  600995
  517564
  478642
  590328
  797043
  728463
  698915
  432359
  523324
  596226
  515538
  653009
  669239
  597903
  637882
  778637
  777738
  786756
  794877
  785794
  789837
  808849
  726818
  733651
  623211
  619166
  633734
  432929
  448773
  400491
  709937
  654256
  552733
  809729
  739792
  731224
  774221
  716303
  698124
  642359
  794214
  542063
  712374
  712409
  588529
  784661
  807347
  740009
  761777
  809121
  731615
  762199
  699225
  791416
  486136
  440749
  445721
  680584
  687248
  692378
  718811
  669201
  621733
]
3.57 ms
(2.44%)
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
  191179
  400491
  415834
  416680
  418145
  420839
  432359
  432929
  440749
  445721
  448773
  460535
  467569
  478642
  480417
  480848
  481144
  485512
  485527
  485666
  486136
  490753
  490996
  491299
  497560
  502464
  515538
  516655
  517564
  521927
  525700
  530431
  531189
  534019
  534201
  540267
  542063
  542213
  550288
  552733
  575591
  576535
  580160
  580174
  580180
  580183
  588529
  590328
  596226
  597903
  600995
  602293
  603601
  619166
  621733
  623211
  626755
  627498
  633734
  637882
  642359
  645167
  652758
  652905
  653009
  654256
  669201
  669239
  680584
  687248
  692378
  698124
  698915
  699225
  709937
  712374
  712409
  716303
  718811
  723361
  724640
  726818
  726861
  727959
  728354
  728463
  731224
  731615
  733651
  736470
  739792
  740009
  761686
  761777
  762199
  765096
  769046
  773421
  774221
  777738
  778637
  784661
  785794
  786756
  789837
  791416
  791729
  793453
  794214
  794877
  797043
  797750
  800960
  807347
  808849
  809121
  809729
  810270
  816371
]
2.08 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hardcore real"
]
1.93 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор real"
]
1.47 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор real"
]

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.