Query Metrics
7
Database Queries
7
Different statements
167.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.78 ms (85.24%) |
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 417709 419057 445766 460531 470345 472865 472966 486274 486698 489785 491010 500114 500574 505433 506978 507141 512877 514738 520959 523072 523286 523413 525062 525932 527596 528903 531955 533619 534569 534677 535219 537306 546332 546820 546825 548499 550911 551567 558612 562200 563336 565824 567086 570507 572504 572951 573516 583770 598223 606636 607025 607171 608683 613580 617254 619132 622029 622661 626143 627894 632337 633253 636057 644905 645446 648192 649870 650593 651858 661275 663304 665333 668402 672240 675871 676201 677920 680400 692581 698819 707281 710989 715881 717060 718391 719062 720428 721882 726208 727899 730023 735397 736531 738604 739950 741239 743615 745223 751620 754073 756094 760863 761135 765893 767391 769725 789062 798630 799620 809333 813599 813979 814149 817549 817981 818738 821027 821538 823121 823515 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (8.19%) |
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 619132 813979 470345 535219 506978 523072 486274 489785 572504 573516 570507 649870 698819 707281 563336 608683 607171 622029 736531 760863 761135 743615 633253 721882 417709 419057 821027 644905 813599 817549 814149 823121 823515 817981 818738 821538 472865 533619 523413 534569 507141 534677 528903 531955 472966 546825 562200 550911 572951 546820 558612 650593 651858 661275 648192 665333 675871 676201 715881 717060 718391 663304 677920 710989 720428 627894 632337 636057 607025 798630 799620 809333 730023 756094 789062 727899 754073 765893 767391 735397 738604 739950 769725 726208 741239 751620 745223 613580 617254 719062 523286 668402 567086 525932 486698 445766 491010 500574 505433 514738 525062 537306 527596 520959 500114 512877 546332 551567 583770 565824 645446 680400 672240 692581 606636 598223 622661 626143 460531 548499 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.77%) |
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 417709 419057 445766 460531 470345 472865 472966 486274 486698 489785 491010 500114 500574 505433 506978 507141 512877 514738 520959 523072 523286 523413 525062 525932 527596 528903 531955 533619 534569 534677 535219 537306 546332 546820 546825 548499 550911 551567 558612 562200 563336 565824 567086 570507 572504 572951 573516 583770 598223 606636 607025 607171 608683 613580 617254 619132 622029 622661 626143 627894 632337 633253 636057 644905 645446 648192 649870 650593 651858 661275 663304 665333 668402 672240 675871 676201 677920 680400 692581 698819 707281 710989 715881 717060 718391 719062 720428 721882 726208 727899 730023 735397 736531 738604 739950 741239 743615 745223 751620 754073 756094 760863 761135 765893 767391 769725 789062 798630 799620 809333 813599 813979 814149 817549 817981 818738 821027 821538 823121 823515 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock in public"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock на улиц"
]
|
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.