Query Metrics
7
Database Queries
7
Different statements
146.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.62 ms (84.54%) |
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 3512 3599 391749 396789 398639 401774 403147 403266 469358 469770 530176 533898 534583 534621 534628 539751 539752 543385 544981 545071 547004 551875 552985 555471 557506 557805 563088 567542 567874 573153 574455 576537 588185 589822 594552 594626 596641 604664 605700 605786 607072 607703 613920 618638 620468 623415 623951 625107 627951 628826 629884 632232 632949 634444 634691 635414 635527 636160 636179 636324 637462 639231 639578 641641 641903 643949 643972 644127 644907 648474 656813 659990 661340 665048 694112 695417 701947 704097 708513 710105 712705 716713 717430 717437 718346 718847 719530 719538 719864 749898 775002 775701 776100 776221 778324 778457 781073 788053 789604 797363 799831 803717 818082 819277 819324 819412 819929 823348 823588 823616 824373 824547 824623 824772 826811 827319 828764 ] |
||||||||||||||||||||||||||||||
|
13.05 ms (8.93%) |
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 589822 613920 623951 628826 632949 634691 635414 636160 636179 643949 596641 604664 618638 620468 635527 641641 644127 625107 627951 628493 594552 605786 607703 632232 637462 639578 641903 643972 803717 799831 749898 605700 623415 701947 403147 710105 534628 775002 3512 3599 398639 403266 824547 530176 567542 659990 712705 716713 594626 401774 391749 396789 819277 819412 824373 824772 644907 819929 823348 823588 823616 824623 826811 827319 818082 819324 828764 828652 469358 534583 533898 534621 539752 539751 469770 543385 547004 567874 576537 544981 557805 563088 574455 552985 557506 573153 656813 694112 708513 717437 718847 661340 665048 704097 717430 718346 719538 648474 695417 719530 719864 545071 551875 555471 607072 629884 636324 634444 588185 639231 778324 778457 788053 789604 797363 775701 776100 776183 776221 781073 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (2.03%) |
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 3512 3599 391749 396789 398639 401774 403147 403266 469358 469770 530176 533898 534583 534621 534628 539751 539752 543385 544981 545071 547004 551875 552985 555471 557506 557805 563088 567542 567874 573153 574455 576537 588185 589822 594552 594626 596641 604664 605700 605786 607072 607703 613920 618638 620468 623415 623951 625107 627951 628826 629884 632232 632949 634444 634691 635414 635527 636160 636179 636324 637462 639231 639578 641641 641903 643949 643972 644127 644907 648474 656813 659990 661340 665048 694112 695417 701947 704097 708513 710105 712705 716713 717430 717437 718346 718847 719530 719538 719864 749898 775002 775701 776100 776221 778324 778457 781073 788053 789604 797363 799831 803717 818082 819277 819324 819412 819929 823348 823588 823616 824373 824547 824623 824772 826811 827319 828764 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"настоящий любитель до…"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральные любительск"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.94%) |
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.