Query Metrics
7
Database Queries
7
Different statements
134.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.59 ms (84.29%) |
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 233489 396356 428675 464213 480973 502323 504759 538135 539251 542211 543359 546087 547085 547172 558696 559967 566440 567953 578722 578781 582001 582840 583319 594547 602392 602667 607000 612037 616640 630035 631994 632026 637543 650491 652532 656834 656846 662522 663446 670830 674606 675694 681509 681756 686850 689068 689958 690923 691373 693420 695359 697007 697190 702155 702926 705208 710839 713975 715117 723087 723824 728918 730157 731126 731157 732650 732842 735917 736239 739939 741081 742592 746345 748350 754863 760949 762779 764429 766344 767690 771802 773960 778127 783815 795049 795756 795955 797033 800916 801983 802600 803742 810304 813715 814127 814716 819408 819747 819909 820001 820132 820197 823258 823725 824088 824136 824417 824774 824823 825532 825838 825881 826328 826484 826581 826929 827470 827704 828627 ] |
||||||||||||||||||||||||||||||
|
11.24 ms (8.34%) |
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 650491 713975 686850 578781 616640 795955 607000 826484 823725 823258 826328 567953 656846 675694 731126 728918 746345 663446 504759 689068 691373 702155 602667 732842 760949 783815 810304 233489 396356 428675 819408 820132 824823 825881 826581 813715 819909 824774 826929 825838 828627 464213 538135 542211 582840 547085 582001 559967 674606 690923 681756 705208 656834 702926 546087 558696 602392 612037 637543 741081 767690 797033 800916 723824 764429 754863 762779 630035 778127 795756 578722 543359 814127 827470 820197 480973 502323 583319 710839 695359 697190 689958 801983 748350 730157 735917 771802 697007 802600 547172 594547 776489 731157 773960 736239 539251 652532 662522 723087 670830 681509 566440 632026 803742 732650 742592 766344 631994 715117 795049 739939 693420 819747 824088 814716 824136 824417 827704 820001 825532 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (2.01%) |
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 233489 396356 428675 464213 480973 502323 504759 538135 539251 542211 543359 546087 547085 547172 558696 559967 566440 567953 578722 578781 582001 582840 583319 594547 602392 602667 607000 612037 616640 630035 631994 632026 637543 650491 652532 656834 656846 662522 663446 670830 674606 675694 681509 681756 686850 689068 689958 690923 691373 693420 695359 697007 697190 702155 702926 705208 710839 713975 715117 723087 723824 728918 730157 731126 731157 732650 732842 735917 736239 739939 741081 742592 746345 748350 754863 760949 762779 764429 766344 767690 771802 773960 778127 783815 795049 795756 795955 797033 800916 801983 802600 803742 810304 813715 814127 814716 819408 819747 819909 820001 820132 820197 823258 823725 824088 824136 824417 824774 824823 825532 825838 825881 826328 826484 826581 826929 827470 827704 828627 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife with friend"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен friend"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен friend"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.13%) |
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.