Query Metrics
7
Database Queries
7
Different statements
245.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.71 ms (88.82%) |
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 29295 145503 326110 355652 381975 398032 398196 398784 417983 421614 427799 430412 441750 451748 458090 458740 472763 474376 478521 480511 480979 481351 515096 525420 531618 537026 537525 538460 544774 547761 550158 557386 558082 558673 565177 573172 573924 574840 575549 576363 577045 580512 597678 597983 612042 616966 630286 631743 637369 638971 651596 654414 655663 660970 665482 666655 666660 670255 673125 673437 676734 683774 683797 684367 695661 702151 702319 703106 703111 704887 705316 712955 713061 715170 715353 717690 719052 721091 722874 725167 729416 729649 729786 731490 731656 735037 735962 736804 741010 743276 743285 744740 747420 751619 751762 753773 755892 756070 756141 757373 760281 761629 764861 764994 767306 767848 773146 774494 776788 780418 781067 781407 784881 795899 796917 796982 804870 806694 810182 811636 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (6.61%) |
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 480979 531618 537525 577045 544774 655663 665482 666660 703111 715353 721091 673437 676734 695661 703106 712955 666655 670255 631743 630286 774494 795899 741010 756070 761629 757373 764861 767848 729786 743276 729416 760281 773146 731490 743285 744740 764994 717690 780418 781407 810182 145503 451748 398196 458740 458090 480511 565177 705316 597678 637369 398032 421614 326110 472763 398784 427799 29295 417983 525420 557386 576363 573924 574840 597983 474376 478521 481351 430412 537026 355652 381975 441750 515096 538460 550158 558082 573172 575549 547761 651596 673125 683774 702151 702319 660970 683797 684367 713061 654414 704887 715170 719052 722874 558673 580512 638971 612042 616966 776788 781067 784881 796917 796982 806694 725167 804870 811636 729649 731656 756141 735037 751762 753773 755892 735962 736804 751619 767306 747420 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.38%) |
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 29295 145503 326110 355652 381975 398032 398196 398784 417983 421614 427799 430412 441750 451748 458090 458740 472763 474376 478521 480511 480979 481351 515096 525420 531618 537026 537525 538460 544774 547761 550158 557386 558082 558673 565177 573172 573924 574840 575549 576363 577045 580512 597678 597983 612042 616966 630286 631743 637369 638971 651596 654414 655663 660970 665482 666655 666660 670255 673125 673437 676734 683774 683797 684367 695661 702151 702319 703106 703111 704887 705316 712955 713061 715170 715353 717690 719052 721091 722874 725167 729416 729649 729786 731490 731656 735037 735962 736804 741010 743276 743285 744740 747420 751619 751762 753773 755892 756070 756141 757373 760281 761629 764861 764994 767306 767848 773146 774494 776788 780418 781067 781407 784881 795899 796917 796982 804870 806694 810182 811636 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая милая"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая милая"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sweet"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.75%) |
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.