Query Metrics
7
Database Queries
7
Different statements
255.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.60 ms (91.86%) |
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 69704 236472 251147 486170 490198 505706 514711 531916 531960 535385 538536 538891 542995 543688 544661 546304 551113 552756 558201 558928 565902 569548 574159 600649 606064 609435 613447 617640 617849 628112 629662 632048 635835 640909 665773 669946 671702 676711 678586 679044 679049 679061 679078 679079 679096 679135 690855 690913 692248 692330 692813 693028 693041 693860 694211 694222 694478 694522 694555 694562 694877 695188 695390 695391 695621 695631 696554 699757 700034 700852 702188 702863 705306 709512 714128 715542 716202 716640 723659 726365 727413 728022 728131 729917 730222 732551 733113 735177 735570 737478 738054 740461 745943 746733 748689 752509 755836 763935 768023 775815 777957 778221 779241 781513 783381 786096 787302 788169 788596 793454 798285 798993 799481 800800 801733 802103 803406 803771 805532 814258 ] |
||||||||||||||||||||||||||||||
|
9.82 ms (3.85%) |
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 538536 665773 692813 694478 702188 694877 695391 546304 613447 779241 800800 729917 763935 805532 735570 735177 702863 723659 486170 505706 531916 531960 552756 574159 558928 565902 669946 676711 692248 695390 696554 709512 694211 700034 705306 671702 693028 600649 629662 617640 793454 798285 803406 786096 799481 803771 727413 781513 733113 728131 737478 745943 609435 715542 778221 787302 69704 814258 716640 694562 679049 606064 635835 728022 752509 748689 755836 558201 544661 542995 679135 632048 798993 738054 732551 726365 746733 617849 700852 775815 788169 538891 535385 679044 690855 690913 694522 695631 678586 679096 693860 695621 693041 551113 777957 730222 783381 801733 740461 768023 628112 490198 699757 802103 569548 543688 714128 692330 640909 236472 251147 679061 679078 679079 694222 695188 694555 716202 788596 514711 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.29%) |
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 69704 236472 251147 486170 490198 505706 514711 531916 531960 535385 538536 538891 542995 543688 544661 546304 551113 552756 558201 558928 565902 569548 574159 600649 606064 609435 613447 617640 617849 628112 629662 632048 635835 640909 665773 669946 671702 676711 678586 679044 679049 679061 679078 679079 679096 679135 690855 690913 692248 692330 692813 693028 693041 693860 694211 694222 694478 694522 694555 694562 694877 695188 695390 695391 695621 695631 696554 699757 700034 700852 702188 702863 705306 709512 714128 715542 716202 716640 723659 726365 727413 728022 728131 729917 730222 732551 733113 735177 735570 737478 738054 740461 745943 746733 748689 752509 755836 763935 768023 775815 777957 778221 779241 781513 783381 786096 787302 788169 788596 793454 798285 798993 799481 800800 801733 802103 803406 803771 805532 814258 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут двоем"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс два"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.