Query Metrics
7
Database Queries
7
Different statements
186.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.52 ms (87.21%) |
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 398138 406340 415796 458208 530280 536053 536079 540165 541944 542722 549299 551891 552519 554684 555319 558430 559434 561511 562157 570941 578937 593661 596549 599705 600778 608096 611954 612985 622078 628358 632086 633825 640870 643241 647200 648572 651328 661329 661383 666708 676756 683897 689868 691112 692402 692581 694121 695005 704387 707264 713779 714602 716472 718764 719889 722952 726886 728276 730665 731399 732099 734377 734394 735118 735179 736559 738976 743872 744810 745247 746356 751490 752622 754397 757557 758878 759817 760751 761159 764419 765802 768591 777156 777636 778140 780210 783781 792769 798315 798812 798944 799822 800448 801589 802913 803483 804429 804471 809742 811761 811857 812231 812242 812249 814298 818950 819083 819801 820186 820983 822634 826901 828135 828138 828330 ] |
||||||||||||||||||||||||||||||
|
12.40 ms (6.66%) |
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 559434 676756 648572 647200 661329 612985 593661 599705 778140 783781 799822 780210 800448 809742 812231 731399 732099 734394 757557 743872 735118 759817 777156 798812 398138 393711 406340 828135 661383 719889 768591 728276 611954 633825 826901 828330 383707 335462 396765 397932 820983 818950 819083 819801 814298 820186 822634 828138 530280 536053 540165 536079 541944 549299 558430 561511 542722 552519 562157 578937 707264 716472 651328 666708 694121 695005 704387 713779 714602 718764 683897 689868 691112 692402 551891 555319 570941 600778 596549 628358 640870 643241 608096 802913 803483 811761 798944 804429 734377 736559 746356 760751 798315 804471 812249 752622 754397 735179 758878 764419 765802 726886 730665 744810 745247 751490 738976 761159 622078 632086 722952 777636 792769 811857 812242 415796 458208 692581 801589 554684 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.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 398138 406340 415796 458208 530280 536053 536079 540165 541944 542722 549299 551891 552519 554684 555319 558430 559434 561511 562157 570941 578937 593661 596549 599705 600778 608096 611954 612985 622078 628358 632086 633825 640870 643241 647200 648572 651328 661329 661383 666708 676756 683897 689868 691112 692402 692581 694121 695005 704387 707264 713779 714602 716472 718764 719889 722952 726886 728276 730665 731399 732099 734377 734394 735118 735179 736559 738976 743872 744810 745247 746356 751490 752622 754397 757557 758878 759817 760751 761159 764419 765802 768591 777156 777636 778140 780210 783781 792769 798315 798812 798944 799822 800448 801589 802913 803483 804429 804471 809742 811761 811857 812231 812242 812249 814298 818950 819083 819801 820186 820983 822634 826901 828135 828138 828330 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public pov"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц пов"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.