Query Metrics
7
Database Queries
7
Different statements
237.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.96 ms (67.25%) |
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 384234 389440 408157 409215 415576 419989 421215 430818 436393 440631 443832 447262 449038 449692 450800 456030 457975 461046 461055 461368 462489 466200 466762 468017 469020 471166 471176 471956 472743 475174 480417 481820 500781 503407 505236 507915 510847 511303 512734 513435 514955 515583 515686 516059 517826 518297 519878 522786 525498 525756 529157 529651 533061 533848 537020 541567 550634 551909 557776 557991 566140 568763 571042 573327 577385 581714 585746 587293 590327 596120 597834 598847 601651 604661 608338 615748 615851 619717 621683 624990 627722 628414 631919 636554 637042 647901 660690 669218 670190 671465 705099 707368 718745 724466 725392 741247 756406 760032 765491 765752 770501 780375 784932 785498 786525 787131 787637 788767 791943 797541 798443 805983 809223 810926 812581 813101 814392 814749 822946 825762 ] |
||||||||||||||||||||||||||||||
|
67.72 ms (28.47%) |
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 805983 809223 756406 724466 760032 765752 813101 447262 450800 421215 825762 525498 513435 671465 557991 596120 608338 590327 786525 436393 443832 462489 466200 384234 822946 471956 471166 533061 461055 550634 577385 660690 624990 798443 785498 788767 475174 408157 449038 409215 466762 449692 481820 518297 503407 515583 514955 505236 517826 541567 566140 705099 707368 669218 568763 597834 787637 791943 810926 461046 510847 500781 581714 457975 557776 571042 619717 636554 480417 529157 511303 537020 814392 601651 415576 507915 533848 637042 627722 765491 615748 797541 814749 461368 522786 647901 615851 631919 812581 787131 469020 472743 529651 456030 519878 468017 573327 551909 670190 718745 587293 598847 621683 628414 784932 780375 770501 525756 604661 585746 741247 512734 515686 516059 725392 389440 471176 419989 440631 430818 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (1.67%) |
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 384234 389440 408157 409215 415576 419989 421215 430818 436393 440631 443832 447262 449038 449692 450800 456030 457975 461046 461055 461368 462489 466200 466762 468017 469020 471166 471176 471956 472743 475174 480417 481820 500781 503407 505236 507915 510847 511303 512734 513435 514955 515583 515686 516059 517826 518297 519878 522786 525498 525756 529157 529651 533061 533848 537020 541567 550634 551909 557776 557991 566140 568763 571042 573327 577385 581714 585746 587293 590327 596120 597834 598847 601651 604661 608338 615748 615851 619717 621683 624990 627722 628414 631919 636554 637042 647901 660690 669218 670190 671465 705099 707368 718745 724466 725392 741247 756406 760032 765491 765752 770501 780375 784932 785498 786525 787131 787637 788767 791943 797541 798443 805983 809223 810926 812581 813101 814392 814749 822946 825762 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom fuck hard"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom секс hard"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.24 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom секс hard"
]
|
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.