Query Metrics
7
Database Queries
7
Different statements
204.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.85 ms (87.37%) |
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 34706 68084 197609 400666 402138 403601 447197 479982 510390 539847 541852 543486 556800 571488 581797 593065 599614 608181 613484 617209 622585 635404 637170 639462 648261 654154 671546 688107 688343 689964 690712 693248 694990 700607 703764 707404 708730 709769 710573 713088 714906 715384 717071 722256 722617 724007 724127 724634 725043 733131 734448 735417 735804 736418 737040 737453 739257 747256 750382 751264 751455 752188 755441 756162 756348 757880 760750 760857 761768 761990 762424 762442 763041 763661 765117 767255 767751 769338 772401 773929 776691 780280 780427 782590 788470 791402 791728 794522 795796 795987 796019 797454 799870 799899 800614 801269 801783 803412 803724 805833 807274 808132 810577 810854 811142 813315 813631 814032 814219 814697 815079 816614 817728 818261 822060 822291 823543 824626 826144 ] |
||||||||||||||||||||||||||||||
|
14.91 ms (7.29%) |
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 694990 613484 617209 782590 794522 801269 756348 791402 807274 810854 724127 717071 776691 447197 402138 581797 197609 814219 813631 822291 824626 816614 817728 818261 823543 814032 815079 822060 539847 541852 543486 556800 648261 688107 700607 715384 690712 693248 708730 688343 703764 713088 593065 599614 608181 637170 780427 791728 795987 797454 800614 805833 810577 811142 803724 808132 724007 725043 733131 734448 737453 739257 747256 760857 763041 767255 795796 801783 803412 756162 765117 767751 772401 724634 761990 769338 752188 755441 760750 762442 763661 773929 750382 751264 751455 772615 635404 710573 722256 813315 510390 735417 68084 671546 722617 757880 761768 403601 34706 400666 826144 814697 479982 571488 654154 689964 707404 714906 709769 622585 639462 788470 796019 799899 780280 736418 737040 799870 735804 762424 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (1.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"you секс"
]
|
||||||||||||||||||||||||||||||
|
2.33 ms (1.14%) |
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 34706 68084 197609 400666 402138 403601 447197 479982 510390 539847 541852 543486 556800 571488 581797 593065 599614 608181 613484 617209 622585 635404 637170 639462 648261 654154 671546 688107 688343 689964 690712 693248 694990 700607 703764 707404 708730 709769 710573 713088 714906 715384 717071 722256 722617 724007 724127 724634 725043 733131 734448 735417 735804 736418 737040 737453 739257 747256 750382 751264 751455 752188 755441 756162 756348 757880 760750 760857 761768 761990 762424 762442 763041 763661 765117 767255 767751 769338 772401 773929 776691 780280 780427 782590 788470 791402 791728 794522 795796 795987 796019 797454 799870 799899 800614 801269 801783 803412 803724 805833 807274 808132 810577 810854 811142 813315 813631 814032 814219 814697 815079 816614 817728 818261 822060 822291 823543 824626 826144 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"you fuck"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"you секс"
]
|
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.