Query Metrics
7
Database Queries
7
Different statements
153.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.27 ms (83.94%) |
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 11393 41776 87974 88788 118237 118436 154195 155257 384223 393684 394536 396231 396784 398041 413053 419403 421366 421582 426689 427447 454802 471832 472777 473054 488721 499872 504681 508924 510561 514618 515785 516426 516495 530060 540911 541096 541328 541394 542124 542701 544829 544961 544963 545411 545459 546257 547453 547465 547471 547477 547501 548723 550284 550555 550895 550940 554889 556842 556892 556907 556908 561019 568267 571166 573936 576479 580176 580207 583586 588514 594619 595860 596610 598115 601542 602241 606503 609920 610314 612070 615946 617969 620611 620901 624197 624925 633755 645019 649556 653216 660364 660369 660380 668663 668690 669058 670356 671008 672944 672952 673257 677322 677333 706411 709628 719573 725382 735555 736022 742224 742459 744033 745129 747153 747673 747920 752679 754902 782854 799007 ] |
||||||||||||||||||||||||||||||
|
14.17 ms (9.20%) |
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 541096 541394 542124 544829 544963 545411 547465 547501 550940 556842 580176 541328 545459 550555 550895 561019 568267 576479 540911 542701 546257 547453 547477 554889 556892 556908 573936 580207 653216 660380 668663 672944 677322 677333 660364 660369 670356 671008 672952 706411 668690 673257 709628 544961 547471 548723 550284 556907 571166 583586 595860 602241 606503 617969 620611 594619 598115 601542 624197 588514 609920 615946 620901 633755 596610 799007 782854 736022 744033 745129 747153 747673 752679 742224 742459 735555 747920 725382 754902 612070 719573 87974 118237 413053 473054 88788 155257 396231 421582 426689 471832 396784 11393 41776 118436 154195 384223 393684 394536 421366 508924 516495 514618 516426 515785 488721 499872 504681 510561 669058 649556 624925 427447 454802 472777 530060 645019 610314 419403 398041 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.78%) |
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 11393 41776 87974 88788 118237 118436 154195 155257 384223 393684 394536 396231 396784 398041 413053 419403 421366 421582 426689 427447 454802 471832 472777 473054 488721 499872 504681 508924 510561 514618 515785 516426 516495 530060 540911 541096 541328 541394 542124 542701 544829 544961 544963 545411 545459 546257 547453 547465 547471 547477 547501 548723 550284 550555 550895 550940 554889 556842 556892 556907 556908 561019 568267 571166 573936 576479 580176 580207 583586 588514 594619 595860 596610 598115 601542 602241 606503 609920 610314 612070 615946 617969 620611 620901 624197 624925 633755 645019 649556 653216 660364 660369 660380 668663 668690 669058 670356 671008 672944 672952 673257 677322 677333 706411 709628 719573 725382 735555 736022 742224 742459 744033 745129 747153 747673 747920 752679 754902 782854 799007 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худую жестко"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худая хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.14%) |
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.