Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.57 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.62 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ногтями"
]
3 14.09 ms
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
  579425
  582417
  583052
  583257
  583581
  542904
  549517
  552779
  553079
  562872
  566755
  567112
  569054
  576520
  576611
  577100
  584809
  684660
  685617
  653146
  673845
  687586
  690846
  659322
  668360
  669218
  672423
  674758
  678175
  686882
  690859
  547958
  550091
  551025
  556121
  557336
  564856
  566105
  566691
  569197
  577980
  581242
  583262
  584282
  585787
  587302
  589703
  592492
  595158
  599376
  599974
  602016
  605003
  606173
  609689
  609841
  616909
  618688
  623715
  624877
  629421
  631054
  643317
  587912
  587928
  589318
  590020
  594594
  594933
  595780
  597722
  598246
  598625
  602194
  603967
  604276
  609580
  609709
  611330
  612478
  624886
  626153
  587866
  596956
  597161
  597182
  597430
  599150
  602578
  602933
  606199
  615587
  615689
  615836
  620083
  623701
  623962
  624320
  625860
  628681
  590344
  592184
  598882
  599203
  601339
  602576
  605826
  608427
  613354
  615838
  622594
  623610
  627701
  633937
  641672
  603420
  604994
  611950
  612346
  615182
]
4 2.75 ms
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
  542904
  547958
  549517
  550091
  551025
  552779
  553079
  556121
  557336
  562872
  564856
  566105
  566691
  566755
  567112
  569054
  569197
  576520
  576611
  577100
  577980
  579425
  581242
  582417
  583052
  583257
  583262
  583581
  584282
  584809
  585787
  587302
  587866
  587912
  587928
  589318
  589703
  590020
  590344
  592184
  592492
  594594
  594933
  595158
  595780
  596956
  597161
  597182
  597430
  597722
  598246
  598625
  598882
  599150
  599203
  599376
  599974
  601339
  602016
  602194
  602576
  602578
  602933
  603420
  603967
  604276
  604994
  605003
  605826
  606173
  606199
  608427
  609580
  609689
  609709
  609841
  611330
  611950
  612346
  612478
  613354
  615182
  615587
  615689
  615836
  615838
  616909
  618688
  620083
  622594
  623610
  623701
  623715
  623962
  624320
  624877
  624886
  625860
  626153
  627701
  628681
  629421
  631054
  633937
  641672
  643317
  653146
  659322
  668360
  669218
  672423
  673845
  674758
  678175
  684660
  685617
  686882
  687586
  690846
  690859
]
5 289.16 ms
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
  542904
  547958
  549517
  550091
  551025
  552779
  553079
  556121
  557336
  562872
  564856
  566105
  566691
  566755
  567112
  569054
  569197
  576520
  576611
  577100
  577980
  579425
  581242
  582417
  583052
  583257
  583262
  583581
  584282
  584809
  585787
  587302
  587866
  587912
  587928
  589318
  589703
  590020
  590344
  592184
  592492
  594594
  594933
  595158
  595780
  596956
  597161
  597182
  597430
  597722
  598246
  598625
  598882
  599150
  599203
  599376
  599974
  601339
  602016
  602194
  602576
  602578
  602933
  603420
  603967
  604276
  604994
  605003
  605826
  606173
  606199
  608427
  609580
  609689
  609709
  609841
  611330
  611950
  612346
  612478
  613354
  615182
  615587
  615689
  615836
  615838
  616909
  618688
  620083
  622594
  623610
  623701
  623715
  623962
  624320
  624877
  624886
  625860
  626153
  627701
  628681
  629421
  631054
  633937
  641672
  643317
  653146
  659322
  668360
  669218
  672423
  673845
  674758
  678175
  684660
  685617
  686882
  687586
  690846
  690859
]
6 2.24 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ногт"
]
7 1.38 ms
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.