Query Metrics
7
Database Queries
7
Different statements
245.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.19 ms (90.08%) |
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 13282 73658 74181 110772 278472 378309 382605 384924 397012 418568 427553 447364 453583 489234 489546 516699 529089 529840 530008 533221 537156 537216 539162 542618 551937 560250 565200 568191 570693 571236 579616 585936 587282 589709 591334 595177 598448 602876 605938 613614 616963 621495 623748 623964 625517 628027 640663 644745 646536 647005 647278 648059 649916 651094 654982 655920 656487 665894 670731 674278 675570 677180 682912 685329 688470 688960 690588 692121 701418 713951 715576 718108 723794 723973 726818 730675 731802 734596 736811 738937 741186 742612 747684 748842 750862 752404 752442 752489 752812 754426 759324 762741 769629 781989 784160 795468 804020 805078 809209 813411 814187 817686 817953 818143 819331 819370 820360 821029 821820 823845 824560 825957 826414 826647 827704 827861 827866 827914 ] |
||||||||||||||||||||||||||||||
|
13.42 ms (5.47%) |
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 13282 591334 378309 809209 529840 651094 623964 726818 742612 828044 74181 384924 825957 539162 530008 537216 685329 654982 818143 824560 537156 568191 570693 648059 649916 715576 690588 713951 688470 587282 613614 625517 628027 644745 605938 602876 616963 795468 805078 723794 752404 752489 784160 734596 747684 766362 723973 750862 748842 759324 640663 701418 579616 529089 589709 827914 781989 533221 516699 677180 692121 646536 718108 752442 813411 571236 453583 682912 585936 598448 73658 397012 819331 730675 817953 827704 814187 823845 542618 560250 656487 647278 688960 647005 655920 595177 769629 736811 804020 382605 427553 278472 826414 675570 674278 623748 741186 110772 418568 819370 827866 447364 551937 565200 665894 670731 621495 754426 762741 738937 752812 731802 820360 821820 826647 817686 821029 827861 489234 489546 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.15%) |
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 13282 73658 74181 110772 278472 378309 382605 384924 397012 418568 427553 447364 453583 489234 489546 516699 529089 529840 530008 533221 537156 537216 539162 542618 551937 560250 565200 568191 570693 571236 579616 585936 587282 589709 591334 595177 598448 602876 605938 613614 616963 621495 623748 623964 625517 628027 640663 644745 646536 647005 647278 648059 649916 651094 654982 655920 656487 665894 670731 674278 675570 677180 682912 685329 688470 688960 690588 692121 701418 713951 715576 718108 723794 723973 726818 730675 731802 734596 736811 738937 741186 742612 747684 748842 750862 752404 752442 752489 752812 754426 759324 762741 769629 781989 784160 795468 804020 805078 809209 813411 814187 817686 817953 818143 819331 819370 820360 821029 821820 823845 824560 825957 826414 826647 827704 827861 827866 827914 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding ass big"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding жоп большие"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding жоп большие"
]
|
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.