Query Metrics
7
Database Queries
7
Different statements
149.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.65 ms (84.92%) |
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 388850 402649 413649 416015 429369 437509 441191 443299 446119 446587 446984 447440 448991 449666 450529 450913 457341 458183 459433 459805 461665 461677 462564 462685 463943 467047 469513 471722 473379 474590 477185 483149 483380 488822 492528 496980 497846 499512 500375 503772 504517 509976 514721 514800 514973 520963 530700 531565 547957 552588 553399 556045 562992 564162 565623 566873 567125 567143 575693 587277 587609 595845 611616 618852 619516 621347 622778 628073 629042 631875 631988 634305 656841 675455 693316 705766 706607 717728 718350 719311 723950 724480 725033 726293 731488 733681 734467 735592 738783 739834 746328 746739 747633 750816 752908 753295 759854 760188 765957 780932 785897 787047 789011 790739 795452 795866 796544 798994 800798 809773 814093 814234 816186 824049 824614 824693 825600 826191 826339 ] |
||||||||||||||||||||||||||||||
|
13.78 ms (9.24%) |
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 499512 461665 474590 547957 446587 575693 469513 462564 459433 514721 450913 463943 587277 567143 471722 459805 553399 447440 449666 467047 477185 402649 492528 530700 462685 628073 416015 496980 509976 500375 441191 446984 619516 564162 621347 458183 514973 429369 556045 413649 552588 443299 514800 611616 622778 497846 717728 795866 726293 531565 798994 800798 747633 789011 724480 595845 809773 739834 824049 718350 735592 719311 631988 562992 731488 587609 733681 693316 780932 634305 705766 631875 566873 461677 750816 437509 473379 787047 446119 450529 790739 565623 504517 457341 618852 629042 488822 448991 824614 520963 483149 483380 825932 826339 388850 752908 795452 759854 738783 675455 746328 656841 503772 814093 814234 753295 824693 760188 826191 816186 706607 796544 785897 725033 746739 765957 723950 567125 734467 825600 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.48%) |
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 388850 402649 413649 416015 429369 437509 441191 443299 446119 446587 446984 447440 448991 449666 450529 450913 457341 458183 459433 459805 461665 461677 462564 462685 463943 467047 469513 471722 473379 474590 477185 483149 483380 488822 492528 496980 497846 499512 500375 503772 504517 509976 514721 514800 514973 520963 530700 531565 547957 552588 553399 556045 562992 564162 565623 566873 567125 567143 575693 587277 587609 595845 611616 618852 619516 621347 622778 628073 629042 631875 631988 634305 656841 675455 693316 705766 706607 717728 718350 719311 723950 724480 725033 726293 731488 733681 734467 735592 738783 739834 746328 746739 747633 750816 752908 753295 759854 760188 765957 780932 785897 787047 789011 790739 795452 795866 796544 798994 800798 809773 814093 814234 816186 824049 824614 824693 825600 826191 826339 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best but fuck"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best секс"
]
|
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.