Query Metrics
7
Database Queries
7
Different statements
160.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.63 ms (79.99%) |
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 406381 419370 425490 428397 464179 465605 467632 491446 498611 501487 501499 517844 531155 531182 531202 531420 532343 532645 532674 532751 532913 532995 533372 533773 536310 536538 536582 536712 537114 537203 537670 541634 545537 556046 556054 562796 565154 569922 569929 572022 583700 583701 599862 599865 599867 599890 599899 599913 599955 599976 600029 600171 600206 600271 600995 601046 601613 603241 604517 604569 604902 605398 605461 605553 607261 607707 614308 614858 614993 617427 632595 632599 632646 632659 632693 633111 633753 633799 634138 634218 634543 634774 636306 636308 636985 637036 639790 641678 641690 642032 642385 642660 643103 645861 646841 648235 648839 648853 648868 650188 650774 651607 666586 666853 668526 668549 676623 676632 676634 677303 678053 678063 678529 699397 708441 713564 720298 792555 803455 ] |
||||||||||||||||||||||||||||||
|
20.34 ms (12.65%) |
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 632659 641690 465605 467632 501487 491446 501499 536712 532995 533372 532674 533773 537114 545537 562796 565154 648235 646841 648853 599976 600171 599955 605461 599862 614993 634543 601613 614858 532751 637036 636308 498611 792555 419370 569929 583700 634774 604902 531202 532343 532913 537203 536310 537670 541634 556054 650774 651607 668549 648839 650188 666853 668526 676632 678063 648868 666586 676623 678529 708441 713564 720298 599890 641678 600206 601046 642385 599899 600995 603241 639790 632599 632646 633111 633753 633799 389700 464179 517844 677303 678053 699397 569922 599867 600029 599913 632693 605398 605553 607707 634138 600271 604569 428397 531155 636306 406381 531182 532645 536538 536582 572022 556046 676634 642032 614308 632595 643103 803455 604517 531420 583701 645861 607261 642660 636985 599865 617427 634218 425490 ] |
||||||||||||||||||||||||||||||
|
4.51 ms (2.81%) |
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 406381 419370 425490 428397 464179 465605 467632 491446 498611 501487 501499 517844 531155 531182 531202 531420 532343 532645 532674 532751 532913 532995 533372 533773 536310 536538 536582 536712 537114 537203 537670 541634 545537 556046 556054 562796 565154 569922 569929 572022 583700 583701 599862 599865 599867 599890 599899 599913 599955 599976 600029 600171 600206 600271 600995 601046 601613 603241 604517 604569 604902 605398 605461 605553 607261 607707 614308 614858 614993 617427 632595 632599 632646 632659 632693 633111 633753 633799 634138 634218 634543 634774 636306 636308 636985 637036 639790 641678 641690 642032 642385 642660 643103 645861 646841 648235 648839 648853 648868 650188 650774 651607 666586 666853 668526 668549 676623 676632 676634 677303 678053 678063 678529 699397 708441 713564 720298 792555 803455 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial anal mom"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов анал mom"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"межрасов анал 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.