Query Metrics
7
Database Queries
7
Different statements
182.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.11 ms (84.00%) |
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 428940 543043 544482 548562 548780 550566 552900 553503 554264 556399 557228 559208 560592 560598 560755 563488 566831 566841 567969 569875 569876 570232 570246 570565 570568 570636 571301 571625 571648 571661 573606 573778 573839 574189 574899 580664 582910 583855 594381 597725 597828 601816 603679 605132 605523 611178 619420 621451 623042 632330 635912 636191 643727 649166 650270 652591 654432 654784 655356 655401 655421 655950 656029 656084 656381 656423 656469 656684 656965 657293 657592 657925 658315 658344 658556 658607 658715 658719 658753 659087 659755 660490 660562 661270 661540 661897 662040 662711 663365 669481 670462 670817 671115 671138 673131 673961 674778 675037 678555 679146 706969 716504 721264 723487 724727 724782 727382 730649 732010 740210 743157 748667 751750 765941 786547 799608 810280 810841 811822 ] |
||||||||||||||||||||||||||||||
|
19.38 ms (10.63%) |
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 619420 621451 765941 748667 623042 553503 560598 573778 548780 560755 570565 570568 571648 544482 548562 550566 557228 560592 566841 569876 570232 574189 574899 583855 543043 556399 559208 563488 566831 571625 571661 573606 580664 582910 655401 655950 657293 657925 658315 658344 658607 658719 659755 661540 662711 670462 670817 671138 673131 674778 678555 679146 706969 721264 723487 649166 654432 655421 656029 656469 657592 658556 658715 658753 659087 660490 662040 663365 671115 673961 650270 652591 654784 655356 656084 656381 656423 656684 656965 660562 661270 661897 669481 675037 716504 552900 567969 570636 573839 597725 594381 605132 643727 603679 605523 632330 635912 636191 597828 601816 786547 727382 799608 810280 810841 811822 724727 730649 732010 740210 724782 751750 743157 611178 428940 554264 569875 569904 570246 571301 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.64%) |
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 428940 543043 544482 548562 548780 550566 552900 553503 554264 556399 557228 559208 560592 560598 560755 563488 566831 566841 567969 569875 569876 570232 570246 570565 570568 570636 571301 571625 571648 571661 573606 573778 573839 574189 574899 580664 582910 583855 594381 597725 597828 601816 603679 605132 605523 611178 619420 621451 623042 632330 635912 636191 643727 649166 650270 652591 654432 654784 655356 655401 655421 655950 656029 656084 656381 656423 656469 656684 656965 657293 657592 657925 658315 658344 658556 658607 658715 658719 658753 659087 659755 660490 660562 661270 661540 661897 662040 662711 663365 669481 670462 670817 671115 671138 673131 673961 674778 675037 678555 679146 706969 716504 721264 723487 724727 724782 727382 730649 732010 740210 743157 748667 751750 765941 786547 799608 810280 810841 811822 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая hair"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая hair"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small hair"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.78%) |
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.