Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
113.82 ms
(82.94%)
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
  532050
  538913
  539649
  541642
  541647
  541661
  541664
  541683
  541740
  541780
  541808
  541873
  541875
  542196
  543497
  544254
  544272
  544277
  544295
  544300
  544313
  544317
  544337
  544347
  544349
  544350
  544352
  547308
  548289
  549273
  549300
  549327
  549957
  549965
  549968
  550017
  550328
  556786
  560080
  560087
  561026
  562830
  562846
  563099
  563534
  563540
  565571
  565993
  566246
  566686
  566692
  566697
  566699
  572594
  572645
  573905
  573911
  573914
  576632
  576687
  577353
  577375
  579950
  581260
  592391
  592446
  592539
  593635
  596576
  597215
  600557
  601055
  601068
  606680
  606781
  608040
  615749
  620120
  621316
  626549
  626556
  628131
  628329
  630769
  631818
  642791
  644287
  646337
  648912
  650833
  671761
  681152
  697705
  699689
  701345
  702461
  702893
  704722
  708785
  709207
  713138
  716323
  717074
  719052
  722685
  723517
  725176
  727490
  730225
  730524
  739478
  742246
  744262
  744527
  744591
  755474
  761321
  790407
  801192
  801362
]
13.98 ms
(10.19%)
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
  592539
  600557
  592391
  596576
  626556
  593635
  628131
  644287
  801362
  739478
  744527
  801192
  742246
  701345
  702461
  702893
  709207
  538913
  543497
  544277
  544313
  544317
  548289
  562830
  565571
  576687
  577353
  581260
  541873
  544254
  544300
  544347
  544352
  560080
  562846
  563540
  566686
  566692
  573905
  573911
  577375
  541875
  544295
  549300
  549327
  549968
  563099
  563534
  566246
  566699
  576632
  681152
  671761
  716323
  650833
  556786
  561026
  601055
  601068
  620120
  606680
  615749
  621316
  597215
  626549
  592446
  628329
  541661
  566697
  573914
  723517
  539649
  532050
  544272
  549965
  560087
  579950
  544337
  549273
  565993
  572645
  544349
  544350
  550017
  646337
  699689
  648912
  717074
  722685
  697705
  704722
  708785
  713138
  719052
  547308
  549957
  550328
  572594
  630769
  631818
  606781
  642791
  790407
  727490
  730225
  725176
  744591
  730524
  744262
  761321
  755474
  608040
  541647
  541780
  541808
  541683
  542196
  541642
  541664
  541740
]
2.44 ms
(1.78%)
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
  532050
  538913
  539649
  541642
  541647
  541661
  541664
  541683
  541740
  541780
  541808
  541873
  541875
  542196
  543497
  544254
  544272
  544277
  544295
  544300
  544313
  544317
  544337
  544347
  544349
  544350
  544352
  547308
  548289
  549273
  549300
  549327
  549957
  549965
  549968
  550017
  550328
  556786
  560080
  560087
  561026
  562830
  562846
  563099
  563534
  563540
  565571
  565993
  566246
  566686
  566692
  566697
  566699
  572594
  572645
  573905
  573911
  573914
  576632
  576687
  577353
  577375
  579950
  581260
  592391
  592446
  592539
  593635
  596576
  597215
  600557
  601055
  601068
  606680
  606781
  608040
  615749
  620120
  621316
  626549
  626556
  628131
  628329
  630769
  631818
  642791
  644287
  646337
  648912
  650833
  671761
  681152
  697705
  699689
  701345
  702461
  702893
  704722
  708785
  709207
  713138
  716323
  717074
  719052
  722685
  723517
  725176
  727490
  730225
  730524
  739478
  742246
  744262
  744527
  744591
  755474
  761321
  790407
  801192
  801362
]
2.05 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "film long"
]
1.67 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фильм длинные"
]
1.65 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.17%)
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.