Query Metrics
7
Database Queries
7
Different statements
175.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.45 ms (84.23%) |
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 308542 415985 416082 417895 418448 419929 421556 424841 430283 430696 430705 433762 444490 446870 446897 447924 449652 456114 458971 462222 463818 464147 465095 465702 467612 469582 470126 482714 483038 491275 496721 501480 501488 505095 510264 513126 516426 520202 521587 525923 528776 530696 530703 530763 532667 533064 534027 535840 536248 537661 538773 540305 543068 543892 544409 545532 545773 545791 545802 547362 550207 557199 562339 562349 564241 565507 566138 582806 583938 587928 591893 599862 599863 599867 599965 600019 600029 600946 601347 604025 604341 604391 604519 604581 605007 605449 606880 619734 629045 632562 632635 632707 633451 633899 635215 636293 641481 641686 643851 644059 645276 646435 647665 648854 652683 654273 674945 675009 682517 688104 708176 715682 719841 720872 722541 723582 817127 818160 820780 828863 ] |
||||||||||||||||||||||||||||||
|
18.26 ms (10.43%) |
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 444490 446870 416082 447924 456114 462222 470126 516426 496721 510264 501480 513126 537661 501488 533064 645276 648854 545791 599867 600029 599863 629045 632707 599862 599965 633451 600019 605449 636293 632635 828863 566138 587928 491275 532667 534027 530696 530703 530763 536248 550207 675009 545773 545802 601347 635215 564241 308542 417895 418448 419929 430705 421556 415985 424841 433762 430283 430696 817127 818160 723582 820780 482714 449652 458971 465095 465702 467612 446897 463818 483038 528776 535840 520202 521587 538773 540305 525923 505095 464147 469582 543068 544409 547362 565507 543892 557199 562339 583938 545532 682517 646435 647665 652683 654273 688104 715682 719841 720872 674945 708176 722541 562349 582806 591893 641686 600946 604025 604391 604519 604581 633899 643851 644059 604341 605007 606880 619734 632562 641481 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.35%) |
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 308542 415985 416082 417895 418448 419929 421556 424841 430283 430696 430705 433762 444490 446870 446897 447924 449652 456114 458971 462222 463818 464147 465095 465702 467612 469582 470126 482714 483038 491275 496721 501480 501488 505095 510264 513126 516426 520202 521587 525923 528776 530696 530703 530763 532667 533064 534027 535840 536248 537661 538773 540305 543068 543892 544409 545532 545773 545791 545802 547362 550207 557199 562339 562349 564241 565507 566138 582806 583938 587928 591893 599862 599863 599867 599965 600019 600029 600946 601347 604025 604341 604391 604519 604581 605007 605449 606880 619734 629045 632562 632635 632707 633451 633899 635215 636293 641481 641686 643851 644059 645276 646435 647665 648854 652683 654273 674945 675009 682517 688104 708176 715682 719841 720872 722541 723582 817127 818160 820780 828863 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long bbc"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные bbc"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"длинные bbc"
]
|
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.