Query Metrics
7
Database Queries
7
Different statements
191.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.27 ms (85.71%) |
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 34697 78994 95982 96872 118234 130289 167756 192888 193662 310758 378046 383188 389231 391922 394586 396595 397302 400960 422331 426511 449073 452397 464951 467715 474673 486768 508679 529897 531877 531970 532221 532746 533594 533794 534328 537220 547477 567396 573932 576981 583712 583729 588507 592027 596108 599993 599999 606405 606514 610540 611307 613825 628347 640858 641685 649543 652885 653362 660427 665973 667981 673365 677706 682250 695249 697369 699751 706611 707292 710500 711891 714626 718838 720139 720207 720264 723497 724309 725400 729819 738830 739860 742286 742356 744432 745245 748357 748475 760507 761167 761781 768186 770234 770823 771358 775981 782677 788294 790389 790842 796221 797080 801934 801948 801950 804700 806943 808093 810829 814895 815723 816222 816568 817877 818848 820678 820771 820778 824130 827201 ] |
||||||||||||||||||||||||||||||
|
15.61 ms (8.15%) |
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 583729 193662 95982 400960 449073 474673 378046 426511 391922 817877 532746 534328 531970 720264 611307 729819 167756 394586 310758 78994 34697 389231 396595 422331 815723 820678 824130 827201 816568 820771 816222 818848 820778 452397 533794 531877 532221 533594 537220 529897 508679 464951 467715 486768 567396 583712 573932 576981 547477 653362 699751 707292 710500 660427 665973 667981 677706 697369 706611 711891 720207 723497 649543 652885 673365 682250 695249 718838 599993 599999 588507 610540 592027 596108 606405 628347 640858 641685 788294 790389 801950 775981 801934 804700 810829 742286 745245 761167 761781 806943 808093 748357 768186 724309 725400 738830 742356 739860 748475 760507 770823 606514 613825 714626 720139 790842 796221 797080 801948 397302 192888 96872 118234 814895 782677 770234 771358 744432 383188 130289 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.81%) |
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 34697 78994 95982 96872 118234 130289 167756 192888 193662 310758 378046 383188 389231 391922 394586 396595 397302 400960 422331 426511 449073 452397 464951 467715 474673 486768 508679 529897 531877 531970 532221 532746 533594 533794 534328 537220 547477 567396 573932 576981 583712 583729 588507 592027 596108 599993 599999 606405 606514 610540 611307 613825 628347 640858 641685 649543 652885 653362 660427 665973 667981 673365 677706 682250 695249 697369 699751 706611 707292 710500 711891 714626 718838 720139 720207 720264 723497 724309 725400 729819 738830 739860 742286 742356 744432 745245 748357 748475 760507 761167 761781 768186 770234 770823 771358 775981 782677 788294 790389 790842 796221 797080 801934 801948 801950 804700 806943 808093 810829 814895 815723 816222 816568 817877 818848 820678 820771 820778 824130 827201 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother double"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин double"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин double"
]
|
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.