Query Metrics
7
Database Queries
7
Different statements
409.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.03 ms (51.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц ван"
]
|
||||||||||||||||||||||||||||||
|
175.34 ms (42.83%) |
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 513986 526765 530280 536053 536079 540165 542722 549299 551891 552519 554684 555319 558430 561511 562157 570941 578937 589329 596549 600778 608096 611954 622078 632086 633825 640870 643241 651328 661383 666708 682956 683897 689868 690415 690424 691112 692402 694121 695005 704387 707264 713779 716472 718764 719889 722952 726886 728276 730665 731399 732099 734377 734394 735118 736559 738976 743872 744810 745247 746356 751490 752622 754397 757557 758878 759817 760751 761159 764419 765802 765878 768591 771990 777156 777636 780210 780509 792769 798315 798812 798944 798989 799822 800448 802913 803483 804429 804471 809742 811857 812231 812242 812249 814298 818742 818950 819083 819455 819801 820186 820515 820983 821438 821571 822274 822634 823343 828135 828138 828425 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (3.20%) |
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 799822 780210 800448 809742 812231 731399 732099 734394 757557 743872 735118 759817 777156 798812 398138 393711 406340 828135 661383 719889 768591 728276 611954 633825 383707 335462 396765 397932 820983 818742 818950 819083 819801 823343 814298 819455 820186 820515 821438 821571 822274 822634 828425 828138 530280 536053 540165 536079 549299 558430 561511 542722 552519 562157 578937 690415 707264 716472 651328 666708 690424 694121 695005 704387 713779 718764 682956 683897 689868 691112 692402 551891 555319 570941 600778 596549 640870 643241 589329 608096 782835 798989 802913 803483 780509 798944 804429 734377 736559 746356 760751 798315 804471 812249 752622 754397 758878 764419 765802 726886 730665 744810 745247 751490 771990 738976 761159 765878 622078 632086 722952 777636 792769 811857 812242 415796 458208 554684 513986 526765 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (0.71%) |
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 513986 526765 530280 536053 536079 540165 542722 549299 551891 552519 554684 555319 558430 561511 562157 570941 578937 589329 596549 600778 608096 611954 622078 632086 633825 640870 643241 651328 661383 666708 682956 683897 689868 690415 690424 691112 692402 694121 695005 704387 707264 713779 716472 718764 719889 722952 726886 728276 730665 731399 732099 734377 734394 735118 736559 738976 743872 744810 745247 746356 751490 752622 754397 757557 758878 759817 760751 761159 764419 765802 765878 768591 771990 777156 777636 780210 780509 792769 798315 798812 798944 798989 799822 800448 802913 803483 804429 804471 809742 811857 812231 812242 812249 814298 818742 818950 819083 819455 819801 820186 820515 820983 821438 821571 822274 822634 823343 828135 828138 828425 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public bathroom"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.