Query Metrics
7
Database Queries
7
Different statements
381.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.22 ms (56.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real большие"
]
|
||||||||||||||||||||||||||||||
|
145.92 ms (38.28%) |
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 204124 274100 400883 401811 421116 478642 478767 483792 488631 493052 520856 529224 529993 530431 533395 534054 534885 539133 539613 554353 561571 572662 575025 575591 605730 622850 622891 625539 628594 632545 635822 659241 666659 668127 668585 670389 674494 679533 681745 682841 688384 690931 693950 707488 710175 712573 714213 714602 714799 716742 719227 719321 721102 721762 722434 724681 726939 727486 728551 730478 730815 730858 732721 733089 733167 734624 735118 736158 736608 737284 737969 741004 741563 742032 743630 744362 745601 746453 747426 750978 753246 755246 756746 759066 760515 761277 763057 769715 775813 779410 780902 785652 788948 798809 799879 799968 801785 802044 807417 808237 813787 813836 818404 820203 820709 821122 821414 821490 821600 822305 823580 824546 824881 824997 825188 825213 825714 826434 827266 827480 ] |
||||||||||||||||||||||||||||||
|
10.28 ms (2.70%) |
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 821600 821490 826434 821414 825188 534054 575591 554353 668127 670389 679533 681745 688384 712573 719321 668585 714602 716742 721762 659241 714213 605730 622850 622891 632545 779410 785652 788948 737284 753246 724681 730815 736608 726939 727486 730478 737969 746453 763057 735118 755246 759066 760515 761277 721102 798809 799879 802044 400883 401811 825213 488631 529993 539133 529224 520856 530431 674494 666659 682841 690931 722434 635822 775813 736158 743630 750978 744362 745601 747426 732721 756746 741563 625539 719227 801785 204124 807417 741004 824881 813836 821122 534885 693950 572662 728551 734624 742032 730858 733089 769715 733167 628594 707488 780902 799968 808237 561571 710175 274100 421116 824997 813787 818404 822305 824546 827480 820203 820709 823580 825714 827266 483792 493052 478642 539613 533395 478767 575025 714799 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (0.68%) |
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 204124 274100 400883 401811 421116 478642 478767 483792 488631 493052 520856 529224 529993 530431 533395 534054 534885 539133 539613 554353 561571 572662 575025 575591 605730 622850 622891 625539 628594 632545 635822 659241 666659 668127 668585 670389 674494 679533 681745 682841 688384 690931 693950 707488 710175 712573 714213 714602 714799 716742 719227 719321 721102 721762 722434 724681 726939 727486 728551 730478 730815 730858 732721 733089 733167 734624 735118 736158 736608 737284 737969 741004 741563 742032 743630 744362 745601 746453 747426 750978 753246 755246 756746 759066 760515 761277 763057 769715 775813 779410 780902 785652 788948 798809 799879 799968 801785 802044 807417 808237 813787 813836 818404 820203 820709 821122 821414 821490 821600 822305 823580 824546 824881 824997 825188 825213 825714 826434 827266 827480 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real big"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real большие"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.36%) |
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.