Query Metrics
7
Database Queries
7
Different statements
182.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.32 ms (85.17%) |
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 440632 452284 572331 581403 586759 593701 593872 599134 603772 604418 607099 608818 626049 626114 626930 630043 630451 637567 645765 655159 656801 657160 660403 665831 669288 669309 676654 676656 677624 684492 695733 695745 696107 707446 709922 710159 712174 714711 715807 720157 720216 724050 725416 726869 726933 728356 728555 737553 740287 740876 746555 749717 752121 752675 752710 753972 756681 756687 757178 761621 762043 762163 762914 762965 765388 765573 765724 766850 766893 766969 767602 769800 770292 770303 771147 771349 771452 771593 774038 774684 775704 775716 775720 776524 777027 778361 778721 778936 782351 783576 784821 785418 785832 787868 789849 790229 790496 790632 791366 791419 794185 794361 797165 797396 798803 800498 801557 801709 804326 806590 811706 818635 818938 824048 825533 825941 826177 826367 826455 827484 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (8.33%) |
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 603772 604418 737553 752710 766969 765573 769800 774038 593872 818635 825533 656801 709922 714711 626930 790229 762043 771147 707446 720157 607099 586759 774684 787868 798803 762965 771349 771452 789849 740287 766850 811706 452284 784821 572331 695733 669288 696107 660403 626114 637567 776524 804326 762163 746555 794361 599134 740876 756681 626049 826455 645765 783576 775720 800498 756687 775704 775716 806590 725416 728356 801709 778936 440632 710159 777027 684492 761621 752121 778721 785418 724050 765388 770303 790496 726933 677624 665831 676656 655159 657160 695745 720216 630451 630043 593701 790632 794185 791366 797165 797396 752675 728555 749717 770292 608818 712174 715807 785832 827484 818938 782351 757178 771593 826177 824048 825941 826367 581403 676654 669309 778361 753972 791419 801557 762914 767602 726869 765724 766893 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (2.03%) |
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 440632 452284 572331 581403 586759 593701 593872 599134 603772 604418 607099 608818 626049 626114 626930 630043 630451 637567 645765 655159 656801 657160 660403 665831 669288 669309 676654 676656 677624 684492 695733 695745 696107 707446 709922 710159 712174 714711 715807 720157 720216 724050 725416 726869 726933 728356 728555 737553 740287 740876 746555 749717 752121 752675 752710 753972 756681 756687 757178 761621 762043 762163 762914 762965 765388 765573 765724 766850 766893 766969 767602 769800 770292 770303 771147 771349 771452 771593 774038 774684 775704 775716 775720 776524 777027 778361 778721 778936 782351 783576 784821 785418 785832 787868 789849 790229 790496 790632 791366 791419 794185 794361 797165 797396 798803 800498 801557 801709 804326 806590 811706 818635 818938 824048 825533 825941 826177 826367 826455 827484 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал жмж секс втро онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал жмж секс втро онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal ffm onlyfans"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.03%) |
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.