Query Metrics
7
Database Queries
7
Different statements
177.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.51 ms (85.32%) |
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 416901 417707 417749 429809 435016 435740 437295 444205 445766 448076 448625 451590 454459 456261 465444 469172 474828 475516 478554 480697 487821 500013 502045 504282 512936 514341 526011 527435 532055 537820 537975 541105 551567 555215 556087 562200 562434 571221 572846 590495 599758 614646 617345 617755 621983 629260 636430 650088 652482 659371 661004 663550 667469 675570 690406 693624 695985 696016 696063 708513 719928 721909 739263 740768 743647 744900 750330 761150 761880 763840 765577 765776 766006 766814 771647 772445 778597 780580 780654 783539 785029 785543 788795 788844 789052 789911 791101 791833 792412 793904 796248 797272 800385 803199 811449 813509 817763 817775 817812 817919 818968 818991 819004 819086 819344 819446 820671 821009 821161 821412 821471 821482 821499 822136 822249 822769 824366 825825 827833 827994 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (8.26%) |
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 739263 527435 555215 456261 448625 465444 761150 526011 614646 435016 429809 817919 818968 818991 822769 819004 821471 821499 822136 824366 817763 817775 819344 821412 817812 821009 821161 821482 822249 825825 827833 827994 532055 556087 562434 708513 719928 650088 659371 636430 621983 785543 811449 813509 772445 788844 789911 793904 800385 803199 766814 765776 740768 744900 778597 780654 820671 514341 572846 695985 696063 696016 617345 788795 797272 789052 791101 771647 445766 551567 796248 675570 763840 537820 629260 537975 541105 693624 663550 617755 785029 743647 783539 791833 765577 435740 500013 590495 792412 417707 512936 487821 448076 416901 504282 667469 652482 750330 469172 417749 766006 761880 780580 451590 571221 599758 444205 474828 437295 562200 721909 475516 502045 690406 480697 478554 454459 661004 819086 819446 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.88%) |
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 416901 417707 417749 429809 435016 435740 437295 444205 445766 448076 448625 451590 454459 456261 465444 469172 474828 475516 478554 480697 487821 500013 502045 504282 512936 514341 526011 527435 532055 537820 537975 541105 551567 555215 556087 562200 562434 571221 572846 590495 599758 614646 617345 617755 621983 629260 636430 650088 652482 659371 661004 663550 667469 675570 690406 693624 695985 696016 696063 708513 719928 721909 739263 740768 743647 744900 750330 761150 761880 763840 765577 765776 766006 766814 771647 772445 778597 780580 780654 783539 785029 785543 788795 788844 789052 789911 791101 791833 792412 793904 796248 797272 800385 803199 811449 813509 817763 817775 817812 817919 818968 818991 819004 819086 819344 819446 820671 821009 821161 821412 821471 821482 821499 822136 822249 822769 824366 825825 827833 827994 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov ass public"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов жоп на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов жоп на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
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.