Query Metrics
7
Database Queries
7
Different statements
143.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.24 ms (86.39%) |
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 381887 418564 418575 427486 435146 438714 444641 444674 449690 453200 453846 453865 454193 454533 454537 456627 456672 456744 459267 470805 472008 473304 475814 476599 477927 478614 479393 479415 482929 485069 485404 485594 494677 501923 504212 506021 506397 506744 511186 513171 513451 515668 516743 521330 527773 533208 541000 542776 543561 545226 546561 548752 553135 553144 554372 558658 563036 566488 568040 601445 609686 614047 630704 661501 667246 670825 690946 703281 714421 718897 721962 724058 726172 726899 728511 729272 730827 730971 732942 733060 733458 734171 735333 736889 740102 740520 743884 743911 744762 750515 758128 759138 759552 766289 766527 767973 775147 775609 779908 788678 788977 789470 794666 795175 795378 796043 799748 800998 802901 803999 805111 812121 814730 818891 823365 824260 824593 826990 827096 827241 ] |
||||||||||||||||||||||||||||||
|
10.81 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 714421 788678 796043 802901 812121 728511 750515 726899 759552 456627 477927 418564 435146 454533 456744 475814 453200 456672 459267 470805 511186 513171 558658 548752 554372 563036 566488 427486 438714 453846 454193 444674 453865 479415 418575 449690 454537 473304 476599 479393 472008 516743 506397 515668 482929 485404 506744 521330 527773 533208 568040 542776 553144 541000 543561 546561 670825 545226 803999 767973 690946 661501 494677 506021 614047 501923 485594 805111 759138 733458 513451 504212 736889 703281 630704 381887 444641 818891 824260 826990 827096 827241 814730 823365 824593 478614 485069 718897 721962 667246 553135 609686 601445 775147 775609 779908 789470 799748 795175 795378 800998 729272 730827 740520 743884 743911 766289 766527 788977 794666 724058 726172 730971 732942 733060 734171 735333 740102 744762 758128 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.55%) |
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 381887 418564 418575 427486 435146 438714 444641 444674 449690 453200 453846 453865 454193 454533 454537 456627 456672 456744 459267 470805 472008 473304 475814 476599 477927 478614 479393 479415 482929 485069 485404 485594 494677 501923 504212 506021 506397 506744 511186 513171 513451 515668 516743 521330 527773 533208 541000 542776 543561 545226 546561 548752 553135 553144 554372 558658 563036 566488 568040 601445 609686 614047 630704 661501 667246 670825 690946 703281 714421 718897 721962 724058 726172 726899 728511 729272 730827 730971 732942 733060 733458 734171 735333 736889 740102 740520 743884 743911 744762 750515 758128 759138 759552 766289 766527 767973 775147 775609 779908 788678 788977 789470 794666 795175 795378 796043 799748 800998 802901 803999 805111 812121 814730 818891 823365 824260 824593 826990 827096 827241 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скрытое домашнее порн…"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт домашн любительск порн"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.06%) |
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.