Query Metrics
7
Database Queries
7
Different statements
165.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.23 ms (88.37%) |
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 72416 73672 122488 125944 246261 387315 401893 467508 495884 531025 531689 532081 533590 533754 537728 538175 540606 544314 548042 548861 549430 549929 552755 574252 595321 613181 613832 614391 616711 619488 642392 643118 656032 657384 661906 668826 670079 685308 689119 692036 696220 713172 714505 719897 720214 722113 723046 723100 724202 725268 726901 730094 734113 736852 737650 738734 742477 746739 747048 747341 748017 748612 752503 755886 770090 772875 773949 779497 782781 784301 789327 789370 792898 794473 795166 800417 801040 802214 804561 805348 806090 809890 811083 814023 814125 814450 817088 817694 817803 820530 821526 823137 823597 823689 823800 823810 823916 823924 823933 824213 824312 824408 824529 825326 825900 826123 826585 826586 826986 827035 827246 827452 827504 828145 828260 828283 828370 828415 828597 ] |
||||||||||||||||||||||||||||||
|
9.91 ms (5.99%) |
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 723100 789327 792898 809890 401893 73672 814125 814450 824408 823924 823916 817803 826123 817694 825326 828260 828415 828145 827452 533754 533590 537728 549430 656032 661906 668826 713172 657384 685308 689119 714505 670079 692036 696220 548042 548861 595321 613181 619488 643118 614391 642392 782781 804561 779497 795166 801040 802214 805348 724202 726901 746739 748017 755886 772875 811083 725268 737650 747048 748612 730094 734113 738734 736852 747341 752503 770090 773949 742477 719897 720214 722113 723046 784301 789370 794473 800417 806090 72416 616711 613832 467508 246261 122488 125944 387315 821526 823597 823800 823810 824213 824529 825900 826586 823689 817088 820530 826986 827035 827504 814023 823137 824264 824312 826585 828370 828283 823933 827246 828597 538175 540606 495884 531689 532081 531025 549929 544314 552755 574252 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short short"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.18%) |
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 72416 73672 122488 125944 246261 387315 401893 467508 495884 531025 531689 532081 533590 533754 537728 538175 540606 544314 548042 548861 549430 549929 552755 574252 595321 613181 613832 614391 616711 619488 642392 643118 656032 657384 661906 668826 670079 685308 689119 692036 696220 713172 714505 719897 720214 722113 723046 723100 724202 725268 726901 730094 734113 736852 737650 738734 742477 746739 747048 747341 748017 748612 752503 755886 770090 772875 773949 779497 782781 784301 789327 789370 792898 794473 795166 800417 801040 802214 804561 805348 806090 809890 811083 814023 814125 814450 817088 817694 817803 820530 821526 823137 823597 823689 823800 823810 823916 823924 823933 824213 824312 824408 824529 825326 825900 826123 826585 826586 826986 827035 827246 827452 827504 828145 828260 828283 828370 828415 828597 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short short"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short short"
]
|
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.