Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.03 ms
(86.23%)
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
  384452
  398797
  429144
  429318
  431333
  529068
  543162
  543750
  548609
  550564
  551002
  551477
  552192
  552201
  552222
  552243
  552467
  552629
  558852
  565250
  565255
  565552
  568513
  569097
  571643
  574492
  574897
  575756
  575790
  576051
  579358
  583641
  590295
  596039
  596625
  597227
  597476
  597798
  597823
  597825
  598039
  598057
  598135
  598680
  598787
  600110
  600330
  603052
  604266
  605503
  608015
  621451
  624170
  628086
  628090
  628379
  628388
  632975
  635117
  641667
  652955
  652960
  654826
  656360
  656785
  657143
  658728
  659161
  659283
  660296
  671325
  671597
  674943
  683559
  684312
  691217
  694492
  699403
  714444
  715332
  715453
  718687
  720223
  720397
  721302
  721317
  721851
  722628
  722649
  729160
  736959
  740344
  746802
  746978
  748663
  749329
  750316
  752721
  753340
  753898
  753902
  754180
  755634
  758983
  760966
  774469
  777652
  781068
  790384
  792179
  793982
  796232
  800390
  805668
  806331
  806334
  807519
  818390
  818531
  828849
]
16.90 ms
(8.28%)
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
  671325
  552243
  621451
  748663
  714444
  774469
  818390
  818531
  543750
  552201
  583641
  550564
  565552
  568513
  558852
  659161
  656360
  660296
  671597
  683559
  654826
  656785
  715332
  590295
  598787
  604266
  635117
  596039
  600110
  740344
  793982
  746978
  721317
  796232
  800390
  674943
  529068
  543162
  552629
  657143
  658728
  720397
  722628
  652955
  694492
  720223
  691217
  722649
  597798
  597823
  603052
  598135
  624170
  807519
  781068
  792179
  746802
  750316
  754180
  755634
  760966
  805668
  806331
  752721
  749329
  753898
  753902
  729160
  736959
  753340
  758983
  699403
  718687
  721302
  721851
  777652
  806334
  384452
  652960
  576051
  548609
  574897
  579358
  551477
  552467
  565250
  565255
  574492
  575756
  575790
  659283
  684312
  569097
  598680
  632975
  597227
  598057
  600330
  628086
  628090
  628379
  628388
  605503
  641667
  431333
  571643
  552222
  715453
  552192
  596625
  597825
  597476
  598039
  608015
  429144
  429318
  828849
  551002
  790384
  398797
]
3.96 ms
(1.94%)
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
  384452
  398797
  429144
  429318
  431333
  529068
  543162
  543750
  548609
  550564
  551002
  551477
  552192
  552201
  552222
  552243
  552467
  552629
  558852
  565250
  565255
  565552
  568513
  569097
  571643
  574492
  574897
  575756
  575790
  576051
  579358
  583641
  590295
  596039
  596625
  597227
  597476
  597798
  597823
  597825
  598039
  598057
  598135
  598680
  598787
  600110
  600330
  603052
  604266
  605503
  608015
  621451
  624170
  628086
  628090
  628379
  628388
  632975
  635117
  641667
  652955
  652960
  654826
  656360
  656785
  657143
  658728
  659161
  659283
  660296
  671325
  671597
  674943
  683559
  684312
  691217
  694492
  699403
  714444
  715332
  715453
  718687
  720223
  720397
  721302
  721317
  721851
  722628
  722649
  729160
  736959
  740344
  746802
  746978
  748663
  749329
  750316
  752721
  753340
  753898
  753902
  754180
  755634
  758983
  760966
  774469
  777652
  781068
  790384
  792179
  793982
  796232
  800390
  805668
  806331
  806334
  807519
  818390
  818531
  828849
]
2.07 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen маленькая"
]
2.03 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen small"
]
1.65 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen маленькая"
]
1.50 ms
(0.74%)
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.