Query Metrics
7
Database Queries
7
Different statements
230.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.34 ms (89.35%) |
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 501513 540760 555747 557005 558460 559478 559739 563882 565205 603782 603841 611491 618306 622323 623319 623479 630329 633241 637504 642259 647316 661894 662857 680730 680806 680808 683496 684419 685448 685460 685478 687107 687680 693153 703245 703625 707927 708749 709872 712380 712655 712943 713151 715596 717378 719792 729413 730103 732906 733221 733516 734051 734397 734404 734789 736745 739582 740533 741788 742334 742618 742632 745985 747625 747799 749676 754644 757740 757870 758389 758426 758853 759518 761300 761662 761872 762004 763431 766150 766631 767611 768141 770500 773059 773786 773910 777028 778754 779485 782931 783063 787619 788054 788586 790084 790542 791811 793314 796144 797550 797565 797645 798055 798788 799681 800396 800582 800794 800801 801611 802022 802144 806590 809683 812155 812335 812437 813413 814663 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (6.17%) |
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 758853 799681 757740 603782 773910 684419 557005 662857 703625 680806 713151 623319 788586 800582 742334 729413 742618 758389 709872 796144 800801 802144 687680 637504 791811 797565 801611 730103 733221 747625 734051 734404 747799 687107 693153 812335 788054 739582 680730 680808 812437 777028 734789 763431 770500 745985 754644 800794 798055 779485 712380 501513 540760 647316 708749 568067 642259 611491 758426 790084 740533 736745 759518 806590 809683 559739 712943 719792 555747 559478 778754 800396 741788 797645 761872 742632 761300 761662 773786 683496 707927 685478 717378 793314 797550 757870 623479 715596 787619 712655 814663 565205 685448 661894 685460 633241 802022 766150 768141 783063 558460 782931 812155 767611 603841 622323 618306 630329 798788 790542 813413 773059 732906 733516 766631 762004 703245 563882 734397 749676 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.38%) |
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 501513 540760 555747 557005 558460 559478 559739 563882 565205 603782 603841 611491 618306 622323 623319 623479 630329 633241 637504 642259 647316 661894 662857 680730 680806 680808 683496 684419 685448 685460 685478 687107 687680 693153 703245 703625 707927 708749 709872 712380 712655 712943 713151 715596 717378 719792 729413 730103 732906 733221 733516 734051 734397 734404 734789 736745 739582 740533 741788 742334 742618 742632 745985 747625 747799 749676 754644 757740 757870 758389 758426 758853 759518 761300 761662 761872 762004 763431 766150 766631 767611 768141 770500 773059 773786 773910 777028 778754 779485 782931 783063 787619 788054 788586 790084 790542 791811 793314 796144 797550 797565 797645 798055 798788 799681 800396 800582 800794 800801 801611 802022 802144 806590 809683 812155 812335 812437 813413 814663 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мое ебля"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мо секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.64%) |
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.