Query Metrics
7
Database Queries
7
Different statements
151.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.09 ms (80.69%) |
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 395989 396642 399857 400941 419906 420228 420877 422568 425610 427539 435401 445885 447499 448349 448519 452847 453170 453209 459237 459491 461707 462791 463326 468441 474913 475335 477537 480460 484980 497641 499934 505130 511933 528052 530480 532727 534587 534600 535427 544200 550919 560636 560931 564942 568093 576980 578630 594340 599072 604366 618670 623003 624273 628097 646880 648794 649130 649187 649857 650024 650160 655924 660367 660721 661421 662162 673833 692038 694192 695900 702048 703582 704178 715050 717247 717366 717905 720707 722516 722535 724281 724734 729337 740489 740501 740597 740965 744981 749919 750213 755630 756078 758780 761048 761562 769071 770269 773659 774688 777045 777631 783069 785580 785773 786048 790459 791840 794090 795600 800565 803108 805300 805513 809845 810702 813122 821195 821765 823427 823519 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (10.68%) |
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 740965 715050 722535 774688 791840 803108 805513 810702 395989 425610 459491 435401 462791 480460 422568 497641 400941 419906 459237 484980 530480 532727 576980 399857 448519 447499 505130 396642 420228 427539 420877 821195 821765 823519 823427 445885 468441 448349 474913 452847 453170 453209 461707 511933 528052 534587 499934 534600 535427 463326 475335 477537 544200 550919 560636 578630 646880 648794 649857 650160 655924 660367 660721 662162 692038 702048 720707 649187 661421 673833 694192 695900 717366 649130 650024 703582 704178 717247 717905 722516 560931 564942 568093 618670 599072 623003 628097 594340 624273 604366 777045 785580 790459 794090 795600 800565 813122 777631 785773 786048 809845 724734 750213 756078 758780 761562 773659 783069 805300 729337 740489 744981 755630 761048 769071 724281 740501 740597 749919 770269 ] |
||||||||||||||||||||||||||||||
|
3.92 ms (2.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen asshole"
]
|
||||||||||||||||||||||||||||||
|
2.99 ms (1.98%) |
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 395989 396642 399857 400941 419906 420228 420877 422568 425610 427539 435401 445885 447499 448349 448519 452847 453170 453209 459237 459491 461707 462791 463326 468441 474913 475335 477537 480460 484980 497641 499934 505130 511933 528052 530480 532727 534587 534600 535427 544200 550919 560636 560931 564942 568093 576980 578630 594340 599072 604366 618670 623003 624273 628097 646880 648794 649130 649187 649857 650024 650160 655924 660367 660721 661421 662162 673833 692038 694192 695900 702048 703582 704178 715050 717247 717366 717905 720707 722516 722535 724281 724734 729337 740489 740501 740597 740965 744981 749919 750213 755630 756078 758780 761048 761562 769071 770269 773659 774688 777045 777631 783069 785580 785773 786048 790459 791840 794090 795600 800565 803108 805300 805513 809845 810702 813122 821195 821765 823427 823519 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen asshole"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen asshole"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.23%) |
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.