Query Metrics
7
Database Queries
7
Different statements
354.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.00 ms (58.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf ride"
]
|
||||||||||||||||||||||||||||||
|
119.52 ms (33.68%) |
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 52454 233446 385245 385596 394012 398364 405488 406765 407187 435503 438028 440943 441570 457036 474248 475282 475699 479123 492304 493443 495234 498210 506697 511378 522474 531457 540808 542493 547142 552370 556761 560369 564287 577458 587299 588652 590765 595131 595255 596389 596884 597917 598095 599786 600238 600912 604909 605060 605892 606933 612482 613690 616879 618553 631728 636141 640302 645365 648810 650598 650935 668794 670208 671725 672147 681508 704558 712116 715485 717064 718130 718822 724188 727548 730297 733387 738468 741186 743010 748653 755203 755843 757274 757483 759490 759739 760598 762437 765725 766696 768387 781785 785094 785188 788128 790165 790889 792419 792608 792618 794439 796326 798822 798829 801513 803877 804000 804005 804394 805291 807861 807876 813206 813688 815345 815446 815823 817571 817834 825611 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (4.98%) |
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 506697 385245 405488 790889 798829 233446 768387 785094 385596 394012 817834 825611 560369 681508 704558 712116 556761 588652 600912 599786 598095 605060 596884 792419 796326 794439 724188 733387 741186 757274 788128 790165 792608 755843 727548 738468 730297 618553 804000 587299 807876 441570 815446 540808 475282 645365 717064 671725 672147 718130 596389 631728 590765 640302 595131 600238 804005 801513 748653 760598 766696 792618 805291 813206 743010 807861 498210 406765 407187 815823 648810 668794 715485 718822 650598 650935 605892 636141 595255 613690 606933 798822 804394 759490 762437 759739 755203 757483 765725 612482 803877 479123 438028 495234 435503 493443 547142 597917 604909 440943 522474 52454 398364 817571 813688 815345 474248 457036 475699 492304 511378 531457 564287 542493 577458 670208 552370 616879 781785 785188 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (0.94%) |
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 52454 233446 385245 385596 394012 398364 405488 406765 407187 435503 438028 440943 441570 457036 474248 475282 475699 479123 492304 493443 495234 498210 506697 511378 522474 531457 540808 542493 547142 552370 556761 560369 564287 577458 587299 588652 590765 595131 595255 596389 596884 597917 598095 599786 600238 600912 604909 605060 605892 606933 612482 613690 616879 618553 631728 636141 640302 645365 648810 650598 650935 668794 670208 671725 672147 681508 704558 712116 715485 717064 718130 718822 724188 727548 730297 733387 738468 741186 743010 748653 755203 755843 757274 757483 759490 759739 760598 762437 765725 766696 768387 781785 785094 785188 788128 790165 790889 792419 792608 792618 794439 796326 798822 798829 801513 803877 804000 804005 804394 805291 807861 807876 813206 813688 815345 815446 815823 817571 817834 825611 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf ride"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf ride"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.46%) |
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.