Query Metrics
7
Database Queries
7
Different statements
193.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.25 ms (83.35%) |
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 419722 424433 428412 437470 443334 443777 456427 456455 467619 474648 474661 474678 474679 474680 474681 474685 474694 474695 474696 474700 479126 484558 484629 484651 484678 484700 484730 508133 508699 514600 517842 522880 522895 522907 530373 530376 530387 530476 530804 530941 531070 531186 531208 531232 532966 533926 534090 536693 542524 543478 544797 562374 562841 566502 571056 571230 576634 592463 599915 599964 599969 600185 600219 600354 603147 604378 604431 610271 632600 632608 632611 632617 632633 633766 634777 634790 637016 637017 637022 637122 637434 637438 637650 637732 639027 639816 640761 640763 640801 641683 641950 642066 642378 647949 648795 648841 649110 650330 651168 656574 666549 666901 668555 678514 680174 681455 694058 702680 702927 704529 716900 720718 724177 733855 733870 733909 775866 775963 811738 813759 ] |
||||||||||||||||||||||||||||||
|
21.64 ms (11.18%) |
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 522907 531070 484678 649110 592463 641950 775866 811738 724177 632611 813759 571056 571230 543478 651168 656574 680174 694058 647949 668555 720718 640761 604378 604431 637122 637438 600219 637650 639816 640801 632608 632633 633766 637732 775963 437470 678514 599964 474648 542524 484730 530387 522880 576634 733909 733855 474661 474694 474685 517842 484558 522895 456427 530804 531208 531232 533926 530476 544797 704529 419722 428412 467619 474700 474681 474695 508699 484700 514600 681455 642378 562841 702680 666549 702927 632600 600354 603147 637017 639027 640763 637022 530373 532966 599969 634777 508133 456455 443777 733870 479126 484629 484651 536693 531186 530941 530376 600185 716900 443334 424433 474678 474680 474696 534090 566502 562374 634790 474679 648795 648841 666901 650330 599915 632617 610271 642066 637016 637434 641683 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.66%) |
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 419722 424433 428412 437470 443334 443777 456427 456455 467619 474648 474661 474678 474679 474680 474681 474685 474694 474695 474696 474700 479126 484558 484629 484651 484678 484700 484730 508133 508699 514600 517842 522880 522895 522907 530373 530376 530387 530476 530804 530941 531070 531186 531208 531232 532966 533926 534090 536693 542524 543478 544797 562374 562841 566502 571056 571230 576634 592463 599915 599964 599969 600185 600219 600354 603147 604378 604431 610271 632600 632608 632611 632617 632633 633766 634777 634790 637016 637017 637022 637122 637434 637438 637650 637732 639027 639816 640761 640763 640801 641683 641950 642066 642378 647949 648795 648841 649110 650330 651168 656574 666549 666901 668555 678514 680174 681455 694058 702680 702927 704529 716900 720718 724177 733855 733870 733909 775866 775963 811738 813759 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double handjob"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double дрочк член"
]
|
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.