Query Metrics
7
Database Queries
7
Different statements
366.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.51 ms (57.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
134.81 ms (36.74%) |
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 381969 420321 541704 543043 548562 549442 550566 552620 552900 556399 557228 558451 560592 563488 566831 566841 569876 570232 571625 571661 572757 573606 573839 574189 574899 579056 582910 583855 594381 597725 597828 602173 605132 611178 614552 632330 635912 636191 643727 648765 649166 650270 654178 654784 655096 655401 655421 655950 656084 656381 656423 656469 656684 657293 657592 657925 658315 658607 658715 658719 658753 659087 659549 659755 659836 660490 660562 660897 661270 661540 661898 662040 662711 668008 669481 670462 673961 678555 679146 680338 699669 706969 712731 716504 721264 723658 724782 726458 730678 732010 738243 740210 743157 751750 757146 786547 799608 806673 811822 814196 816697 816913 817820 818316 819123 819969 820642 820660 820915 821003 821025 821355 821547 822254 825471 826368 826528 826564 826674 826846 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (4.24%) |
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 548562 550566 557228 560592 566841 569876 570232 574189 574899 583855 541704 543043 549442 556399 558451 563488 566831 571625 571661 573606 582910 655401 655950 657293 657925 658315 658607 658719 659549 659755 659836 661540 662711 670462 678555 679146 706969 721264 649166 655421 656469 657592 658715 658753 659087 660490 660897 661898 662040 673961 680338 699669 648765 650270 654178 654784 655096 656084 656381 656423 656684 660562 661270 668008 669481 712731 716504 552620 552900 572757 573839 579056 597725 594381 605132 643727 602173 632330 635912 636191 597828 614552 786547 806673 799608 811822 732010 740210 724782 730678 751750 726458 738243 743157 757146 611178 381969 420321 817820 820642 820660 825471 723658 826368 826528 826674 826564 819969 821003 821547 822254 826846 814196 816697 816913 818316 819123 820915 821025 821355 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.63%) |
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 381969 420321 541704 543043 548562 549442 550566 552620 552900 556399 557228 558451 560592 563488 566831 566841 569876 570232 571625 571661 572757 573606 573839 574189 574899 579056 582910 583855 594381 597725 597828 602173 605132 611178 614552 632330 635912 636191 643727 648765 649166 650270 654178 654784 655096 655401 655421 655950 656084 656381 656423 656469 656684 657293 657592 657925 658315 658607 658715 658719 658753 659087 659549 659755 659836 660490 660562 660897 661270 661540 661898 662040 662711 668008 669481 670462 673961 678555 679146 680338 699669 706969 712731 716504 721264 723658 724782 726458 730678 732010 738243 740210 743157 751750 757146 786547 799608 806673 811822 814196 816697 816913 817820 818316 819123 819969 820642 820660 820915 821003 821025 821355 821547 822254 825471 826368 826528 826564 826674 826846 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny small"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.38%) |
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.