Query Metrics
7
Database Queries
7
Different statements
174.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.41 ms (82.82%) |
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 366354 387258 390180 396450 403519 404451 413175 414845 418073 418079 418270 418939 418948 420231 422735 427897 428104 428334 430748 437463 443573 445499 446173 450814 452079 452206 458001 458106 458341 460071 462436 472151 472831 475262 476340 476578 477338 482780 483251 488936 493197 494720 497428 502284 503683 506762 509373 510463 512781 513005 513331 514130 523316 530729 532484 538276 538653 539786 542224 543920 544834 549270 554315 554927 557851 563858 564342 564719 565152 565700 568546 575762 576698 576721 586398 590501 596973 598177 600258 603134 606838 608620 610666 615636 624802 624803 630612 633937 637694 639334 642665 662143 671208 674414 681189 713565 720245 726512 726537 726546 726587 746774 759724 761208 770402 771649 789525 789692 792606 792652 796105 810765 810978 814743 814891 815883 815885 815960 820767 823303 ] |
||||||||||||||||||||||||||||||
|
18.87 ms (10.82%) |
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 624803 796105 761208 770402 726546 771649 610666 637694 789692 810978 414845 428104 396450 403519 418270 418948 445499 390180 418073 420231 458106 502284 494720 523316 639334 446173 510463 366354 387258 404451 413175 418939 437463 428334 418079 823303 815960 820767 477338 483251 458341 472151 476340 452206 482780 488936 506762 538653 512781 513005 497428 503683 532484 460071 542224 575762 564342 565152 568546 713565 662143 681189 549270 557851 624802 590501 603134 615636 633937 789525 792606 726512 726537 746774 726587 759724 606838 608620 792652 450814 430748 509373 514130 422735 427897 443573 814743 814891 815885 815883 452079 458001 472831 462436 475262 476578 493197 530729 539786 538276 513331 565700 576698 576721 543920 554315 554927 563858 564719 671208 720245 674414 544834 600258 642665 586398 596973 598177 630612 810765 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.88%) |
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 366354 387258 390180 396450 403519 404451 413175 414845 418073 418079 418270 418939 418948 420231 422735 427897 428104 428334 430748 437463 443573 445499 446173 450814 452079 452206 458001 458106 458341 460071 462436 472151 472831 475262 476340 476578 477338 482780 483251 488936 493197 494720 497428 502284 503683 506762 509373 510463 512781 513005 513331 514130 523316 530729 532484 538276 538653 539786 542224 543920 544834 549270 554315 554927 557851 563858 564342 564719 565152 565700 568546 575762 576698 576721 586398 590501 596973 598177 600258 603134 606838 608620 610666 615636 624802 624803 630612 633937 637694 639334 642665 662143 671208 674414 681189 713565 720245 726512 726537 726546 726587 746774 759724 761208 770402 771649 789525 789692 792606 792652 796105 810765 810978 814743 814891 815883 815885 815960 820767 823303 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"housewife interracial"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"housewife межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"housewife межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.98%) |
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.