Query Metrics
7
Database Queries
7
Different statements
143.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.62 ms (83.17%) |
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 46283 391891 478735 514992 528494 530621 536012 552988 559326 559334 559853 562901 565702 590564 591572 595746 598284 600861 605743 610422 625623 627359 631298 633030 636495 636969 637383 644169 646075 654679 659002 668777 679230 680673 686851 688398 689488 691388 691432 691812 694438 695782 697129 697623 698346 701167 701526 705178 708983 710046 710210 710398 712258 715016 715035 715407 715700 717449 717664 718057 718949 719768 723642 723819 728673 730681 730803 731656 733529 735592 736804 737095 739833 739967 740713 742133 745568 747480 747633 750807 751285 751314 752934 755659 757700 759390 760521 762020 765104 765346 766154 767729 769179 773002 776034 777760 780573 780857 784122 785542 785655 787400 787684 791024 794442 794659 794877 795777 796996 797045 798891 800121 801018 801253 802215 802264 810381 811636 813848 813943 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (9.54%) |
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 742133 747633 810381 46283 391891 723642 813943 478735 559334 565702 559326 559853 697623 715016 715407 717664 688398 705178 710210 715035 686851 695782 715700 718057 636969 644169 590564 598284 625623 631298 787400 798891 780857 785655 802215 737095 740713 765104 811636 730681 731656 733529 766154 767729 728673 736804 745568 760521 765346 769179 739967 633030 697129 791024 795777 797045 813848 514992 536012 528494 530621 552988 562901 668777 679230 689488 691388 712258 654679 659002 680673 694438 701526 708983 710398 646075 691432 691812 698346 701167 710046 717449 718949 719768 600861 605743 591572 595746 610422 637383 627359 636495 776034 777760 780573 784122 785542 801018 787684 794877 796996 801253 723819 739833 751285 752934 755659 794442 794659 800121 802264 747480 750807 751314 759390 762020 773002 730803 735592 757700 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.22%) |
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 46283 391891 478735 514992 528494 530621 536012 552988 559326 559334 559853 562901 565702 590564 591572 595746 598284 600861 605743 610422 625623 627359 631298 633030 636495 636969 637383 644169 646075 654679 659002 668777 679230 680673 686851 688398 689488 691388 691432 691812 694438 695782 697129 697623 698346 701167 701526 705178 708983 710046 710210 710398 712258 715016 715035 715407 715700 717449 717664 718057 718949 719768 723642 723819 728673 730681 730803 731656 733529 735592 736804 737095 739833 739967 740713 742133 745568 747480 747633 750807 751285 751314 752934 755659 757700 759390 760521 762020 765104 765346 766154 767729 769179 773002 776034 777760 780573 780857 784122 785542 785655 787400 787684 791024 794442 794659 794877 795777 796996 797045 798891 800121 801018 801253 802215 802264 810381 811636 813848 813943 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"стон"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стон"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"стон"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
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.