Query Metrics
7
Database Queries
7
Different statements
198.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.41 ms (89.96%) |
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 400406 403938 413171 461841 462528 468327 471590 478354 531055 531674 533233 533294 535471 538599 539092 539096 539873 542905 543951 544712 544781 545289 546508 547377 548478 553309 556197 556446 556801 562752 568296 571099 571187 576592 585858 590486 593215 595464 597505 601598 602648 602833 604947 605799 609742 610856 612961 613140 614438 615906 615994 616102 616246 619490 622969 627157 628048 628767 631181 631371 635067 637184 640551 641125 644367 651278 662125 668297 687786 687830 696147 702873 704272 704626 706863 711725 716035 718853 719592 720088 723625 736972 749995 754568 764961 773296 775248 775677 779274 779846 788088 790186 795785 799804 799901 802551 813327 813498 813600 817987 819892 819893 820062 820360 821755 823650 824397 824929 825132 825445 825602 825799 826103 826154 827221 827241 827510 827649 827851 ] |
||||||||||||||||||||||||||||||
|
10.05 ms (5.07%) |
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 687830 702873 544712 544781 556446 571099 590486 615906 616246 640551 602648 604947 609742 613140 615994 622969 637184 644367 610856 627157 628767 631371 641125 593215 595464 597505 601598 602833 612961 616102 779274 813498 749995 614438 619490 628048 631181 704272 827851 539096 662125 706863 478354 542905 802551 825132 533233 538599 539092 531674 546508 547377 556801 651278 576592 635067 585858 795785 799901 754568 788088 400406 468327 720088 605799 462528 471590 775248 779846 764961 799804 813327 773296 736972 775677 790186 413171 403938 819892 819893 820360 821755 824929 813600 723625 825602 823650 825799 826154 827221 827241 820062 825445 817987 824397 825195 827649 826103 827510 461841 531055 539873 535471 533294 543951 548478 571187 553309 556197 545289 568296 668297 696147 718853 719592 687786 704626 711725 716035 562752 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.46%) |
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 400406 403938 413171 461841 462528 468327 471590 478354 531055 531674 533233 533294 535471 538599 539092 539096 539873 542905 543951 544712 544781 545289 546508 547377 548478 553309 556197 556446 556801 562752 568296 571099 571187 576592 585858 590486 593215 595464 597505 601598 602648 602833 604947 605799 609742 610856 612961 613140 614438 615906 615994 616102 616246 619490 622969 627157 628048 628767 631181 631371 635067 637184 640551 641125 644367 651278 662125 668297 687786 687830 696147 702873 704272 704626 706863 711725 716035 718853 719592 720088 723625 736972 749995 754568 764961 773296 775248 775677 779274 779846 788088 790186 795785 799804 799901 802551 813327 813498 813600 817987 819892 819893 820062 820360 821755 823650 824397 824929 825132 825445 825602 825799 826103 826154 827221 827241 827510 827649 827851 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск красивая"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.78%) |
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.