Query Metrics
7
Database Queries
7
Different statements
160.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.95 ms (80.84%) |
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 401916 406381 406933 409861 417212 428397 443779 458555 474718 483547 489328 514580 517844 522871 522911 524986 530495 530912 530935 531155 531182 532676 532812 534215 536310 536582 541419 541634 541635 541690 541738 541886 541923 543849 543918 551919 556046 556054 559577 562832 566782 569922 577368 580290 583701 599844 599865 599867 599890 599899 599913 600029 600271 601046 601600 604517 604569 605553 607261 610271 613146 614308 619483 623380 628336 632595 632599 632617 632646 632693 633111 633123 633753 633758 633786 633799 634138 634218 635215 636300 636306 636309 639334 639790 639818 641678 642018 642066 642385 642660 645936 647932 647960 648795 648817 648820 648839 648868 650155 650774 651607 665776 666586 666853 668526 668549 676623 676632 676634 678063 678128 685701 695122 713564 716887 720298 803455 809508 820762 ] |
||||||||||||||||||||||||||||||
|
19.96 ms (12.42%) |
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 532676 536310 530935 551919 580290 541634 541690 556054 650774 651607 668549 648795 648817 648839 665776 666853 668526 676632 678063 645936 648868 666586 676623 678128 713564 720298 599890 632617 641678 642018 601046 601600 610271 613146 642066 642385 599899 633786 639790 619483 632599 632646 633111 633753 633758 633799 636309 716887 809508 389700 443779 401916 409861 517844 522911 541419 650155 623380 406933 483547 514580 543849 559577 577368 562832 541738 541923 566782 569922 599867 600029 599844 599913 632693 605553 633123 634138 600271 604569 428397 458555 417212 474718 522871 531155 532812 636306 406381 820762 531182 534215 530912 530495 536582 541886 556046 647932 647960 648820 676634 695122 639818 614308 632595 803455 604517 635215 524986 541635 543918 583701 685701 607261 628336 639334 642660 599865 636300 634218 489328 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.03%) |
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 401916 406381 406933 409861 417212 428397 443779 458555 474718 483547 489328 514580 517844 522871 522911 524986 530495 530912 530935 531155 531182 532676 532812 534215 536310 536582 541419 541634 541635 541690 541738 541886 541923 543849 543918 551919 556046 556054 559577 562832 566782 569922 577368 580290 583701 599844 599865 599867 599890 599899 599913 600029 600271 601046 601600 604517 604569 605553 607261 610271 613146 614308 619483 623380 628336 632595 632599 632617 632646 632693 633111 633123 633753 633758 633786 633799 634138 634218 635215 636300 636306 636309 639334 639790 639818 641678 642018 642066 642385 642660 645936 647932 647960 648795 648817 648820 648839 648868 650155 650774 651607 665776 666586 666853 668526 668549 676623 676632 676634 678063 678128 685701 695122 713564 716887 720298 803455 809508 820762 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double anal mom"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double анал mom"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double анал mom"
]
|
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.