Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.11 ms
(81.90%)
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
  546292
  551977
  558895
  559878
  583417
  590297
  591836
  591904
  596820
  598182
  599138
  599798
  602218
  603219
  603315
  605226
  608026
  618295
  619459
  622201
  622651
  626665
  630444
  634694
  638058
  640868
  642216
  658180
  658951
  668950
  705052
  705804
  707452
  707544
  709878
  709916
  711994
  713113
  714126
  717282
  725087
  725298
  725439
  726309
  726623
  726928
  727042
  727169
  727437
  728630
  730379
  731007
  732200
  732760
  734069
  734301
  734461
  735029
  738160
  738191
  739541
  740771
  741045
  741266
  742590
  743147
  747861
  756868
  758110
  759374
  761171
  761527
  763373
  763629
  764565
  765007
  765215
  767289
  767443
  768172
  769119
  769189
  769220
  769688
  770951
  779716
  783024
  783963
  784340
  785690
  788385
  788449
  788646
  789704
  794990
  795606
  796018
  796493
  796811
  797884
  799739
  799889
  801221
  801554
  802137
  802363
  803351
  803840
  805103
  806737
  807305
  808751
  809740
  809745
  810565
  811504
  812148
  812150
  812314
  812837
]
15.68 ms
(10.60%)
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
  705052
  707544
  709878
  709916
  713113
  714126
  717282
  658180
  658951
  668950
  705804
  707452
  711994
  546292
  551977
  558895
  559878
  583417
  591836
  603315
  605226
  640868
  642216
  590297
  599138
  619459
  622201
  602218
  608026
  622651
  626665
  634694
  591904
  596820
  598182
  599798
  603219
  618295
  630444
  638058
  783963
  788385
  788646
  789704
  794990
  795606
  796493
  802137
  803840
  808751
  811504
  812314
  779716
  785690
  788449
  796018
  797884
  799889
  803351
  805103
  806737
  809745
  810565
  812837
  725087
  725439
  726928
  727169
  727437
  731007
  734301
  734461
  740771
  743147
  756868
  765007
  769220
  770951
  783024
  784340
  796811
  799739
  801221
  801554
  802363
  807305
  809740
  812148
  812150
  725298
  726309
  732760
  734069
  741266
  758110
  761171
  761527
  763373
  767289
  769119
  728630
  735029
  738191
  742590
  747861
  764565
  769189
  726623
  730379
  732200
  738160
  739541
  741045
  759374
  763629
  765215
  767443
  768172
  769688
  727042
]
2.72 ms
(1.84%)
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
  546292
  551977
  558895
  559878
  583417
  590297
  591836
  591904
  596820
  598182
  599138
  599798
  602218
  603219
  603315
  605226
  608026
  618295
  619459
  622201
  622651
  626665
  630444
  634694
  638058
  640868
  642216
  658180
  658951
  668950
  705052
  705804
  707452
  707544
  709878
  709916
  711994
  713113
  714126
  717282
  725087
  725298
  725439
  726309
  726623
  726928
  727042
  727169
  727437
  728630
  730379
  731007
  732200
  732760
  734069
  734301
  734461
  735029
  738160
  738191
  739541
  740771
  741045
  741266
  742590
  743147
  747861
  756868
  758110
  759374
  761171
  761527
  763373
  763629
  764565
  765007
  765215
  767289
  767443
  768172
  769119
  769189
  769220
  769688
  770951
  779716
  783024
  783963
  784340
  785690
  788385
  788449
  788646
  789704
  794990
  795606
  796018
  796493
  796811
  797884
  799739
  799889
  801221
  801554
  802137
  802363
  803351
  803840
  805103
  806737
  807305
  808751
  809740
  809745
  810565
  811504
  812148
  812150
  812314
  812837
]
2.49 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "у тебя такой маленький"
]
2.05 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленький"
]
1.87 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.