Query Metrics
7
Database Queries
7
Different statements
147.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.75 ms (80.68%) |
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 114536 391511 394191 397445 398820 408493 422110 437178 526028 532255 534461 552873 553343 566238 581382 590625 593083 593693 599681 602365 604193 612973 613766 626633 662474 663499 663865 663881 667615 667621 671440 683484 695475 697215 701987 703795 706253 708688 713710 715660 716824 717118 717231 727583 729263 729704 730362 735499 740205 742082 743738 744486 744661 750125 752072 753727 756435 758212 767439 773806 778688 778801 780378 780409 781555 781652 782148 783754 783826 784638 786952 787794 789300 789598 791985 795038 795513 797725 799795 801009 801061 801588 802027 802425 802686 803211 803263 803565 805426 808203 808509 809360 810874 811810 812188 813813 814964 815419 815462 815481 815629 815768 818161 819045 819871 819879 820036 820810 821575 821580 823052 823512 823676 824506 824536 824985 826071 826165 827949 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (11.10%) |
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 716824 789300 812188 532255 391511 398820 422110 815629 821580 823052 823676 824985 818161 820036 813813 824536 826071 819879 823512 826165 663499 713710 717118 717231 663881 662474 667615 703795 602365 593083 599681 778688 780378 789598 791985 797725 801061 803211 805426 767439 802686 808203 811810 740205 742082 729704 730362 735499 744661 727583 743738 750125 772918 715660 780409 781555 781652 802027 808509 397445 437178 814964 827949 114536 553343 815768 824506 581382 802425 756435 815462 819045 819871 815419 566238 667621 663865 671440 552873 612973 801009 803263 787794 786952 801588 758212 753727 752072 773806 701987 706253 782148 783754 783826 803565 809360 394191 408493 815481 820810 821575 526028 534461 683484 695475 708688 697215 590625 613766 593693 604193 626633 778801 795038 795513 729263 744486 784638 799795 810874 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.35%) |
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 114536 391511 394191 397445 398820 408493 422110 437178 526028 532255 534461 552873 553343 566238 581382 590625 593083 593693 599681 602365 604193 612973 613766 626633 662474 663499 663865 663881 667615 667621 671440 683484 695475 697215 701987 703795 706253 708688 713710 715660 716824 717118 717231 727583 729263 729704 730362 735499 740205 742082 743738 744486 744661 750125 752072 753727 756435 758212 767439 773806 778688 778801 780378 780409 781555 781652 782148 783754 783826 784638 786952 787794 789300 789598 791985 795038 795513 797725 799795 801009 801061 801588 802027 802425 802686 803211 803263 803565 805426 808203 808509 809360 810874 811810 812188 813813 814964 815419 815462 815481 815629 815768 818161 819045 819871 819879 820036 820810 821575 821580 823052 823512 823676 824506 824536 824985 826071 826165 827949 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"him fuck"
]
|
||||||||||||||||||||||||||||||
|
2.38 ms (1.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"him секс"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"him секс"
]
|
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.