Query Metrics
7
Database Queries
7
Different statements
216.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.01 ms (89.90%) |
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 73503 418438 425475 529594 529610 531876 534654 550596 559171 583594 622853 625231 627126 637798 717103 718117 723196 724806 724829 725333 726308 734453 735559 735789 735795 738543 740040 740082 740666 742951 743967 744713 744762 746391 747273 748107 749145 750358 750574 750671 750856 751004 751287 751972 752221 753778 754432 754497 755866 757186 757301 757686 758128 758604 759872 760092 762253 763524 764716 765823 767908 768699 768882 769046 769073 770098 770729 771873 773809 774919 775187 775512 777873 778012 778600 779035 779123 779132 779142 780452 781125 781184 782345 782858 784290 784426 785735 786700 787167 788962 789282 789380 789825 792260 792728 793484 794623 794889 794912 795855 796792 796937 797342 797357 801437 803551 805106 808479 816659 823605 823650 825335 825412 825916 826613 827141 827167 827241 827490 828847 ] |
||||||||||||||||||||||||||||||
|
11.94 ms (5.50%) |
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 622853 637798 425475 73503 418438 825916 826613 825335 816659 823650 827141 827167 827241 823605 825412 828847 827490 529594 531876 529610 534654 550596 559171 583594 718117 775512 778600 779132 779142 787167 788962 789380 792260 793484 794623 794912 795855 796937 797342 803551 774919 775187 778012 779123 780452 781125 781184 782345 782858 784426 785735 794889 801437 805106 725333 740040 749145 750358 750574 750671 751004 752221 754432 755866 757186 757301 764716 769073 784290 786700 789825 792728 808479 734453 742951 743967 744762 746391 750856 758128 759872 762253 765823 769046 724829 726308 735789 735795 747273 751972 753778 757686 758604 767908 735559 738543 751287 760092 763524 768699 768882 770098 771873 724806 740082 740666 744713 748107 754497 770729 773809 625231 627126 717103 723196 777873 779035 789282 796792 797357 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.31%) |
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 73503 418438 425475 529594 529610 531876 534654 550596 559171 583594 622853 625231 627126 637798 717103 718117 723196 724806 724829 725333 726308 734453 735559 735789 735795 738543 740040 740082 740666 742951 743967 744713 744762 746391 747273 748107 749145 750358 750574 750671 750856 751004 751287 751972 752221 753778 754432 754497 755866 757186 757301 757686 758128 758604 759872 760092 762253 763524 764716 765823 767908 768699 768882 769046 769073 770098 770729 771873 773809 774919 775187 775512 777873 778012 778600 779035 779123 779132 779142 780452 781125 781184 782345 782858 784290 784426 785735 786700 787167 788962 789282 789380 789825 792260 792728 793484 794623 794889 794912 795855 796792 796937 797342 797357 801437 803551 805106 808479 816659 823605 823650 825335 825412 825916 826613 827141 827167 827241 827490 828847 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск hot"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hot"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск hot"
]
|
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.