Query Metrics
7
Database Queries
7
Different statements
148.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.77 ms (84.13%) |
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 39142 146050 185567 384266 384906 385548 388453 392658 398221 401654 414297 457307 459536 465104 477561 479070 479146 483640 483758 499694 510510 512196 515721 521351 525168 529743 530823 531059 531668 531689 532175 532183 532279 532704 533259 533269 533335 533558 533666 535653 535806 536079 536220 536951 537027 537794 538090 538116 538615 539250 542697 543003 543029 543244 546251 548832 570902 626783 628489 702443 706891 711668 717939 719742 720360 721069 721650 727663 730625 730884 731199 732164 733361 735682 736744 737326 738875 739882 742617 745336 746530 747038 749419 753538 755605 757639 760173 760691 760918 761718 809750 815435 815764 815822 815903 818704 818747 818925 819709 819738 820543 820638 820983 823045 823133 825107 826061 826116 826179 826587 827098 828005 828058 828382 828430 828459 828462 828700 ] |
||||||||||||||||||||||||||||||
|
11.15 ms (7.52%) |
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 414297 384266 185567 826081 828462 465104 499694 532175 546251 730625 733361 738875 732164 757639 459536 818747 823105 823133 815822 825107 826061 826179 815903 818925 815435 815764 826116 828382 828058 828005 828459 828430 457307 532279 532704 533259 536220 538615 521351 531689 532183 533558 512196 530823 531668 536951 537027 537794 538116 510510 533269 533335 479146 543003 742617 760918 727663 730884 731199 755605 745336 760691 717939 809750 401654 392658 398221 826587 827098 760173 753538 388453 385548 39142 819709 818704 820543 820983 823045 819738 820638 828700 483640 477561 539250 531059 533666 525168 529743 535806 538090 515721 535653 536079 479070 483758 542697 543244 543029 548832 570902 721650 706891 719742 702443 711668 720360 721069 626783 628489 737326 747038 735682 736744 746530 749419 739882 761718 146050 384906 ] |
||||||||||||||||||||||||||||||
|
4.14 ms (2.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.83%) |
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 39142 146050 185567 384266 384906 385548 388453 392658 398221 401654 414297 457307 459536 465104 477561 479070 479146 483640 483758 499694 510510 512196 515721 521351 525168 529743 530823 531059 531668 531689 532175 532183 532279 532704 533259 533269 533335 533558 533666 535653 535806 536079 536220 536951 537027 537794 538090 538116 538615 539250 542697 543003 543029 543244 546251 548832 570902 626783 628489 702443 706891 711668 717939 719742 720360 721069 721650 727663 730625 730884 731199 732164 733361 735682 736744 737326 738875 739882 742617 745336 746530 747038 749419 753538 755605 757639 760173 760691 760918 761718 809750 815435 815764 815822 815903 818704 818747 818925 819709 819738 820543 820638 820983 823045 823133 825107 826061 826116 826179 826587 827098 828005 828058 828382 828430 828459 828462 828700 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член ххх"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член ххх"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.