Query Metrics
7
Database Queries
7
Different statements
187.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.89 ms (86.66%) |
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 389630 398001 405699 423595 424191 427065 428773 438978 439268 441162 444911 453873 455133 455642 460979 461392 461393 465918 466344 479421 481351 485294 493813 494806 505946 507637 510331 521481 532920 548185 549577 553004 556162 558636 563687 567873 568266 568646 569355 576229 577762 577780 579127 579381 586298 593553 599829 600932 602792 613577 614533 614577 621105 622361 630732 631801 632843 638490 639236 641250 644129 652380 660821 668509 669303 672896 678195 678615 678732 680466 681703 681731 690623 693675 696325 700113 706759 707496 709189 710142 713314 714305 718068 720138 722169 723171 724861 725517 732131 739134 739991 741372 744470 745086 745609 754522 758256 765887 774100 774653 775274 776824 777278 783927 784022 784038 784524 784743 785459 788002 788359 792441 794218 796387 796734 800654 802220 806650 808153 812184 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (8.17%) |
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 678195 681703 713314 700113 690623 630732 600932 641250 774653 788002 796734 776824 785459 794218 812184 725517 806650 739134 741372 745609 774100 758256 621105 718068 722169 723171 788359 800654 808153 507637 532920 556162 681731 710142 672896 586298 593553 441162 481351 510331 485294 444911 577762 579127 553004 563687 706759 707496 622361 631801 632843 644129 599829 613577 614577 639236 638490 784022 784524 796387 724861 784743 792441 744470 745086 732131 754522 765887 739991 602792 709189 720138 775274 777278 783927 784038 455642 389630 461392 479421 465918 466344 405699 493813 453873 455133 494806 579381 567873 696325 714305 577780 802220 614533 398001 461393 439268 428773 423595 427065 438978 460979 424191 521481 505946 548185 549577 558636 569355 568646 668509 678615 660821 678732 693675 652380 669303 680466 568266 576229 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.40%) |
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 389630 398001 405699 423595 424191 427065 428773 438978 439268 441162 444911 453873 455133 455642 460979 461392 461393 465918 466344 479421 481351 485294 493813 494806 505946 507637 510331 521481 532920 548185 549577 553004 556162 558636 563687 567873 568266 568646 569355 576229 577762 577780 579127 579381 586298 593553 599829 600932 602792 613577 614533 614577 621105 622361 630732 631801 632843 638490 639236 641250 644129 652380 660821 668509 669303 672896 678195 678615 678732 680466 681703 681731 690623 693675 696325 700113 706759 707496 709189 710142 713314 714305 718068 720138 722169 723171 724861 725517 732131 739134 739991 741372 744470 745086 745609 754522 758256 765887 774100 774653 775274 776824 777278 783927 784022 784038 784524 784743 785459 788002 788359 792441 794218 796387 796734 800654 802220 806650 808153 812184 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.