Query Metrics
7
Database Queries
7
Different statements
398.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.47 ms (52.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп stepmom"
]
|
||||||||||||||||||||||||||||||
|
168.05 ms (42.19%) |
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 191069 387453 395731 400484 433249 452464 466710 507805 541793 547568 555032 561520 565648 568343 571132 601468 618019 618181 629612 661918 682612 686158 689369 691376 693087 696745 696990 700611 701243 708259 712620 713416 715511 717171 717911 717920 720008 720514 720906 724123 724632 725159 725179 725538 726735 726989 733015 736861 737980 739951 742529 745164 746071 746639 749009 749363 749760 753497 754990 755517 756354 756859 758342 759094 760974 760982 761025 761234 765502 771483 775736 777996 780109 781496 782928 785107 788214 789181 792523 793814 794215 794324 794338 794639 795043 795303 795364 795815 795869 796062 796066 796656 798801 799751 800816 801175 801253 801521 801545 802048 803725 804224 805713 813684 816605 817536 817972 818510 819917 819929 819936 820736 823694 823705 823848 824744 824772 825825 827483 828788 ] |
||||||||||||||||||||||||||||||
|
12.22 ms (3.07%) |
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 724123 761025 696990 191069 827483 817972 759094 824772 823848 819929 819936 823694 816605 817536 818510 819917 820736 823705 824744 825825 828788 452464 507805 541793 547568 561520 565648 568343 571132 708259 720514 682612 693087 696745 713416 689369 691376 629612 601468 618181 795043 795815 798801 781496 794215 794639 796066 801521 803725 725159 726735 749363 754990 793814 795869 805713 724632 725179 733015 765502 771483 725538 739951 745164 746639 760974 760982 761234 726989 742529 749760 756354 758342 700611 701243 712620 717171 717911 775736 780109 782928 788214 789181 792523 794324 794338 795364 799751 802048 804224 395731 555032 618019 801175 795303 796656 801253 746071 753497 755517 801545 736861 737980 749009 777996 800816 661918 756859 796062 400484 387453 433249 813684 466710 686158 715511 717920 720008 720906 785107 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.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 191069 387453 395731 400484 433249 452464 466710 507805 541793 547568 555032 561520 565648 568343 571132 601468 618019 618181 629612 661918 682612 686158 689369 691376 693087 696745 696990 700611 701243 708259 712620 713416 715511 717171 717911 717920 720008 720514 720906 724123 724632 725159 725179 725538 726735 726989 733015 736861 737980 739951 742529 745164 746071 746639 749009 749363 749760 753497 754990 755517 756354 756859 758342 759094 760974 760982 761025 761234 765502 771483 775736 777996 780109 781496 782928 785107 788214 789181 792523 793814 794215 794324 794338 794639 795043 795303 795364 795815 795869 796062 796066 796656 798801 799751 800816 801175 801253 801521 801545 802048 803725 804224 805713 813684 816605 817536 817972 818510 819917 819929 819936 820736 823694 823705 823848 824744 824772 825825 827483 828788 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.39%) |
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.