Query Metrics
7
Database Queries
7
Different statements
214.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.74 ms (88.75%) |
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 167756 197345 401684 402541 435788 435864 438452 442190 442296 474423 479037 489288 492516 500616 506136 506822 510421 510773 512881 521240 522285 524314 525402 527156 528034 534991 535857 536701 541965 542959 543623 545219 550396 552077 553131 553142 557365 559122 564603 566509 573031 573037 573216 579381 579451 579611 582437 583871 588736 592571 593873 598956 605397 610952 613333 614059 615535 621477 622829 623165 624616 625434 640703 645946 645949 645951 650197 650915 651886 652590 659241 660150 666420 667966 669192 671886 672812 672878 677098 679533 683256 684066 685810 687583 688287 691462 693961 696047 706249 707739 714117 721459 722915 723779 724948 725687 726705 727828 732964 733451 742535 745880 750816 760515 763057 766570 772941 774178 776716 781873 784261 795084 802908 803292 803526 811084 815853 818504 821337 821596 ] |
||||||||||||||||||||||||||||||
|
14.03 ms (6.53%) |
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 742535 745880 707739 776716 803526 435864 479037 442296 527156 535857 679533 685810 659241 723779 763057 760515 722915 774178 197345 167756 402541 401684 438452 435788 442190 815853 818504 821337 821596 492516 474423 489288 500616 506822 512881 525402 510773 522285 534991 524314 528034 536701 506136 510421 521240 564603 579381 579451 582437 583871 543623 559122 566509 541965 542959 545219 553131 573031 573216 645949 645951 652590 666420 669192 671886 684066 706249 645946 650915 651886 660150 667966 688287 714117 721459 650197 672812 672878 677098 683256 687583 691462 693961 696047 550396 552077 553142 557365 573037 579611 621477 640703 588736 592571 598956 610952 615535 623165 605397 614059 622829 624616 593873 613333 625434 781873 784261 795084 803292 724948 725687 726705 802908 811084 727828 766570 772941 732964 733451 750816 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.46%) |
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 167756 197345 401684 402541 435788 435864 438452 442190 442296 474423 479037 489288 492516 500616 506136 506822 510421 510773 512881 521240 522285 524314 525402 527156 528034 534991 535857 536701 541965 542959 543623 545219 550396 552077 553131 553142 557365 559122 564603 566509 573031 573037 573216 579381 579451 579611 582437 583871 588736 592571 593873 598956 605397 610952 613333 614059 615535 621477 622829 623165 624616 625434 640703 645946 645949 645951 650197 650915 651886 652590 659241 660150 666420 667966 669192 671886 672812 672878 677098 679533 683256 684066 685810 687583 688287 691462 693961 696047 706249 707739 714117 721459 722915 723779 724948 725687 726705 727828 732964 733451 742535 745880 750816 760515 763057 766570 772941 774178 776716 781873 784261 795084 802908 803292 803526 811084 815853 818504 821337 821596 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural porn"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные porn"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные porn"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.72%) |
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.