Query Metrics
7
Database Queries
7
Different statements
172.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.46 ms (85.63%) |
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 393980 478283 479224 497410 525602 534104 543359 544131 545218 566463 571110 595306 601849 606667 606853 607035 609566 610862 612888 613678 613953 620486 621730 621786 623993 632500 635822 635850 637299 640231 647421 650967 653368 653388 654006 654875 656813 657247 669983 675885 681509 686450 689889 689930 695358 695839 697581 697933 702863 703282 704169 704622 705727 705784 707938 708742 710328 713413 716962 717578 720019 720027 724159 725614 728379 731333 733278 733491 745506 750158 751967 761407 765041 766395 768096 768608 771806 780058 782310 784628 786272 787213 788378 789792 792673 793157 793234 793302 794452 794516 795805 795955 796586 797123 799829 800182 800892 802934 809968 816095 817487 817737 819166 819277 819358 819712 819747 820114 820156 823353 823645 824235 824489 824803 824849 825809 825947 826618 827258 827372 ] |
||||||||||||||||||||||||||||||
|
13.36 ms (7.76%) |
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 610862 751967 612888 393980 819747 816095 820114 823645 819712 823353 824235 824849 817487 819358 825947 478283 720019 780058 786272 788378 794516 795955 800892 789792 793157 793234 794452 795805 800182 724159 731333 784628 787213 792673 793302 796586 802934 765041 766395 733491 771806 761407 720027 782310 534104 544131 543359 545218 650967 653368 653388 657247 675885 695358 695839 705784 708742 689930 704169 647421 654006 654875 669983 681509 686450 689889 704622 707938 710328 716962 571110 606667 607035 613678 613953 637299 595306 606853 621730 621786 635822 640231 609566 623993 799829 809968 745506 725614 728379 768608 733278 750158 620486 632500 635850 697581 697933 702863 703282 713413 566463 601849 768096 717578 797123 819277 824803 826618 825809 827258 827372 817737 819166 824489 820156 479224 497410 525602 656813 705727 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.23%) |
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 393980 478283 479224 497410 525602 534104 543359 544131 545218 566463 571110 595306 601849 606667 606853 607035 609566 610862 612888 613678 613953 620486 621730 621786 623993 632500 635822 635850 637299 640231 647421 650967 653368 653388 654006 654875 656813 657247 669983 675885 681509 686450 689889 689930 695358 695839 697581 697933 702863 703282 704169 704622 705727 705784 707938 708742 710328 713413 716962 717578 720019 720027 724159 725614 728379 731333 733278 733491 745506 750158 751967 761407 765041 766395 768096 768608 771806 780058 782310 784628 786272 787213 788378 789792 792673 793157 793234 793302 794452 794516 795805 795955 796586 797123 799829 800182 800892 802934 809968 816095 817487 817737 819166 819277 819358 819712 819747 820114 820156 823353 823645 824235 824489 824803 824849 825809 825947 826618 827258 827372 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск husband"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск husband"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur husband"
]
|
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.