Query Metrics
7
Database Queries
7
Different statements
153.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.00 ms (86.13%) |
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 13181 383509 385596 385752 388023 403875 421639 441363 452737 457521 457960 458721 482606 500712 511691 524418 526616 547769 556791 557635 557709 558188 558725 569575 575942 576173 576791 582451 582624 588058 593082 595625 596792 599191 603007 603612 604367 611920 612063 620657 621600 623689 627796 628602 643537 660454 661590 665712 666935 675050 680534 680584 694650 700849 706826 709674 714372 716955 720089 724749 724893 734353 734365 734408 734593 736864 738851 739158 739802 739821 740911 742626 743415 745467 746385 748272 756776 759916 763154 767295 767304 767328 767870 769029 769089 772272 775537 776031 777768 778006 780331 780977 783929 784519 784543 786135 787777 789881 789883 791622 792417 793792 794120 798665 799196 803932 804380 804911 807160 809583 809887 812165 816823 819149 819646 819748 826380 826979 827976 ] |
||||||||||||||||||||||||||||||
|
11.01 ms (7.18%) |
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 582624 793792 748272 780331 558725 611920 628602 777768 739821 739802 700849 799196 383509 595625 756776 661590 680584 599191 547769 776031 388023 441363 457960 556791 557709 582451 804380 784519 511691 558188 557635 709674 666935 596792 569575 643537 603612 789883 789881 739158 620657 826979 759916 736864 767295 826380 767870 575942 716955 819748 791622 767304 767328 766501 738851 734408 385596 798665 734593 819149 786135 724893 804911 778006 576173 809583 714372 680534 588058 612063 623689 603007 780977 740911 769089 792417 742626 746385 784543 13181 500712 458721 819646 576791 720089 604367 621600 807160 812165 745467 787777 403875 816823 482606 675050 627796 734353 743415 772272 783929 794120 724749 734365 763154 769029 803932 809887 524418 385752 421639 827976 452737 457521 526616 706826 665712 694650 660454 593082 775537 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.50%) |
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 13181 383509 385596 385752 388023 403875 421639 441363 452737 457521 457960 458721 482606 500712 511691 524418 526616 547769 556791 557635 557709 558188 558725 569575 575942 576173 576791 582451 582624 588058 593082 595625 596792 599191 603007 603612 604367 611920 612063 620657 621600 623689 627796 628602 643537 660454 661590 665712 666935 675050 680534 680584 694650 700849 706826 709674 714372 716955 720089 724749 724893 734353 734365 734408 734593 736864 738851 739158 739802 739821 740911 742626 743415 745467 746385 748272 756776 759916 763154 767295 767304 767328 767870 769029 769089 772272 775537 776031 777768 778006 780331 780977 783929 784519 784543 786135 787777 789881 789883 791622 792417 793792 794120 798665 799196 803932 804380 804911 807160 809583 809887 812165 816823 819149 819646 819748 826380 826979 827976 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"juicy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"juicy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"juicy pussy"
]
|
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.