Query Metrics
7
Database Queries
7
Different statements
172.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.49 ms (85.70%) |
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 465047 511806 514139 530029 536915 553841 554991 566062 578730 595590 620037 622275 626285 640442 658523 661589 667589 682495 685757 688095 689296 692756 700639 700648 706379 706415 716288 716294 716956 723993 724319 725035 726844 727396 727889 729200 732699 734365 736074 738110 740312 740794 740858 741786 742795 742887 749595 750484 750937 751669 752235 752240 752295 752408 752452 752544 753099 753736 757850 758901 759267 761283 763035 764022 770730 770740 770778 772034 772314 773296 777513 784081 787965 791335 794798 796219 798117 798765 800770 801217 801224 801890 805365 805485 806085 806700 806911 807264 810802 810874 811468 813503 813601 813647 814029 814287 815233 815917 816620 816624 817290 817427 817931 817949 818867 818939 818946 818969 818981 819543 819655 819913 822376 822377 823439 823466 824636 824899 825262 826645 ] |
||||||||||||||||||||||||||||||
|
13.89 ms (8.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 818867 818969 818981 823439 824636 824899 813601 826645 814029 816620 816624 817290 819655 819913 822377 813647 817427 817949 818939 818946 822376 825262 814287 815233 815917 817931 819543 823466 465047 514139 536915 511806 530029 566062 554991 578730 682495 692756 700648 716956 661589 689296 706379 706415 716288 716294 658523 667589 685757 688095 700639 553841 640442 620037 622275 626285 595590 777513 800770 801217 801224 805365 806085 810802 791335 798117 801890 806700 806911 811468 813503 740794 740858 742795 750484 752235 752240 752408 758901 770730 772034 772314 784081 787965 794798 796219 798765 805485 807264 810874 725035 726844 732699 738110 741786 751669 752544 757850 759267 770778 723993 727396 727889 752452 753099 763035 773296 724319 734365 740312 742887 750937 752295 753736 761283 764022 770740 729200 736074 749595 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (2.02%) |
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 465047 511806 514139 530029 536915 553841 554991 566062 578730 595590 620037 622275 626285 640442 658523 661589 667589 682495 685757 688095 689296 692756 700639 700648 706379 706415 716288 716294 716956 723993 724319 725035 726844 727396 727889 729200 732699 734365 736074 738110 740312 740794 740858 741786 742795 742887 749595 750484 750937 751669 752235 752240 752295 752408 752452 752544 753099 753736 757850 758901 759267 761283 763035 764022 770730 770740 770778 772034 772314 773296 777513 784081 787965 791335 794798 796219 798117 798765 800770 801217 801224 801890 805365 805485 806085 806700 806911 807264 810802 810874 811468 813503 813601 813647 814029 814287 815233 815917 816620 816624 817290 817427 817931 817949 818867 818939 818946 818969 818981 819543 819655 819913 822376 822377 823439 823466 824636 824899 825262 826645 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina pussy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская pussy"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская pussy"
]
|
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.