Query Metrics
7
Database Queries
7
Different statements
160.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.25 ms (84.14%) |
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 130089 130126 416824 421228 421264 428113 442987 454388 460043 474248 479479 480206 494799 497602 498097 499249 503379 505095 507024 509446 510774 527389 528529 530184 534809 535548 537857 544062 545983 547026 548231 555782 559729 560319 561589 564392 566449 570888 571194 571972 576639 579452 583421 593270 593571 594340 595113 601664 604576 606766 606956 613163 613172 618236 621074 622876 622935 629522 635280 639306 643653 648794 651664 662052 678173 682248 683183 690786 690809 690839 692326 692335 693049 693055 693072 694075 694181 694203 694221 695276 695613 697382 697806 697986 697988 698531 699730 699755 714289 716299 719207 720471 723714 725095 729123 731681 737152 739767 740150 741283 768462 769418 774831 775905 779986 790391 792472 793446 794375 797231 797324 800608 800752 801064 806268 808727 808730 809243 809497 810336 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (9.39%) |
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 635280 618236 595113 606956 790391 793446 810336 725095 769418 768462 739767 639306 797324 808727 474248 498097 499249 510774 560319 561589 651664 682248 690809 693055 697382 690786 692326 694203 695613 698531 719207 662052 678173 693049 697986 697988 699755 720471 593571 622876 629522 792472 723714 613163 622935 716299 774831 775905 801064 809497 130126 479479 454388 527389 537857 497602 530184 503379 564392 545983 547026 566449 571194 570888 571972 579452 583421 648794 695276 683183 690839 694221 714289 559729 593270 601664 643653 613172 621074 594340 779986 808730 809243 797231 800608 729123 806268 731681 737152 740150 741283 606766 697806 699730 794375 800752 130089 416824 509446 421228 421264 428113 442987 604576 460043 507024 528529 535548 494799 505095 534809 480206 544062 555782 548231 576639 692335 693072 694075 694181 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.82%) |
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 130089 130126 416824 421228 421264 428113 442987 454388 460043 474248 479479 480206 494799 497602 498097 499249 503379 505095 507024 509446 510774 527389 528529 530184 534809 535548 537857 544062 545983 547026 548231 555782 559729 560319 561589 564392 566449 570888 571194 571972 576639 579452 583421 593270 593571 594340 595113 601664 604576 606766 606956 613163 613172 618236 621074 622876 622935 629522 635280 639306 643653 648794 651664 662052 678173 682248 683183 690786 690809 690839 692326 692335 693049 693055 693072 694075 694181 694203 694221 695276 695613 697382 697806 697986 697988 698531 699730 699755 714289 716299 719207 720471 723714 725095 729123 731681 737152 739767 740150 741283 768462 769418 774831 775905 779986 790391 792472 793446 794375 797231 797324 800608 800752 801064 806268 808727 808730 809243 809497 810336 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тут он 4 к"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"четыр"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.