Query Metrics
7
Database Queries
7
Different statements
444.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
422.70 ms (95.14%) |
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 4225 220876 398005 402369 411663 416879 417790 423363 425535 425554 427020 427790 428734 429595 434239 435774 437476 442410 442465 444668 446060 446914 447755 448295 448526 450855 453780 454869 464047 473567 474886 475815 481193 482277 487380 490752 490754 492790 495465 499756 504752 504764 505545 508649 508730 515006 523227 528908 539531 546906 557366 565723 566352 569557 576127 579686 623956 680852 692180 698355 700546 713040 716002 728479 728513 729959 734932 735607 737983 742497 742665 754115 755243 755611 756361 758746 759105 761122 766370 767993 768527 770742 774197 778209 778319 780074 783876 793530 793554 793557 795908 801945 804946 808096 810632 810819 813083 814063 816193 818624 818748 819679 819825 819916 820214 823600 824125 824446 824877 824975 825101 825169 825208 825232 825303 825599 827254 827264 827479 827634 ] |
||||||||||||||||||||||||||||||
|
11.70 ms (2.63%) |
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 734932 767993 770742 504764 411663 827264 778209 499756 565723 464047 495465 692180 220876 820214 823600 825208 827254 824125 824877 825599 818748 827634 716002 793554 810632 801945 804946 729959 813083 4225 402369 816193 818624 819679 824446 814063 819916 825169 825303 827479 819825 824975 825101 825232 713040 778319 808096 780074 783876 793530 810819 755611 758746 759105 728513 754115 756361 728479 742665 755243 761122 735607 768527 737983 742497 774197 793557 795908 427020 566352 698355 623956 766370 398005 429595 435774 434239 442465 416879 427790 428734 442410 448295 453780 447755 475815 490754 490752 504752 505545 546906 579686 423363 417790 444668 446060 482277 425554 446914 450855 454869 448526 473567 437476 508730 528908 487380 492790 425535 481193 474886 508649 523227 539531 515006 569557 557366 576127 680852 700546 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (0.71%) |
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 4225 220876 398005 402369 411663 416879 417790 423363 425535 425554 427020 427790 428734 429595 434239 435774 437476 442410 442465 444668 446060 446914 447755 448295 448526 450855 453780 454869 464047 473567 474886 475815 481193 482277 487380 490752 490754 492790 495465 499756 504752 504764 505545 508649 508730 515006 523227 528908 539531 546906 557366 565723 566352 569557 576127 579686 623956 680852 692180 698355 700546 713040 716002 728479 728513 729959 734932 735607 737983 742497 742665 754115 755243 755611 756361 758746 759105 761122 766370 767993 768527 770742 774197 778209 778319 780074 783876 793530 793554 793557 795908 801945 804946 808096 810632 810819 813083 814063 816193 818624 818748 819679 819825 819916 820214 823600 824125 824446 824877 824975 825101 825169 825208 825232 825303 825599 827254 827264 827479 827634 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск спящ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск спящ"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur sleeping"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.36%) |
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.