Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.18 ms
(86.71%)
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
  181184
  370332
  390643
  391717
  393475
  396075
  396245
  397856
  401108
  401976
  402438
  462207
  467948
  470965
  478310
  484827
  507092
  508542
  513157
  516511
  520388
  520788
  525030
  531647
  544200
  560961
  564348
  566764
  567232
  567311
  576134
  583383
  584915
  592402
  592686
  602409
  604322
  604338
  609267
  615698
  616885
  617698
  623130
  625461
  636956
  641192
  654338
  671890
  680395
  680780
  684122
  685513
  686113
  694132
  713670
  713911
  714964
  716992
  717221
  717725
  721971
  724118
  726641
  728379
  730457
  731234
  733246
  734432
  734959
  734990
  735961
  737051
  738589
  739913
  740726
  742846
  743069
  748980
  754207
  756789
  760955
  762271
  762809
  763009
  764843
  765103
  765364
  765366
  765540
  765708
  766711
  766712
  766786
  767055
  767972
  768703
  769786
  771344
  771429
  777631
  777646
  781412
  782445
  783275
  783778
  786372
  786400
  790394
  790770
  791426
  791599
  792953
  793179
  794142
  796364
  804708
  804995
  806046
  810533
  813903
]
14.18 ms
(7.58%)
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
  786400
  791599
  793179
  804708
  806046
  734432
  740726
  743069
  754207
  781412
  782445
  786372
  790770
  792953
  794142
  731234
  742846
  763009
  764843
  766711
  766712
  768703
  730457
  739913
  762271
  765103
  765366
  767972
  724118
  728379
  762809
  765364
  765540
  765708
  726641
  734959
  734990
  735961
  737051
  738589
  756789
  767055
  771429
  609267
  623130
  713670
  714964
  716992
  717221
  717725
  721971
  783275
  783778
  791426
  393475
  397856
  402438
  181184
  771344
  508542
  513157
  520388
  520788
  516511
  525030
  478310
  567311
  584915
  654338
  602409
  592402
  604338
  462207
  396075
  484827
  507092
  583383
  544200
  564348
  567232
  576134
  713911
  685513
  684122
  560961
  615698
  592686
  636956
  604322
  616885
  617698
  777646
  777631
  796364
  760955
  766786
  733246
  641192
  391717
  370332
  396245
  401976
  401108
  671890
  694132
  804995
  810533
  790394
  769786
  748980
  390643
  470965
  467948
  531647
  680780
  686113
  680395
  566764
  625461
  813903
]
3.56 ms
(1.90%)
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
  181184
  370332
  390643
  391717
  393475
  396075
  396245
  397856
  401108
  401976
  402438
  462207
  467948
  470965
  478310
  484827
  507092
  508542
  513157
  516511
  520388
  520788
  525030
  531647
  544200
  560961
  564348
  566764
  567232
  567311
  576134
  583383
  584915
  592402
  592686
  602409
  604322
  604338
  609267
  615698
  616885
  617698
  623130
  625461
  636956
  641192
  654338
  671890
  680395
  680780
  684122
  685513
  686113
  694132
  713670
  713911
  714964
  716992
  717221
  717725
  721971
  724118
  726641
  728379
  730457
  731234
  733246
  734432
  734959
  734990
  735961
  737051
  738589
  739913
  740726
  742846
  743069
  748980
  754207
  756789
  760955
  762271
  762809
  763009
  764843
  765103
  765364
  765366
  765540
  765708
  766711
  766712
  766786
  767055
  767972
  768703
  769786
  771344
  771429
  777631
  777646
  781412
  782445
  783275
  783778
  786372
  786400
  790394
  790770
  791426
  791599
  792953
  793179
  794142
  796364
  804708
  804995
  806046
  810533
  813903
]
2.24 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð¥ð╗ð¥ð┤ÐïðÁ Ðüð┐ðÁÐÇð╝ð░ ð▓ ð░ð¢ð░ð╗ÔÔǪ"
]
1.67 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые сперм анал"
]
1.55 ms
(0.83%)
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.