Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.06 ms
(82.31%)
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
  13229
  187800
  187851
  188122
  188655
  224587
  326115
  362726
  384124
  385581
  387104
  387524
  387856
  388714
  388740
  388785
  391287
  393481
  395861
  403324
  409312
  413678
  415147
  421866
  421883
  422171
  426515
  428155
  432625
  432803
  439634
  439662
  439722
  439791
  439856
  440911
  440996
  441583
  441921
  442814
  451497
  455882
  459649
  461081
  464198
  467124
  468338
  468373
  471685
  473325
  474109
  474260
  475294
  477133
  478378
  481124
  483656
  497730
  498081
  500963
  519071
  522508
  523338
  530402
  531556
  535441
  537264
  542950
  544108
  549237
  555103
  555282
  559359
  564285
  564296
  564297
  570402
  586963
  591333
  595425
  627361
  646289
  680434
  710560
  711744
  715952
  725619
  733251
  734390
  735031
  735880
  735936
  736099
  736174
  742351
  742633
  743829
  749245
  756241
  758122
  758192
  759878
  759946
  773312
  784066
  787870
  788543
  791624
  813085
  816382
  817886
  818542
  824164
  824360
  826265
  827492
  827632
  827973
  828380
  828553
]
19.18 ms
(11.27%)
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
  432803
  468338
  421866
  421883
  461081
  395861
  471685
  519071
  385581
  387524
  441921
  441583
  432625
  455882
  595425
  474260
  500963
  388714
  409312
  467124
  710560
  759946
  627361
  788543
  481124
  387856
  388785
  403324
  384124
  478378
  483656
  522508
  426515
  415147
  459649
  393481
  549237
  586963
  422171
  451497
  535441
  188655
  224587
  413678
  816382
  824360
  824164
  817886
  542950
  564285
  787870
  735880
  759878
  734390
  784066
  13229
  464198
  187851
  391287
  474109
  388740
  428155
  523338
  715952
  742633
  497730
  498081
  818542
  827632
  646289
  362726
  387104
  826265
  827492
  828553
  711744
  564296
  758192
  773312
  791624
  475294
  187800
  439634
  439662
  439856
  439722
  439791
  442814
  440996
  591333
  440911
  188122
  326115
  828380
  827973
  473325
  477133
  468373
  531556
  537264
  530402
  544108
  559359
  555282
  564297
  570402
  680434
  555103
  813085
  742351
  749245
  736174
  756241
  735031
  743829
  733251
  735936
  725619
  736099
  758122
]
2.84 ms
(1.67%)
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
  13229
  187800
  187851
  188122
  188655
  224587
  326115
  362726
  384124
  385581
  387104
  387524
  387856
  388714
  388740
  388785
  391287
  393481
  395861
  403324
  409312
  413678
  415147
  421866
  421883
  422171
  426515
  428155
  432625
  432803
  439634
  439662
  439722
  439791
  439856
  440911
  440996
  441583
  441921
  442814
  451497
  455882
  459649
  461081
  464198
  467124
  468338
  468373
  471685
  473325
  474109
  474260
  475294
  477133
  478378
  481124
  483656
  497730
  498081
  500963
  519071
  522508
  523338
  530402
  531556
  535441
  537264
  542950
  544108
  549237
  555103
  555282
  559359
  564285
  564296
  564297
  570402
  586963
  591333
  595425
  627361
  646289
  680434
  710560
  711744
  715952
  725619
  733251
  734390
  735031
  735880
  735936
  736099
  736174
  742351
  742633
  743829
  749245
  756241
  758122
  758192
  759878
  759946
  773312
  784066
  787870
  788543
  791624
  813085
  816382
  817886
  818542
  824164
  824360
  826265
  827492
  827632
  827973
  828380
  828553
]
2.31 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак анал mature"
]
2.04 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy anal mature"
]
2.01 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак анал mature"
]

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.