Query Metrics
7
Database Queries
7
Different statements
516.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
280.39 ms (54.31%) |
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 155232 272725 398099 401961 409035 415745 415749 419824 421827 434327 435689 437733 440641 441160 444535 445945 448079 452960 458766 465680 467885 467939 475319 476051 497778 499924 513450 513630 514339 518614 523358 523640 535359 535367 545042 545434 554550 554680 554989 584039 586975 587214 589390 589701 594340 597482 598310 598406 599795 600936 601143 602249 604118 604265 604660 604927 605379 606127 606254 606503 607142 624197 628107 628113 633119 638688 638737 638829 639969 640859 652971 707408 708626 710357 719461 722388 726946 728567 734823 736020 739089 744773 745542 748504 750881 752641 752697 752944 753124 756045 758785 758786 758790 759362 760862 761608 766124 772548 776035 776840 787525 788802 790154 796672 796675 796696 796715 801639 806794 806947 807835 809626 811048 811696 812542 812779 813597 819689 824531 824837 ] |
||||||||||||||||||||||||||||||
|
210.46 ms (40.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд соло milf"
]
|
||||||||||||||||||||||||||||||
|
14.76 ms (2.86%) |
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 719461 545434 554989 584039 605379 606254 606503 586975 589701 604265 607142 624197 589390 594340 597482 598310 600936 604660 628113 639969 587214 638688 638737 796696 796715 801639 806794 807835 811048 811696 812542 790154 806947 752641 752697 753124 809626 812779 728567 748504 758785 726946 745542 758786 758790 760862 761608 766124 739089 750881 633119 640859 707408 710357 722388 776035 796675 155232 440641 441160 465680 467885 476051 437733 475319 434327 452960 458766 497778 514339 513630 523640 628107 421827 409035 518614 401961 824531 824837 448079 513450 554550 554680 601143 599795 604118 787525 272725 398099 813597 788802 734823 756045 736020 819689 535359 535367 545042 708626 652971 604927 606127 638829 796672 772548 744773 759362 415745 776840 752944 499924 419824 467939 523358 602249 598406 444535 415749 435689 445945 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo solo milf"
]
|
||||||||||||||||||||||||||||||
|
2.85 ms (0.55%) |
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 155232 272725 398099 401961 409035 415745 415749 419824 421827 434327 435689 437733 440641 441160 444535 445945 448079 452960 458766 465680 467885 467939 475319 476051 497778 499924 513450 513630 514339 518614 523358 523640 535359 535367 545042 545434 554550 554680 554989 584039 586975 587214 589390 589701 594340 597482 598310 598406 599795 600936 601143 602249 604118 604265 604660 604927 605379 606127 606254 606503 607142 624197 628107 628113 633119 638688 638737 638829 639969 640859 652971 707408 708626 710357 719461 722388 726946 728567 734823 736020 739089 744773 745542 748504 750881 752641 752697 752944 753124 756045 758785 758786 758790 759362 760862 761608 766124 772548 776035 776840 787525 788802 790154 796672 796675 796696 796715 801639 806794 806947 807835 809626 811048 811696 812542 812779 813597 819689 824531 824837 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд соло milf"
]
|
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.