Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.60 ms
(53.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп шорт"
]
158.64 ms
(39.18%)
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
  382347
  412227
  414200
  415942
  418378
  424199
  424314
  425740
  427187
  432990
  436689
  438192
  442425
  442678
  442832
  443061
  444279
  445605
  446489
  447125
  451250
  452161
  454640
  454666
  455351
  458899
  460907
  463344
  463581
  464506
  466610
  466729
  468826
  469087
  470509
  474118
  474425
  474584
  476544
  478378
  479299
  480886
  484223
  488500
  488546
  489283
  489301
  489780
  489891
  490003
  493801
  495057
  495544
  504024
  504739
  505236
  506749
  507101
  507227
  510203
  511804
  513461
  513540
  513547
  513671
  514572
  516439
  516896
  517683
  518058
  518351
  520057
  521525
  522126
  523035
  523457
  523511
  523888
  524567
  524585
  524782
  525258
  525597
  526097
  526105
  527088
  528041
  528140
  528690
  528699
  528718
  529478
  530741
  530774
  535357
  539771
  549739
  552463
  554262
  554829
  555899
  556529
  558611
  561820
  562243
  563211
  563929
  566788
  567006
  567563
  569933
  591092
  600421
  604551
  605238
  609898
  613180
  619366
  674758
  675380
]
21.69 ms
(5.36%)
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
  490003
  495057
  504024
  517683
  523457
  510203
  522126
  535357
  516439
  525597
  530774
  523888
  526097
  528718
  567563
  561820
  567006
  674758
  549739
  554262
  555899
  563211
  619366
  591092
  600421
  436689
  443061
  458899
  463581
  464506
  480886
  442425
  460907
  444279
  470509
  474118
  412227
  415942
  418378
  432990
  463344
  479299
  445605
  478378
  513540
  516896
  518058
  520057
  523511
  525258
  489301
  506749
  511804
  513671
  524567
  529478
  488500
  489283
  493801
  507101
  514572
  518351
  524782
  528140
  505236
  507227
  524585
  469087
  558611
  454666
  569933
  604551
  613180
  424199
  513547
  438192
  442832
  454640
  447125
  476544
  495544
  526105
  527088
  528690
  566788
  605238
  609898
  427187
  504739
  484223
  489891
  513461
  425740
  556529
  523035
  528699
  528041
  382347
  552463
  554829
  474584
  675380
  562243
  563929
  451250
  455351
  530741
  452161
  446489
  414200
  442678
  424314
  466610
  468826
  488546
  489780
  466729
  474425
  521525
  539771
]
3.33 ms
(0.82%)
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
  382347
  412227
  414200
  415942
  418378
  424199
  424314
  425740
  427187
  432990
  436689
  438192
  442425
  442678
  442832
  443061
  444279
  445605
  446489
  447125
  451250
  452161
  454640
  454666
  455351
  458899
  460907
  463344
  463581
  464506
  466610
  466729
  468826
  469087
  470509
  474118
  474425
  474584
  476544
  478378
  479299
  480886
  484223
  488500
  488546
  489283
  489301
  489780
  489891
  490003
  493801
  495057
  495544
  504024
  504739
  505236
  506749
  507101
  507227
  510203
  511804
  513461
  513540
  513547
  513671
  514572
  516439
  516896
  517683
  518058
  518351
  520057
  521525
  522126
  523035
  523457
  523511
  523888
  524567
  524585
  524782
  525258
  525597
  526097
  526105
  527088
  528041
  528140
  528690
  528699
  528718
  529478
  530741
  530774
  535357
  539771
  549739
  552463
  554262
  554829
  555899
  556529
  558611
  561820
  562243
  563211
  563929
  566788
  567006
  567563
  569933
  591092
  600421
  604551
  605238
  609898
  613180
  619366
  674758
  675380
]
2.33 ms
(0.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.29 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass shorts"
]
2.06 ms
(0.51%)
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.