Query Metrics
7
Database Queries
7
Different statements
194.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.81 ms (83.50%) |
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 387742 416632 418440 420849 420877 421189 427539 428695 435401 443198 445470 446063 448519 451372 451907 453583 461707 462791 464811 465269 465468 465548 471532 474913 485031 487359 487414 488454 492750 498260 498305 498666 500240 500965 502779 503836 508072 508885 516434 518147 519772 521219 526608 526766 528052 533540 534587 540945 541274 550919 552566 555387 555873 556206 566863 570716 571086 584228 585356 591736 592712 593768 595573 601333 604286 604366 613004 628097 628553 655275 660367 662165 687083 692038 692767 695900 696598 704178 704184 704186 712633 712877 717366 717873 722516 722934 725622 726596 726858 728771 729167 729287 732067 740489 743611 744653 748981 749694 751727 752636 752940 756693 758790 761018 761048 765465 769071 775239 790459 793013 796204 796297 798775 799949 800604 800766 803108 804568 805300 813122 ] |
||||||||||||||||||||||||||||||
|
21.24 ms (10.89%) |
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 687083 585356 793013 796204 800766 749694 744653 796297 435401 498260 418440 492750 704186 712877 592712 761018 508885 570716 453583 748981 500965 695900 722516 448519 474913 717366 740489 726858 550919 591736 765465 798775 445470 421189 503836 516434 471532 533540 540945 662165 704184 595573 804568 799949 743611 728771 732067 726596 803108 462791 427539 604366 813122 752940 805300 729287 502779 420849 420877 534587 556206 692038 761048 769071 461707 528052 660367 704178 613004 628097 790459 756693 758790 751727 519772 526766 717873 800604 712633 729167 464811 451372 485031 541274 555387 692767 593768 752636 387742 443198 498305 498666 521219 500240 508072 722934 566863 775239 428695 487359 488454 465269 571086 655275 526608 416632 451907 487414 465468 552566 628553 725622 696598 555873 601333 584228 604286 518147 446063 465548 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.37%) |
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 387742 416632 418440 420849 420877 421189 427539 428695 435401 443198 445470 446063 448519 451372 451907 453583 461707 462791 464811 465269 465468 465548 471532 474913 485031 487359 487414 488454 492750 498260 498305 498666 500240 500965 502779 503836 508072 508885 516434 518147 519772 521219 526608 526766 528052 533540 534587 540945 541274 550919 552566 555387 555873 556206 566863 570716 571086 584228 585356 591736 592712 593768 595573 601333 604286 604366 613004 628097 628553 655275 660367 662165 687083 692038 692767 695900 696598 704178 704184 704186 712633 712877 717366 717873 722516 722934 725622 726596 726858 728771 729167 729287 732067 740489 743611 744653 748981 749694 751727 752636 752940 756693 758790 761018 761048 765465 769071 775239 790459 793013 796204 796297 798775 799949 800604 800766 803108 804568 805300 813122 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck my asshole"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс my asshole"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс my asshole"
]
|
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.