Query Metrics
7
Database Queries
7
Different statements
366.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.10 ms (56.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
138.94 ms (37.86%) |
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 282465 384233 401391 403053 422358 453127 454274 456627 470257 470733 470742 493093 533284 543694 545517 545734 548016 551157 556359 563999 564823 565648 567863 577276 577836 580044 592326 593995 594051 594067 596686 598520 603374 605822 611193 620690 627111 628958 631551 631828 637609 637898 641032 641787 644600 644699 648729 652991 660799 677459 677543 678711 683341 685237 687796 690032 690214 691422 701384 702656 702683 707741 708955 713785 715406 716991 721561 726556 729720 730404 730714 730780 732820 733176 735773 736410 738339 741377 742986 743708 744377 744941 750205 750352 757278 759581 763814 778835 780440 780672 783780 785082 788948 793518 795704 796614 797041 797371 800560 801136 802481 809808 809980 810609 817261 817629 818639 819382 823365 823578 825184 825260 825602 825808 826888 826914 827126 827716 827720 ] |
||||||||||||||||||||||||||||||
|
12.08 ms (3.29%) |
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 470733 384233 422358 627111 691422 644699 282465 825602 825184 825808 826888 826914 827720 817629 818639 823578 823365 543694 563999 545734 778835 788948 793518 797041 809980 741377 742986 763814 732820 735773 738339 743708 726556 744941 750205 715406 780440 403053 809808 401391 785082 733176 567863 545517 454274 470257 456627 470742 533284 565648 556359 564823 577836 660799 677459 677543 701384 707741 648729 690214 702656 652991 678711 687796 702683 713785 548016 577276 580044 592326 598520 628958 631828 637898 603374 637609 644600 594051 594067 596686 593995 631551 641032 736410 730714 750352 611193 620690 627511 708955 641787 802481 801136 683341 690032 605822 757278 730780 817261 827126 827716 819382 825260 551157 721561 783780 796614 797371 800560 729720 795704 744377 716991 780672 810609 685237 493093 453127 759581 730404 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (1.01%) |
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 282465 384233 401391 403053 422358 453127 454274 456627 470257 470733 470742 493093 533284 543694 545517 545734 548016 551157 556359 563999 564823 565648 567863 577276 577836 580044 592326 593995 594051 594067 596686 598520 603374 605822 611193 620690 627111 628958 631551 631828 637609 637898 641032 641787 644600 644699 648729 652991 660799 677459 677543 678711 683341 685237 687796 690032 690214 691422 701384 702656 702683 707741 708955 713785 715406 716991 721561 726556 729720 730404 730714 730780 732820 733176 735773 736410 738339 741377 742986 743708 744377 744941 750205 750352 757278 759581 763814 778835 780440 780672 783780 785082 788948 793518 795704 796614 797041 797371 800560 801136 802481 809808 809980 810609 817261 817629 818639 819382 823365 823578 825184 825260 825602 825808 826888 826914 827126 827716 827720 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old homemade"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old домашн любительск"
]
|
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.