Query Metrics
7
Database Queries
7
Different statements
152.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.49 ms (82.38%) |
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 12141 389093 389124 390888 400986 414795 418411 418416 420700 422420 428281 435880 441611 443248 443877 444542 444814 447308 447642 447751 448325 454840 455140 463815 470129 473955 479190 479560 479748 488735 489661 490671 491488 491670 492482 493194 496032 496049 496818 501831 501838 503411 505086 510505 518472 519542 521809 528459 535641 558051 558601 560387 560635 574804 575087 575088 575094 575115 575488 575734 575791 575795 576023 576056 576416 581168 589015 591224 592358 596585 596586 596616 596648 597028 597599 597963 597997 598441 598565 598568 598590 598672 598699 600107 600115 604142 609144 618347 626878 636273 636274 643593 644018 673459 677344 679389 714480 714500 720776 721226 722689 722719 730762 735866 736846 742143 751770 752735 754192 755926 757928 765235 768398 777035 778374 778773 807985 811439 811682 821851 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (11.14%) |
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 626878 811439 754192 751770 755926 422420 560387 598590 479190 489661 496818 505086 528459 496049 596648 644018 598565 389093 479748 501838 503411 518472 596585 400986 443877 443248 574804 592358 447642 447751 501831 492482 598441 596616 596586 673459 720776 722719 677344 598672 643593 778773 811682 730762 765235 735866 768398 752735 777035 778374 414795 821851 535641 560635 575087 575094 575115 575488 575795 576023 576416 558051 575088 575791 576056 581168 722689 679389 714480 721226 575734 598568 598699 597997 600107 600115 597599 604142 636274 589015 636273 807985 742143 757928 714500 390888 479560 418411 473955 448325 491670 491488 521809 488735 490671 493194 609144 558601 597963 496032 618347 454840 418416 463815 444542 519542 510505 470129 591224 736846 447308 12141 435880 420700 455140 428281 444814 441611 389124 597028 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.15%) |
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 12141 389093 389124 390888 400986 414795 418411 418416 420700 422420 428281 435880 441611 443248 443877 444542 444814 447308 447642 447751 448325 454840 455140 463815 470129 473955 479190 479560 479748 488735 489661 490671 491488 491670 492482 493194 496032 496049 496818 501831 501838 503411 505086 510505 518472 519542 521809 528459 535641 558051 558601 560387 560635 574804 575087 575088 575094 575115 575488 575734 575791 575795 576023 576056 576416 581168 589015 591224 592358 596585 596586 596616 596648 597028 597599 597963 597997 598441 598565 598568 598590 598672 598699 600107 600115 604142 609144 618347 626878 636273 636274 643593 644018 673459 677344 679389 714480 714500 720776 721226 722689 722719 730762 735866 736846 742143 751770 752735 754192 755926 757928 765235 768398 777035 778374 778773 807985 811439 811682 821851 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian young teen"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск young teen"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск young 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.