Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.40 ms
(84.61%)
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
  31941
  88274
  136157
  172556
  382168
  384576
  389460
  389560
  401564
  410312
  416943
  428911
  438025
  446446
  469592
  479041
  496508
  531520
  534644
  536468
  536493
  536567
  537827
  543940
  550046
  551819
  551967
  553163
  558123
  560337
  580333
  580387
  580503
  582426
  582452
  585840
  591476
  604261
  605024
  609721
  609784
  615985
  620219
  628112
  629813
  630068
  639315
  639652
  658850
  661694
  661709
  664394
  666070
  666077
  668700
  671032
  672926
  673216
  686937
  687325
  694650
  700985
  713145
  714365
  720529
  722340
  726634
  731787
  735558
  735810
  739937
  740423
  743610
  744030
  744202
  744206
  744797
  749015
  753699
  754583
  754656
  755000
  755342
  757433
  762208
  765688
  770108
  770168
  770244
  776404
  777775
  782943
  782953
  785136
  785605
  788128
  789183
  790396
  791303
  795221
  799171
  800739
  800744
  803684
  806642
  806658
  807858
  807884
  810649
  811060
  813720
  816382
  818551
  819628
  824685
  825324
  825437
  827184
  827668
  827693
]
13.99 ms
(8.49%)
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
  664394
  673216
  686937
  553163
  580503
  639315
  609721
  620219
  629813
  630068
  639652
  585840
  591476
  604261
  615985
  782953
  789183
  790396
  810649
  776404
  785605
  799171
  735810
  744030
  744797
  749015
  753699
  754656
  782943
  788128
  795221
  800739
  803684
  806658
  731787
  755000
  755342
  770168
  735558
  739937
  770244
  740423
  744202
  754583
  757433
  770108
  726634
  744206
  762208
  765688
  605024
  628112
  714365
  720529
  722340
  777775
  785136
  791303
  800744
  806642
  807858
  807884
  811060
  401564
  172556
  88274
  416943
  479041
  31941
  389460
  384576
  743610
  446446
  551819
  609784
  136157
  382168
  389560
  438025
  410312
  428911
  816382
  825437
  825324
  827184
  827693
  813720
  818551
  819628
  824685
  827668
  469592
  531520
  537827
  534644
  536493
  536468
  536567
  496508
  560337
  582452
  543940
  550046
  580387
  582426
  551967
  558123
  580333
  658850
  661709
  666070
  668700
  671032
  672926
  700985
  661694
  666077
  687325
  694650
  713145
]
2.78 ms
(1.68%)
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
  31941
  88274
  136157
  172556
  382168
  384576
  389460
  389560
  401564
  410312
  416943
  428911
  438025
  446446
  469592
  479041
  496508
  531520
  534644
  536468
  536493
  536567
  537827
  543940
  550046
  551819
  551967
  553163
  558123
  560337
  580333
  580387
  580503
  582426
  582452
  585840
  591476
  604261
  605024
  609721
  609784
  615985
  620219
  628112
  629813
  630068
  639315
  639652
  658850
  661694
  661709
  664394
  666070
  666077
  668700
  671032
  672926
  673216
  686937
  687325
  694650
  700985
  713145
  714365
  720529
  722340
  726634
  731787
  735558
  735810
  739937
  740423
  743610
  744030
  744202
  744206
  744797
  749015
  753699
  754583
  754656
  755000
  755342
  757433
  762208
  765688
  770108
  770168
  770244
  776404
  777775
  782943
  782953
  785136
  785605
  788128
  789183
  790396
  791303
  795221
  799171
  800739
  800744
  803684
  806642
  806658
  807858
  807884
  810649
  811060
  813720
  816382
  818551
  819628
  824685
  825324
  825437
  827184
  827668
  827693
]
2.50 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.21 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло короткая стрижка…"
]
1.99 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло короткостриженная"
]
1.89 ms
(1.15%)
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.