Query Metrics
7
Database Queries
7
Different statements
214.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.67 ms (86.44%) |
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 416583 427555 439463 441031 442907 443241 443909 454091 458699 465854 468692 480031 481861 483187 490543 494463 514388 518506 533451 535640 537467 540235 555571 560054 564705 566392 569122 571031 585417 609896 612070 614244 620731 622374 623411 629923 630225 633503 636553 637154 641837 645232 647641 647839 647976 655833 662080 665747 670761 680443 694469 698890 699606 702635 705907 710920 711673 714247 716368 717820 717842 720645 721116 724281 725601 727532 727794 727923 728332 728386 732293 736265 737161 737408 738483 740505 740610 744650 747136 749462 749539 750241 750637 751700 752653 752676 758232 758794 759500 761163 765628 770783 770784 771332 789516 790959 795403 796943 797585 797733 799955 800474 802314 805032 806425 809847 810225 811672 811808 811994 813377 814212 815855 816555 817252 820794 821193 821195 821503 821597 ] |
||||||||||||||||||||||||||||||
|
17.60 ms (8.19%) |
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 811994 795403 797733 800474 737408 752676 765628 770783 811808 727923 728332 752653 758232 759500 761163 727794 747136 623411 630225 633503 698890 705907 714247 716368 720645 813377 441031 465854 458699 468692 494463 535640 483187 518506 555571 728386 620731 427555 514388 564705 815855 821195 821503 814212 816555 817252 820794 821193 821597 481861 480031 537467 540235 533451 560054 571031 569122 647839 711673 647976 662080 670761 699606 645232 647641 655833 665747 680443 694469 721116 566392 636553 614244 622374 637154 641837 629923 585417 790959 802314 810225 797585 809847 725601 727532 736265 740610 744650 750637 789516 806425 749539 771332 724281 738483 740505 750241 732293 737161 749462 751700 758794 770784 609896 612070 702635 710920 717820 717842 796943 799955 805032 811672 439463 416583 442907 443909 443241 454091 490543 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (1.93%) |
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 416583 427555 439463 441031 442907 443241 443909 454091 458699 465854 468692 480031 481861 483187 490543 494463 514388 518506 533451 535640 537467 540235 555571 560054 564705 566392 569122 571031 585417 609896 612070 614244 620731 622374 623411 629923 630225 633503 636553 637154 641837 645232 647641 647839 647976 655833 662080 665747 670761 680443 694469 698890 699606 702635 705907 710920 711673 714247 716368 717820 717842 720645 721116 724281 725601 727532 727794 727923 728332 728386 732293 736265 737161 737408 738483 740505 740610 744650 747136 749462 749539 750241 750637 751700 752653 752676 758232 758794 759500 761163 765628 770783 770784 771332 789516 790959 795403 796943 797585 797733 799955 800474 802314 805032 806425 809847 810225 811672 811808 811994 813377 814212 815855 816555 817252 820794 821193 821195 821503 821597 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy teen анал"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy teen анал"
]
|
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.