Query Metrics
7
Database Queries
7
Different statements
142.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.33 ms (84.33%) |
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 187840 187964 188515 233292 327523 381757 385638 385991 386044 388318 395938 396865 397220 397224 398466 398551 398567 421524 454203 480077 488311 514823 515060 531940 540568 548052 550652 554322 577832 591265 592791 599277 607607 619600 633345 635610 639652 651621 662898 664389 664793 665235 665419 665486 666153 667254 667294 667607 678757 678761 693254 695634 698497 710011 717700 719925 720610 721002 721454 724290 725504 726910 726965 728254 731767 731785 732179 732986 733134 733946 735028 735442 739174 742274 744339 744797 745444 749232 752888 755256 755684 770121 770203 773900 776131 781679 781693 781919 781933 781963 781967 781978 784632 785436 788285 789197 789301 796807 799162 799171 801053 802439 802759 804453 807605 807626 808163 814621 817393 817721 817980 818648 819628 820284 823976 824938 825036 825241 827629 827668 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (9.14%) |
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 731785 749232 770121 770203 773900 755256 776131 781679 781919 781933 781967 788285 799162 802759 807605 807626 808163 388318 607607 398466 824938 818648 488311 781978 732179 735028 454203 386044 188515 381757 814621 825036 827629 817980 480077 514823 531940 540568 515060 550652 554322 577832 666153 667294 667607 717700 662898 664793 665235 678757 695634 698497 720610 721454 665419 665486 667254 678761 591265 592791 599277 633345 619600 639652 781963 789197 801053 781693 789301 799171 802439 744339 744797 755684 785436 804453 726910 733946 739174 732986 735442 745444 724290 731767 742274 710011 721002 784632 796807 233292 398551 327523 693254 719925 725504 728254 726965 385638 421524 825241 651621 664389 548052 635610 752888 733134 187840 385991 187964 395938 396865 397220 397224 398567 820284 823976 817721 817393 819628 827668 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.54%) |
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 187840 187964 188515 233292 327523 381757 385638 385991 386044 388318 395938 396865 397220 397224 398466 398551 398567 421524 454203 480077 488311 514823 515060 531940 540568 548052 550652 554322 577832 591265 592791 599277 607607 619600 633345 635610 639652 651621 662898 664389 664793 665235 665419 665486 666153 667254 667294 667607 678757 678761 693254 695634 698497 710011 717700 719925 720610 721002 721454 724290 725504 726910 726965 728254 731767 731785 732179 732986 733134 733946 735028 735442 739174 742274 744339 744797 745444 749232 752888 755256 755684 770121 770203 773900 776131 781679 781693 781919 781933 781963 781967 781978 784632 785436 788285 789197 789301 796807 799162 799171 801053 802439 802759 804453 807605 807626 808163 814621 817393 817721 817980 818648 819628 820284 823976 824938 825036 825241 827629 827668 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопу бабки"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.