Query Metrics
7
Database Queries
7
Different statements
485.48 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 209.59 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob mom ass"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.04 ms |
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 716191 611893 629846 776775 798733 803169 811986 775569 781488 789505 789720 798047 813486 769978 727758 790005 471403 815379 617157 821447 815521 815765 601615 800325 810813 774533 735459 404555 531523 815256 817323 818123 818333 817443 823563 687505 702947 606684 801898 755388 765147 765554 797787 754212 808081 822168 714475 703144 628653 713262 469061 400209 772719 749206 820718 815380 689302 746846 775626 688277 778847 771544 413111 801726 430835 552047 532114 818495 796219 817233 757024 785094 815464 585127 813676 816255 817918 818419 815698 813785 817800 824953 820060 726677 761321 529718 554967 779389 610057 555121 821774 805816 817473 816586 819044 562875 683530 805385 760841 739258 714750 778218 782636 524896 365295 816538 821180 694214 457298 428472 516209 523779 585724 815391 819560 816887 451723 584729 682525 583564 ] |
||||||||||||||||||||||||||||||
| 4 | 2.64 ms |
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 365295 400209 404555 413111 428472 430835 451723 457298 469061 471403 516209 523779 524896 529718 531523 532114 552047 554967 555121 562875 583564 584729 585127 585724 601615 606684 610057 611893 617157 628653 629846 682525 683530 687505 688277 689302 694214 702947 703144 713262 714475 714750 716191 726677 727758 735459 739258 746846 749206 754212 755388 757024 760841 761321 765147 765554 769978 771544 772719 774533 775569 775626 776775 778218 778847 779389 781488 782636 785094 789505 789720 790005 796219 797787 798047 798733 800325 801726 801898 803169 805385 805816 808081 810813 811986 813486 813676 813785 815256 815379 815380 815391 815464 815521 815698 815765 816255 816538 816586 816887 817233 817323 817443 817473 817800 817918 818123 818333 818419 818495 819044 819560 820060 820718 821180 821447 821774 822168 823563 824953 ] |
||||||||||||||||||||||||||||||
| 5 | 253.46 ms |
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 365295 400209 404555 413111 428472 430835 451723 457298 469061 471403 516209 523779 524896 529718 531523 532114 552047 554967 555121 562875 583564 584729 585127 585724 601615 606684 610057 611893 617157 628653 629846 682525 683530 687505 688277 689302 694214 702947 703144 713262 714475 714750 716191 726677 727758 735459 739258 746846 749206 754212 755388 757024 760841 761321 765147 765554 769978 771544 772719 774533 775569 775626 776775 778218 778847 779389 781488 782636 785094 789505 789720 790005 796219 797787 798047 798733 800325 801726 801898 803169 805385 805816 808081 810813 811986 813486 813676 813785 815256 815379 815380 815391 815464 815521 815698 815765 816255 816538 816586 816887 817233 817323 817443 817473 817800 817918 818123 818333 818419 818495 819044 819560 820060 820718 821180 821447 821774 822168 823563 824953 ] |
||||||||||||||||||||||||||||||
| 6 | 2.13 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс mom жоп"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.76 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс mom жоп"
]
|
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.