Query Metrics
7
Database Queries
7
Different statements
146.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.26 ms (85.03%) |
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 491814 519231 519235 524966 532047 535488 535493 537721 537729 538831 538847 538904 538935 538948 540446 540474 542457 542464 542475 542488 543010 544264 544265 544276 544297 544331 544334 544575 544577 544587 544591 545765 547285 547307 547316 547327 547341 547354 547654 548292 549269 549278 549283 549284 549333 549347 549359 549373 549385 549402 549407 549408 549420 549917 549921 549927 549929 549933 549940 549943 549952 549991 550321 550620 551508 551715 556985 557330 559118 560078 560084 561585 570768 570771 570802 570821 570829 571020 571025 572612 574180 574194 574208 574210 574241 579917 579919 579920 579924 579927 579928 579933 579939 581352 583812 583820 583830 583848 583857 583858 583899 592472 592514 592533 624157 626558 628317 629902 629936 648485 649989 668441 677702 681076 685472 687098 695210 696268 696270 789016 ] |
||||||||||||||||||||||||||||||
|
11.52 ms (7.88%) |
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 544334 547327 548292 551715 583830 549408 549917 572612 574194 583812 524966 581352 592533 549933 549333 579928 549407 549283 549359 549943 579927 538831 540446 544265 549373 549420 544587 544577 550321 571025 537721 629936 537729 547285 549929 579924 551508 579933 696268 547307 519231 538935 538904 542457 542475 549385 544297 547341 570821 574180 574208 579919 579939 583857 549284 549927 570829 583820 544331 696270 648485 695210 547316 547354 549402 549991 557330 570768 570802 574210 579920 628317 538948 538847 560078 542464 544264 545765 560084 574241 583858 687098 549347 583899 592472 624157 592514 535488 532047 535493 550620 549952 561585 570771 549940 579917 677702 549269 549921 583848 626558 789016 629902 540474 543010 559118 544575 549278 542488 544276 544591 556985 571020 649989 668441 681076 685472 547654 519235 491814 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.83%) |
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 491814 519231 519235 524966 532047 535488 535493 537721 537729 538831 538847 538904 538935 538948 540446 540474 542457 542464 542475 542488 543010 544264 544265 544276 544297 544331 544334 544575 544577 544587 544591 545765 547285 547307 547316 547327 547341 547354 547654 548292 549269 549278 549283 549284 549333 549347 549359 549373 549385 549402 549407 549408 549420 549917 549921 549927 549929 549933 549940 549943 549952 549991 550321 550620 551508 551715 556985 557330 559118 560078 560084 561585 570768 570771 570802 570821 570829 571020 571025 572612 574180 574194 574208 574210 574241 579917 579919 579920 579924 579927 579928 579933 579939 581352 583812 583820 583830 583848 583857 583858 583899 592472 592514 592533 624157 626558 628317 629902 629936 648485 649989 668441 677702 681076 685472 687098 695210 696268 696270 789016 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сцен фильм"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сцена из кино"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сцен фильм"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.