Query Metrics
7
Database Queries
7
Different statements
269.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
244.93 ms (90.72%) |
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 100535 137351 407792 433917 469496 511164 511203 521513 547388 555952 565634 566472 575596 575619 577832 578948 585393 587117 591156 593996 610244 613898 617777 618273 629596 631446 631851 632796 634298 639631 641405 643190 643765 646060 651853 668064 668774 677584 678241 678370 679564 683314 692679 693882 695457 695847 697324 700507 701605 701939 703628 704364 705177 706542 707730 709506 712362 713816 714628 716754 717357 717408 723019 723144 725318 725367 726471 726493 727001 728380 728799 731144 734175 736270 738313 738693 738955 741567 742768 746291 746737 747873 752368 762659 763678 763841 764707 764772 765114 765128 768040 769084 771791 777622 778274 779563 781187 781902 782514 783448 783521 786937 791696 794799 794955 795765 795853 798983 799015 799084 799969 800141 800907 801320 811956 818058 818186 818537 819446 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (5.41%) |
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 695457 765114 728799 752368 100535 407792 511164 575596 693882 713816 631851 632796 610244 591156 794799 734175 728380 736270 764772 727001 742768 738313 746737 763678 716754 555952 801320 783448 794955 137351 818537 818186 469496 521513 511203 575619 547388 678241 712362 678370 717408 613898 643190 585393 781902 783521 786937 779563 781187 798983 800907 731144 795853 799084 747873 738955 726493 763841 771791 641405 704364 782514 791696 799015 799969 433917 818058 819446 565634 577832 578948 692679 703628 705177 707730 646060 651853 677584 679564 683314 695847 697324 701605 709506 717357 723019 668064 668774 714628 723144 566472 593996 587117 634298 631446 618273 629596 778274 795765 777622 725367 746291 765128 769084 800141 811956 725318 741567 762659 726471 738693 762017 764707 768040 617777 639631 643765 700507 701939 706542 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (0.99%) |
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 100535 137351 407792 433917 469496 511164 511203 521513 547388 555952 565634 566472 575596 575619 577832 578948 585393 587117 591156 593996 610244 613898 617777 618273 629596 631446 631851 632796 634298 639631 641405 643190 643765 646060 651853 668064 668774 677584 678241 678370 679564 683314 692679 693882 695457 695847 697324 700507 701605 701939 703628 704364 705177 706542 707730 709506 712362 713816 714628 716754 717357 717408 723019 723144 725318 725367 726471 726493 727001 728380 728799 731144 734175 736270 738313 738693 738955 741567 742768 746291 746737 747873 752368 762659 763678 763841 764707 764772 765114 765128 768040 769084 771791 777622 778274 779563 781187 781902 782514 783448 783521 786937 791696 794799 794955 795765 795853 798983 799015 799084 799969 800141 800907 801320 811956 818058 818186 818537 819446 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие suck"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие suck"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big suck"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.66%) |
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.