Query Metrics
7
Database Queries
7
Different statements
183.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.94 ms (84.44%) |
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 411471 417110 418942 422275 422365 427647 428082 430400 444843 448427 449349 449424 449843 452962 453025 453798 453993 457323 457551 457557 457903 457921 457934 458017 458313 459084 462214 462613 463464 468058 479817 481539 482113 487051 497037 503001 504103 506246 507005 507212 509219 509325 511472 511505 511779 512739 513382 514447 517409 517980 522560 524818 524826 525328 526356 528687 534722 542540 544958 556677 556888 557102 559085 562482 562954 562966 563300 563785 563811 564429 571511 573760 574958 578798 580935 581953 591358 592778 595182 596329 600982 601185 604053 606935 610037 616094 619909 622503 623928 626324 627326 629954 632198 644056 652007 673415 694938 707436 709431 714868 725012 735685 737274 748001 756245 757110 758224 764005 771789 776209 790667 796124 797462 799336 803580 807842 811123 813246 823736 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (9.16%) |
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 764005 825734 428082 444843 487051 453993 452962 534722 517409 562954 563811 562482 563300 694938 707436 673415 714868 563785 610037 591358 595182 596329 604053 623928 626324 627326 796124 790667 799336 807842 725012 748001 756245 737274 619909 422365 457557 462613 479817 514447 528687 525328 509219 811123 556888 559085 457903 644056 430400 448427 449843 458313 462214 457323 457551 457921 504103 511779 524818 497037 542540 581953 556677 652007 709431 592778 629954 600982 622503 601185 776209 757110 803580 813246 735685 771789 758224 632198 453025 417110 453798 481539 411471 524826 509325 503001 506246 511505 823736 449424 457934 512739 564429 616094 427647 418942 422275 449349 463464 468058 507212 526356 507005 482113 544958 571511 580935 557102 574958 562966 573760 578798 606935 797462 458017 459084 511472 517980 522560 513382 ] |
||||||||||||||||||||||||||||||
|
4.30 ms (2.34%) |
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 411471 417110 418942 422275 422365 427647 428082 430400 444843 448427 449349 449424 449843 452962 453025 453798 453993 457323 457551 457557 457903 457921 457934 458017 458313 459084 462214 462613 463464 468058 479817 481539 482113 487051 497037 503001 504103 506246 507005 507212 509219 509325 511472 511505 511779 512739 513382 514447 517409 517980 522560 524818 524826 525328 526356 528687 534722 542540 544958 556677 556888 557102 559085 562482 562954 562966 563300 563785 563811 564429 571511 573760 574958 578798 580935 581953 591358 592778 595182 596329 600982 601185 604053 606935 610037 616094 619909 622503 623928 626324 627326 629954 632198 644056 652007 673415 694938 707436 709431 714868 725012 735685 737274 748001 756245 757110 758224 764005 771789 776209 790667 796124 797462 799336 803580 807842 811123 813246 823736 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"inside of pussy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"inside pussy"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"inside pussy"
]
|
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.