Query Metrics
7
Database Queries
7
Different statements
157.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.77 ms (84.43%) |
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 468298 473454 493808 528121 530051 530059 538069 538264 545684 546510 575637 586092 589281 592294 596545 597667 601349 603943 605505 612057 621829 621832 621853 621918 622287 622323 623382 624194 625604 626284 626674 626710 633928 634362 635358 635829 640183 651702 652030 675160 678910 679405 682261 694933 701604 703373 703457 708520 713853 716971 719327 720284 720313 724029 724329 726948 727613 728300 731475 732709 733025 736450 738051 739548 739624 740129 740698 743799 747174 748390 748403 751846 752316 752437 752686 755253 756045 756719 757327 757483 757649 759243 759753 766676 770351 770515 770719 770752 772208 772775 772824 773319 773694 773961 774819 774829 776227 778808 780121 784969 784994 785003 785609 785676 785789 788075 788138 788223 792188 793831 794163 799988 807259 808036 810635 823570 825442 826028 826245 ] |
||||||||||||||||||||||||||||||
|
14.03 ms (8.92%) |
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 528121 589281 703373 538264 538069 575637 651702 675160 652030 678910 679405 703457 708520 546510 592294 597667 603943 621918 635358 621832 622287 622323 605505 612057 634362 626674 785003 794163 625604 493808 682261 624194 640183 633928 626284 626710 776227 793831 788075 726948 759243 770351 770752 635829 530051 530059 825442 826245 823570 468298 473454 545684 694933 720284 716971 713853 720313 586092 621829 596545 621853 623382 780121 774819 774829 775333 784969 784994 785676 799988 808036 727613 738051 739624 772775 772824 773319 773694 807259 732709 733025 740129 756045 759753 724329 728300 736450 748390 751846 752686 739548 743799 747174 752316 752437 755253 757649 772208 773961 731475 740698 748403 756719 757483 766676 770515 701604 778808 785609 785789 788223 792188 810635 826028 719327 601349 788138 770719 724029 757327 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.06%) |
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 468298 473454 493808 528121 530051 530059 538069 538264 545684 546510 575637 586092 589281 592294 596545 597667 601349 603943 605505 612057 621829 621832 621853 621918 622287 622323 623382 624194 625604 626284 626674 626710 633928 634362 635358 635829 640183 651702 652030 675160 678910 679405 682261 694933 701604 703373 703457 708520 713853 716971 719327 720284 720313 724029 724329 726948 727613 728300 731475 732709 733025 736450 738051 739548 739624 740129 740698 743799 747174 748390 748403 751846 752316 752437 752686 755253 756045 756719 757327 757483 757649 759243 759753 766676 770351 770515 770719 770752 772208 772775 772824 773319 773694 773961 774819 774829 776227 778808 780121 784969 784994 785003 785609 785676 785789 788075 788138 788223 792188 793831 794163 799988 807259 808036 810635 823570 825442 826028 826245 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск латинская"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur latina"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
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.