Query Metrics
7
Database Queries
7
Different statements
162.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.49 ms (80.28%) |
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 389700 391386 405074 406322 414075 414372 418399 420192 420760 424876 426368 428397 429793 443529 445737 446529 451866 462372 462379 464179 468035 478973 483319 485100 489424 497870 507880 516842 517743 517844 521829 522871 530026 530053 530499 530501 530796 530805 531144 531202 531534 532343 532655 532703 532751 532789 532954 533013 533363 533837 534149 536310 536752 536783 537584 537659 537773 537894 541207 545305 545427 545537 566855 567144 568589 576529 584006 599861 599890 599976 600171 601613 607814 614858 615716 630297 631196 632657 632678 633111 633795 633799 633819 634138 634778 634790 635224 637093 639759 639790 640813 641678 642043 645236 648839 648868 649546 650198 651607 666528 666853 666902 668526 674966 676623 677303 677783 678063 678089 678495 678504 679032 680118 708441 712374 716887 735107 742926 788115 813082 ] |
||||||||||||||||||||||||||||||
|
19.24 ms (11.84%) |
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 537773 483319 545305 545537 645236 666528 666902 584006 599976 600171 637093 635224 615716 601613 614858 414075 521829 497870 462379 788115 813082 516842 489424 532751 530026 640813 632678 712374 534149 533363 677783 631196 507880 545427 649546 406322 418399 420760 426368 420192 429793 446529 530499 530796 532954 531144 531202 532343 530053 531534 532703 536310 537894 530805 536752 537659 566855 651607 678089 648839 666853 668526 678063 678495 648868 676623 680118 708441 599861 599890 630297 633795 641678 632657 633819 639759 634778 634790 639790 633111 633799 642043 716887 389700 462372 464179 478973 517844 533013 607814 735107 414372 567144 391386 405074 443529 424876 485100 530501 533837 537584 541207 576529 677303 678504 650198 674966 679032 568589 634138 742926 428397 468035 445737 522871 517743 451866 532789 532655 536783 ] |
||||||||||||||||||||||||||||||
|
4.63 ms (2.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc хардкор анал"
]
|
||||||||||||||||||||||||||||||
|
3.47 ms (2.13%) |
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 389700 391386 405074 406322 414075 414372 418399 420192 420760 424876 426368 428397 429793 443529 445737 446529 451866 462372 462379 464179 468035 478973 483319 485100 489424 497870 507880 516842 517743 517844 521829 522871 530026 530053 530499 530501 530796 530805 531144 531202 531534 532343 532655 532703 532751 532789 532954 533013 533363 533837 534149 536310 536752 536783 537584 537659 537773 537894 541207 545305 545427 545537 566855 567144 568589 576529 584006 599861 599890 599976 600171 601613 607814 614858 615716 630297 631196 632657 632678 633111 633795 633799 633819 634138 634778 634790 635224 637093 639759 639790 640813 641678 642043 645236 648839 648868 649546 650198 651607 666528 666853 666902 668526 674966 676623 677303 677783 678063 678089 678495 678504 679032 680118 708441 712374 716887 735107 742926 788115 813082 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc extreme anal"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc хардкор анал"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.