Query Metrics
7
Database Queries
7
Different statements
429.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
402.98 ms (93.77%) |
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 12102 12708 136203 192551 381748 385199 396268 397325 400534 401599 423498 426632 426911 430460 431718 441774 444649 448078 451631 460407 466327 482557 487422 487768 487982 496367 499042 499066 500494 514875 516985 518599 527769 529870 531574 533498 533891 535585 538919 539131 541563 541577 542091 542178 542344 542403 543647 544783 546252 548882 548884 548885 550557 552066 560265 560896 561066 573246 573986 578002 585623 592638 593843 598859 600783 608110 617974 618842 622731 622746 638756 644008 650595 661435 661593 662638 662838 689483 700686 707582 709288 709593 710256 711867 716197 716699 718232 721605 738326 740401 745311 751915 763878 764485 767120 771750 775587 778096 781627 782165 787781 790819 791353 793113 793355 793737 796020 796727 796749 796773 801027 808682 814697 817073 820032 824513 824814 825849 825973 827597 ] |
||||||||||||||||||||||||||||||
|
17.58 ms (4.09%) |
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 790819 796020 718232 401599 12708 430460 441774 824513 824814 825849 825973 487422 516985 538919 499042 500494 539131 482557 543647 546252 550557 689483 710256 716197 721605 593843 622746 585623 600783 775587 793113 796727 796749 740401 791353 751915 738326 767120 771750 745311 808682 426632 444649 487768 451631 638756 552066 598859 518599 496367 535585 533891 541563 541577 560265 560896 662638 662838 650595 709288 709593 661435 661593 700686 707582 622731 617974 608110 644008 711867 801027 396268 400534 397325 136203 381748 12102 817073 827597 814697 460407 487982 466327 499066 527769 533498 514875 548885 578002 542344 542091 548884 573246 548882 778096 782165 793355 793737 763878 764485 781627 787781 796773 385199 192551 423498 820032 448078 529870 531574 542178 542403 544783 561066 573986 716699 592638 618842 431718 426911 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.53%) |
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 12102 12708 136203 192551 381748 385199 396268 397325 400534 401599 423498 426632 426911 430460 431718 441774 444649 448078 451631 460407 466327 482557 487422 487768 487982 496367 499042 499066 500494 514875 516985 518599 527769 529870 531574 533498 533891 535585 538919 539131 541563 541577 542091 542178 542344 542403 543647 544783 546252 548882 548884 548885 550557 552066 560265 560896 561066 573246 573986 578002 585623 592638 593843 598859 600783 608110 617974 618842 622731 622746 638756 644008 650595 661435 661593 662638 662838 689483 700686 707582 709288 709593 710256 711867 716197 716699 718232 721605 738326 740401 745311 751915 763878 764485 767120 771750 775587 778096 781627 782165 787781 790819 791353 793113 793355 793737 796020 796727 796749 796773 801027 808682 814697 817073 820032 824513 824814 825849 825973 827597 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave amateur"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован любительск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.36%) |
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.