Query Metrics
7
Database Queries
7
Different statements
224.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.76 ms (89.04%) |
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 58237 58336 389760 408316 426218 427408 476539 539544 545068 552301 557001 557269 560035 560090 564820 578807 579558 586216 602005 603625 606839 606852 606991 607010 607025 620513 622707 622845 625026 627206 627768 633556 633856 638542 651040 651268 664808 665865 665887 667208 667562 672846 677921 682525 692733 695773 702978 704673 705111 707456 714917 716312 717036 718884 720086 721156 721946 721978 725087 726602 726842 728650 730670 731197 732154 733195 733900 736863 742763 744261 746107 748441 749218 749756 752056 755780 757094 757688 759965 761506 763964 766462 768472 774291 780520 784223 785679 787027 787052 788819 789141 789266 789267 790318 791196 793649 794005 795536 796434 796468 799886 800928 801373 804854 807394 810679 811121 811927 813028 814104 817249 818753 819952 820164 821686 823269 824733 825457 ] |
||||||||||||||||||||||||||||||
|
14.82 ms (6.61%) |
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 602005 622845 606991 607025 789141 789266 793649 804854 811927 725087 728650 787052 790318 794005 800928 733900 731197 755780 768472 730670 744261 752056 757688 757837 742763 627206 702978 721946 427408 408316 603625 761506 665887 638542 780520 825457 667562 682525 633556 620513 785679 810679 733195 801373 821686 819952 560090 692733 667208 677921 557001 811121 799886 726842 749218 766462 749756 757094 622707 784223 785027 58336 814104 823269 820164 552301 545068 560035 665865 695773 718884 721978 672846 704673 705111 717036 707456 606852 607010 627768 787027 788819 791196 796468 796434 807394 813028 759965 736863 774291 726602 748441 732154 746107 763964 606839 625026 716312 721156 789267 795536 389760 58237 426218 818753 817249 824733 476539 539544 557269 564820 651040 651268 664808 714917 720086 578807 579558 586216 633856 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.28%) |
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 58237 58336 389760 408316 426218 427408 476539 539544 545068 552301 557001 557269 560035 560090 564820 578807 579558 586216 602005 603625 606839 606852 606991 607010 607025 620513 622707 622845 625026 627206 627768 633556 633856 638542 651040 651268 664808 665865 665887 667208 667562 672846 677921 682525 692733 695773 702978 704673 705111 707456 714917 716312 717036 718884 720086 721156 721946 721978 725087 726602 726842 728650 730670 731197 732154 733195 733900 736863 742763 744261 746107 748441 749218 749756 752056 755780 757094 757688 759965 761506 763964 766462 768472 774291 780520 784223 785679 787027 787052 788819 789141 789266 789267 790318 791196 793649 794005 795536 796434 796468 799886 800928 801373 804854 807394 810679 811121 811927 813028 814104 817249 818753 819952 820164 821686 823269 824733 825457 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex cheating"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс cheating"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс cheating"
]
|
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.