Query Metrics
7
Database Queries
7
Different statements
156.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.20 ms (83.65%) |
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 80699 191679 229528 506567 524489 531527 532103 533154 539215 540438 540554 542878 543491 546008 547024 547038 548042 548472 549880 557516 563997 565130 567114 570824 576000 578794 588409 596442 607184 614212 614391 618659 618662 622627 634766 638493 642301 644147 650431 650509 651671 665801 670220 682850 696314 696586 710538 713748 714401 714416 718234 721868 722105 723046 725793 726135 732132 737650 738019 744195 744342 744481 748088 748355 752844 753947 754640 758939 759098 759112 759149 759489 768006 768734 769434 770099 778568 778598 780533 782591 784923 790337 794402 794543 795277 799629 800873 801497 801712 802214 802269 802986 803728 805337 805923 806303 806361 806537 812502 813602 814391 816151 817092 817195 817304 817532 817555 817668 817694 820746 823185 824988 825707 825822 826219 826239 826600 826893 826902 828145 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (9.48%) |
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 713748 651671 665801 696314 546008 588409 614212 622627 596442 634766 794402 805923 806303 782591 790337 794543 802269 758939 803728 806537 812502 744481 752844 759098 759112 732132 726135 738019 753947 618662 778568 802986 813602 826600 817092 817195 825822 826902 817532 817668 817694 817304 820746 825707 828145 531527 506567 532103 543491 542878 549880 650509 682850 696586 548042 578794 642301 614391 638493 778598 780533 784923 802214 768006 770099 795277 800873 801712 737650 744195 748088 754640 744342 721868 722105 723046 799629 229528 191679 80699 816151 824988 817555 826219 826893 814391 823185 826239 533154 539215 540438 524489 540554 557516 563997 567114 576000 547038 548472 565130 547024 570824 650431 670220 710538 714416 718234 618659 644147 805337 769434 801497 806361 748355 768734 725793 759149 759489 607184 714401 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.81%) |
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 80699 191679 229528 506567 524489 531527 532103 533154 539215 540438 540554 542878 543491 546008 547024 547038 548042 548472 549880 557516 563997 565130 567114 570824 576000 578794 588409 596442 607184 614212 614391 618659 618662 622627 634766 638493 642301 644147 650431 650509 651671 665801 670220 682850 696314 696586 710538 713748 714401 714416 718234 721868 722105 723046 725793 726135 732132 737650 738019 744195 744342 744481 748088 748355 752844 753947 754640 758939 759098 759112 759149 759489 768006 768734 769434 770099 778568 778598 780533 782591 784923 790337 794402 794543 795277 799629 800873 801497 801712 802214 802269 802986 803728 805337 805923 806303 806361 806537 812502 813602 814391 816151 817092 817195 817304 817532 817555 817668 817694 820746 823185 824988 825707 825822 826219 826239 826600 826893 826902 828145 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy saggy tits"
]
|
||||||||||||||||||||||||||||||
|
2.24 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy saggy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy saggy сиськ"
]
|
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.