Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.46 ms
(86.77%)
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
  365056
  428570
  452746
  462580
  518766
  529922
  536299
  542131
  544048
  545248
  547441
  547496
  548451
  550542
  553221
  555245
  555253
  555415
  555775
  558268
  559491
  566423
  567622
  583492
  585193
  585256
  585898
  586016
  586134
  589807
  593521
  599364
  605890
  616018
  617573
  618259
  618494
  619697
  622358
  623130
  626796
  628611
  628751
  630828
  633715
  634081
  634605
  636585
  638999
  639821
  640366
  640442
  642004
  648122
  650146
  669870
  670251
  680542
  687382
  692972
  696763
  699323
  701000
  702318
  706895
  707441
  708541
  709544
  712628
  718498
  722043
  726490
  726917
  728181
  728518
  731007
  734346
  734380
  736808
  739184
  743756
  744003
  746562
  755949
  756830
  761724
  768870
  772522
  773912
  775650
  776842
  779223
  780605
  781496
  784988
  786736
  788244
  788981
  789520
  792796
  793138
  794194
  794215
  794639
  795341
  795425
  795876
  796314
  798593
  798755
  800641
  801455
  801621
  803111
  804026
  805266
  810093
  811844
  811873
]
12.43 ms
(7.07%)
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
  547441
  559491
  566423
  593521
  616018
  628751
  642004
  630828
  633715
  636585
  599364
  628611
  634605
  586016
  638999
  779223
  780605
  800641
  801455
  781496
  794215
  794639
  798593
  734346
  734380
  743671
  784988
  796314
  801621
  811873
  728181
  743756
  726490
  726917
  736808
  728518
  755949
  768870
  772522
  773912
  756830
  622358
  623130
  701000
  708541
  788981
  793138
  795425
  803111
  804026
  811844
  452746
  544048
  555775
  555253
  555415
  567622
  550542
  555245
  619697
  585193
  605890
  586134
  640366
  794194
  699323
  536299
  680542
  585898
  626796
  761724
  365056
  462580
  670251
  634081
  545248
  558268
  648122
  795876
  795341
  798755
  529922
  553221
  702318
  617573
  744003
  547496
  428570
  518766
  542131
  548451
  583492
  687382
  692972
  696763
  722043
  650146
  718498
  669870
  706895
  707441
  709544
  712628
  585256
  640442
  589807
  639821
  618259
  618494
  775650
  776842
  786736
  788244
  789520
  805266
  731007
  739184
  746562
  792796
  810093
]
2.81 ms
(1.60%)
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
  365056
  428570
  452746
  462580
  518766
  529922
  536299
  542131
  544048
  545248
  547441
  547496
  548451
  550542
  553221
  555245
  555253
  555415
  555775
  558268
  559491
  566423
  567622
  583492
  585193
  585256
  585898
  586016
  586134
  589807
  593521
  599364
  605890
  616018
  617573
  618259
  618494
  619697
  622358
  623130
  626796
  628611
  628751
  630828
  633715
  634081
  634605
  636585
  638999
  639821
  640366
  640442
  642004
  648122
  650146
  669870
  670251
  680542
  687382
  692972
  696763
  699323
  701000
  702318
  706895
  707441
  708541
  709544
  712628
  718498
  722043
  726490
  726917
  728181
  728518
  731007
  734346
  734380
  736808
  739184
  743756
  744003
  746562
  755949
  756830
  761724
  768870
  772522
  773912
  775650
  776842
  779223
  780605
  781496
  784988
  786736
  788244
  788981
  789520
  792796
  793138
  794194
  794215
  794639
  795341
  795425
  795876
  796314
  798593
  798755
  800641
  801455
  801621
  803111
  804026
  805266
  810093
  811844
  811873
]
2.64 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gape vagina"
]
2.02 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк вагин"
]
1.56 ms
(0.89%)
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.