Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
274.86 ms
(67.49%)
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
  470007
  470311
  506861
  437980
  406853
  416152
  444841
  411183
  440710
  452827
  434964
  460525
  466645
  422241
  430396
  449280
  484764
  453506
  472379
  498933
  446745
  123994
  419427
  434081
  441664
  431727
  435658
  426042
  418032
  482579
  466708
  477636
  445632
  455023
  469349
  463590
  481550
  420507
  458269
  456307
  425594
  466486
  461581
  522409
  501232
  403283
  447217
  411425
  454954
  434854
  435165
  444523
  420217
  423642
  456807
  468738
  463420
  444672
  389281
  436578
  467646
  463445
  480895
  469299
  527205
  508316
  508374
  432656
  423513
  458318
  452405
  495221
  441925
  429107
  419567
  404346
  439195
  445825
  454743
  457208
  428253
  435795
  449586
  464836
  431209
  441756
  452269
  462402
  454600
  462696
  460359
  454869
  454111
  385830
  420219
  428354
  428595
  448512
  461655
  474809
  472399
  418005
  425682
  459040
  463271
  462996
  427843
  429929
  457881
  441288
  405683
  430832
  432270
  435512
  441654
  410891
  448196
  478791
  478285
  452410
]
123.18 ms
(30.25%)
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
  123994
  385830
  389281
  403283
  404346
  405683
  406853
  410891
  411183
  411425
  416152
  418005
  418032
  419427
  419567
  420217
  420219
  420507
  422241
  423513
  423642
  425594
  425682
  426042
  427843
  428253
  428354
  428595
  429107
  429929
  430396
  430832
  431209
  431727
  432270
  432656
  434081
  434854
  434964
  435165
  435512
  435658
  435795
  436578
  437980
  439195
  440710
  441288
  441654
  441664
  441756
  441925
  444523
  444672
  444841
  445632
  445825
  446745
  447217
  448196
  448512
  449280
  449586
  452269
  452405
  452410
  452827
  453506
  454111
  454600
  454743
  454869
  454954
  455023
  456307
  456807
  457208
  457881
  458269
  458318
  459040
  460359
  460525
  461581
  461655
  462402
  462696
  462996
  463271
  463420
  463445
  463590
  464836
  466486
  466645
  466708
  467646
  468738
  469299
  469349
  470007
  470311
  472379
  472399
  474809
  477636
  478285
  478791
  480895
  481550
  482579
  484764
  495221
  498933
  501232
  506861
  508316
  508374
  522409
  527205
]
2.74 ms
(0.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
  123994
  385830
  389281
  403283
  404346
  405683
  406853
  410891
  411183
  411425
  416152
  418005
  418032
  419427
  419567
  420217
  420219
  420507
  422241
  423513
  423642
  425594
  425682
  426042
  427843
  428253
  428354
  428595
  429107
  429929
  430396
  430832
  431209
  431727
  432270
  432656
  434081
  434854
  434964
  435165
  435512
  435658
  435795
  436578
  437980
  439195
  440710
  441288
  441654
  441664
  441756
  441925
  444523
  444672
  444841
  445632
  445825
  446745
  447217
  448196
  448512
  449280
  449586
  452269
  452405
  452410
  452827
  453506
  454111
  454600
  454743
  454869
  454954
  455023
  456307
  456807
  457208
  457881
  458269
  458318
  459040
  460359
  460525
  461581
  461655
  462402
  462696
  462996
  463271
  463420
  463445
  463590
  464836
  466486
  466645
  466708
  467646
  468738
  469299
  469349
  470007
  470311
  472379
  472399
  474809
  477636
  478285
  478791
  480895
  481550
  482579
  484764
  495221
  498933
  501232
  506861
  508316
  508374
  522409
  527205
]
1.75 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "стройные голые девушк…"
]
1.68 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "стройные голые девушк"
]
1.59 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.36%)
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.