Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
188.44 ms
(83.26%)
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
  385380
  388151
  411036
  411044
  413464
  419147
  423988
  425578
  438077
  439601
  439668
  440988
  442695
  444041
  446293
  449158
  452388
  458005
  464391
  467888
  468019
  468281
  469066
  476331
  481964
  486884
  489127
  493115
  493280
  494207
  498425
  507214
  509272
  510918
  513023
  513630
  514390
  514680
  515133
  515624
  519655
  519994
  520015
  520020
  525369
  527168
  536547
  537483
  542369
  546898
  555377
  555410
  559052
  573746
  575031
  580127
  582431
  583205
  584766
  587157
  591338
  598325
  607569
  608931
  620579
  621344
  621712
  622976
  625947
  632186
  639010
  642928
  666068
  672825
  700821
  706569
  708150
  708573
  708587
  709325
  709404
  709807
  710682
  712634
  715373
  723175
  724921
  726975
  728478
  728808
  728937
  740347
  741053
  743497
  753033
  757434
  759356
  759739
  760602
  761889
  764234
  765514
  769158
  773908
  784624
  784667
  784876
  788528
  789968
  791117
  792819
  794761
  795058
  803489
  803826
  804721
  812067
  812384
  813416
  823786
]
26.47 ms
(11.70%)
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
  494207
  493115
  513630
  481964
  489127
  789968
  715373
  413464
  442695
  449158
  458005
  452388
  515624
  446293
  546898
  559052
  575031
  580127
  723175
  425578
  514680
  527168
  469066
  468281
  520020
  584766
  591338
  724921
  438077
  440988
  509272
  525369
  493280
  498425
  515133
  823786
  513023
  536547
  582431
  672825
  700821
  710682
  712634
  666068
  708573
  709404
  608931
  621344
  587157
  788528
  804721
  784876
  803489
  812067
  757434
  760602
  773908
  791117
  803826
  759739
  761889
  728808
  759356
  728478
  706569
  708150
  795058
  519655
  468019
  464391
  520015
  486884
  573746
  622976
  621712
  439668
  467888
  419147
  444041
  476331
  411036
  439601
  388151
  411044
  423988
  519994
  507214
  510918
  583205
  708587
  709807
  598325
  620579
  625947
  607569
  639010
  642928
  784667
  792819
  740347
  769158
  794761
  812384
  813416
  753033
  726975
  743497
  765514
  764234
  728937
  741053
  632186
  709325
  784624
  385380
  514390
  537483
  555377
  555410
  542369
]
3.33 ms
(1.47%)
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
  385380
  388151
  411036
  411044
  413464
  419147
  423988
  425578
  438077
  439601
  439668
  440988
  442695
  444041
  446293
  449158
  452388
  458005
  464391
  467888
  468019
  468281
  469066
  476331
  481964
  486884
  489127
  493115
  493280
  494207
  498425
  507214
  509272
  510918
  513023
  513630
  514390
  514680
  515133
  515624
  519655
  519994
  520015
  520020
  525369
  527168
  536547
  537483
  542369
  546898
  555377
  555410
  559052
  573746
  575031
  580127
  582431
  583205
  584766
  587157
  591338
  598325
  607569
  608931
  620579
  621344
  621712
  622976
  625947
  632186
  639010
  642928
  666068
  672825
  700821
  706569
  708150
  708573
  708587
  709325
  709404
  709807
  710682
  712634
  715373
  723175
  724921
  726975
  728478
  728808
  728937
  740347
  741053
  743497
  753033
  757434
  759356
  759739
  760602
  761889
  764234
  765514
  769158
  773908
  784624
  784667
  784876
  788528
  789968
  791117
  792819
  794761
  795058
  803489
  803826
  804721
  812067
  812384
  813416
  823786
]
2.54 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "your mother"
]
1.94 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "your мам женщин"
]
1.67 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "your мам женщин"
]

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.