Query Metrics
7
Database Queries
7
Different statements
148.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.86 ms (84.50%) |
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 12309 39285 70150 81173 310945 340242 382818 383971 386650 387195 389743 391032 391491 392872 398977 417283 418717 419223 419927 422302 435799 436418 438764 459776 469388 478524 485640 494164 503034 514126 529339 544317 554225 556552 561243 575303 581744 584997 589034 590266 593181 595634 595695 606101 623656 626489 626495 627635 628681 648169 670801 675536 678187 686583 692967 703662 709244 715746 716597 716650 719130 719775 723127 723131 723287 729270 734424 743633 745572 756258 761639 762635 762638 763228 763457 764555 765734 767398 768358 768807 769668 769859 771516 771568 771710 772258 774711 778671 778739 779037 779997 780925 782011 782941 783223 783760 783763 786421 789768 791702 791705 792493 793397 793693 793747 793766 795005 798163 798251 798339 798636 799488 803038 804220 810592 813306 814022 814311 814368 819728 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (9.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 799488 723287 595634 589034 798636 745572 392872 419927 503034 626489 791705 765734 709244 419223 435799 438764 391032 469388 398977 814368 623656 715746 792493 386650 340242 798163 793747 791702 769668 763457 819728 814311 764555 719775 529339 310945 575303 590266 734424 762635 780925 793397 648169 581744 556552 436418 81173 814022 675536 703662 70150 391491 686583 778671 12309 478524 692967 593181 789768 793693 798251 803038 743633 761639 779997 782011 783223 804220 813306 418717 670801 389743 756258 810592 771568 729270 606101 716597 768807 771710 382818 387195 584997 786421 544317 769859 459776 595695 762638 627635 494164 793766 774711 798339 719130 39285 716650 628681 779037 422302 783763 723127 768358 772258 771516 783760 514126 723131 626495 554225 795005 763228 767398 485640 561243 678187 782941 778739 417283 383971 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.61%) |
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 12309 39285 70150 81173 310945 340242 382818 383971 386650 387195 389743 391032 391491 392872 398977 417283 418717 419223 419927 422302 435799 436418 438764 459776 469388 478524 485640 494164 503034 514126 529339 544317 554225 556552 561243 575303 581744 584997 589034 590266 593181 595634 595695 606101 623656 626489 626495 627635 628681 648169 670801 675536 678187 686583 692967 703662 709244 715746 716597 716650 719130 719775 723127 723131 723287 729270 734424 743633 745572 756258 761639 762635 762638 763228 763457 764555 765734 767398 768358 768807 769668 769859 771516 771568 771710 772258 774711 778671 778739 779037 779997 780925 782011 782941 783223 783760 783763 786421 789768 791702 791705 792493 793397 793693 793747 793766 795005 798163 798251 798339 798636 799488 803038 804220 810592 813306 814022 814311 814368 819728 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"глубокий минет сперма"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс сперм"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.00%) |
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.