Query Metrics
7
Database Queries
7
Different statements
200.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.50 ms (88.85%) |
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 400015 414643 424191 425299 449335 460114 466686 468999 505186 514394 514978 515045 522931 530892 531499 536886 538535 543132 548489 556948 557465 560163 565232 566063 568410 577318 577463 577976 586966 589077 591721 592874 606055 608558 609966 610615 613273 630106 630286 632766 633848 636333 649702 654180 666655 666660 675584 675826 686091 693248 744089 748160 763804 763957 764843 765853 770653 770792 772963 774494 774994 777210 777675 778471 779566 779596 779843 780214 783164 783992 784087 785987 786467 786816 789855 790510 791124 791516 793166 793295 793999 794068 797675 798616 799976 800291 807279 807298 808815 809760 810780 810882 811204 811395 811500 813509 815062 817952 817969 817993 819955 820444 820466 820870 820944 820965 821181 821673 822120 822193 822249 822439 822547 822913 823145 823290 823414 823516 827877 827914 ] |
||||||||||||||||||||||||||||||
|
12.74 ms (6.34%) |
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 530892 531499 556948 566063 568410 649702 548489 608558 632766 633848 610615 630106 636333 778471 779566 774994 793295 748160 784087 791516 811500 765853 770653 609966 797675 798616 810780 425299 449335 468999 414643 424191 514394 515045 505186 522931 514978 817969 817993 821673 822193 817952 820965 822120 822547 823290 819955 820466 820870 823516 820444 820944 821181 822249 822439 822913 823145 823414 827877 827914 538535 460114 543132 666660 675584 693248 654180 666655 686091 560163 565232 577463 606055 630286 774494 777210 777675 785987 791124 793166 799976 807279 779843 807298 813509 770792 783164 786816 789855 793999 810882 811395 763957 764843 772963 744089 763804 779596 780214 786467 790510 794068 800291 808815 809760 811204 400015 557465 592874 586966 613273 783992 815062 536886 466686 577318 577976 675826 589077 591721 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.51%) |
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 400015 414643 424191 425299 449335 460114 466686 468999 505186 514394 514978 515045 522931 530892 531499 536886 538535 543132 548489 556948 557465 560163 565232 566063 568410 577318 577463 577976 586966 589077 591721 592874 606055 608558 609966 610615 613273 630106 630286 632766 633848 636333 649702 654180 666655 666660 675584 675826 686091 693248 744089 748160 763804 763957 764843 765853 770653 770792 772963 774494 774994 777210 777675 778471 779566 779596 779843 780214 783164 783992 784087 785987 786467 786816 789855 790510 791124 791516 793166 793295 793999 794068 797675 798616 799976 800291 807279 807298 808815 809760 810780 810882 811204 811395 811500 813509 815062 817952 817969 817993 819955 820444 820466 820870 820944 820965 821181 821673 822120 822193 822249 822439 822547 822913 823145 823290 823414 823516 827877 827914 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov beauty girl"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов beauty девушк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов beauty девушк"
]
|
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.