Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.17 ms
(53.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young волосатая анал"
]
153.71 ms
(39.10%)
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
  385314
  385469
  388722
  389966
  390402
  390567
  390747
  391034
  391945
  395596
  395682
  395860
  396020
  401137
  401967
  404318
  404644
  404698
  404768
  404829
  404939
  405029
  405485
  405830
  406062
  408245
  409083
  409877
  410237
  411761
  411918
  413460
  415112
  422592
  422652
  424410
  424426
  424436
  424461
  424462
  426434
  427433
  428703
  443695
  445903
  447094
  451464
  453096
  454298
  457500
  458011
  459802
  459804
  461056
  461620
  462470
  463948
  466212
  469283
  469576
  474685
  476344
  481998
  483149
  486542
  488373
  491354
  491392
  493951
  495558
  496032
  503127
  510578
  511815
  512800
  513149
  513785
  519268
  522611
  528020
  529524
  544478
  565156
  565172
  576720
  577368
  579389
  586628
  590802
  597494
  600316
  614023
  614401
  619439
  623493
  624427
  628327
  630526
  661974
  685791
  688546
  688624
  703140
  703902
  706286
  712311
  718496
  727812
  736440
  776312
  789691
  790813
  799146
  802723
  804464
  815869
  816340
  818442
  820327
  821365
]
20.54 ms
(5.23%)
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
  424436
  619439
  404698
  422592
  422652
  469576
  503127
  630526
  804464
  415112
  404318
  385314
  409877
  427433
  395860
  410237
  411761
  424462
  401137
  790813
  736440
  623493
  821365
  510578
  597494
  706286
  703140
  528020
  624427
  727812
  586628
  426434
  453096
  395682
  776312
  404939
  688624
  614023
  614401
  451464
  491354
  462470
  685791
  396020
  481998
  495558
  401967
  463948
  512800
  712311
  390747
  411918
  469283
  424426
  496032
  390567
  816340
  818442
  688546
  789691
  385469
  511815
  590802
  544478
  428703
  466212
  405485
  454298
  513785
  459804
  408245
  458011
  404644
  461620
  404829
  388722
  519268
  483149
  404768
  600316
  445903
  491392
  628327
  577368
  579389
  565172
  576720
  565156
  488373
  389966
  457500
  529524
  395596
  406062
  447094
  486542
  661974
  703902
  802723
  424410
  391945
  443695
  405029
  476344
  405830
  424461
  513149
  820327
  815869
  718496
  390402
  409083
  459802
  474685
  461056
  391034
  413460
  522611
  799146
  493951
]
3.03 ms
(0.77%)
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
  385314
  385469
  388722
  389966
  390402
  390567
  390747
  391034
  391945
  395596
  395682
  395860
  396020
  401137
  401967
  404318
  404644
  404698
  404768
  404829
  404939
  405029
  405485
  405830
  406062
  408245
  409083
  409877
  410237
  411761
  411918
  413460
  415112
  422592
  422652
  424410
  424426
  424436
  424461
  424462
  426434
  427433
  428703
  443695
  445903
  447094
  451464
  453096
  454298
  457500
  458011
  459802
  459804
  461056
  461620
  462470
  463948
  466212
  469283
  469576
  474685
  476344
  481998
  483149
  486542
  488373
  491354
  491392
  493951
  495558
  496032
  503127
  510578
  511815
  512800
  513149
  513785
  519268
  522611
  528020
  529524
  544478
  565156
  565172
  576720
  577368
  579389
  586628
  590802
  597494
  600316
  614023
  614401
  619439
  623493
  624427
  628327
  630526
  661974
  685791
  688546
  688624
  703140
  703902
  706286
  712311
  718496
  727812
  736440
  776312
  789691
  790813
  799146
  802723
  804464
  815869
  816340
  818442
  820327
  821365
]
2.04 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young hairy anal"
]
1.86 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young волосатая анал"
]

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.