Query Metrics
7
Database Queries
7
Different statements
472.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.35 ms (49.56%) |
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 428686 484268 535443 540150 542445 543022 544617 551037 551894 556040 559020 562053 565571 565997 570735 571248 575411 576509 580129 580382 584267 584379 585812 592890 596244 612553 615605 615634 619807 621363 623339 626841 630536 632991 633823 639741 639751 642700 644655 649306 650608 662480 662796 666472 666734 668628 672760 677892 678492 678966 681251 690524 697555 701194 704916 710265 712712 714612 714658 721737 726434 727052 732805 733887 734342 737605 738564 741441 741756 741862 743380 743684 744280 744418 745264 746686 748154 749335 750533 751470 761479 762210 768157 775860 784161 784254 784308 784501 786608 790371 793671 795137 795812 796919 797250 799636 800527 801326 802949 803960 804199 805836 808659 810347 810390 811270 811862 811882 811889 811992 812279 812326 812934 814333 817889 818377 819573 820774 826971 827080 ] |
||||||||||||||||||||||||||||||
|
214.68 ms (45.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
15.52 ms (3.28%) |
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 803960 761479 732805 784501 801326 540150 797250 799636 678492 721737 804199 805836 737605 712712 580129 623339 666472 639751 580382 556040 562053 584267 650608 690524 615634 811882 744418 762210 743684 701194 811862 811889 584379 630536 678966 428686 571248 626841 796919 811270 734342 808659 748154 542445 662480 644655 810390 733887 710265 672760 751470 704916 639741 543022 677892 668628 714612 817889 826971 621363 795137 812934 632991 592890 786608 741756 585812 745264 544617 790371 775860 800527 484268 784161 814333 559020 649306 596244 793671 768157 795812 551037 810347 811992 727052 750533 575411 681251 570735 666734 812326 726434 633823 565997 565571 551894 802949 827080 576509 812279 744280 738564 746686 818377 819573 820774 662796 697555 714658 619807 741862 743380 749335 612553 784254 784308 741441 535443 642700 615605 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.59%) |
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 428686 484268 535443 540150 542445 543022 544617 551037 551894 556040 559020 562053 565571 565997 570735 571248 575411 576509 580129 580382 584267 584379 585812 592890 596244 612553 615605 615634 619807 621363 623339 626841 630536 632991 633823 639741 639751 642700 644655 649306 650608 662480 662796 666472 666734 668628 672760 677892 678492 678966 681251 690524 697555 701194 704916 710265 712712 714612 714658 721737 726434 727052 732805 733887 734342 737605 738564 741441 741756 741862 743380 743684 744280 744418 745264 746686 748154 749335 750533 751470 761479 762210 768157 775860 784161 784254 784308 784501 786608 790371 793671 795137 795812 796919 797250 799636 800527 801326 802949 803960 804199 805836 808659 810347 810390 811270 811862 811882 811889 811992 812279 812326 812934 814333 817889 818377 819573 820774 826971 827080 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss big tits"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.34%) |
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.