Query Metrics
7
Database Queries
7
Different statements
182.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.46 ms (87.41%) |
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 479130 566879 582489 588715 599090 601477 604352 606875 609565 613576 615861 620728 620979 621290 621348 622558 630314 635712 637543 638421 638743 638889 641648 647688 656246 656846 657222 661638 666079 668786 668791 676740 678399 684752 684792 688723 689431 692682 693731 693740 701211 703729 705871 707515 710118 712641 715117 716651 718659 719392 720841 720991 723805 724144 724680 726181 726714 729897 731039 732941 733018 734328 735473 737001 738148 739544 741563 745910 746133 746576 747035 748350 751268 751799 754845 754863 754866 755243 759453 761515 761525 762189 762779 764581 765723 765811 767762 767845 768930 770067 771802 771808 772429 773454 773465 779394 780379 784229 785799 786639 787225 787266 788399 791428 792455 793321 793713 794059 794597 795006 795375 795467 796257 796319 796756 804545 805106 807872 808776 812727 ] |
||||||||||||||||||||||||||||||
|
11.79 ms (6.46%) |
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 762779 621348 701211 692682 621290 731039 746133 746576 770067 707515 582489 604352 719392 676740 606875 805106 787225 804545 705871 693731 768930 638421 599090 780379 786639 751268 726714 666079 637543 784229 737001 761525 668791 668786 724680 723805 771808 479130 566879 656246 684752 620728 601477 794597 724144 733018 732941 793321 689431 684792 710118 647688 678399 693740 720991 615861 588715 620979 635712 622558 638743 792455 812727 779394 791428 794059 796319 726181 761515 787266 795375 795467 745910 755243 767762 767845 729897 738148 739544 754863 762189 764581 703729 716651 796257 807872 613576 688723 712641 638889 734328 759453 772429 796756 754845 754866 748350 735473 771802 656846 661638 657222 641648 630314 788399 785799 795006 751799 765723 773454 773465 747035 765811 718659 720841 609565 793713 741563 715117 808776 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мою жену трахает"
]
|
||||||||||||||||||||||||||||||
|
2.43 ms (1.33%) |
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 479130 566879 582489 588715 599090 601477 604352 606875 609565 613576 615861 620728 620979 621290 621348 622558 630314 635712 637543 638421 638743 638889 641648 647688 656246 656846 657222 661638 666079 668786 668791 676740 678399 684752 684792 688723 689431 692682 693731 693740 701211 703729 705871 707515 710118 712641 715117 716651 718659 719392 720841 720991 723805 724144 724680 726181 726714 729897 731039 732941 733018 734328 735473 737001 738148 739544 741563 745910 746133 746576 747035 748350 751268 751799 754845 754863 754866 755243 759453 761515 761525 762189 762779 764581 765723 765811 767762 767845 768930 770067 771802 771808 772429 773454 773465 779394 780379 784229 785799 786639 787225 787266 788399 791428 792455 793321 793713 794059 794597 795006 795375 795467 796257 796319 796756 804545 805106 807872 808776 812727 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мо жен секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.