Query Metrics
7
Database Queries
7
Different statements
142.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.31 ms (84.59%) |
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 28014 28197 39167 402398 417077 457731 459514 527075 533430 534368 534723 535413 539751 539752 542174 543660 544332 544362 546341 546814 546839 548104 550539 550595 550936 553235 553807 554209 554572 554696 554703 554794 561620 562631 577002 577430 580384 586351 592159 598789 601220 609765 614625 618056 632679 633903 637462 638125 639231 643031 651917 652283 655542 656813 661342 661377 664119 666991 669930 672422 683568 685423 691542 691834 692721 692763 693126 693578 694425 694432 695667 696055 696628 696673 696699 699005 707562 708001 709932 709987 712660 713096 714842 716137 716146 718029 721920 724731 729323 734120 738004 739337 771512 777137 777229 777630 779767 779843 780137 780897 783761 787582 787623 787642 791118 793208 797813 801589 803303 805072 805308 808303 808710 809700 812307 813589 814058 814163 821181 ] |
||||||||||||||||||||||||||||||
|
12.10 ms (8.51%) |
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 28197 39167 28014 402398 417077 813589 814163 814058 821181 457731 459514 533430 535413 539752 527075 534368 534723 539751 543660 553807 554696 554703 544362 546341 546839 548104 550936 542174 544332 550539 553235 554572 554794 562631 577002 577430 580384 651917 655542 656813 661377 692763 693126 693578 694425 696055 709987 712660 718029 721920 664119 672422 683568 685423 691542 691834 692721 695667 709932 713096 714842 716146 652283 661342 666991 669930 694432 696628 696673 696699 699005 707562 708001 716137 546814 550595 554209 561620 586351 632679 633903 598789 601220 609765 614625 618056 592159 637462 638125 639231 643031 777137 777229 779767 780137 780897 783761 801589 803303 805308 777630 778565 779843 787582 787623 791118 793208 808303 729323 734120 738004 739337 771512 787642 797813 805072 808710 809700 812307 724731 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (2.15%) |
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 28014 28197 39167 402398 417077 457731 459514 527075 533430 534368 534723 535413 539751 539752 542174 543660 544332 544362 546341 546814 546839 548104 550539 550595 550936 553235 553807 554209 554572 554696 554703 554794 561620 562631 577002 577430 580384 586351 592159 598789 601220 609765 614625 618056 632679 633903 637462 638125 639231 643031 651917 652283 655542 656813 661342 661377 664119 666991 669930 672422 683568 685423 691542 691834 692721 692763 693126 693578 694425 694432 695667 696055 696628 696673 696699 699005 707562 708001 709932 709987 712660 713096 714842 716137 716146 718029 721920 724731 729323 734120 738004 739337 771512 777137 777229 777630 779767 779843 780137 780897 783761 787582 787623 787642 791118 793208 797813 801589 803303 805072 805308 808303 808710 809700 812307 813589 814058 814163 821181 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нае"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.08%) |
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.