Query Metrics
7
Database Queries
7
Different statements
260.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.91 ms (89.84%) |
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 12680 93079 96503 114645 150488 242127 329606 333653 382164 382803 383508 386395 386816 386869 388091 388584 390593 391740 392805 395511 396677 397227 398204 398579 398704 399389 400311 402042 402103 402859 403559 405847 411069 411074 411236 411310 411335 411752 412207 413958 415907 416102 417751 421743 425222 428135 428602 429119 429897 430064 432641 437564 437742 437826 439893 440694 440942 441609 443044 443840 444289 446249 447141 447938 451566 451567 453197 453604 454648 454651 457546 457558 457603 458090 458104 458264 458441 458744 458828 460426 461773 461847 462705 463430 463709 465977 466528 466786 467135 467785 469481 471997 472797 475095 475896 476153 477605 478989 479398 485408 488637 489172 490590 490806 490814 494613 498155 498210 500950 501989 502681 509549 510637 512616 512664 515615 516931 519409 524716 524728 ] |
||||||||||||||||||||||||||||||
|
17.09 ms (6.56%) |
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 399389 411335 429119 437742 439893 444289 447938 454648 458744 461773 463709 465977 475095 476153 479398 451566 453604 458441 462705 472797 475896 478989 501989 502681 516931 489172 490814 494613 498210 509549 488637 490590 498155 500950 510637 512616 485408 512664 515615 519409 524716 524728 386395 386816 386869 382803 383508 150488 114645 242127 392805 391740 395511 333653 329606 382164 93079 12680 96503 388584 388091 390593 396677 397227 398204 400311 398704 398579 402103 402859 402042 403559 405847 411310 416102 417751 428602 440694 411069 412207 413958 415907 432641 437826 441609 411074 428135 443044 443840 411236 411752 421743 425222 429897 437564 440942 430064 446249 454651 457546 457558 458104 458828 460426 461847 466528 466786 469481 471997 490806 447141 451567 453197 457603 458090 458264 463430 467135 467785 477605 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.93%) |
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 12680 93079 96503 114645 150488 242127 329606 333653 382164 382803 383508 386395 386816 386869 388091 388584 390593 391740 392805 395511 396677 397227 398204 398579 398704 399389 400311 402042 402103 402859 403559 405847 411069 411074 411236 411310 411335 411752 412207 413958 415907 416102 417751 421743 425222 428135 428602 429119 429897 430064 432641 437564 437742 437826 439893 440694 440942 441609 443044 443840 444289 446249 447141 447938 451566 451567 453197 453604 454648 454651 457546 457558 457603 458090 458104 458264 458441 458744 458828 460426 461773 461847 462705 463430 463709 465977 466528 466786 467135 467785 469481 471997 472797 475095 475896 476153 477605 478989 479398 485408 488637 489172 490590 490806 490814 494613 498155 498210 500950 501989 502681 509549 510637 512616 512664 515615 516931 519409 524716 524728 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"потрахал"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"потраха"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"потраха"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.57%) |
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.