Query Metrics
7
Database Queries
7
Different statements
149.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.66 ms (82.88%) |
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 480031 512079 521764 528082 533794 535534 537343 547066 561872 566878 568157 571031 578208 596108 612079 613000 614305 618858 621319 622374 622377 626253 629923 632041 632060 633738 634209 634553 634600 636553 637154 645232 645352 646833 647976 650011 665747 675479 685687 692471 694469 695276 699606 699607 701237 704925 705722 710308 710920 712053 714117 714124 715523 715533 716205 716247 717820 718838 720343 721116 721990 724037 724232 724310 725601 725605 726366 726483 726638 726858 726871 727532 727742 728345 732293 733557 735908 737178 737202 742685 750637 751017 755847 755994 756410 758794 761167 765465 765509 770156 770188 771332 773796 773974 775140 775191 775787 777065 790860 790986 790993 793497 793534 794788 794796 794824 797585 800384 800402 801934 802314 803522 805634 805962 814037 817492 821193 825587 826015 826246 ] |
||||||||||||||||||||||||||||||
|
15.11 ms (10.13%) |
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 817492 821193 825587 826015 826246 814037 480031 528082 533794 512079 537343 521764 535534 561872 568157 571031 547066 566878 578208 645352 646833 675479 695276 699607 715523 716205 716247 721990 647976 650011 685687 692471 699606 701237 704925 710308 714117 645232 665747 694469 705722 712053 714124 718838 720343 721116 613000 618858 636553 612079 614305 621319 622374 633738 634553 637154 629923 632041 632060 634209 634600 596108 622377 626253 775787 790986 793497 802314 805962 775140 790860 794788 797585 800402 801934 803522 805634 724037 725601 726871 727532 727742 735908 750637 761167 770188 790993 793534 794796 794824 800384 751017 771332 726366 728345 733557 755847 756410 765465 765509 724310 726638 732293 737178 737202 755994 770156 724232 725605 726483 726858 742685 758794 773796 773974 710920 715533 717820 775191 777065 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.96%) |
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 480031 512079 521764 528082 533794 535534 537343 547066 561872 566878 568157 571031 578208 596108 612079 613000 614305 618858 621319 622374 622377 626253 629923 632041 632060 633738 634209 634553 634600 636553 637154 645232 645352 646833 647976 650011 665747 675479 685687 692471 694469 695276 699606 699607 701237 704925 705722 710308 710920 712053 714117 714124 715523 715533 716205 716247 717820 718838 720343 721116 721990 724037 724232 724310 725601 725605 726366 726483 726638 726858 726871 727532 727742 728345 732293 733557 735908 737178 737202 742685 750637 751017 755847 755994 756410 758794 761167 765465 765509 770156 770188 771332 773796 773974 775140 775191 775787 777065 790860 790986 790993 793497 793534 794788 794796 794824 797585 800384 800402 801934 802314 803522 805634 805962 814037 817492 821193 825587 826015 826246 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy boobs anal"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy boobs анал"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy boobs анал"
]
|
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.