Query Metrics
7
Database Queries
7
Different statements
362.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.82 ms (58.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"молодые 18 19 старый лет"
]
|
||||||||||||||||||||||||||||||
|
122.35 ms (33.71%) |
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 7088 34884 60096 392206 393046 396811 400438 402036 418484 429292 429949 465823 470733 474767 500453 524016 527864 535972 541350 544873 545547 546992 550447 552232 554236 556285 569365 573842 574289 574808 575636 577905 577989 578709 585822 590328 593919 594286 595538 614665 618144 622303 629497 629727 630478 643879 644686 645728 652424 656779 657158 668189 670762 676499 676524 676532 676929 677026 677750 693506 709459 715247 720104 721225 721756 723010 728759 729705 730432 730676 732401 735092 735743 737763 740281 741320 742075 744314 744320 744882 746932 748649 755130 755553 755853 756488 760288 761861 762015 764406 766517 773029 773277 774811 777474 778266 778510 778518 779926 780808 782440 785171 785242 787941 789003 789845 791325 791748 794079 795611 796230 797473 797573 802522 804197 804853 807924 812478 ] |
||||||||||||||||||||||||||||||
|
19.27 ms (5.31%) |
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 550447 60096 527864 535972 544873 554236 575636 577905 552232 556285 541350 569365 676929 723010 645728 657158 670762 676524 693506 709459 720104 652424 676499 676532 677026 677750 721225 545547 574289 577989 585822 590328 593919 630478 594286 622303 629727 595538 614665 618144 774811 777474 778510 778518 779926 785171 791325 794079 797573 782440 787941 802522 807924 729705 730676 742075 744882 766517 791748 797473 732401 735743 740281 755853 761861 762015 773277 735092 737763 748649 755553 760288 764406 773029 728759 730432 741320 746932 755130 756488 643879 706529 721756 780808 785242 789003 795611 804197 804853 812478 7088 392206 761775 629497 744320 400438 418484 474767 578709 465823 470733 524016 574808 644686 656779 429292 500453 668189 744314 396811 429949 715247 573842 789845 778266 796230 393046 546992 402036 34884 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (0.83%) |
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 7088 34884 60096 392206 393046 396811 400438 402036 418484 429292 429949 465823 470733 474767 500453 524016 527864 535972 541350 544873 545547 546992 550447 552232 554236 556285 569365 573842 574289 574808 575636 577905 577989 578709 585822 590328 593919 594286 595538 614665 618144 622303 629497 629727 630478 643879 644686 645728 652424 656779 657158 668189 670762 676499 676524 676532 676929 677026 677750 693506 709459 715247 720104 721225 721756 723010 728759 729705 730432 730676 732401 735092 735743 737763 740281 741320 742075 744314 744320 744882 746932 748649 755130 755553 755853 756488 760288 761861 762015 764406 766517 773029 773277 774811 777474 778266 778510 778518 779926 780808 782440 785171 785242 787941 789003 789845 791325 791748 794079 795611 796230 797473 797573 802522 804197 804853 807924 812478 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодые 18летними с дедами"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые 18 19 старый лет"
]
|
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.