Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.08 ms
(84.20%)
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
  475327
  479982
  484153
  491178
  533175
  533190
  533230
  533288
  541063
  544072
  545254
  545858
  553106
  553429
  553806
  559305
  559316
  562554
  564043
  577676
  578427
  592851
  594286
  596381
  601328
  611463
  614281
  615156
  637798
  642226
  646066
  648422
  649072
  655538
  666683
  672725
  672732
  686741
  687140
  688268
  691611
  697733
  697937
  700717
  715457
  727985
  743069
  746262
  754939
  759249
  760397
  763413
  763433
  763550
  764246
  764856
  764858
  765369
  765995
  767339
  767449
  768533
  768542
  772551
  773193
  773407
  773413
  774327
  774420
  777565
  777591
  781553
  781636
  783354
  784063
  785985
  787071
  787583
  791788
  792462
  792500
  793348
  794065
  795112
  795474
  796004
  797208
  798582
  799218
  799515
  799608
  800782
  801547
  802514
  802588
  803181
  804779
  805209
  805523
  806116
  808478
  809231
  809672
  809739
  809861
  809908
  810424
  813861
  813977
  815059
  815085
  815103
  815115
  815134
  816627
  825049
  827757
]
12.70 ms
(8.35%)
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
  793348
  799218
  799515
  801547
  805209
  809739
  809861
  727985
  743069
  763433
  765995
  767449
  781553
  783354
  784063
  787583
  791788
  792462
  792500
  794065
  795474
  797208
  799608
  802588
  803181
  804779
  805523
  808478
  809672
  809908
  760397
  764858
  773193
  754939
  759249
  764246
  773407
  774327
  746262
  763413
  763550
  765369
  767339
  768533
  768542
  772551
  773413
  764856
  614281
  637798
  697733
  700717
  777565
  777591
  781636
  785985
  787071
  796004
  798582
  800782
  802514
  806116
  809231
  810424
  816627
  686741
  764517
  815115
  825049
  826432
  827757
  828697
  795112
  815085
  774420
  815059
  815103
  813861
  813977
  815134
  479982
  475327
  484153
  533288
  533190
  533230
  533175
  491178
  545858
  553429
  553806
  562554
  577676
  559305
  559316
  578427
  541063
  544072
  545254
  553106
  649072
  687140
  688268
  691611
  655538
  672725
  672732
  715457
  646066
  648422
  666683
  697937
  564043
  592851
  596381
  601328
  611463
  615156
  642226
  594286
]
3.07 ms
(2.02%)
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
  475327
  479982
  484153
  491178
  533175
  533190
  533230
  533288
  541063
  544072
  545254
  545858
  553106
  553429
  553806
  559305
  559316
  562554
  564043
  577676
  578427
  592851
  594286
  596381
  601328
  611463
  614281
  615156
  637798
  642226
  646066
  648422
  649072
  655538
  666683
  672725
  672732
  686741
  687140
  688268
  691611
  697733
  697937
  700717
  715457
  727985
  743069
  746262
  754939
  759249
  760397
  763413
  763433
  763550
  764246
  764856
  764858
  765369
  765995
  767339
  767449
  768533
  768542
  772551
  773193
  773407
  773413
  774327
  774420
  777565
  777591
  781553
  781636
  783354
  784063
  785985
  787071
  787583
  791788
  792462
  792500
  793348
  794065
  795112
  795474
  796004
  797208
  798582
  799218
  799515
  799608
  800782
  801547
  802514
  802588
  803181
  804779
  805209
  805523
  806116
  808478
  809231
  809672
  809739
  809861
  809908
  810424
  813861
  813977
  815059
  815085
  815103
  815115
  815134
  816627
  825049
  827757
]
2.19 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "от первой лица"
]
2.14 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.13 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов"
]
1.82 ms
(1.19%)
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.