Query Metrics
7
Database Queries
7
Different statements
154.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.84 ms (85.52%) |
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 383687 398747 461864 490125 510494 530559 543106 545034 568903 570677 571488 588278 592159 592680 594581 596981 610489 618099 619815 623372 626023 627623 630212 632938 634819 634948 635522 639680 644773 645697 648693 652338 652468 660622 665324 668813 671228 682957 684886 693683 696299 700775 701859 705074 705807 713493 713785 714507 719677 725741 726267 729918 730356 730719 731304 731792 735394 736502 739095 740208 740272 740859 745849 748880 749014 749373 749662 753429 754864 757654 757695 758506 758654 760256 763424 764861 765345 766093 767680 769199 771437 783457 783699 783995 784232 784235 785232 786204 786784 788383 789060 791481 791671 792417 793308 796492 798864 799670 800942 801511 803204 804816 805072 810941 811239 812208 812438 816130 817496 818135 820450 820736 821788 822533 823407 824488 825056 826745 828373 828626 ] |
||||||||||||||||||||||||||||||
|
10.35 ms (6.71%) |
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 705807 713493 713785 719677 799670 726267 729918 731792 749014 811239 754864 764861 763424 749373 714507 788383 804816 812438 398747 822533 823407 826745 820736 828373 490125 570677 696299 627623 785232 791671 800942 796492 798864 730719 735394 765345 769199 783699 792417 801511 805072 731304 739095 740208 748880 760256 740272 753429 757654 730356 771437 632938 634948 789060 700775 740859 383687 623372 810941 634819 824488 461864 571488 543106 645697 671228 684886 803204 766093 784235 757695 701859 825056 818135 816130 817496 828626 530559 652338 668813 705074 660622 568903 594581 596981 592680 618099 635522 630212 644773 592159 639680 783995 786204 786784 812208 749662 758654 783457 736502 745849 758506 767680 725741 821788 820450 510494 545034 648693 652468 665324 682957 693683 610489 619815 626023 588278 793308 784232 791481 ] |
||||||||||||||||||||||||||||||
|
3.73 ms (2.42%) |
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 383687 398747 461864 490125 510494 530559 543106 545034 568903 570677 571488 588278 592159 592680 594581 596981 610489 618099 619815 623372 626023 627623 630212 632938 634819 634948 635522 639680 644773 645697 648693 652338 652468 660622 665324 668813 671228 682957 684886 693683 696299 700775 701859 705074 705807 713493 713785 714507 719677 725741 726267 729918 730356 730719 731304 731792 735394 736502 739095 740208 740272 740859 745849 748880 749014 749373 749662 753429 754864 757654 757695 758506 758654 760256 763424 764861 765345 766093 767680 769199 771437 783457 783699 783995 784232 784235 785232 786204 786784 788383 789060 791481 791671 792417 793308 796492 798864 799670 800942 801511 803204 804816 805072 810941 811239 812208 812438 816130 817496 818135 820450 820736 821788 822533 823407 824488 825056 826745 828373 828626 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in room"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс room"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс room"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.