Query Metrics
7
Database Queries
7
Different statements
224.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.65 ms (83.12%) |
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 119987 388401 451741 460770 461738 473931 512295 512827 541073 552145 552637 556911 561685 561730 561813 561880 561903 563647 565274 565552 565953 566031 568121 568357 573839 574481 574507 574841 575162 575165 575505 576047 576274 576324 576407 576412 579182 580236 587858 590821 591841 592071 594381 595418 596459 596583 597233 597469 598086 598444 598675 598782 598796 600167 603584 621066 621451 629029 635061 635117 635742 639699 644311 644674 652591 652605 652882 655096 656684 659161 659412 659836 660562 661270 667747 668370 671656 675037 675797 680198 696228 696400 699026 699505 699587 700176 700282 713320 714449 716027 721264 724727 727824 728322 730678 742144 743180 743221 745503 746978 747576 753031 753307 753339 753348 753395 753397 753398 753404 753831 753885 759639 760909 766461 766959 772860 785772 796227 828324 828626 ] |
||||||||||||||||||||||||||||||
|
25.36 ms (11.29%) |
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 561880 568357 575165 576324 541073 561685 568121 576047 680198 675797 696228 716027 561903 576274 592071 598675 597469 598444 595418 598782 579182 828324 587858 644674 696400 743180 753404 753348 753397 753885 753398 728322 745503 828626 598086 644311 796227 512827 556911 714449 451741 759639 652605 652882 699587 591841 598796 785772 747576 753031 742144 727824 575505 552637 671656 574481 621066 461738 119987 700282 753831 565953 603584 596583 597233 600167 659836 721264 652591 655096 656684 660562 661270 675037 573839 594381 629029 724727 730678 576412 460770 576407 563647 596459 473931 639699 512295 565552 659161 635117 746978 667747 635742 743221 552145 621451 700176 753307 753339 753395 388401 699505 713320 668370 635061 766461 766959 772860 760909 699026 574507 561813 566031 574841 561730 565274 575162 580236 659412 590821 ] |
||||||||||||||||||||||||||||||
|
4.61 ms (2.05%) |
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 119987 388401 451741 460770 461738 473931 512295 512827 541073 552145 552637 556911 561685 561730 561813 561880 561903 563647 565274 565552 565953 566031 568121 568357 573839 574481 574507 574841 575162 575165 575505 576047 576274 576324 576407 576412 579182 580236 587858 590821 591841 592071 594381 595418 596459 596583 597233 597469 598086 598444 598675 598782 598796 600167 603584 621066 621451 629029 635061 635117 635742 639699 644311 644674 652591 652605 652882 655096 656684 659161 659412 659836 660562 661270 667747 668370 671656 675037 675797 680198 696228 696400 699026 699505 699587 700176 700282 713320 714449 716027 721264 724727 727824 728322 730678 742144 743180 743221 745503 746978 747576 753031 753307 753339 753348 753395 753397 753398 753404 753831 753885 759639 760909 766461 766959 772860 785772 796227 828324 828626 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small teen 18"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая teen 18"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая teen 18"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.83%) |
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.