Query Metrics
7
Database Queries
7
Different statements
165.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.19 ms (84.49%) |
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 114153 182206 357457 365056 388672 391674 392064 393148 393188 395373 398099 398626 401451 415311 424332 426043 429278 434293 440898 441098 449305 454467 468024 468059 468131 469246 475755 476711 479249 480024 491273 493696 500947 504887 505101 518634 518643 525679 526445 527207 531062 533276 538530 545599 556530 558749 564120 565425 581236 586374 588650 599864 603423 604387 604865 605742 616978 618580 619367 619802 621946 632708 633756 636414 653554 653555 657781 662483 695885 712512 713189 720103 734868 735776 736094 744982 745964 747432 750933 751006 752785 762714 765224 765484 768517 768670 768929 771887 773283 773302 773496 776963 777782 777882 779272 783907 784409 784704 784931 786662 789042 795012 800516 801236 801715 801724 802439 803676 803960 805146 806933 809751 810461 811507 812310 812385 812538 812690 824867 827895 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (9.70%) |
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 476711 695885 657781 618580 783907 773283 800516 809751 812538 768517 744982 745964 768929 773302 784704 415311 401451 398099 805146 491273 588650 653554 365056 357457 712512 786662 752785 765484 773496 392064 393148 441098 824867 827895 475755 533276 581236 662483 565425 603423 795012 812310 802439 801724 735776 762714 713189 621946 468059 653555 777882 801236 468024 424332 538530 604387 525679 182206 500947 556530 619367 493696 518634 564120 449305 518643 527207 531062 619802 616978 636414 605742 426043 434293 789042 765224 803960 114153 440898 454467 480024 599864 604865 811507 391674 388672 504887 505101 479249 545599 558749 720103 784931 810461 812690 776963 779272 806933 812385 747432 801715 734868 736094 768670 771887 750933 777782 784409 398626 395373 429278 803676 633756 632708 469246 526445 751006 393188 468131 586374 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.49%) |
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 114153 182206 357457 365056 388672 391674 392064 393148 393188 395373 398099 398626 401451 415311 424332 426043 429278 434293 440898 441098 449305 454467 468024 468059 468131 469246 475755 476711 479249 480024 491273 493696 500947 504887 505101 518634 518643 525679 526445 527207 531062 533276 538530 545599 556530 558749 564120 565425 581236 586374 588650 599864 603423 604387 604865 605742 616978 618580 619367 619802 621946 632708 633756 636414 653554 653555 657781 662483 695885 712512 713189 720103 734868 735776 736094 744982 745964 747432 750933 751006 752785 762714 765224 765484 768517 768670 768929 771887 773283 773302 773496 776963 777782 777882 779272 783907 784409 784704 784931 786662 789042 795012 800516 801236 801715 801724 802439 803676 803960 805146 806933 809751 810461 811507 812310 812385 812538 812690 824867 827895 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазмы секс"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оргазм секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.93%) |
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.