Query Metrics
7
Database Queries
7
Different statements
139.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.23 ms (83.77%) |
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 156920 385467 393097 399886 400521 513421 519601 534123 534345 536963 543359 544642 545218 549148 552102 560030 580396 585785 588124 595306 601849 603458 610089 610862 611547 612683 614006 618592 621730 621786 623426 628619 635831 637299 646486 647421 648693 653368 653388 653773 654006 654875 656852 675844 687354 689889 695358 702863 703140 704169 705784 713413 715806 716962 717445 717578 718142 726124 728379 729009 729832 729891 730199 730924 732816 734370 734677 742771 742974 743888 750636 754849 758815 765921 767672 768096 770470 772218 776504 776530 778800 779577 779841 780601 780662 781666 782455 783536 787102 788009 788245 789487 790654 792783 793308 794639 795618 801170 803804 803892 805603 805788 809977 814060 816099 816610 817342 817737 819028 819159 819433 819505 820178 823285 823441 824760 824803 825199 825809 827578 ] |
||||||||||||||||||||||||||||||
|
12.65 ms (9.04%) |
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 743888 729891 754849 767672 772218 729009 778800 819433 817342 825199 819159 534345 534123 519601 549148 552102 560030 646486 648693 653773 703140 675844 687354 717445 580396 610089 612683 614006 611547 618592 585785 588124 628619 779577 783536 788009 793308 801170 779841 782455 789487 803804 809977 732816 742974 787102 795618 805603 805788 734677 758815 770470 726124 730924 765921 623426 776504 776530 780601 780662 781666 792783 399886 156920 824803 825809 817737 536963 513421 543359 545218 653368 653388 695358 705784 704169 715806 647421 654006 654875 656852 689889 716962 610862 637299 595306 603458 621730 621786 601849 794639 729832 730199 734370 750636 788245 728379 742771 768096 702863 713413 717578 718142 803892 393097 544642 635831 790654 385467 400521 820178 823285 824760 816099 816610 819028 827578 819505 814060 823441 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.30%) |
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 156920 385467 393097 399886 400521 513421 519601 534123 534345 536963 543359 544642 545218 549148 552102 560030 580396 585785 588124 595306 601849 603458 610089 610862 611547 612683 614006 618592 621730 621786 623426 628619 635831 637299 646486 647421 648693 653368 653388 653773 654006 654875 656852 675844 687354 689889 695358 702863 703140 704169 705784 713413 715806 716962 717445 717578 718142 726124 728379 729009 729832 729891 730199 730924 732816 734370 734677 742771 742974 743888 750636 754849 758815 765921 767672 768096 770470 772218 776504 776530 778800 779577 779841 780601 780662 781666 782455 783536 787102 788009 788245 789487 790654 792783 793308 794639 795618 801170 803804 803892 805603 805788 809977 814060 816099 816610 817342 817737 819028 819159 819433 819505 820178 823285 823441 824760 824803 825199 825809 827578 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband fuck"
]
|
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.