Query Metrics
7
Database Queries
7
Different statements
188.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.99 ms (85.60%) |
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 96452 365995 401916 425491 428391 428418 434658 443132 443704 443771 443844 444123 444127 444141 446105 453625 454126 454129 454147 459518 462042 462329 462525 466002 466262 469890 469917 470322 470512 470518 470941 474923 475143 475894 476935 477398 479109 481099 484133 484681 484706 485516 486385 491210 491381 491396 497568 497589 500617 500625 501756 505920 506042 508016 510656 511708 511739 512328 517616 521925 523300 523947 543587 543677 544177 548668 548727 548905 549778 552123 557963 559026 559716 565416 565450 567388 570505 574812 575472 587191 590375 596604 598532 601958 618236 620640 622661 637662 641756 649135 649266 654734 656023 658273 673533 676448 678539 678588 679102 679365 708134 709295 711643 716406 721203 721332 721395 723074 723540 723609 738812 740584 758404 766274 789823 791361 793915 797908 802018 805166 ] |
||||||||||||||||||||||||||||||
|
17.21 ms (9.15%) |
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 658273 656023 673533 637662 618236 805166 802018 679102 454129 544177 549778 565450 567388 96452 434658 443132 521925 511708 505920 491210 474923 679365 470941 559716 590375 587191 462329 443844 444127 475143 462042 491381 721203 723074 598532 758404 740584 543677 557963 649266 793915 738812 484706 716406 708134 641756 453625 462525 476935 497568 523300 491396 444123 481099 548668 596604 425491 428391 365995 469917 470322 477398 508016 486385 484133 500625 510656 575472 791361 723609 574812 678588 548727 570505 709295 721395 470518 469890 497589 501756 470512 466262 454147 723540 559026 622661 428418 459518 466002 511739 500617 517616 485516 512328 552123 543587 565416 454126 523947 548905 443771 446105 766274 443704 479109 475894 444141 601958 401916 506042 654734 797908 789823 484681 721332 649135 676448 678539 620640 711643 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.57%) |
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 96452 365995 401916 425491 428391 428418 434658 443132 443704 443771 443844 444123 444127 444141 446105 453625 454126 454129 454147 459518 462042 462329 462525 466002 466262 469890 469917 470322 470512 470518 470941 474923 475143 475894 476935 477398 479109 481099 484133 484681 484706 485516 486385 491210 491381 491396 497568 497589 500617 500625 501756 505920 506042 508016 510656 511708 511739 512328 517616 521925 523300 523947 543587 543677 544177 548668 548727 548905 549778 552123 557963 559026 559716 565416 565450 567388 570505 574812 575472 587191 590375 596604 598532 601958 618236 620640 622661 637662 641756 649135 649266 654734 656023 658273 673533 676448 678539 678588 679102 679365 708134 709295 711643 716406 721203 721332 721395 723074 723540 723609 738812 740584 758404 766274 789823 791361 793915 797908 802018 805166 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð¥ð╗ð¥ð┤ÐïðÁ ð▓ÐéÐÇð¥Ðæð╝ ÐÇÐâÐüÐüð║ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые секс втро русск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.79%) |
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.