Query Metrics
7
Database Queries
7
Different statements
163.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.71 ms (84.14%) |
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 327981 383020 388421 395805 396102 396243 448824 452832 461011 461611 466441 468706 469302 473428 474913 479821 482231 484424 485646 508292 508679 511988 517038 517509 519440 525052 529897 534551 534578 536986 537452 537882 550344 550917 552697 558028 563870 568477 570722 577344 579762 581246 582805 591860 600358 605874 606346 609888 614967 615571 641781 642073 663162 665336 667976 671487 672942 674491 674815 692718 695908 700259 700993 705818 712697 715024 715894 717366 719772 720076 720122 720415 722353 724875 736101 739390 741246 741537 744357 749457 751510 751611 752727 752759 755336 758880 761063 761163 761465 761467 761790 765703 766835 767265 770312 770904 774691 777847 790320 795544 796875 796879 796947 797842 799710 803387 805735 805961 806377 806583 806686 806687 811119 811325 812500 812576 814648 815511 815943 817667 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (9.62%) |
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 563870 671487 615571 641781 805961 812500 805735 796875 803387 765703 815511 770904 744357 517038 484424 581246 568477 579762 695908 712697 692718 600358 591860 796879 761790 796947 383020 327981 817667 815943 525052 508292 466441 667976 715894 674491 700259 719772 550344 550917 799710 739390 741246 806687 761063 749457 755336 795544 388421 570722 700993 761163 395805 552697 396243 396102 814648 452832 474913 479821 485646 448824 468706 473428 482231 517509 534551 536986 537452 537882 511988 519440 529897 534578 508679 461611 558028 577344 582805 674815 663162 665336 717366 720122 672942 705818 715024 720076 720415 642073 605874 606346 614967 609888 774691 777847 790320 811119 811325 806686 812576 751611 797842 752727 766835 724875 752759 758880 736101 741537 751510 767265 761465 761467 770312 722353 806377 806583 469302 461011 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.82%) |
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 327981 383020 388421 395805 396102 396243 448824 452832 461011 461611 466441 468706 469302 473428 474913 479821 482231 484424 485646 508292 508679 511988 517038 517509 519440 525052 529897 534551 534578 536986 537452 537882 550344 550917 552697 558028 563870 568477 570722 577344 579762 581246 582805 591860 600358 605874 606346 609888 614967 615571 641781 642073 663162 665336 667976 671487 672942 674491 674815 692718 695908 700259 700993 705818 712697 715024 715894 717366 719772 720076 720122 720415 722353 724875 736101 739390 741246 741537 744357 749457 751510 751611 752727 752759 755336 758880 761063 761163 761465 761467 761790 765703 766835 767265 770312 770904 774691 777847 790320 795544 796875 796879 796947 797842 799710 803387 805735 805961 806377 806583 806686 806687 811119 811325 812500 812576 814648 815511 815943 817667 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal big toys"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большие toys"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал большие toys"
]
|
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.