Query Metrics
7
Database Queries
7
Different statements
176.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.29 ms (87.32%) |
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 540146 544232 545418 546357 551578 554726 562111 575358 581392 581550 585350 585927 596222 599987 607217 607503 608679 610771 611467 613768 614330 618177 618862 618870 629680 630536 632579 632901 633244 633716 635812 638740 639125 639741 640361 642774 646255 647860 650634 651922 655568 655569 660053 665922 666850 666894 667354 668683 670405 671773 672401 674202 678796 684789 688677 690942 692621 699179 704896 705351 709712 712830 715951 716069 719649 723383 724124 726330 726878 728860 734350 734542 738118 738445 738675 738807 739919 740775 740846 741221 741402 741881 744765 746081 746616 748384 748973 749321 751431 751437 751453 754184 756461 757217 759313 760446 760939 771857 773277 774666 782745 783920 783930 784260 785114 787022 790082 790158 798387 804371 809358 809851 811658 814285 814302 820347 826849 827591 827592 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (7.10%) |
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 723383 575358 633244 585927 607217 614330 785114 798387 787022 756461 744765 728860 739919 759313 771857 741402 705351 783930 716069 688677 618870 790158 666894 646255 599987 632579 651922 820347 827592 827591 826849 546357 562111 544232 581550 671773 672401 684789 692621 719649 660053 667354 670405 690942 581392 607503 596222 610771 613768 585350 611467 638740 809358 809851 738118 740775 751437 757217 783920 804371 811658 740846 773277 738445 741221 751453 760939 734542 738807 608679 633716 635812 545418 639741 642774 827961 712830 748384 814302 540146 554726 665922 674202 704896 650634 655569 715951 655568 668683 678796 699179 551578 639125 640361 629680 790082 782745 754184 760446 748973 726878 738675 734350 741881 746616 749321 751431 632901 709712 774666 784260 618862 726330 724124 746081 647860 666850 618177 630536 814285 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.81%) |
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 540146 544232 545418 546357 551578 554726 562111 575358 581392 581550 585350 585927 596222 599987 607217 607503 608679 610771 611467 613768 614330 618177 618862 618870 629680 630536 632579 632901 633244 633716 635812 638740 639125 639741 640361 642774 646255 647860 650634 651922 655568 655569 660053 665922 666850 666894 667354 668683 670405 671773 672401 674202 678796 684789 688677 690942 692621 699179 704896 705351 709712 712830 715951 716069 719649 723383 724124 726330 726878 728860 734350 734542 738118 738445 738675 738807 739919 740775 740846 741221 741402 741881 744765 746081 746616 748384 748973 749321 751431 751437 751453 754184 756461 757217 759313 760446 760939 771857 773277 774666 782745 783920 783930 784260 785114 787022 790082 790158 798387 804371 809358 809851 811658 814285 814302 820347 826849 827591 827592 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодые писают"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.72%) |
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.