Query Metrics
7
Database Queries
7
Different statements
160.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.47 ms (85.22%) |
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 81065 191189 388688 396088 397299 403703 413472 418365 419174 422150 422426 424529 425395 427149 431345 433404 434889 439446 439450 447830 448843 449146 450149 450156 450779 452224 452429 452675 457008 458639 459969 459989 460814 461984 463537 463618 469988 470053 473650 479784 487950 491175 495280 497234 497766 503082 503359 512631 517132 523272 524395 540647 542345 543507 546868 547031 556766 564688 567010 574659 576502 579664 579849 579877 585838 593381 598300 612951 613848 614045 618104 627183 636116 636462 645265 647657 653330 665740 667909 705226 707698 708148 708450 708894 709292 709819 718980 720074 720607 723155 726907 728741 728967 734521 735867 736425 747544 752876 759653 761949 763378 764486 774534 776773 780936 785175 786312 789783 792062 793451 795483 801063 803258 803604 804210 806797 808095 809485 811906 814675 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (9.09%) |
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 439450 413472 439446 422426 424529 433404 431345 814675 457008 450156 452429 459989 463537 479784 447830 448843 450149 452224 459969 469988 470053 495280 517132 540647 497766 503359 460814 473650 487950 574659 579877 556766 567010 576502 542345 543507 547031 667909 705226 707698 708450 723155 720074 645265 647657 653330 665740 709292 709819 718980 546868 564688 579664 579849 585838 612951 613848 614045 627183 593381 618104 636116 598300 786312 795483 804210 776773 789783 811906 785175 792062 728967 736425 726907 763378 734521 735867 752876 728741 747544 759653 761949 764486 636462 708148 708894 720607 774534 780936 793451 801063 803258 803604 806797 808095 809485 427149 81065 388688 458639 396088 403703 425395 452675 191189 418365 449146 461984 463618 450779 512631 491175 503082 497234 523272 524395 397299 422150 419174 434889 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.54%) |
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 81065 191189 388688 396088 397299 403703 413472 418365 419174 422150 422426 424529 425395 427149 431345 433404 434889 439446 439450 447830 448843 449146 450149 450156 450779 452224 452429 452675 457008 458639 459969 459989 460814 461984 463537 463618 469988 470053 473650 479784 487950 491175 495280 497234 497766 503082 503359 512631 517132 523272 524395 540647 542345 543507 546868 547031 556766 564688 567010 574659 576502 579664 579849 579877 585838 593381 598300 612951 613848 614045 618104 627183 636116 636462 645265 647657 653330 665740 667909 705226 707698 708148 708450 708894 709292 709819 718980 720074 720607 723155 726907 728741 728967 734521 735867 736425 747544 752876 759653 761949 763378 764486 774534 776773 780936 785175 786312 789783 792062 793451 795483 801063 803258 803604 804210 806797 808095 809485 811906 814675 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"load"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"load"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"load"
]
|
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.