Query Metrics
7
Database Queries
7
Different statements
400.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.63 ms (52.55%) |
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 385781 386959 410075 426947 429827 448749 458749 477560 490160 505636 522644 525252 534812 540728 541035 548080 550645 550674 554748 561409 576162 585237 585652 590468 593660 605410 609108 609653 614213 621467 625597 627237 630296 633554 638048 638058 646682 654239 654494 654619 655083 655733 656042 658318 659452 659622 659759 665423 667046 667312 667916 677920 690364 696343 697604 698088 709517 710188 710213 710410 714048 714456 719644 721355 721985 722043 724724 725934 725979 725987 727015 727374 729569 731727 736058 736535 738414 738436 738887 739871 740218 742178 744661 749465 753262 753411 755799 757035 757210 761147 765886 765893 768578 770476 774058 777894 780370 780883 780885 780907 784104 786309 789593 792434 794489 795770 798847 802063 803698 805206 807357 810952 814979 817722 817845 818797 820666 823441 824804 825536 ] |
||||||||||||||||||||||||||||||
|
166.88 ms (41.64%) |
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 385781 386959 410075 426947 429827 448749 458749 477560 490160 505636 522644 525252 534812 540728 541035 548080 550645 550674 554748 561409 576162 585237 585652 590468 593660 605410 609108 609653 614213 621467 625597 627237 630296 633554 638048 638058 646682 654239 654494 654619 655083 655733 656042 658318 659452 659622 659759 665423 667046 667312 667916 677920 690364 696343 697604 698088 709517 710188 710213 710410 714048 714456 719644 721355 721985 722043 724724 725934 725979 725987 727015 727374 729569 731727 736058 736535 738414 738436 738887 739871 740218 742178 744661 749465 753262 753411 755799 757035 757210 761147 765886 765893 768578 770476 774058 777894 780370 780883 780885 780907 784104 786309 789593 792434 794489 795770 798847 802063 803698 805206 807357 810952 814979 817722 817845 818797 820666 823441 824804 825536 ] |
||||||||||||||||||||||||||||||
|
13.34 ms (3.33%) |
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 490160 749465 753262 709517 385781 646682 656042 667046 714456 659759 665423 794489 725979 803698 731727 738414 721985 780885 505636 736535 818797 777894 742178 724724 765886 817722 654494 721355 780370 807357 761147 786309 814979 525252 658318 590468 625597 630296 802063 738436 638048 795770 817845 820666 823441 561409 696343 654619 655083 690364 593660 585652 780907 729569 810952 768578 738887 740218 744661 770476 798847 458749 429827 722043 667312 757035 757210 614213 386959 477560 540728 667916 448749 522644 554748 609653 753411 710188 824804 534812 719644 825536 576162 550674 805206 784104 792434 725934 698088 621467 725987 627237 585237 605410 659452 655733 426947 410075 550645 541035 654239 659622 677920 697604 710213 710410 609108 633554 638058 765893 755799 727374 727015 736058 739871 774058 714048 780883 789593 548080 ] |
||||||||||||||||||||||||||||||
|
4.49 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс stranger"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob stranger"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс stranger"
]
|
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.