Query Metrics
7
Database Queries
7
Different statements
160.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.40 ms (84.38%) |
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 217 8347 106347 149622 165669 184943 185353 185401 239495 270386 282864 322187 382396 382807 383018 383553 383660 384986 386747 387777 389122 389135 390241 390329 393080 401489 401492 402593 402601 406191 406425 408085 411132 413943 451001 460134 464616 465886 489606 506795 508745 510033 510041 525768 549583 551316 551358 551401 558383 560102 560108 580644 583110 584735 593481 599327 600596 600628 607286 608595 610257 615004 622028 623327 623950 626152 628343 632696 636852 643426 644093 647643 651941 653241 663695 665166 666331 676976 677376 687138 688589 694336 700805 705689 708768 715853 723077 724712 726511 727924 735417 741631 742993 748752 753784 757659 768115 771358 771380 771678 772007 772642 774330 776798 785716 797781 797909 799316 799522 799738 800009 804671 807925 814793 825109 825312 826902 827860 828714 ] |
||||||||||||||||||||||||||||||
|
13.89 ms (8.66%) |
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 525768 600628 623327 644093 402601 551401 797909 665166 694336 807925 774330 771380 643426 797781 185353 622028 383553 217 768115 165669 184943 825312 584735 282864 632696 389122 411132 663695 799316 580644 700805 799522 185401 387777 593481 384986 560102 647643 666331 676976 814793 551316 626152 804671 772007 390329 742993 464616 460134 828714 753784 386747 401489 506795 510041 551358 748752 383018 383660 389135 382807 558383 708768 239495 390241 270386 610257 106347 401492 8347 688589 715853 599327 608595 727924 615004 549583 826902 651941 653241 687138 677376 583110 600596 607286 623950 735417 724712 413943 628343 382396 560108 723077 322187 705689 799738 772642 402593 726511 406191 741631 825109 465886 510033 393080 406425 827860 770558 636852 771678 785716 408085 149622 776798 757659 800009 771358 451001 508745 489606 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (2.26%) |
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 217 8347 106347 149622 165669 184943 185353 185401 239495 270386 282864 322187 382396 382807 383018 383553 383660 384986 386747 387777 389122 389135 390241 390329 393080 401489 401492 402593 402601 406191 406425 408085 411132 413943 451001 460134 464616 465886 489606 506795 508745 510033 510041 525768 549583 551316 551358 551401 558383 560102 560108 580644 583110 584735 593481 599327 600596 600628 607286 608595 610257 615004 622028 623327 623950 626152 628343 632696 636852 643426 644093 647643 651941 653241 663695 665166 666331 676976 677376 687138 688589 694336 700805 705689 708768 715853 723077 724712 726511 727924 735417 741631 742993 748752 753784 757659 768115 771358 771380 771678 772007 772642 774330 776798 785716 797781 797909 799316 799522 799738 800009 804671 807925 814793 825109 825312 826902 827860 828714 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits massage"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.