Query Metrics
7
Database Queries
7
Different statements
225.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.61 ms (90.62%) |
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 337061 382792 397765 615894 629549 636500 639871 648741 693795 697733 698723 698917 699392 699538 706597 707583 714745 718853 719087 722167 724842 728116 728868 728870 730318 730510 730679 731186 732692 733448 734491 734604 734657 735664 735780 736720 740541 741319 743070 743708 744923 746132 746853 747056 747061 748002 749615 749791 753988 755107 756979 757605 757712 757930 762655 763603 763843 764570 764662 765369 765802 766162 766934 766964 767294 767884 767892 768117 768542 768719 768720 772797 772997 773375 773378 777565 777621 777629 778477 780094 780112 782084 782897 784426 787153 787588 790662 791364 791814 792327 792435 792439 792679 794584 795929 797744 798961 800039 800173 802088 802272 803884 812140 817032 818736 819133 819300 819313 819382 819414 819451 819728 823255 823862 823876 825892 826006 826224 826583 826677 ] |
||||||||||||||||||||||||||||||
|
11.61 ms (5.14%) |
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 767884 767892 772997 736720 744923 746132 747056 747061 756979 757712 757930 764662 766162 728116 728868 728870 730510 730679 735664 735780 753988 764570 765369 767294 768542 768719 768720 724842 730318 733448 734604 741319 746853 748002 749791 757605 763843 768117 772797 773375 773378 629549 697733 706597 714745 719087 777565 777621 777629 780112 787153 787588 791364 792679 794584 795929 797744 798961 802088 802272 803884 812140 397765 337061 382792 819728 823255 826224 826677 826583 823876 817032 819414 826006 819300 819313 819382 819451 825892 818736 819133 823862 699392 693795 698917 707583 718853 648741 698723 699538 722167 615894 636500 639871 778477 782084 782897 791814 792439 780094 784426 792435 734657 740541 749615 755107 766964 790662 792327 800039 800173 732692 734491 763603 731186 743070 765802 743708 762655 766934 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.11%) |
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 337061 382792 397765 615894 629549 636500 639871 648741 693795 697733 698723 698917 699392 699538 706597 707583 714745 718853 719087 722167 724842 728116 728868 728870 730318 730510 730679 731186 732692 733448 734491 734604 734657 735664 735780 736720 740541 741319 743070 743708 744923 746132 746853 747056 747061 748002 749615 749791 753988 755107 756979 757605 757712 757930 762655 763603 763843 764570 764662 765369 765802 766162 766934 766964 767294 767884 767892 768117 768542 768719 768720 772797 772997 773375 773378 777565 777621 777629 778477 780094 780112 782084 782897 784426 787153 787588 790662 791364 791814 792327 792435 792439 792679 794584 795929 797744 798961 800039 800173 802088 802272 803884 812140 817032 818736 819133 819300 819313 819382 819414 819451 819728 823255 823862 823876 825892 826006 826224 826583 826677 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot sperm"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot сперм"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot сперм"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.68%) |
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.