Query Metrics
7
Database Queries
7
Different statements
200.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.80 ms (87.82%) |
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 88174 383411 396367 404084 460298 467138 482246 485078 486778 525080 531736 531745 536467 538371 550375 551837 553680 563512 565148 570677 574899 581059 582729 583453 588167 596247 607000 609566 616912 623647 627203 634397 638676 644622 650155 650269 660629 663529 667447 674503 678228 685113 685409 688524 703012 703573 703972 704127 707964 711347 711509 712784 719924 723839 725290 725304 728942 730611 733108 734081 736183 737547 740406 740687 741134 743837 744678 746181 747618 752186 753740 757666 758005 758830 759050 761657 762198 765877 765972 766285 767366 767878 771675 771762 773520 776630 777789 780750 780906 783153 783740 785901 787732 787766 789168 789246 790340 794723 797221 799253 802470 803133 803181 804724 807233 808082 812284 812628 813335 817505 817611 819946 820308 821265 824748 824771 825495 826407 827553 828626 ] |
||||||||||||||||||||||||||||||
|
14.07 ms (7.03%) |
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 812284 725290 725304 733108 737547 761657 765877 771762 734081 743837 752186 759050 744678 758005 765972 767366 771675 607000 627203 711509 719924 776630 780750 787766 383411 650155 88174 396367 404084 824771 819946 820308 821265 824748 825495 827553 817505 817611 826407 828626 486778 485078 460298 482246 525080 538371 531736 536467 531745 467138 553680 565148 581059 550375 551837 570677 574899 563512 583453 663529 685409 688524 707964 650269 660629 667447 685113 703573 704127 674503 678228 703012 703972 711347 712784 582729 634397 588167 596247 644622 616912 623647 638676 609566 780906 783153 785901 787732 794723 797221 802470 803133 812628 777789 789168 799253 804724 723839 740687 741134 746181 747618 766285 773520 783740 789246 790340 803181 807233 808082 813335 728942 730611 736183 740406 753740 757666 758830 762198 767878 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.64%) |
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 88174 383411 396367 404084 460298 467138 482246 485078 486778 525080 531736 531745 536467 538371 550375 551837 553680 563512 565148 570677 574899 581059 582729 583453 588167 596247 607000 609566 616912 623647 627203 634397 638676 644622 650155 650269 660629 663529 667447 674503 678228 685113 685409 688524 703012 703573 703972 704127 707964 711347 711509 712784 719924 723839 725290 725304 728942 730611 733108 734081 736183 737547 740406 740687 741134 743837 744678 746181 747618 752186 753740 757666 758005 758830 759050 761657 762198 765877 765972 766285 767366 767878 771675 771762 773520 776630 777789 780750 780906 783153 783740 785901 787732 787766 789168 789246 790340 794723 797221 799253 802470 803133 803181 804724 807233 808082 812284 812628 813335 817505 817611 819946 820308 821265 824748 824771 825495 826407 827553 828626 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"they are new"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"new"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"new"
]
|
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.