Query Metrics
7
Database Queries
7
Different statements
149.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.81 ms (85.39%) |
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 494861 499902 500538 500916 504810 508396 510882 513826 519865 522433 522784 523279 526794 527072 527463 527928 530646 532525 534595 539397 546067 546429 546433 547554 550782 557102 559300 563686 577147 578805 584040 584095 586033 586981 587950 588727 589298 589647 591220 591719 591901 591928 591956 598297 602016 602526 604352 610085 611559 612237 613921 618147 621171 623472 623732 624377 627674 635012 636147 649271 664497 665998 667344 680216 689917 697683 699291 709486 716431 717035 718332 718613 720345 720352 723172 727782 730148 730181 734585 736681 738330 740611 744749 746434 748613 748805 750902 763350 767292 768171 768577 768643 768990 771918 771925 773601 775244 775313 776023 779859 780658 781115 783869 784606 785532 787665 791320 791609 792577 792989 793054 795196 795223 796137 796181 797407 802614 811174 812981 813013 ] |
||||||||||||||||||||||||||||||
|
11.09 ms (7.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 523279 519865 522433 589647 610085 612237 627674 785532 795196 784606 723172 526794 763350 508396 780658 768643 744749 746434 740611 768577 689917 618147 499902 500538 500916 504810 557102 577147 591928 613921 539397 546067 546429 550782 716431 649271 709486 563686 635012 624377 802614 734585 559300 602526 587950 727782 771918 796137 791320 797407 748805 602016 792577 534595 623472 598297 611559 697683 664497 510882 718332 720352 776023 791609 736681 768990 771925 527928 621171 586981 513826 584040 665998 578805 588727 591719 591220 591956 589298 795223 793054 748613 730181 768171 720345 813013 781115 796181 811174 783869 812981 787665 522784 527463 527072 530646 547554 680216 586033 623732 604352 775244 779859 730148 738330 494861 667344 584095 699291 718613 636147 591901 750902 532525 717035 546433 775313 792989 767292 773601 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.87%) |
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 494861 499902 500538 500916 504810 508396 510882 513826 519865 522433 522784 523279 526794 527072 527463 527928 530646 532525 534595 539397 546067 546429 546433 547554 550782 557102 559300 563686 577147 578805 584040 584095 586033 586981 587950 588727 589298 589647 591220 591719 591901 591928 591956 598297 602016 602526 604352 610085 611559 612237 613921 618147 621171 623472 623732 624377 627674 635012 636147 649271 664497 665998 667344 680216 689917 697683 699291 709486 716431 717035 718332 718613 720345 720352 723172 727782 730148 730181 734585 736681 738330 740611 744749 746434 748613 748805 750902 763350 767292 768171 768577 768643 768990 771918 771925 773601 775244 775313 776023 779859 780658 781115 783869 784606 785532 787665 791320 791609 792577 792989 793054 795196 795223 796137 796181 797407 802614 811174 812981 813013 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее кончил внутр…"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск кремпа сперм"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск кремпа сперм"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
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.