Query Metrics
7
Database Queries
7
Different statements
145.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.02 ms (84.32%) |
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 304063 423544 457596 496876 500320 507477 514875 521082 532616 533407 537774 539959 539960 544873 546283 550968 569277 576471 577659 585490 588845 591781 595625 600590 605799 612992 615951 617546 619699 631298 634638 636716 638187 639094 641509 651223 651584 651724 653357 656812 659429 663195 664503 668105 677157 691781 693873 695549 707478 708748 709803 714350 714703 725446 726448 729546 735743 736012 736310 737868 737889 739809 739920 741122 743240 744176 745467 746822 747427 748280 748299 749493 749701 750662 751679 752194 752849 753612 753666 755080 755585 757689 758621 767396 768862 769463 772560 772606 773023 778155 778303 780461 784106 785366 785367 787338 787531 788529 790240 792371 796378 796926 797918 799734 800116 803136 803828 807160 810168 810917 812668 813365 814179 821359 823773 825404 825807 827077 ] |
||||||||||||||||||||||||||||||
|
13.85 ms (9.50%) |
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 663195 707478 708748 595625 739809 750662 752849 737889 507477 304063 423544 821359 827077 814179 823773 825404 825807 457596 521082 539959 539960 500320 532616 533407 496876 514875 537774 544873 546283 577659 576471 550968 651223 651724 656812 693873 709803 714703 651584 677157 691781 714350 653357 659429 664503 668105 695549 569277 605799 638187 639094 617547 585490 588845 612992 615951 634638 641509 591781 600590 617546 619699 631298 636716 778155 780461 785366 807160 812668 778303 784106 785367 787531 792371 799734 800116 803136 803828 813365 736310 737868 741122 743240 744176 745467 748280 748299 755080 755585 767396 772560 772606 787338 788529 790240 796378 796926 797918 810168 810917 735743 739920 752194 759378 725446 729546 751679 758621 769463 726448 746822 749493 753612 753666 773023 736012 747427 749701 757689 768862 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.88%) |
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 304063 423544 457596 496876 500320 507477 514875 521082 532616 533407 537774 539959 539960 544873 546283 550968 569277 576471 577659 585490 588845 591781 595625 600590 605799 612992 615951 617546 619699 631298 634638 636716 638187 639094 641509 651223 651584 651724 653357 656812 659429 663195 664503 668105 677157 691781 693873 695549 707478 708748 709803 714350 714703 725446 726448 729546 735743 736012 736310 737868 737889 739809 739920 741122 743240 744176 745467 746822 747427 748280 748299 749493 749701 750662 751679 752194 752849 753612 753666 755080 755585 757689 758621 767396 768862 769463 772560 772606 773023 778155 778303 780461 784106 785366 785367 787338 787531 788529 790240 792371 796378 796926 797918 799734 800116 803136 803828 807160 810168 810917 812668 813365 814179 821359 823773 825404 825807 827077 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wet masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрые мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.94%) |
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.