Query Metrics
7
Database Queries
7
Different statements
198.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.64 ms (87.50%) |
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 88439 386095 405483 416402 420037 423497 427233 450651 452662 465676 486307 501137 509365 510309 513226 514620 522526 523368 523376 525335 529838 542892 543661 544073 544783 544896 550535 550645 552446 553374 555635 556342 568905 575662 579839 582648 582654 588477 591006 592584 594639 600795 601981 602137 605045 607836 613945 622367 631653 634033 634892 639481 640908 641319 644217 644624 659177 669545 670008 679891 680234 684847 686323 689943 692756 695552 697216 698386 699480 700842 701579 705335 708495 709844 713288 718910 719030 719790 723288 723713 725487 725493 730078 734011 734353 744809 746175 749437 755085 768092 778932 782654 782874 783288 783989 785251 786929 788616 790760 791755 792463 792701 792788 794035 796576 798463 805108 807076 807241 809608 809952 812051 812435 812492 813363 814970 819186 825131 827182 827185 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (7.08%) |
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 768092 639481 698386 699480 701579 708495 718910 783288 785251 792463 792788 798463 807076 809952 812435 812492 420037 405483 88439 452662 601981 522526 386095 423497 416402 427233 827185 827182 814970 819186 825131 450651 465676 486307 509365 514620 523376 501137 513226 523368 525335 529838 510309 542892 544783 550645 582648 575662 582654 543661 544073 553374 556342 568905 659177 669545 679891 689943 692756 705335 719030 723288 695552 697216 709844 713288 670008 680234 684847 686323 700842 719790 544896 550535 552446 555635 579839 594639 622367 634033 634892 644217 591006 602137 631653 644624 588477 607836 640908 641319 592584 600795 605045 613945 782874 783989 788616 778932 782654 796576 805108 813363 723713 730078 734011 734353 744809 746175 749437 755085 786929 790760 791755 792701 794035 807241 809608 812051 725487 725493 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.52%) |
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 88439 386095 405483 416402 420037 423497 427233 450651 452662 465676 486307 501137 509365 510309 513226 514620 522526 523368 523376 525335 529838 542892 543661 544073 544783 544896 550535 550645 552446 553374 555635 556342 568905 575662 579839 582648 582654 588477 591006 592584 594639 600795 601981 602137 605045 607836 613945 622367 631653 634033 634892 639481 640908 641319 644217 644624 659177 669545 670008 679891 680234 684847 686323 689943 692756 695552 697216 698386 699480 700842 701579 705335 708495 709844 713288 718910 719030 719790 723288 723713 725487 725493 730078 734011 734353 744809 746175 749437 755085 768092 778932 782654 782874 783288 783989 785251 786929 788616 790760 791755 792463 792701 792788 794035 796576 798463 805108 807076 807241 809608 809952 812051 812435 812492 813363 814970 819186 825131 827182 827185 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер sexy"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam sexy"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер sexy"
]
|
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.