Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.33 ms
(87.05%)
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
  509103
  519241
  538664
  538835
  538847
  538858
  538865
  538948
  538955
  539175
  541361
  541378
  541396
  541607
  541624
  541626
  542464
  542470
  542488
  542938
  543010
  543806
  544276
  544293
  544294
  544314
  544316
  544325
  544326
  544331
  544343
  544591
  545765
  546719
  548271
  548288
  548290
  548299
  548300
  548504
  549282
  549938
  550033
  554900
  556789
  556985
  556988
  559118
  560078
  560084
  560920
  561032
  561585
  561594
  563099
  563538
  564543
  566569
  566682
  566860
  572558
  572583
  572625
  573912
  574201
  574203
  574249
  574286
  576633
  576640
  576709
  576718
  577118
  577241
  581285
  583861
  586826
  586850
  590932
  592424
  592461
  592472
  592474
  592481
  592493
  592501
  593270
  593402
  621703
  623939
  624153
  624157
  626558
  626563
  628170
  628171
  628298
  628319
  629286
  629902
  630309
  647334
  648485
  649573
  649989
  651210
  651617
  668441
  668465
  668941
  670764
  672190
  673567
  687098
  687114
  696268
  696270
  706907
  742152
  750065
]
12.86 ms
(7.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
  546719
  548299
  548290
  544314
  573912
  577241
  673567
  696268
  566569
  623939
  628171
  519241
  541396
  583861
  556789
  576633
  561594
  548300
  572583
  592461
  592481
  544326
  628319
  572625
  593270
  539175
  544293
  549282
  566682
  548288
  544331
  581285
  672190
  696270
  648485
  649573
  651617
  706907
  574249
  576640
  628298
  592424
  624153
  626563
  509103
  541378
  541607
  538948
  538847
  560078
  542464
  542938
  545765
  548271
  560084
  687098
  549938
  592472
  586826
  593402
  624157
  592474
  750065
  576709
  576718
  563099
  628170
  538858
  538835
  544343
  543806
  561032
  561585
  574203
  574286
  687114
  647334
  670764
  548504
  564543
  572558
  574201
  592493
  621703
  626558
  586850
  742152
  629286
  629902
  543010
  559118
  563538
  542488
  544276
  544591
  556985
  649989
  668441
  577118
  592501
  590932
  538664
  541361
  556988
  541626
  630309
  550033
  538865
  538955
  542470
  544316
  566860
  541624
  544294
  544325
  651210
  668941
  668465
  554900
  560920
]
2.56 ms
(1.46%)
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
  509103
  519241
  538664
  538835
  538847
  538858
  538865
  538948
  538955
  539175
  541361
  541378
  541396
  541607
  541624
  541626
  542464
  542470
  542488
  542938
  543010
  543806
  544276
  544293
  544294
  544314
  544316
  544325
  544326
  544331
  544343
  544591
  545765
  546719
  548271
  548288
  548290
  548299
  548300
  548504
  549282
  549938
  550033
  554900
  556789
  556985
  556988
  559118
  560078
  560084
  560920
  561032
  561585
  561594
  563099
  563538
  564543
  566569
  566682
  566860
  572558
  572583
  572625
  573912
  574201
  574203
  574249
  574286
  576633
  576640
  576709
  576718
  577118
  577241
  581285
  583861
  586826
  586850
  590932
  592424
  592461
  592472
  592474
  592481
  592493
  592501
  593270
  593402
  621703
  623939
  624153
  624157
  626558
  626563
  628170
  628171
  628298
  628319
  629286
  629902
  630309
  647334
  648485
  649573
  649989
  651210
  651617
  668441
  668465
  668941
  670764
  672190
  673567
  687098
  687114
  696268
  696270
  706907
  742152
  750065
]
1.99 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "films retro"
]
1.87 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фильм ретр"
]
1.48 ms
(0.85%)
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.