Query Metrics
7
Database Queries
7
Different statements
176.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.30 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 312919 381963 396237 417828 419069 425131 432359 433697 451723 464817 475902 481357 483194 484476 488452 491115 495906 497021 501104 508845 510543 510550 511288 512177 513119 515371 516615 520262 520814 522084 524138 528930 532018 538109 540082 540089 540245 540317 543846 544910 545312 546827 550077 558218 566316 570857 572219 575075 575437 576055 579223 587436 603564 614566 616082 624159 626324 627666 628724 662459 687021 690144 694213 697494 704955 714225 722345 722464 726291 727610 731893 732806 734413 738939 744494 745498 748615 757391 758510 758915 769581 775854 778734 778882 783833 788950 789128 790197 790921 792326 793080 795061 795613 795919 796613 796726 796734 796955 797029 798705 799784 802066 802345 805172 807971 808217 808257 810414 812988 813099 814685 814693 817048 817063 818635 819034 819708 820786 823330 823655 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (8.96%) |
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 513119 522084 546827 550077 579223 628724 626324 497021 312919 819708 820786 823330 814685 817048 817063 819034 823655 814693 818635 451723 484476 481357 540089 501104 528930 540082 540317 532018 545312 558218 566316 576055 544910 572219 694213 687021 722345 690144 697494 704955 722464 575075 603564 614566 624159 627666 616082 775854 792326 795919 796734 796955 799784 805172 807971 812988 813099 788950 789128 790197 793080 795061 796726 798705 758915 808217 810414 726291 734413 732806 748615 727610 731893 778734 778882 783833 790921 796613 797029 802066 802345 396237 381963 433697 419069 483194 508845 510543 511288 538109 524138 543846 570857 662459 714225 795613 808257 745498 758510 744494 757391 769581 464817 488452 491115 512177 540245 475902 738939 417828 425131 432359 495906 575437 587436 520262 510550 515371 516615 520814 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.69%) |
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 312919 381963 396237 417828 419069 425131 432359 433697 451723 464817 475902 481357 483194 484476 488452 491115 495906 497021 501104 508845 510543 510550 511288 512177 513119 515371 516615 520262 520814 522084 524138 528930 532018 538109 540082 540089 540245 540317 543846 544910 545312 546827 550077 558218 566316 570857 572219 575075 575437 576055 579223 587436 603564 614566 616082 624159 626324 627666 628724 662459 687021 690144 694213 697494 704955 714225 722345 722464 726291 727610 731893 732806 734413 738939 744494 745498 748615 757391 758510 758915 769581 775854 778734 778882 783833 788950 789128 790197 790921 792326 793080 795061 795613 795919 796613 796726 796734 796955 797029 798705 799784 802066 802345 805172 807971 808217 808257 810414 812988 813099 814685 814693 817048 817063 818635 819034 819708 820786 823330 823655 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gag on sperm"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм сперм"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.