Query Metrics
7
Database Queries
7
Different statements
148.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.04 ms (81.10%) |
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 558073 590970 596584 597577 597978 597982 598028 598045 598543 598591 598728 598796 600119 600142 600147 608188 612574 616682 616771 618769 621725 626483 628804 639156 651935 653371 660283 661512 668133 672449 672475 672809 673170 680676 680782 687426 687846 687940 689161 689217 696330 697251 702283 711149 711716 712226 712957 713420 713921 714575 714656 719162 719418 720649 721575 721597 723210 725507 726398 727523 727827 729424 730031 731197 735115 736128 736869 741170 741744 742144 742906 743105 743679 745344 745352 745637 745720 749766 751025 757846 760517 760520 764057 764112 764121 764137 765886 766460 768163 768467 768486 773002 778876 782307 782520 783887 784169 785941 786233 787189 787286 787598 788473 790259 791918 791955 792277 796511 799805 799847 801460 804872 807275 809561 809566 809938 809976 811150 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (11.35%) |
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 702283 712957 719418 720649 723210 661512 672449 672809 673170 680676 680782 687846 696330 697251 711149 712226 713420 713921 714656 719162 721597 651935 653371 660283 668133 672475 687426 687940 689161 689217 711716 714575 721575 558073 597978 597982 598028 598045 598591 598796 600147 612574 616771 590970 596584 598728 600142 608188 621725 598543 600119 616682 626483 628804 597577 618769 639156 642091 778876 782520 783887 785941 787189 787286 787598 788473 790259 791955 792277 796511 799805 801460 804872 807275 809566 809976 782307 784169 786233 791918 799847 809938 811150 725507 736128 741170 742906 743105 743679 751025 760517 760520 764121 768163 805492 809561 727827 729424 730031 735115 736869 742144 745344 745637 745720 749766 757846 765886 766460 768467 768486 773002 726398 727523 731197 741744 745352 764057 764112 764137 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.24%) |
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 558073 590970 596584 597577 597978 597982 598028 598045 598543 598591 598728 598796 600119 600142 600147 608188 612574 616682 616771 618769 621725 626483 628804 639156 651935 653371 660283 661512 668133 672449 672475 672809 673170 680676 680782 687426 687846 687940 689161 689217 696330 697251 702283 711149 711716 712226 712957 713420 713921 714575 714656 719162 719418 720649 721575 721597 723210 725507 726398 727523 727827 729424 730031 731197 735115 736128 736869 741170 741744 742144 742906 743105 743679 745344 745352 745637 745720 749766 751025 757846 760517 760520 764057 764112 764121 764137 765886 766460 768163 768467 768486 773002 778876 782307 782520 783887 784169 785941 786233 787189 787286 787598 788473 790259 791918 791955 792277 796511 799805 799847 801460 804872 807275 809561 809566 809938 809976 811150 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2014 rus"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
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.