Query Metrics
7
Database Queries
7
Different statements
197.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.43 ms (88.13%) |
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 69704 395955 490490 493824 501137 527764 530095 531377 531924 532110 533268 533662 534640 535385 536063 537405 538891 542995 543732 544661 548135 548969 558201 561399 561757 568280 573225 573977 576484 584695 592962 593804 600649 604970 609435 617640 618951 619602 620666 629642 629662 631827 633427 639841 648898 651420 659059 665615 671702 675534 682405 685633 690872 693028 694476 694540 696272 697976 698431 699731 709376 710937 715542 720507 726448 727413 727715 728131 731054 733113 735152 736384 736620 737478 739774 740822 742042 742310 742680 745943 746304 747354 748990 752090 753991 759728 762242 764504 764603 765745 776913 778160 778221 781513 785313 786096 787302 787904 791027 791652 791708 791753 792392 793153 793454 795366 797100 798285 799481 799746 799972 800008 801516 803406 803477 803771 805927 812443 814258 822999 ] |
||||||||||||||||||||||||||||||
|
13.41 ms (6.77%) |
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 659059 671702 675534 685633 690872 693028 694476 694540 696272 697976 698431 710937 720507 548969 561757 573977 600649 592962 620666 629662 631827 604970 617640 619602 629642 633427 593804 618951 639841 787904 791708 791753 793454 797100 798285 799972 803406 812443 776913 778160 786096 795366 799481 803771 805927 727413 727715 742042 746304 748990 753991 781513 785313 792392 793153 799746 731054 733113 736384 752090 759728 728131 736620 742310 742680 726448 762242 735152 737478 739774 740822 745943 747354 764504 764603 765745 609435 699731 709376 715542 778221 787302 791027 791652 800008 801516 803477 395955 69704 537405 558201 682405 814258 822999 490490 493824 534640 536063 533268 538891 501137 527764 531377 532110 535385 530095 531924 533662 544661 568280 573225 576484 542995 548135 561399 543732 584695 648898 651420 665615 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.29%) |
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 69704 395955 490490 493824 501137 527764 530095 531377 531924 532110 533268 533662 534640 535385 536063 537405 538891 542995 543732 544661 548135 548969 558201 561399 561757 568280 573225 573977 576484 584695 592962 593804 600649 604970 609435 617640 618951 619602 620666 629642 629662 631827 633427 639841 648898 651420 659059 665615 671702 675534 682405 685633 690872 693028 694476 694540 696272 697976 698431 699731 709376 710937 715542 720507 726448 727413 727715 728131 731054 733113 735152 736384 736620 737478 739774 740822 742042 742310 742680 745943 746304 747354 748990 752090 753991 759728 762242 764504 764603 765745 776913 778160 778221 781513 785313 786096 787302 787904 791027 791652 791708 791753 792392 793153 793454 795366 797100 798285 799481 799746 799972 800008 801516 803406 803477 803771 805927 812443 814258 822999 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"два"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.88%) |
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.