Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.70 ms
(80.72%)
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
  13767
  27635
  329500
  401560
  421432
  425128
  427057
  446061
  447376
  454516
  456894
  459265
  497125
  497324
  523049
  523940
  526539
  528988
  530405
  534339
  534353
  535432
  537615
  537828
  541669
  541762
  542144
  544956
  545761
  548510
  550013
  556093
  558145
  562953
  563535
  568721
  576317
  576480
  577493
  579123
  580710
  584593
  585896
  606792
  611485
  613629
  614766
  614848
  619094
  633034
  634432
  634463
  647219
  661378
  680933
  680945
  680968
  683435
  683766
  688999
  692713
  698819
  699859
  702143
  713167
  713187
  714004
  717601
  718520
  719094
  719563
  721882
  721906
  721918
  728713
  732923
  734028
  734069
  734071
  737144
  738421
  738909
  739220
  743653
  750982
  757026
  757548
  768017
  768057
  768969
  768983
  771393
  772844
  776637
  778523
  778765
  781413
  785103
  785526
  785540
  789045
  789265
  791491
  792186
  792434
  792456
  792757
  793050
  793973
  798842
  801637
  802704
  804353
  805138
  805190
  808849
  809537
  811897
  812485
  813296
]
20.74 ms
(12.34%)
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
  680968
  683766
  699859
  634432
  619094
  613629
  614848
  785526
  805138
  778765
  789265
  813296
  792434
  793050
  808849
  734069
  732923
  737144
  702143
  789045
  791491
  809537
  454516
  534353
  541669
  556093
  713167
  568721
  585896
  739220
  768057
  768969
  523940
  456894
  534339
  576480
  541762
  544956
  713187
  719094
  661378
  680933
  692713
  717601
  719563
  721918
  801637
  728713
  792456
  750982
  721882
  804353
  329500
  421432
  579123
  459265
  425128
  562953
  812485
  781413
  528988
  446061
  580710
  447376
  497324
  718520
  611485
  542144
  633034
  776637
  738909
  738421
  401560
  27635
  427057
  497125
  530405
  537828
  577493
  558145
  647219
  714004
  683435
  698819
  680945
  688999
  606792
  614766
  805190
  811897
  743653
  757026
  772844
  793973
  802704
  734028
  768983
  771393
  734071
  757548
  768017
  634463
  721906
  778523
  785103
  785540
  792186
  792757
  798842
  523049
  526539
  535432
  576317
  563535
  13767
  537615
  584593
  545761
  548510
  550013
]
3.16 ms
(1.88%)
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
  13767
  27635
  329500
  401560
  421432
  425128
  427057
  446061
  447376
  454516
  456894
  459265
  497125
  497324
  523049
  523940
  526539
  528988
  530405
  534339
  534353
  535432
  537615
  537828
  541669
  541762
  542144
  544956
  545761
  548510
  550013
  556093
  558145
  562953
  563535
  568721
  576317
  576480
  577493
  579123
  580710
  584593
  585896
  606792
  611485
  613629
  614766
  614848
  619094
  633034
  634432
  634463
  647219
  661378
  680933
  680945
  680968
  683435
  683766
  688999
  692713
  698819
  699859
  702143
  713167
  713187
  714004
  717601
  718520
  719094
  719563
  721882
  721906
  721918
  728713
  732923
  734028
  734069
  734071
  737144
  738421
  738909
  739220
  743653
  750982
  757026
  757548
  768017
  768057
  768969
  768983
  771393
  772844
  776637
  778523
  778765
  781413
  785103
  785526
  785540
  789045
  789265
  791491
  792186
  792434
  792456
  792757
  793050
  793973
  798842
  801637
  802704
  804353
  805138
  805190
  808849
  809537
  811897
  812485
  813296
]
2.68 ms
(1.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк пляж природ"
]
2.04 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl beach"
]
1.69 ms
(1.01%)
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.