Query Metrics
7
Database Queries
7
Different statements
253.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
225.33 ms (89.00%) |
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 281567 381828 382456 387274 389756 393738 393741 393745 393780 394224 400418 400446 400448 400458 401996 411958 418485 422684 430713 443967 445062 448927 452490 460036 464283 464316 467320 473322 493188 503949 507379 510751 515070 515161 515177 515220 525115 530360 530365 538850 542942 547061 548556 550639 551066 551978 559909 561734 562114 562119 562123 565535 566517 566518 566526 570901 578479 593440 595869 596353 596896 601300 607075 607306 610021 613465 624829 630192 633516 641120 642816 644698 650432 651165 664309 664828 665475 681213 681813 682515 684564 684580 684980 684995 700659 708799 712823 712827 712833 712837 714455 716236 716326 718554 722687 732116 732120 732421 732466 741973 743082 743117 743128 744337 744627 748999 757973 759567 759578 759599 766037 766536 767964 774158 775825 804748 807701 807968 812151 814122 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (6.27%) |
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 393738 393741 393780 393745 394224 281567 382456 381828 389756 387274 400418 400446 400448 400458 401996 422684 430713 411958 445062 418485 443967 814122 452490 464316 473322 448927 493188 464283 467320 507379 515220 530360 515070 515161 515177 530365 503949 510751 525115 538850 460036 542942 548556 550639 562114 547061 551066 551978 562123 566518 578479 559909 665475 682515 684564 700659 714455 651165 684580 684980 712823 712833 712837 716236 716326 718554 650432 664309 664828 681213 681813 684995 708799 712827 722687 561734 562119 565535 566517 566526 570901 596896 607306 630192 633516 593440 595869 610021 613465 642816 644698 601300 607075 624829 596353 641120 775825 804748 812151 732466 743082 743128 744627 748999 759567 807701 807968 732120 741973 757973 759599 766037 766536 767964 774158 743117 744337 759578 732116 732421 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.35%) |
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 281567 381828 382456 387274 389756 393738 393741 393745 393780 394224 400418 400446 400448 400458 401996 411958 418485 422684 430713 443967 445062 448927 452490 460036 464283 464316 467320 473322 493188 503949 507379 510751 515070 515161 515177 515220 525115 530360 530365 538850 542942 547061 548556 550639 551066 551978 559909 561734 562114 562119 562123 565535 566517 566518 566526 570901 578479 593440 595869 596353 596896 601300 607075 607306 610021 613465 624829 630192 633516 641120 642816 644698 650432 651165 664309 664828 665475 681213 681813 682515 684564 684580 684980 684995 700659 708799 712823 712827 712833 712837 714455 716236 716326 718554 722687 732116 732120 732421 732466 741973 743082 743117 743128 744337 744627 748999 757973 759567 759578 759599 766037 766536 767964 774158 775825 804748 807701 807968 812151 814122 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"grandpa teens"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"grandpa teens"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"grandpa teens"
]
|
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.