Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.89 ms
(83.29%)
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
  6976
  91510
  157617
  382078
  391478
  391686
  393050
  393145
  393233
  395937
  395989
  396075
  396456
  396552
  396724
  398200
  399066
  399378
  399837
  401367
  402351
  403293
  403703
  405421
  417135
  418347
  418862
  420118
  421517
  424303
  429071
  429319
  429909
  430293
  437562
  443232
  444726
  445182
  446165
  452424
  452740
  452744
  453047
  454081
  456158
  456555
  456588
  460107
  462967
  464563
  465808
  470278
  473127
  475483
  476946
  480230
  484717
  496730
  503411
  507291
  517905
  527215
  528496
  530493
  531913
  533012
  533982
  535644
  536251
  536579
  538665
  561073
  574372
  605892
  625895
  633768
  639762
  640813
  648701
  664476
  666528
  669446
  673223
  676636
  680100
  689456
  691567
  693291
  694612
  698405
  701309
  709693
  718983
  722494
  723589
  728225
  728269
  738435
  741527
  758196
  758486
  770420
  770456
  770797
  772421
  774672
  777619
  778042
  789588
  800367
  805367
  805900
  806324
  810261
  813884
  814123
  823173
  825876
]
15.35 ms
(9.41%)
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
  536251
  443232
  446165
  676636
  694612
  805367
  625895
  464563
  462967
  456588
  405421
  418862
  437562
  722494
  673223
  691567
  664476
  605892
  772421
  728225
  728269
  770420
  758486
  402351
  398200
  460107
  594372
  393233
  806324
  470278
  561073
  403293
  723589
  456158
  496730
  538665
  669446
  701309
  738435
  91510
  396724
  468318
  396552
  418347
  417135
  709693
  465808
  391478
  399837
  813884
  814123
  452744
  698405
  774672
  810261
  770456
  6976
  393145
  444726
  528496
  574372
  758196
  393050
  403703
  473127
  429909
  533012
  445182
  533982
  640813
  639762
  633768
  503411
  527215
  382078
  399066
  420118
  429319
  823173
  476946
  484717
  480230
  531913
  648701
  741527
  453047
  456555
  517905
  680100
  666528
  157617
  391686
  825876
  452424
  452740
  689456
  693291
  805900
  777619
  778042
  770797
  718983
  789588
  800367
  395989
  421517
  424303
  454081
  475483
  536579
  535644
  530493
  507291
  395937
  396075
  396456
  399378
  401367
  429071
  430293
]
3.95 ms
(2.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.80 ms
(1.72%)
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
  6976
  91510
  157617
  382078
  391478
  391686
  393050
  393145
  393233
  395937
  395989
  396075
  396456
  396552
  396724
  398200
  399066
  399378
  399837
  401367
  402351
  403293
  403703
  405421
  417135
  418347
  418862
  420118
  421517
  424303
  429071
  429319
  429909
  430293
  437562
  443232
  444726
  445182
  446165
  452424
  452740
  452744
  453047
  454081
  456158
  456555
  456588
  460107
  462967
  464563
  465808
  470278
  473127
  475483
  476946
  480230
  484717
  496730
  503411
  507291
  517905
  527215
  528496
  530493
  531913
  533012
  533982
  535644
  536251
  536579
  538665
  561073
  574372
  605892
  625895
  633768
  639762
  640813
  648701
  664476
  666528
  669446
  673223
  676636
  680100
  689456
  691567
  693291
  694612
  698405
  701309
  709693
  718983
  722494
  723589
  728225
  728269
  738435
  741527
  758196
  758486
  770420
  770456
  770797
  772421
  774672
  777619
  778042
  789588
  800367
  805367
  805900
  806324
  810261
  813884
  814123
  823173
  825876
]
1.88 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge dick teen"
]
1.75 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные член teen"
]
1.53 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные член teen"
]

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.