Query Metrics
7
Database Queries
7
Different statements
146.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.22 ms (83.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 48547 69589 85949 150261 381983 387648 393600 397106 398753 399021 400518 404084 414765 443143 469292 480220 482418 508231 511462 512384 514670 522565 524729 536993 537637 555533 571744 579853 582864 583314 585401 585769 591516 598131 601173 602730 606926 614706 616585 622179 625122 627268 627768 628776 629816 635830 639929 640727 642562 650881 651348 651420 654217 662920 666019 666686 679549 683484 690703 695773 695805 697471 702380 702993 705224 710419 713413 715787 718592 718872 719648 722442 725094 726019 729587 730928 731131 732592 734270 734700 736338 738377 741268 744080 749076 749639 752019 754173 757760 760874 761504 762507 762819 764668 765424 767819 768660 768876 770592 771730 773116 778184 780376 783964 784009 784680 787286 788592 789282 793412 796289 798235 798675 799723 801325 801768 802475 804060 809362 813744 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (8.93%) |
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 757760 789282 69589 48547 469292 522565 585769 629816 591516 650881 651348 713413 798675 582864 683484 662920 715787 583314 787286 804060 783964 788592 760874 780376 666019 754173 695773 784009 397106 404084 511462 537637 666686 702993 705224 718872 718592 602730 598131 627268 628776 802475 741268 752019 765424 773116 726019 729587 738377 749076 734270 762819 771730 625122 710419 400518 414765 398753 85949 387648 770592 798235 801325 809362 651420 761504 730928 555533 399021 150261 749639 514670 536993 690703 702380 614706 736338 734700 719648 778184 784680 679549 622179 744080 512384 443143 482418 722442 642562 627768 725094 801768 393600 654217 601173 616585 585401 767819 768660 768876 697471 799723 732592 695805 764668 635830 381983 813744 480220 508231 639929 793412 731131 796289 762507 606926 524729 640727 571744 579853 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.96%) |
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 48547 69589 85949 150261 381983 387648 393600 397106 398753 399021 400518 404084 414765 443143 469292 480220 482418 508231 511462 512384 514670 522565 524729 536993 537637 555533 571744 579853 582864 583314 585401 585769 591516 598131 601173 602730 606926 614706 616585 622179 625122 627268 627768 628776 629816 635830 639929 640727 642562 650881 651348 651420 654217 662920 666019 666686 679549 683484 690703 695773 695805 697471 702380 702993 705224 710419 713413 715787 718592 718872 719648 722442 725094 726019 729587 730928 731131 732592 734270 734700 736338 738377 741268 744080 749076 749639 752019 754173 757760 760874 761504 762507 762819 764668 765424 767819 768660 768876 770592 771730 773116 778184 780376 783964 784009 784680 787286 788592 789282 793412 796289 798235 798675 799723 801325 801768 802475 804060 809362 813744 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"друг жен секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"друга жену трахнул"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.14%) |
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.