Query Metrics
7
Database Queries
7
Different statements
247.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.88 ms (84.90%) |
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 188389 385814 396305 396524 396589 397674 398940 399176 402632 404730 413073 414799 416178 417612 419225 419731 422774 424195 425744 427069 429886 432486 432507 433461 433596 433775 434562 436639 438100 438446 439023 439743 441031 442870 443687 445019 445029 445135 446336 453224 454743 456485 456742 456909 457111 458382 459474 460393 461653 464926 466676 467536 467547 467758 468183 470518 471663 472116 474503 474647 474780 475371 476688 477399 479568 480896 546002 546376 552352 557591 557940 557989 561332 565441 565674 566286 566665 567035 567038 567221 567237 574257 576371 579210 579487 583084 586529 586810 590479 592146 593376 593793 594245 594790 595088 596278 597977 598033 598414 598928 598973 600636 604887 606625 607714 612534 620491 623815 623835 642934 644490 655078 657930 668628 672311 681251 689521 736421 749899 797871 ] |
||||||||||||||||||||||||||||||
|
26.01 ms (10.52%) |
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 557591 557989 561332 567038 574257 576371 579487 583084 655078 657930 689521 668628 672311 681251 546002 546376 552352 557940 565441 565674 566286 566665 567035 567221 567237 579210 586810 592146 594245 600636 604887 623835 586529 593376 594790 597977 598928 606625 607714 612534 590479 595088 598414 598973 620491 644490 593793 596278 598033 623815 642934 797871 736421 749899 396589 397674 413073 414799 419225 424195 432486 432507 434562 438446 439743 446336 453224 456742 456909 457111 458382 468183 470518 472116 480896 385814 396305 399176 417612 429886 433596 441031 445019 459474 464926 467536 474503 474647 475371 477399 479568 398940 433461 439023 442870 445135 454743 456485 460393 461653 466676 467547 467758 471663 474780 476688 188389 396524 402632 404730 416178 419731 422774 425744 427069 433775 436639 438100 443687 445029 ] |
||||||||||||||||||||||||||||||
|
4.06 ms (1.64%) |
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 188389 385814 396305 396524 396589 397674 398940 399176 402632 404730 413073 414799 416178 417612 419225 419731 422774 424195 425744 427069 429886 432486 432507 433461 433596 433775 434562 436639 438100 438446 439023 439743 441031 442870 443687 445019 445029 445135 446336 453224 454743 456485 456742 456909 457111 458382 459474 460393 461653 464926 466676 467536 467547 467758 468183 470518 471663 472116 474503 474647 474780 475371 476688 477399 479568 480896 546002 546376 552352 557591 557940 557989 561332 565441 565674 566286 566665 567035 567038 567221 567237 574257 576371 579210 579487 583084 586529 586810 590479 592146 593376 593793 594245 594790 595088 596278 597977 598033 598414 598928 598973 600636 604887 606625 607714 612534 620491 623815 623835 642934 644490 655078 657930 668628 672311 681251 689521 736421 749899 797871 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сидя"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сид"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.56%) |
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.