Query Metrics
7
Database Queries
7
Different statements
146.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.37 ms (86.80%) |
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 32994 314006 317898 364242 391815 398522 417240 433704 468952 475988 477285 478158 481986 488563 493107 494667 496247 512649 514208 528062 530539 536974 538165 541722 544639 546296 548604 553417 555010 556282 556617 567477 575269 583343 586197 586295 586312 588756 599681 600660 616070 617496 625086 632754 633300 641920 642274 643988 644171 644199 645623 650294 652699 656494 663285 665324 665515 671223 684876 699156 707174 707238 709677 709834 710097 712646 713587 714777 715591 716066 717578 720844 724453 725053 726947 726999 727683 730093 730645 730944 741765 743496 747540 748002 749994 750673 753642 758136 759680 761405 762168 766056 766952 768982 769193 771260 771488 771556 772522 777184 783940 784382 787123 787654 788062 788560 790325 790670 794451 794816 795236 795577 796679 797123 798043 801759 802918 803468 804037 806088 ] |
||||||||||||||||||||||||||||||
|
10.04 ms (6.84%) |
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 794451 806088 777184 784382 787654 788560 790670 794816 798043 725053 727683 747540 750673 761405 766056 769193 771488 787123 788062 790325 795236 795577 796679 801759 724453 730645 730944 749994 753642 759680 766952 768982 771260 741765 743496 762168 730093 758136 771556 772522 726947 726999 748002 616070 699156 709677 715591 717578 720844 783940 797123 802918 803468 804037 317898 364242 32994 398522 512649 391815 314006 433704 417240 475988 468952 481986 488563 496247 530539 536974 528062 538165 494667 514208 477285 478158 493107 546296 548604 556282 556617 583343 541722 650294 684876 707174 713587 645623 652699 656494 663285 665324 665515 671223 707238 709834 710097 712646 714777 716066 544639 553417 555010 567477 575269 632754 633300 643988 588756 600660 625086 641920 642274 644199 586295 586312 599681 617496 644171 586197 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.63%) |
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 32994 314006 317898 364242 391815 398522 417240 433704 468952 475988 477285 478158 481986 488563 493107 494667 496247 512649 514208 528062 530539 536974 538165 541722 544639 546296 548604 553417 555010 556282 556617 567477 575269 583343 586197 586295 586312 588756 599681 600660 616070 617496 625086 632754 633300 641920 642274 643988 644171 644199 645623 650294 652699 656494 663285 665324 665515 671223 684876 699156 707174 707238 709677 709834 710097 712646 713587 714777 715591 716066 717578 720844 724453 725053 726947 726999 727683 730093 730645 730944 741765 743496 747540 748002 749994 750673 753642 758136 759680 761405 762168 766056 766952 768982 769193 771260 771488 771556 772522 777184 783940 784382 787123 787654 788062 788560 790325 790670 794451 794816 795236 795577 796679 797123 798043 801759 802918 803468 804037 806088 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зашёл к соседям"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосед"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.03%) |
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.