Query Metrics
7
Database Queries
7
Different statements
165.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.32 ms (86.64%) |
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 281942 373741 394116 395732 396064 396092 396449 396657 396788 398902 400463 401037 404384 410374 413099 416889 418027 418469 420186 421378 430796 442962 452206 454799 456044 456655 459818 474994 477411 479873 487228 491190 505331 514892 522970 528929 529275 530276 530685 531631 532794 533591 533768 538272 538326 541655 541913 548100 549999 552109 556194 559828 561720 565062 570406 575351 575805 575935 577847 579264 580781 584558 586664 589103 596634 597056 597241 601522 605344 607601 609884 618846 620051 620181 624279 624298 646286 690285 690396 712930 715087 718895 720731 721223 724287 730218 731869 736818 737624 740105 741283 742231 743131 743172 752987 756746 760935 760964 761629 766340 767598 767848 769098 773707 777139 787768 790531 796532 800001 800224 810279 817703 820806 821116 821482 821977 822086 822652 824198 824284 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (7.52%) |
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 479873 624298 767598 396064 398902 413099 416889 454799 821977 820806 824198 822652 824284 532794 538272 575935 575351 690285 718895 580781 624279 810279 790531 752987 766340 742231 395732 396092 396657 418027 456044 549999 565062 577847 712930 561720 570406 597241 620051 800001 396449 442962 477411 396788 401037 505331 452206 487228 491190 373741 430796 514892 529275 530685 474994 559828 584558 586664 589103 609884 605344 743131 731869 400463 421378 522970 528929 281942 817703 822086 821116 821482 530276 531631 533768 533591 538326 548100 541655 552109 715087 720731 646286 690396 721223 556194 596634 597056 620181 787768 796532 743172 760964 761629 800224 737624 767848 769098 730218 773707 736818 756746 760935 740105 777139 394116 404384 410374 418469 456655 459818 541913 575805 579264 601522 724287 741283 607601 618846 420186 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.67%) |
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 281942 373741 394116 395732 396064 396092 396449 396657 396788 398902 400463 401037 404384 410374 413099 416889 418027 418469 420186 421378 430796 442962 452206 454799 456044 456655 459818 474994 477411 479873 487228 491190 505331 514892 522970 528929 529275 530276 530685 531631 532794 533591 533768 538272 538326 541655 541913 548100 549999 552109 556194 559828 561720 565062 570406 575351 575805 575935 577847 579264 580781 584558 586664 589103 596634 597056 597241 601522 605344 607601 609884 618846 620051 620181 624279 624298 646286 690285 690396 712930 715087 718895 720731 721223 724287 730218 731869 736818 737624 740105 741283 742231 743131 743172 752987 756746 760935 760964 761629 766340 767598 767848 769098 773707 777139 787768 790531 796532 800001 800224 810279 817703 820806 821116 821482 821977 822086 822652 824198 824284 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная teen"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sport teen"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спортивная teen"
]
|
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.