Query Metrics
7
Database Queries
7
Different statements
167.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.39 ms (84.64%) |
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 232953 233321 390923 391475 391581 391968 393701 397279 397410 398957 401124 402340 417276 426725 443156 443673 443686 443706 444001 444142 444258 462579 463166 466187 467214 469844 469898 470785 470926 473252 477958 477980 479765 494362 494382 496965 501845 503870 504744 520300 526111 542934 542942 543694 543738 546627 552859 556849 557326 563207 565107 569684 570056 580241 580640 595363 595863 596650 597585 598443 600042 612022 622111 627748 655718 655752 656728 657025 657030 657643 660513 668648 676472 676473 692859 701501 704010 710957 714447 714455 715425 716835 717699 720824 720825 721552 722443 725914 728351 735594 740494 741029 741047 744508 745760 747476 749896 749940 753815 758033 766043 766536 769766 779523 781687 781701 782217 789202 789401 789829 789885 817660 818083 819047 820079 820225 820298 823910 825682 827978 ] |
||||||||||||||||||||||||||||||
|
15.57 ms (9.32%) |
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 467214 565107 542934 692859 714447 720825 569684 570056 596650 595863 704010 470926 463166 390923 443156 479765 503870 494362 496965 546627 820225 781687 393701 556849 563207 401124 417276 426725 402340 391581 398957 676472 818083 819047 817660 820079 823910 825682 827978 580241 657030 657025 657643 660513 710957 721552 655718 655752 656728 668648 717699 720824 722443 557326 600042 597585 612022 789885 789202 789401 741029 749940 725914 728351 740494 744508 745760 753815 758033 769766 735594 766043 747476 749896 779523 789829 714455 676473 701501 622111 397279 232953 542942 716835 552859 598443 627748 595363 766536 443686 443706 466187 470785 477958 477980 444142 444258 462579 469844 469898 473252 443673 444001 501845 494382 526111 520300 580640 820298 782217 391968 233321 543694 543738 391475 397410 781701 741047 715425 504744 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.45%) |
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 232953 233321 390923 391475 391581 391968 393701 397279 397410 398957 401124 402340 417276 426725 443156 443673 443686 443706 444001 444142 444258 462579 463166 466187 467214 469844 469898 470785 470926 473252 477958 477980 479765 494362 494382 496965 501845 503870 504744 520300 526111 542934 542942 543694 543738 546627 552859 556849 557326 563207 565107 569684 570056 580241 580640 595363 595863 596650 597585 598443 600042 612022 622111 627748 655718 655752 656728 657025 657030 657643 660513 668648 676472 676473 692859 701501 704010 710957 714447 714455 715425 716835 717699 720824 720825 721552 722443 725914 728351 735594 740494 741029 741047 744508 745760 747476 749896 749940 753815 758033 766043 766536 769766 779523 781687 781701 782217 789202 789401 789829 789885 817660 818083 819047 820079 820225 820298 823910 825682 827978 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian old young"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск old young"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск old young"
]
|
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.