Query Metrics
7
Database Queries
7
Different statements
168.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.45 ms (86.14%) |
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 203504 386103 389458 417438 420652 423808 423962 431528 444168 452472 453082 472942 477493 485078 528608 531915 540776 543211 544771 550127 552601 553692 559886 569777 569781 570683 570854 577751 584437 592403 592579 610614 623411 626255 641292 644643 648901 665826 666499 667686 672759 689078 694556 695614 696137 717906 723911 723919 724842 729881 730633 733448 736141 736644 740828 742677 742694 747940 748432 748445 752512 752989 753425 753506 756463 756733 761839 761951 764019 766299 768982 770882 770912 771398 772219 772642 775183 775261 776013 776546 777181 777451 778197 778840 779083 780215 785345 786243 786562 789412 789582 790933 791692 792451 794273 795317 796723 796755 797512 799674 799998 800621 802517 802691 802706 803344 805019 805585 805675 807019 807037 807277 809749 810075 810079 811934 813603 817556 817592 827414 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (8.13%) |
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 791692 802517 802691 803344 807277 730633 736141 770912 786243 790933 797512 805585 809749 753425 756733 772219 723911 723919 742677 748432 752989 764019 729881 740828 770882 771398 742694 756463 623411 626255 644643 717906 775183 775261 780215 794273 805675 423808 423962 453082 420652 796723 795317 389458 444168 452472 203504 817556 540776 813603 817592 827414 485078 531915 550127 543211 553692 569777 577751 584437 552601 696137 672759 689078 695614 665826 667686 694556 569781 570683 592579 610614 641292 776013 785345 792451 802706 807019 811934 778197 778840 779083 789582 796755 805019 753506 799674 800621 810079 736644 747940 761951 768982 766299 752512 724842 733448 748445 761839 772642 776546 777181 777451 789412 799998 810075 431528 559886 592403 570854 666499 472942 544771 648901 807037 786562 477493 386103 417438 528608 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.51%) |
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 203504 386103 389458 417438 420652 423808 423962 431528 444168 452472 453082 472942 477493 485078 528608 531915 540776 543211 544771 550127 552601 553692 559886 569777 569781 570683 570854 577751 584437 592403 592579 610614 623411 626255 641292 644643 648901 665826 666499 667686 672759 689078 694556 695614 696137 717906 723911 723919 724842 729881 730633 733448 736141 736644 740828 742677 742694 747940 748432 748445 752512 752989 753425 753506 756463 756733 761839 761951 764019 766299 768982 770882 770912 771398 772219 772642 775183 775261 776013 776546 777181 777451 778197 778840 779083 780215 785345 786243 786562 789412 789582 790933 791692 792451 794273 795317 796723 796755 797512 799674 799998 800621 802517 802691 802706 803344 805019 805585 805675 807019 807037 807277 809749 810075 810079 811934 813603 817556 817592 827414 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел дрочк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"чулки дрочка"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.94%) |
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.