Query Metrics
7
Database Queries
7
Different statements
159.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.74 ms (83.41%) |
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 311853 387422 416881 420326 420327 421103 422369 425566 428935 429431 436675 451539 453783 453787 460782 495106 497827 504079 536959 547207 549089 549136 551698 560967 561859 575685 578545 578581 578598 579853 585401 585591 588121 588136 588467 594608 599475 599766 601173 603617 604004 605631 606869 611443 617590 618208 618369 630476 633895 635578 636889 637955 640153 642288 645895 649226 655449 657852 666030 694896 696231 696906 700706 707517 707738 711013 711103 712959 715707 719792 720163 728686 733963 734079 739717 740016 740095 741018 748371 751802 751920 753534 754343 755151 756680 758035 759374 761203 764378 765347 765815 768660 769304 780546 780743 782673 783212 783664 784551 787052 787937 788094 791494 797090 797664 797794 800258 802685 803775 804854 805392 806649 810017 811453 813106 813914 818518 819832 819860 ] |
||||||||||||||||||||||||||||||
|
16.25 ms (10.21%) |
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 588121 588136 601173 605631 637955 585401 618208 603617 642288 611443 617590 618369 780546 780743 782673 788094 797664 791494 797090 804854 733963 739717 740016 741018 755151 768660 769304 787052 787937 797794 811453 734079 753534 728686 754343 756680 759374 764378 740095 748371 758035 606869 700706 711013 711103 778798 783664 802685 810017 311853 387422 420326 421103 453783 460782 451539 547207 551698 575685 578545 560967 594608 640153 630476 636889 800258 806649 783212 751802 751920 765815 696906 453787 549089 715707 428935 813914 561859 588467 761203 765347 436675 425566 429431 416881 420327 422369 818518 819832 819860 497827 504079 495106 536959 578581 549136 645895 649226 657852 666030 694896 707517 707738 720163 696231 719792 655449 712959 578598 579853 599475 599766 635578 604004 585591 633895 805392 813106 784551 803775 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.44%) |
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 311853 387422 416881 420326 420327 421103 422369 425566 428935 429431 436675 451539 453783 453787 460782 495106 497827 504079 536959 547207 549089 549136 551698 560967 561859 575685 578545 578581 578598 579853 585401 585591 588121 588136 588467 594608 599475 599766 601173 603617 604004 605631 606869 611443 617590 618208 618369 630476 633895 635578 636889 637955 640153 642288 645895 649226 655449 657852 666030 694896 696231 696906 700706 707517 707738 711013 711103 712959 715707 719792 720163 728686 733963 734079 739717 740016 740095 741018 748371 751802 751920 753534 754343 755151 756680 758035 759374 761203 764378 765347 765815 768660 769304 780546 780743 782673 783212 783664 784551 787052 787937 788094 791494 797090 797664 797794 800258 802685 803775 804854 805392 806649 810017 811453 813106 813914 818518 819832 819860 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк friend"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl and friend"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк friend"
]
|
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.