Query Metrics
7
Database Queries
7
Different statements
457.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.67 ms (47.54%) |
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 547992 564391 565029 574114 583559 583625 608980 612494 617034 618409 619241 630230 632064 646662 650594 651301 654899 674009 677158 678651 682232 684320 684367 684799 684893 685417 687326 690652 690732 690750 691969 698652 700607 702378 703265 703282 708081 711071 719892 722092 726899 727348 727695 728935 729748 730276 730622 730830 732515 735394 737973 738541 740208 743714 744161 745284 745832 746753 747254 751270 753233 753641 754577 756318 757654 760964 763809 764994 766200 770343 770375 772401 776128 777720 779404 779550 779925 780780 782117 782445 783088 785108 786074 786422 786535 787471 787988 788148 788381 788433 788666 789168 789931 792364 794753 794768 795791 796591 797057 797209 797820 799726 801677 802854 802856 802878 805705 805712 807294 807382 807421 807893 808197 810400 810941 813335 816187 816767 817343 ] |
||||||||||||||||||||||||||||||
|
209.97 ms (45.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
20.15 ms (4.40%) |
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 583559 583625 565029 646662 654899 674009 682232 684320 684799 684893 685417 687326 700607 702378 719892 690732 691969 677158 690750 708081 722092 574114 618409 617034 619241 777720 780780 786422 786535 789931 792364 797057 799726 801677 807294 807382 807421 779404 785108 788433 789168 805712 729748 735394 737973 744161 760964 763809 782445 786074 787471 788148 797209 802854 807893 810400 813335 730830 740208 743714 745284 753641 759141 766200 772401 726899 747254 770375 727348 730276 732515 757654 730622 738541 746753 751270 753233 754577 764994 632064 698652 703265 703282 711071 776128 779550 788381 794753 796591 802878 808197 651301 650594 816187 816767 783088 794768 805705 810941 756318 770343 817343 547992 564391 690652 678651 684367 608980 612494 630230 788666 779925 795791 802856 782117 787988 797820 728935 745832 727695 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (0.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 547992 564391 565029 574114 583559 583625 608980 612494 617034 618409 619241 630230 632064 646662 650594 651301 654899 674009 677158 678651 682232 684320 684367 684799 684893 685417 687326 690652 690732 690750 691969 698652 700607 702378 703265 703282 708081 711071 719892 722092 726899 727348 727695 728935 729748 730276 730622 730830 732515 735394 737973 738541 740208 743714 744161 745284 745832 746753 747254 751270 753233 753641 754577 756318 757654 760964 763809 764994 766200 770343 770375 772401 776128 777720 779404 779550 779925 780780 782117 782445 783088 785108 786074 786422 786535 787471 787988 788148 788381 788433 788666 789168 789931 792364 794753 794768 795791 796591 797057 797209 797820 799726 801677 802854 802856 802878 805705 805712 807294 807382 807421 807893 808197 810400 810941 813335 816187 816767 817343 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck stepsister"
]
|
||||||||||||||||||||||||||||||
|
2.29 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс stepsister"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс stepsister"
]
|
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.