Query Metrics
7
Database Queries
7
Different statements
167.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.28 ms (84.58%) |
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 294490 443540 466587 470153 491211 495113 533716 534482 539341 539588 544422 547054 551196 552891 562604 577226 577264 578823 588731 612869 613792 614213 615474 615477 616082 617002 617623 625428 630846 631709 639213 644864 644902 650100 654130 661599 663957 668554 670622 675794 675892 692108 695706 695797 707379 712244 714710 714956 716725 717104 719797 721747 724063 725325 726359 728977 729664 734113 741604 746571 751469 756268 761538 767943 768115 769949 771734 773360 774905 775649 776707 777608 777897 785305 786627 788369 788476 789139 790247 791067 794157 799566 799629 802336 802775 803688 803703 804578 807515 808137 808514 809772 811159 811356 813301 813898 814014 814096 814328 814992 815098 815475 815873 817045 817049 817396 819196 819371 819568 819616 819624 820451 822878 823440 823617 824272 824390 826307 826371 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (9.54%) |
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 756268 734113 767970 741604 773360 799629 562604 443540 670622 712244 466587 804578 578823 814096 707379 802336 777897 726359 775649 811356 294490 824272 577264 613792 614213 785305 751469 729664 769949 771734 746571 767943 725325 774905 777608 803688 808137 794157 761538 817045 819371 824390 826307 644864 644902 813898 814014 814992 815098 815873 819568 819616 814328 817396 819624 820451 822878 823440 823617 815475 817049 819196 826371 491211 470153 533716 534482 495113 539588 539341 544422 551196 577226 547054 552891 654130 668554 675892 695706 716725 717104 721747 650100 661599 663957 695797 714710 675794 692108 714956 719797 615477 625428 631709 639213 588731 615474 612869 617623 630846 616082 617002 786627 791067 802775 776707 788369 788476 799566 807515 808514 813301 724063 728977 768115 789139 790247 803703 809772 811159 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.62%) |
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 294490 443540 466587 470153 491211 495113 533716 534482 539341 539588 544422 547054 551196 552891 562604 577226 577264 578823 588731 612869 613792 614213 615474 615477 616082 617002 617623 625428 630846 631709 639213 644864 644902 650100 654130 661599 663957 668554 670622 675794 675892 692108 695706 695797 707379 712244 714710 714956 716725 717104 719797 721747 724063 725325 726359 728977 729664 734113 741604 746571 751469 756268 761538 767943 768115 769949 771734 773360 774905 775649 776707 777608 777897 785305 786627 788369 788476 789139 790247 791067 794157 799566 799629 802336 802775 803688 803703 804578 807515 808137 808514 809772 811159 811356 813301 813898 814014 814096 814328 814992 815098 815475 815873 817045 817049 817396 819196 819371 819568 819616 819624 820451 822878 823440 823617 824272 824390 826307 826371 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy минет оральн секс"
]
|
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.