Query Metrics
7
Database Queries
7
Different statements
199.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.53 ms (87.70%) |
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 478158 517432 526136 526141 530645 532807 534345 534355 534723 535413 536050 539751 539752 539787 541071 541102 541815 542468 546336 546839 550172 550539 553807 554572 554831 554837 560674 561620 567500 567575 574147 574711 577002 577430 580384 586351 592646 592851 594321 594897 599647 601220 604090 607172 609765 614625 618951 619675 621588 628592 630879 633666 634855 635630 637462 639218 639231 643031 651075 667418 668538 685672 689478 691542 691834 692437 692497 692919 693126 693618 695682 698171 698207 699005 705788 708001 709987 710429 713939 714842 716146 720510 724731 726931 727439 730656 732739 732795 738414 739810 746968 757558 757606 759313 766011 767975 768681 771512 772284 772435 772510 777229 785515 789064 791556 791570 794489 796338 797032 799003 801589 801696 802804 803366 804350 810621 811478 812226 812243 812621 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (6.70%) |
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 535413 539752 534723 539751 553807 554837 546839 550539 554572 577002 577430 580384 651075 692437 692497 693126 709987 691542 691834 692919 714842 716146 667418 693618 699005 708001 561620 586351 594897 635630 601220 609765 614625 619675 630879 594321 637462 639231 643031 777229 801589 812621 771512 724731 732739 768681 757558 772435 759313 730656 732795 739810 746968 633666 710429 713939 720510 812226 526136 534345 539787 530645 532807 526141 534355 517432 536050 478158 541815 546336 574147 541102 542468 550172 574711 541071 554831 560674 567500 567575 705788 695682 698207 668538 685672 689478 698171 592851 607172 621588 592646 604090 628592 634855 639218 599647 618951 785515 789064 791556 794489 799003 802804 796338 797032 803366 804350 726931 791570 801696 810621 811478 812243 766011 772284 727439 767975 738414 757606 772510 ] |
||||||||||||||||||||||||||||||
|
3.81 ms (1.91%) |
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 478158 517432 526136 526141 530645 532807 534345 534355 534723 535413 536050 539751 539752 539787 541071 541102 541815 542468 546336 546839 550172 550539 553807 554572 554831 554837 560674 561620 567500 567575 574147 574711 577002 577430 580384 586351 592646 592851 594321 594897 599647 601220 604090 607172 609765 614625 618951 619675 621588 628592 630879 633666 634855 635630 637462 639218 639231 643031 651075 667418 668538 685672 689478 691542 691834 692437 692497 692919 693126 693618 695682 698171 698207 699005 705788 708001 709987 710429 713939 714842 716146 720510 724731 726931 727439 730656 732739 732795 738414 739810 746968 757558 757606 759313 766011 767975 768681 771512 772284 772435 772510 777229 785515 789064 791556 791570 794489 796338 797032 799003 801589 801696 802804 803366 804350 810621 811478 812226 812243 812621 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"перед публикой"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"публик"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
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.