Query Metrics
7
Database Queries
7
Different statements
176.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.17 ms (87.14%) |
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 30208 30791 37495 61969 102234 178567 251476 385379 385385 390389 391701 403539 405939 407187 411621 418739 418968 439442 444591 454487 467022 475387 480908 504812 515569 516824 523904 545090 566643 578200 593452 596795 601618 602128 605763 607396 614726 614733 623638 630370 641794 647645 664227 664275 673536 675990 678806 697391 698125 698128 699441 707642 709623 714528 716164 716331 716883 727785 728378 728667 729578 732292 734390 735836 735845 735959 738209 738297 740985 750198 753783 754191 755363 758329 758791 760406 770930 775558 776176 776557 776829 781369 782408 782594 784780 784788 788230 788490 789402 795754 796243 797103 798051 800543 800869 800875 801416 802432 802834 803176 804800 807057 807769 810000 813620 813920 814293 814722 814770 816013 817116 818903 819196 819262 820713 821405 823585 823887 826235 ] |
||||||||||||||||||||||||||||||
|
13.52 ms (7.64%) |
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 804800 102234 391701 411621 814722 816013 823585 821405 819196 820713 516824 523904 515569 675990 678806 699441 716883 673536 697391 709623 602128 596795 593452 775558 776557 802432 776176 788490 802834 807057 728667 729578 735836 735959 754191 795754 807769 760406 755363 734390 735845 738209 738297 727785 728648 753783 607396 614733 707642 714528 716164 781369 782408 784780 788230 797103 803176 385379 480908 37495 178567 385385 439442 784788 810000 728378 750198 800869 782594 732292 444591 418968 813920 454487 770930 390389 818903 61969 405939 758329 504812 251476 30791 30208 403539 407187 418739 819262 823887 813620 817116 826235 814293 814770 475387 467022 566643 578200 545090 664227 647645 664275 698125 698128 716331 605763 614726 641794 601618 623638 630370 776829 789402 800875 798051 740985 758791 796243 800543 801416 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.61%) |
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 30208 30791 37495 61969 102234 178567 251476 385379 385385 390389 391701 403539 405939 407187 411621 418739 418968 439442 444591 454487 467022 475387 480908 504812 515569 516824 523904 545090 566643 578200 593452 596795 601618 602128 605763 607396 614726 614733 623638 630370 641794 647645 664227 664275 673536 675990 678806 697391 698125 698128 699441 707642 709623 714528 716164 716331 716883 727785 728378 728667 729578 732292 734390 735836 735845 735959 738209 738297 740985 750198 753783 754191 755363 758329 758791 760406 770930 775558 776176 776557 776829 781369 782408 782594 784780 784788 788230 788490 789402 795754 796243 797103 798051 800543 800869 800875 801416 802432 802834 803176 804800 807057 807769 810000 813620 813920 814293 814722 814770 816013 817116 818903 819196 819262 820713 821405 823585 823887 826235 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"curvy big ass"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"curvy большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"curvy большая большие жоп"
]
|
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.