Query Metrics
7
Database Queries
7
Different statements
156.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.20 ms (85.07%) |
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 311897 382902 401441 401654 401700 408257 424380 427966 444407 447124 453383 460281 461763 463840 465104 474506 479788 486877 489257 489258 499802 502242 502841 509248 512811 517286 519257 526056 530739 531134 531183 535802 536285 536540 536640 537771 539679 542198 542636 543017 543107 543808 545277 546065 546708 559953 567112 569826 575919 576804 581348 581816 583714 584592 592046 593413 598652 612726 617619 619393 622777 624833 628515 629850 630877 634337 639335 641950 646602 646875 650012 651956 665004 665260 677735 678533 684343 698821 712317 715594 723093 723174 724459 726044 726463 729665 730628 732184 735783 737736 738875 742045 746679 748912 754178 760319 772807 776146 781546 785496 787014 787546 788315 791275 791989 804485 809778 810006 811738 814975 818747 819307 819683 820472 826004 826114 826627 828647 828749 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (8.69%) |
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 576804 810006 781546 748912 724459 629850 776146 463840 531183 536640 489257 584592 684343 559953 641950 617619 811738 772807 543017 819307 546065 546708 444407 509248 519257 502841 814975 531134 569826 567112 698821 581348 639335 622777 628515 760319 788315 311897 408257 453383 517286 526056 424380 499802 382902 465104 545277 738875 583714 401441 826114 735783 737736 828647 677735 723174 646602 634337 787014 791275 754178 791989 536540 646875 592046 447124 502242 651956 537771 624833 427966 461763 530739 479788 542198 543107 593413 598652 650012 665004 730628 746679 712317 785496 401700 726463 818747 401654 826627 826111 828749 474506 732184 729665 809778 536285 543808 678533 581816 612726 489258 539679 460281 486877 820472 512811 542636 575919 619393 630877 787546 726044 819683 535802 665260 723093 804485 742045 715594 826004 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.75%) |
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 311897 382902 401441 401654 401700 408257 424380 427966 444407 447124 453383 460281 461763 463840 465104 474506 479788 486877 489257 489258 499802 502242 502841 509248 512811 517286 519257 526056 530739 531134 531183 535802 536285 536540 536640 537771 539679 542198 542636 543017 543107 543808 545277 546065 546708 559953 567112 569826 575919 576804 581348 581816 583714 584592 592046 593413 598652 612726 617619 619393 622777 624833 628515 629850 630877 634337 639335 641950 646602 646875 650012 651956 665004 665260 677735 678533 684343 698821 712317 715594 723093 723174 724459 726044 726463 729665 730628 732184 735783 737736 738875 742045 746679 748912 754178 760319 772807 776146 781546 785496 787014 787546 788315 791275 791989 804485 809778 810006 811738 814975 818747 819307 819683 820472 826004 826114 826627 828647 828749 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge cock"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные cock"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие огромные cock"
]
|
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.