Query Metrics
7
Database Queries
7
Different statements
161.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.68 ms (87.51%) |
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 33077 51524 388583 420748 452687 474721 479481 482867 483989 485736 491653 492695 495529 499578 503011 519267 522682 523956 525288 526150 527693 534345 541959 542698 544072 551104 562821 562911 585785 599813 608270 610704 612494 616709 622615 623071 629727 629751 638968 640826 640844 640863 647114 650293 653848 659313 659482 663463 664696 667443 682671 689094 690364 690468 691235 692412 692842 698386 698775 699235 699870 703795 705538 705746 706121 706543 712065 713460 718971 720418 720676 725426 731412 731440 731539 732664 734061 738922 739607 740048 741931 743579 744501 745763 746982 749571 753929 761160 762640 763429 763977 764597 766494 772503 773855 774033 776359 777691 778633 779848 780857 783729 785506 786047 789059 790152 790225 790251 792392 793306 794970 796619 798865 798904 798975 805426 806960 809345 813901 817746 ] |
||||||||||||||||||||||||||||||
|
9.67 ms (5.97%) |
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 452687 479481 420748 491653 492695 522682 482867 483989 519267 525288 485736 495529 503011 523956 527693 33077 51524 388583 817746 813901 474721 526150 534345 499578 541959 542698 562821 544072 551104 647114 663463 664696 667443 689094 705746 706121 706543 720676 653848 659313 659482 691235 692842 713460 650293 682671 690364 690468 692412 699235 703795 712065 562911 608270 623071 629727 629751 638968 640826 640863 585785 612494 599813 610704 616709 622615 640844 779848 785506 789059 793306 794970 798865 798904 798975 776359 777691 780857 783729 786047 790225 790251 796619 805426 806960 725426 731440 739607 740048 744501 753929 766494 792392 809345 732664 745763 749571 763429 763977 764597 772503 773855 741931 762640 774033 731412 731539 734061 738922 743579 746982 761160 698386 698775 699870 705538 718971 720418 778633 790152 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.07%) |
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 33077 51524 388583 420748 452687 474721 479481 482867 483989 485736 491653 492695 495529 499578 503011 519267 522682 523956 525288 526150 527693 534345 541959 542698 544072 551104 562821 562911 585785 599813 608270 610704 612494 616709 622615 623071 629727 629751 638968 640826 640844 640863 647114 650293 653848 659313 659482 663463 664696 667443 682671 689094 690364 690468 691235 692412 692842 698386 698775 699235 699870 703795 705538 705746 706121 706543 712065 713460 718971 720418 720676 725426 731412 731440 731539 732664 734061 738922 739607 740048 741931 743579 744501 745763 746982 749571 753929 761160 762640 763429 763977 764597 766494 772503 773855 774033 776359 777691 778633 779848 780857 783729 785506 786047 789059 790152 790225 790251 792392 793306 794970 796619 798865 798904 798975 805426 806960 809345 813901 817746 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в машина"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.94%) |
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.