Query Metrics
7
Database Queries
7
Different statements
190.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.08 ms (87.13%) |
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 221091 305328 306045 338098 388193 398552 398753 403979 413643 417844 464373 470548 484145 500617 503791 504161 506813 517448 518499 520162 520393 520758 535585 536211 538043 543685 543688 543943 543982 544696 544751 545080 545106 553241 562588 566431 566445 566464 568180 579304 579541 586737 587216 593885 599533 603608 605029 605616 606064 608645 610780 610816 614565 620432 630712 631329 635787 635842 635871 642525 644421 650797 651262 653593 653615 653634 654268 654276 654292 675934 675960 680588 681785 682914 690000 692454 698086 711013 715581 718964 720965 721933 723967 728946 731358 732690 732704 732743 732850 733045 733076 733148 736778 742663 742684 747234 748741 755011 767861 773948 773961 775969 776528 780688 781638 782036 784323 784875 788596 790971 799553 799674 801533 804512 809533 810286 813050 823928 825998 826217 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (7.12%) |
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 782036 784323 398753 654292 653615 788596 736778 733076 654276 566445 732704 711013 388193 823928 748741 675934 520393 620432 603608 500617 518499 517448 610816 776528 545080 801533 809533 536211 690000 813050 651262 605029 543943 630712 305328 653593 593885 635787 733045 732850 767861 731358 484145 398552 644421 720965 755011 599533 464373 520758 631329 742684 413643 417844 732690 579541 825998 635871 543982 804512 721933 723967 587216 221091 799674 682914 799553 775969 586737 742663 503791 306045 698086 773948 680588 773961 579304 608645 732743 747234 535585 544751 568180 553241 606064 715581 470548 650797 544696 543688 718964 545106 338098 614565 543685 728946 504161 826217 654268 780688 520162 566431 566464 681785 675960 642525 810286 733148 403979 506813 784875 781638 790971 610780 538043 692454 635842 605616 562588 653634 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.74%) |
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 221091 305328 306045 338098 388193 398552 398753 403979 413643 417844 464373 470548 484145 500617 503791 504161 506813 517448 518499 520162 520393 520758 535585 536211 538043 543685 543688 543943 543982 544696 544751 545080 545106 553241 562588 566431 566445 566464 568180 579304 579541 586737 587216 593885 599533 603608 605029 605616 606064 608645 610780 610816 614565 620432 630712 631329 635787 635842 635871 642525 644421 650797 651262 653593 653615 653634 654268 654276 654292 675934 675960 680588 681785 682914 690000 692454 698086 711013 715581 718964 720965 721933 723967 728946 731358 732690 732704 732743 732850 733045 733076 733148 736778 742663 742684 747234 748741 755011 767861 773948 773961 775969 776528 780688 781638 782036 784323 784875 788596 790971 799553 799674 801533 804512 809533 810286 813050 823928 825998 826217 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex wife threesome"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс жен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс жен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.