Query Metrics
7
Database Queries
7
Different statements
348.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.59 ms (60.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public russian"
]
|
||||||||||||||||||||||||||||||
|
121.21 ms (34.74%) |
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 335462 383707 393711 396765 397932 415796 458208 513986 526765 528350 530280 536053 536079 540165 541944 542722 549299 551891 552519 554684 555319 556375 558430 561511 562157 569538 570941 589329 589362 596549 600778 608096 611954 615014 622078 628358 632086 633825 634369 640870 643241 651328 655509 661339 661383 664655 666708 683766 683897 689868 690415 690424 691112 692402 694121 695005 704387 707264 713779 716472 718764 719889 722952 725441 726886 728276 730665 734377 735179 736559 738976 745247 746356 751242 752622 754397 758878 758942 760751 761159 764419 765802 765878 768591 771990 777636 792769 794030 798315 798812 798944 798989 802913 803483 804429 804471 804877 809945 811761 811857 812242 812249 813585 814298 818742 818950 819083 819455 820186 820515 820983 821438 821571 822274 822634 823343 828135 828138 828425 ] |
||||||||||||||||||||||||||||||
|
10.23 ms (2.93%) |
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 798812 393711 683766 634369 751242 758942 813585 655509 794030 804877 725441 809945 528350 661383 719889 768591 728276 611954 633825 383707 335462 396765 397932 820983 818742 818950 819083 823343 814298 819455 820186 820515 821438 821571 822274 822634 828425 828138 530280 536053 540165 536079 541944 549299 558430 561511 542722 552519 562157 690415 707264 716472 651328 666708 690424 694121 695005 704387 713779 718764 683897 689868 691112 692402 551891 555319 570941 600778 596549 628358 640870 643241 589329 608096 782835 798989 802913 803483 811761 798944 804429 734377 736559 746356 760751 798315 804471 812249 752622 754397 735179 758878 764419 765802 726886 730665 745247 771990 738976 761159 765878 622078 632086 722952 777636 792769 811857 812242 415796 458208 828135 554684 513986 526765 569538 556375 661339 664655 589362 615014 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.60%) |
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 335462 383707 393711 396765 397932 415796 458208 513986 526765 528350 530280 536053 536079 540165 541944 542722 549299 551891 552519 554684 555319 556375 558430 561511 562157 569538 570941 589329 589362 596549 600778 608096 611954 615014 622078 628358 632086 633825 634369 640870 643241 651328 655509 661339 661383 664655 666708 683766 683897 689868 690415 690424 691112 692402 694121 695005 704387 707264 713779 716472 718764 719889 722952 725441 726886 728276 730665 734377 735179 736559 738976 745247 746356 751242 752622 754397 758878 758942 760751 761159 764419 765802 765878 768591 771990 777636 792769 794030 798315 798812 798944 798989 802913 803483 804429 804471 804877 809945 811761 811857 812242 812249 813585 814298 818742 818950 819083 819455 820186 820515 820983 821438 821571 822274 822634 823343 828135 828138 828425 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц русск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц русск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.