Query Metrics
7
Database Queries
7
Different statements
202.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.05 ms (88.03%) |
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 97156 219172 391904 470593 473321 476426 485485 490227 500551 500617 510427 517448 528665 532717 534133 535585 536202 536211 539533 540122 544252 544661 544696 544713 544749 544751 545091 545096 545584 547961 554876 557069 563659 566394 568187 568188 571121 579305 579598 583715 592708 602808 603578 603625 603646 603690 605583 606064 606471 616745 622116 622125 622179 625307 632251 632413 633965 635787 635788 635842 635863 635872 639075 640909 642524 643927 648996 650852 651313 651318 651423 651434 653437 653603 653628 653634 653880 654206 654256 654293 673533 678306 679549 681740 690012 692470 695177 696167 697494 702877 713445 715581 717313 720916 728742 731358 732704 735078 736778 739606 749548 758035 767857 767861 770837 775896 781638 789011 790060 793231 806376 807844 809781 817663 819180 824132 825279 825628 827873 827896 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (7.36%) |
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 642524 605583 606471 635787 536211 544713 583715 728742 500617 535585 606064 690012 490227 568187 736778 571121 476426 544661 616745 625307 500551 651434 713445 635842 545584 470593 824132 557069 715581 545096 568188 825279 622125 654256 579305 545091 809781 807844 673533 654206 819180 528665 735078 653437 602808 695177 678306 632413 790060 391904 635872 579598 563659 539533 603578 219172 517448 485485 717313 739606 793231 806376 732704 758035 635788 681740 473321 510427 817663 825628 544252 770837 749548 767857 767861 731358 789011 97156 775896 544696 697494 603625 640909 603690 643927 702877 536202 653634 650852 651313 653628 653603 639075 622116 633965 544751 544749 781638 827873 827896 532717 540122 534133 566394 554876 648996 651423 679549 692470 651318 653880 654293 696167 592708 622179 632251 603646 635863 720916 547961 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.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 97156 219172 391904 470593 473321 476426 485485 490227 500551 500617 510427 517448 528665 532717 534133 535585 536202 536211 539533 540122 544252 544661 544696 544713 544749 544751 545091 545096 545584 547961 554876 557069 563659 566394 568187 568188 571121 579305 579598 583715 592708 602808 603578 603625 603646 603690 605583 606064 606471 616745 622116 622125 622179 625307 632251 632413 633965 635787 635788 635842 635863 635872 639075 640909 642524 643927 648996 650852 651313 651318 651423 651434 653437 653603 653628 653634 653880 654206 654256 654293 673533 678306 679549 681740 690012 692470 695177 696167 697494 702877 713445 715581 717313 720916 728742 731358 732704 735078 736778 739606 749548 758035 767857 767861 770837 775896 781638 789011 790060 793231 806376 807844 809781 817663 819180 824132 825279 825628 827873 827896 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее мжм любитель…"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск мжм секс втро любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск мжм секс втро любительск"
]
|
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.