Query Metrics
7
Database Queries
7
Different statements
133.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
112.45 ms (84.36%) |
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 446573 497336 498442 508976 539745 542012 552458 553024 556459 556563 563759 571382 572683 584274 592575 599055 603604 610527 629714 638952 662443 701545 707521 708871 709378 710293 719407 720324 723897 724054 724320 726947 735111 736912 743466 747665 748629 749937 752076 758410 760361 763342 764070 765041 765797 767104 767324 767836 769624 771714 771752 772888 772891 774729 775290 775401 777210 777214 777828 778305 778309 778328 778351 778468 778603 778939 779142 779296 779966 780112 780288 780867 782166 783547 783781 784193 785311 785994 786097 786620 786664 787537 788622 788639 788645 788965 789513 790588 790656 790662 791103 791185 792782 792915 793474 793724 793888 797207 798339 799541 799552 803332 805518 806379 813577 814207 816752 818066 818902 818970 819448 819895 821831 824254 825495 826054 826862 827406 ] |
||||||||||||||||||||||||||||||
|
11.03 ms (8.27%) |
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 824254 826862 827406 818066 818970 816752 708871 709378 710293 610527 629714 597175 638952 778328 779142 783781 785994 786664 788645 777828 778603 786097 788639 791185 758410 772888 782166 790588 790662 792782 735111 765041 743466 767104 772891 720324 778305 778309 778351 784193 788622 792915 799541 799552 719407 736912 780867 803332 764070 726947 552458 818902 603604 826054 775401 775290 748629 791103 814207 774729 553024 508976 572683 542012 797207 819895 592575 787537 793724 793888 798339 785311 763342 771752 793474 599055 805518 571382 707521 701545 662443 777210 749937 767324 806379 723897 760361 763756 765797 777214 780112 790656 819448 778468 779296 788965 724054 779966 767836 584274 780288 786620 789513 724320 747665 769624 771714 778939 783547 497336 556563 563759 556459 498442 752076 446573 539745 813577 821831 825495 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (2.10%) |
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 446573 497336 498442 508976 539745 542012 552458 553024 556459 556563 563759 571382 572683 584274 592575 599055 603604 610527 629714 638952 662443 701545 707521 708871 709378 710293 719407 720324 723897 724054 724320 726947 735111 736912 743466 747665 748629 749937 752076 758410 760361 763342 764070 765041 765797 767104 767324 767836 769624 771714 771752 772888 772891 774729 775290 775401 777210 777214 777828 778305 778309 778328 778351 778468 778603 778939 779142 779296 779966 780112 780288 780867 782166 783547 783781 784193 785311 785994 786097 786620 786664 787537 788622 788639 788645 788965 789513 790588 790656 790662 791103 791185 792782 792915 793474 793724 793888 797207 798339 799541 799552 803332 805518 806379 813577 814207 816752 818066 818902 818970 819448 819895 821831 824254 825495 826054 826862 827406 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob threesome onlyfans"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс секс втро онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.