Query Metrics
7
Database Queries
7
Different statements
187.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.94 ms (85.84%) |
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 96524 96636 191356 388940 392333 396664 401049 401261 404194 410397 410836 411829 417091 419873 424648 443103 443716 451626 454778 459370 460451 466316 469690 470614 474527 474538 477875 479936 481145 483717 484648 486161 488927 490044 504173 507675 513797 516078 516674 525129 528178 528867 530790 532363 534275 536645 536666 537236 543840 545470 545611 546200 550430 559228 560405 560427 564661 564800 565539 566032 577966 583505 583997 585323 586575 587852 590505 590809 590854 593867 597840 600173 602928 623178 623262 633454 635949 637087 637147 638552 639722 640538 640691 641930 644380 648526 650476 650818 650847 651601 663437 664957 665379 665662 667288 667476 667496 674082 697266 716394 719104 728200 734840 752523 765841 774598 778614 781990 785059 789878 792343 801949 801972 802109 803074 810832 814856 814924 815789 816086 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (8.75%) |
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 483717 460451 488927 474538 674082 665662 792343 419873 470614 650476 537236 404194 486161 665379 597840 765841 507675 536666 590809 528867 410836 454778 474527 477875 532363 534275 697266 564800 585323 778614 774598 443103 484648 810832 716394 424648 545611 651601 513797 650818 752523 801972 565539 504173 550430 543840 667476 664957 728200 593867 590854 801949 564661 623262 602928 525129 639722 577966 546200 191356 536645 516078 586575 459370 96636 600173 392333 814924 635949 644380 401261 401049 490044 466316 388940 814856 583505 623178 633454 587852 637087 785059 789878 443716 528178 545470 583997 479936 96524 410397 566032 640691 781990 815789 481145 530790 559228 663437 650847 640538 637147 638552 803074 469690 516674 560427 560405 667496 719104 667288 734840 641930 396664 816086 411829 648526 590505 417091 451626 802109 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.56%) |
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 96524 96636 191356 388940 392333 396664 401049 401261 404194 410397 410836 411829 417091 419873 424648 443103 443716 451626 454778 459370 460451 466316 469690 470614 474527 474538 477875 479936 481145 483717 484648 486161 488927 490044 504173 507675 513797 516078 516674 525129 528178 528867 530790 532363 534275 536645 536666 537236 543840 545470 545611 546200 550430 559228 560405 560427 564661 564800 565539 566032 577966 583505 583997 585323 586575 587852 590505 590809 590854 593867 597840 600173 602928 623178 623262 633454 635949 637087 637147 638552 639722 640538 640691 641930 644380 648526 650476 650818 650847 651601 663437 664957 665379 665662 667288 667476 667496 674082 697266 716394 719104 728200 734840 752523 765841 774598 778614 781990 785059 789878 792343 801949 801972 802109 803074 810832 814856 814924 815789 816086 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo threesome"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.82%) |
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.