Query Metrics
7
Database Queries
7
Different statements
195.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.65 ms (86.86%) |
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 441864 448637 458387 461921 465277 487682 500929 503786 506291 518535 519683 523039 523724 536527 538268 541119 544080 547419 549069 557828 562105 564252 567939 577638 579101 581109 590807 592061 593594 604349 606251 606947 613038 619488 620614 630457 632156 632435 633637 638033 638770 641318 644583 646085 650687 650725 662087 662139 673624 687844 689542 697491 697589 698725 704654 706931 711870 715012 716050 721556 723820 725136 726171 726929 727852 728555 730329 730346 731243 731346 731389 734390 739894 740879 743905 744790 747492 747682 748979 750244 751438 751664 754200 755125 756301 757888 758312 759290 759914 761491 761521 763059 763963 769491 770303 773417 773482 777694 778285 778427 782979 785488 786790 786988 789874 794369 794674 794917 795313 795836 796164 796297 797520 800471 804413 805030 806393 810907 813906 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (7.89%) |
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 632435 638033 592061 604349 620614 638770 786790 800471 805030 726171 739894 751438 726929 747492 730346 734390 755125 773417 731243 644583 698725 716050 794369 804413 549069 697491 619488 590807 756301 813906 518535 538268 562105 557828 579101 581109 547419 577638 704654 646085 721556 662139 673624 689542 697589 567939 606251 593594 777694 778285 794674 795836 791945 743905 759914 761521 794917 725136 723820 731389 750244 754200 763059 773482 728555 606947 632156 641318 786988 461921 523039 523724 503786 541119 564252 544080 650687 650725 687844 711870 662087 706931 715012 613038 630457 789874 806393 778427 795313 740879 744790 761491 782979 785488 796164 810907 727852 730329 747682 748979 757888 759290 751664 763963 769491 731346 758312 770303 796297 797520 633637 441864 465277 448637 458387 487682 519683 500929 536527 506291 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.51%) |
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 441864 448637 458387 461921 465277 487682 500929 503786 506291 518535 519683 523039 523724 536527 538268 541119 544080 547419 549069 557828 562105 564252 567939 577638 579101 581109 590807 592061 593594 604349 606251 606947 613038 619488 620614 630457 632156 632435 633637 638033 638770 641318 644583 646085 650687 650725 662087 662139 673624 687844 689542 697491 697589 698725 704654 706931 711870 715012 716050 721556 723820 725136 726171 726929 727852 728555 730329 730346 731243 731346 731389 734390 739894 740879 743905 744790 747492 747682 748979 750244 751438 751664 754200 755125 756301 757888 758312 759290 759914 761491 761521 763059 763963 769491 770303 773417 773482 777694 778285 778427 782979 785488 786790 786988 789874 794369 794674 794917 795313 795836 796164 796297 797520 800471 804413 805030 806393 810907 813906 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"болью"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.72%) |
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.