Query Metrics
7
Database Queries
7
Different statements
202.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.32 ms (87.26%) |
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 4123 11330 15364 28382 183239 263536 371061 384872 387226 389347 389791 390257 398104 399964 401874 407793 428096 450672 451608 465518 469133 499780 500892 502788 510830 516159 517231 518527 524787 526699 530047 531909 533612 536449 537494 538099 543085 553684 556460 558218 558226 566561 568651 574026 582438 584508 588118 588662 591965 597847 602440 604561 604993 612227 615453 616059 617526 621289 624180 628656 636049 636888 645365 649937 652992 655295 656102 665741 667385 667752 671349 675672 676657 680544 687880 688976 692174 692733 692745 693665 695310 699262 699518 701619 702106 705257 706069 706727 707856 710119 714533 714582 716278 717653 723189 727571 733282 734167 738840 742321 744450 753012 773678 779120 784651 785018 795301 796062 805780 808269 811706 813747 814026 814706 818535 825049 825067 828478 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (7.56%) |
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 795301 390257 582438 499780 543085 617526 808269 785018 784651 738840 753012 811706 825049 818535 826340 825067 828478 636888 616059 4123 15364 183239 11330 389347 398104 401874 428096 469133 705257 805780 779120 727571 733282 796062 734167 742321 744450 773678 516159 384872 263536 371061 28382 389791 387226 399964 407793 814706 813747 814026 465518 451608 450672 531909 533612 538099 500892 502788 510830 524787 536449 537494 518527 530047 517231 526699 553684 558218 566561 568651 558226 574026 584508 645365 655295 665741 667385 667752 675672 688976 692733 692745 699518 701619 706069 706727 713291 717653 723189 649937 656102 676657 680544 695310 710119 714533 716278 652992 671349 687880 692174 693665 699262 702106 707856 714582 556460 591965 602440 615453 628656 636049 588118 604561 612227 621289 624180 588662 597847 604993 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.61%) |
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 4123 11330 15364 28382 183239 263536 371061 384872 387226 389347 389791 390257 398104 399964 401874 407793 428096 450672 451608 465518 469133 499780 500892 502788 510830 516159 517231 518527 524787 526699 530047 531909 533612 536449 537494 538099 543085 553684 556460 558218 558226 566561 568651 574026 582438 584508 588118 588662 591965 597847 602440 604561 604993 612227 615453 616059 617526 621289 624180 628656 636049 636888 645365 649937 652992 655295 656102 665741 667385 667752 671349 675672 676657 680544 687880 688976 692174 692733 692745 693665 695310 699262 699518 701619 702106 705257 706069 706727 707856 710119 714533 714582 716278 717653 723189 727571 733282 734167 738840 742321 744450 753012 773678 779120 784651 785018 795301 796062 805780 808269 811706 813747 814026 814706 818535 825049 825067 828478 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"and big ass"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.