Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.88 ms
(82.97%)
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
  46053
  213017
  382728
  384967
  386555
  389065
  390707
  393430
  418429
  425478
  432533
  432571
  433059
  433061
  433433
  433599
  433740
  434087
  434236
  438366
  441357
  441635
  442076
  443173
  446527
  446669
  447164
  458787
  460442
  487555
  489768
  493296
  506942
  520166
  524020
  528861
  530606
  538060
  539154
  540372
  542777
  544073
  545241
  548408
  552247
  554046
  561571
  565227
  568559
  570853
  579790
  584130
  591124
  592682
  592747
  593245
  593736
  595679
  595841
  599716
  599798
  603299
  604874
  606109
  608105
  621453
  650556
  661507
  664206
  664658
  677994
  697392
  697893
  709402
  709878
  710050
  710900
  717782
  719972
  723259
  728651
  741037
  744764
  746436
  746457
  746580
  746589
  749427
  753494
  755364
  758065
  758302
  758375
  761391
  764768
  767720
  769237
  775530
  780244
  784936
  785104
  791828
  792463
  792470
  792922
  794061
  803732
  814666
  817408
  817564
  825250
  828029
  828152
  828279
  828435
  828557
  828673
  828795
  828797
]
18.37 ms
(10.45%)
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
  746580
  753494
  758375
  746457
  749427
  755364
  767720
  728651
  746436
  746589
  758065
  758302
  710050
  717782
  775530
  791828
  792463
  792470
  792922
  794061
  803732
  446527
  389065
  390707
  433433
  825250
  828279
  828152
  828029
  828795
  828435
  591124
  213017
  493296
  441357
  433740
  441635
  425478
  442076
  487555
  458787
  528861
  506942
  552247
  579790
  606109
  592747
  593245
  432533
  433059
  438366
  447164
  432571
  433061
  433599
  434236
  489768
  817564
  817408
  828233
  828797
  828673
  828557
  540372
  604874
  784936
  741037
  744764
  769237
  761391
  382728
  764768
  386555
  384967
  393430
  46053
  418429
  443173
  434087
  814666
  446669
  520166
  530606
  538060
  524020
  539154
  460442
  542777
  561571
  570853
  584130
  568559
  544073
  548408
  554046
  565227
  664658
  709402
  650556
  661507
  709878
  710900
  723259
  664206
  677994
  697392
  697893
  719972
  545241
  603299
  595679
  621453
  592682
  593736
  595841
  608105
  599716
  599798
  780244
  785104
]
2.70 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "видео для дрочи"
]
2.46 ms
(1.40%)
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
  46053
  213017
  382728
  384967
  386555
  389065
  390707
  393430
  418429
  425478
  432533
  432571
  433059
  433061
  433433
  433599
  433740
  434087
  434236
  438366
  441357
  441635
  442076
  443173
  446527
  446669
  447164
  458787
  460442
  487555
  489768
  493296
  506942
  520166
  524020
  528861
  530606
  538060
  539154
  540372
  542777
  544073
  545241
  548408
  552247
  554046
  561571
  565227
  568559
  570853
  579790
  584130
  591124
  592682
  592747
  593245
  593736
  595679
  595841
  599716
  599798
  603299
  604874
  606109
  608105
  621453
  650556
  661507
  664206
  664658
  677994
  697392
  697893
  709402
  709878
  710050
  710900
  717782
  719972
  723259
  728651
  741037
  744764
  746436
  746457
  746580
  746589
  749427
  753494
  755364
  758065
  758302
  758375
  761391
  764768
  767720
  769237
  775530
  780244
  784936
  785104
  791828
  792463
  792470
  792922
  794061
  803732
  814666
  817408
  817564
  825250
  828029
  828152
  828279
  828435
  828557
  828673
  828795
  828797
]
2.31 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "виде дрочк"
]
2.19 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.08%)
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.