Query Metrics

10 Database Queries
10 Different statements
224.04 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.82 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.82 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толпой"
]
3 1.84 ms
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01’ÜŒƒkq\x7F°zyÐÀ©>\x10"
]
4 2.30 ms
SELECT COUNT(*)
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)
            WHERE p.type = ? AND `p`.`status` = ? AND `t0`.`is_tested` = 1
Parameters:
[
  b"\x01’ÜŒƒkq\x7F°zyÐÀ©>\x10"
  0
  10
]
5 6.74 ms
SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = ? AND p.post_id = t0.post_id WHERE (p.type = ? AND p.status = ?) AND (t0.is_tested = 0) ORDER BY t0.ctr DESC LIMIT 120 OFFSET 840
Parameters:
[
  b"\x01’ÜŒƒkq\x7F°zyÐÀ©>\x10"
  0
  10
]
6 17.31 ms
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
  679536
  679471
  679467
  679465
  679461
  679457
  679453
  679447
  679444
  679441
  679420
  679396
  679326
  679317
  679314
  679099
  679098
  679034
  679032
  679029
  679025
  679019
  679016
  679003
  678985
  678795
  678791
  678533
  678529
  678522
  678517
  678514
  678495
  678493
  678479
  678192
  678161
  678153
  678144
  678143
  678141
  678138
  678135
  678127
  678126
  678125
  678121
  678117
  678109
  678099
  678097
  678089
  678081
  678073
  678067
  678066
  678063
  678053
  678052
  678032
  678028
  677986
  677952
  677881
  677801
  677798
  677784
  677783
  677781
  677777
  677773
  677730
  677705
  677703
  677676
  677674
  677672
  677671
  677307
  677303
  677296
  677295
  677293
  677098
  677088
  677082
  677075
  676989
  676896
  676895
  676887
  676850
  676788
  676641
  676638
  676636
  676632
  676623
  676622
  676428
  676397
  676396
  676375
  676345
  676344
  676342
  676333
  676326
  676313
  676309
  676112
  676111
  676110
  676107
  676103
  676101
  676097
  676095
  676092
  676091
]
7 2.70 ms
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
  676091
  676092
  676095
  676097
  676101
  676103
  676107
  676110
  676111
  676112
  676309
  676313
  676326
  676333
  676342
  676344
  676345
  676375
  676396
  676397
  676428
  676622
  676623
  676632
  676636
  676638
  676641
  676788
  676850
  676887
  676895
  676896
  676989
  677075
  677082
  677088
  677098
  677293
  677295
  677296
  677303
  677307
  677671
  677672
  677674
  677676
  677703
  677705
  677730
  677773
  677777
  677781
  677783
  677784
  677798
  677801
  677881
  677952
  677986
  678028
  678032
  678052
  678053
  678063
  678066
  678067
  678073
  678081
  678089
  678097
  678099
  678109
  678117
  678121
  678125
  678126
  678127
  678135
  678138
  678141
  678143
  678144
  678153
  678161
  678192
  678479
  678493
  678495
  678514
  678517
  678522
  678529
  678533
  678791
  678795
  678985
  679003
  679016
  679019
  679025
  679029
  679032
  679034
  679098
  679099
  679314
  679317
  679326
  679396
  679420
  679441
  679444
  679447
  679453
  679457
  679461
  679465
  679467
  679471
  679536
]
8 185.76 ms
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
  676091
  676092
  676095
  676097
  676101
  676103
  676107
  676110
  676111
  676112
  676309
  676313
  676326
  676333
  676342
  676344
  676345
  676375
  676396
  676397
  676428
  676622
  676623
  676632
  676636
  676638
  676641
  676788
  676850
  676887
  676895
  676896
  676989
  677075
  677082
  677088
  677098
  677293
  677295
  677296
  677303
  677307
  677671
  677672
  677674
  677676
  677703
  677705
  677730
  677773
  677777
  677781
  677783
  677784
  677798
  677801
  677881
  677952
  677986
  678028
  678032
  678052
  678053
  678063
  678066
  678067
  678073
  678081
  678089
  678097
  678099
  678109
  678117
  678121
  678125
  678126
  678127
  678135
  678138
  678141
  678143
  678144
  678153
  678161
  678192
  678479
  678493
  678495
  678514
  678517
  678522
  678529
  678533
  678791
  678795
  678985
  679003
  679016
  679019
  679025
  679029
  679032
  679034
  679098
  679099
  679314
  679317
  679326
  679396
  679420
  679441
  679444
  679447
  679453
  679457
  679461
  679465
  679467
  679471
  679536
]
9 2.10 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "группов секс"
]
10 1.66 ms
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.