Query Metrics
7
Database Queries
7
Different statements
396.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.26 ms (52.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge anal"
]
|
||||||||||||||||||||||||||||||
|
155.94 ms (39.37%) |
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 182118 315244 386798 387026 388722 398114 399083 400638 402626 414071 414122 415877 415879 416032 416583 416621 416624 416653 416681 416683 416696 416715 416722 418112 418989 437863 439052 440913 441095 441120 444531 446695 448791 451774 463855 477761 482773 485546 486784 487418 493696 494493 496337 498294 498319 500338 502465 505386 506105 511721 511857 511893 513963 515488 519481 520786 521831 523355 530480 531103 532729 532837 532838 534636 536253 536621 540032 540990 541860 544831 544964 545379 545426 547468 547474 547488 547847 550288 556871 561015 564237 573204 580174 594491 599834 601789 605026 605483 619286 619659 619802 629808 632121 635993 649520 650326 650333 662448 668688 669018 669038 671052 676111 695870 708465 709128 709693 720289 722392 723618 747468 750121 751424 752706 756192 759344 761432 770405 782804 814443 ] |
||||||||||||||||||||||||||||||
|
20.97 ms (5.29%) |
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 506105 511857 761432 532838 532837 463855 556871 751424 414122 416681 486784 530480 650333 676111 619802 451774 523355 536621 440913 547847 708465 635993 601789 387026 315244 418989 441120 416583 439052 444531 416696 723618 482773 448791 531103 502465 515488 496337 500338 505386 547488 541860 547468 671052 619659 722392 388722 416032 493696 498294 520786 386798 402626 416624 416653 418112 414071 437863 415879 416621 416715 415877 814443 446695 494493 532729 540032 513963 511893 534636 536253 487418 540990 545379 564237 573204 550288 544831 547474 580174 662448 669038 720289 669018 695870 649520 650326 544964 545426 561015 599834 619286 594491 629808 605026 605483 782804 756192 747468 770405 750121 752706 759344 632121 709128 709693 399083 477761 416683 416722 511721 498319 485546 519481 521831 668688 182118 398114 400638 441095 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.77%) |
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 182118 315244 386798 387026 388722 398114 399083 400638 402626 414071 414122 415877 415879 416032 416583 416621 416624 416653 416681 416683 416696 416715 416722 418112 418989 437863 439052 440913 441095 441120 444531 446695 448791 451774 463855 477761 482773 485546 486784 487418 493696 494493 496337 498294 498319 500338 502465 505386 506105 511721 511857 511893 513963 515488 519481 520786 521831 523355 530480 531103 532729 532837 532838 534636 536253 536621 540032 540990 541860 544831 544964 545379 545426 547468 547474 547488 547847 550288 556871 561015 564237 573204 580174 594491 599834 601789 605026 605483 619286 619659 619802 629808 632121 635993 649520 650326 650333 662448 668688 669018 669038 671052 676111 695870 708465 709128 709693 720289 722392 723618 747468 750121 751424 752706 756192 759344 761432 770405 782804 814443 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные анал"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.