Query Metrics
7
Database Queries
7
Different statements
160.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.92 ms (83.56%) |
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 16762 24289 117513 383583 384888 385278 386598 386872 404090 417255 419103 421113 443111 443947 450257 452695 462215 462738 471770 476698 477480 485818 487613 494935 509372 514611 517823 521672 533892 535824 558078 560988 572355 574473 575941 577638 588889 590337 591008 591015 591025 591049 591527 591530 603817 605754 617592 617757 620505 621868 622886 623987 623997 625890 636156 642234 642237 642260 642271 645928 659349 661320 665230 665600 675393 684531 685448 693257 693648 694194 695826 701210 705317 705371 705403 710325 712512 717853 717914 718849 723745 725101 725160 725468 726232 732906 734587 735948 740514 743866 744804 745596 747797 751471 755216 776402 779459 779651 780555 781002 784228 785183 786897 787043 789444 789585 793095 793654 795980 799966 801446 803658 809016 809548 809575 809766 810965 811082 811470 813118 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (10.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 710325 776402 780555 781002 799966 809766 810965 117513 386598 462738 476698 443111 514611 383583 385278 384888 386872 24289 16762 404090 417255 419103 421113 443947 471770 450257 452695 485818 462215 477480 517823 494935 509372 535824 521672 533892 487613 572355 574473 577638 645928 659349 661320 685448 693257 693648 701210 705371 717853 717914 718849 684531 694194 695826 705317 705403 712512 665230 665600 675393 558078 560988 575941 591008 636156 642237 588889 591049 591527 603817 617592 622886 642260 590337 591015 591025 605754 623987 642234 642271 591530 617757 620505 621868 623997 625890 779459 784228 785183 786897 787043 789444 789585 779651 793095 809016 809548 809575 813118 725160 725468 793654 795980 801446 803658 811082 811470 725101 745596 723745 726232 732906 740514 743866 744804 755216 735948 747797 751471 734587 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.65%) |
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 16762 24289 117513 383583 384888 385278 386598 386872 404090 417255 419103 421113 443111 443947 450257 452695 462215 462738 471770 476698 477480 485818 487613 494935 509372 514611 517823 521672 533892 535824 558078 560988 572355 574473 575941 577638 588889 590337 591008 591015 591025 591049 591527 591530 603817 605754 617592 617757 620505 621868 622886 623987 623997 625890 636156 642234 642237 642260 642271 645928 659349 661320 665230 665600 675393 684531 685448 693257 693648 694194 695826 701210 705317 705371 705403 710325 712512 717853 717914 718849 723745 725101 725160 725468 726232 732906 734587 735948 740514 743866 744804 745596 747797 751471 755216 776402 779459 779651 780555 781002 784228 785183 786897 787043 789444 789585 793095 793654 795980 799966 801446 803658 809016 809548 809575 809766 810965 811082 811470 813118 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кухн"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.