Query Metrics
7
Database Queries
7
Different statements
153.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.61 ms (83.33%) |
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 426681 428738 436627 443904 450385 461938 464580 464874 480725 481276 488224 494861 500271 500947 502626 509108 509570 511133 517006 518925 523261 528495 529092 529331 531326 542312 544206 549108 549808 562224 567390 571430 574089 581938 583418 583542 586456 588014 590802 591750 593987 594983 596336 599117 604981 605443 609848 613172 613765 614066 615679 618921 619092 621523 624158 626282 626322 626338 627724 634742 636272 639782 641192 641830 652547 656629 660613 662162 666021 673150 675188 680440 692428 695902 701184 702320 708465 712325 717247 720262 720651 726942 727743 727745 736225 737276 737992 740678 740854 748994 749282 751670 755705 756336 756535 757042 759435 759885 759920 761047 765094 768157 770302 771179 777001 777624 780718 784275 785518 786509 786524 789854 791803 792912 796139 805372 808073 809485 809822 813051 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (10.07%) |
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 531326 583542 549108 571430 662162 692428 695902 656629 701184 712325 652547 660613 673150 675188 717247 581938 593987 596336 613765 634742 613172 614066 594983 618921 586456 789854 727743 727745 748994 749282 757042 796139 809822 765094 771179 726942 751670 756535 759435 768157 737276 759885 759920 737992 756336 626282 641192 702320 720651 777001 786524 792912 808073 809485 740678 770302 591750 443904 436627 480725 450385 464874 509108 500271 511133 517006 529331 542312 549808 567390 574089 562224 680440 666021 619092 641830 626322 626338 624158 627724 636272 639782 780718 785518 786509 791803 805372 813051 784275 740854 755705 761047 609848 621523 777624 428738 481276 461938 464580 736225 426681 544206 590802 488224 502626 523261 494861 500947 509570 518925 528495 529092 720262 708465 583418 599117 588014 604981 605443 615679 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.78%) |
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 426681 428738 436627 443904 450385 461938 464580 464874 480725 481276 488224 494861 500271 500947 502626 509108 509570 511133 517006 518925 523261 528495 529092 529331 531326 542312 544206 549108 549808 562224 567390 571430 574089 581938 583418 583542 586456 588014 590802 591750 593987 594983 596336 599117 604981 605443 609848 613172 613765 614066 615679 618921 619092 621523 624158 626282 626322 626338 627724 634742 636272 639782 641192 641830 652547 656629 660613 662162 666021 673150 675188 680440 692428 695902 701184 702320 708465 712325 717247 720262 720651 726942 727743 727745 736225 737276 737992 740678 740854 748994 749282 751670 755705 756336 756535 757042 759435 759885 759920 761047 765094 768157 770302 771179 777001 777624 780718 784275 785518 786509 786524 789854 791803 792912 796139 805372 808073 809485 809822 813051 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"боли"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.