Query Metrics
7
Database Queries
7
Different statements
143.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.25 ms (85.96%) |
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 425496 449910 476674 477973 484458 486544 494151 494669 495937 506342 510310 510405 527116 537289 538497 554275 554867 555076 555096 562622 564672 567403 570403 570701 584381 600669 600828 601714 603800 605471 606346 606655 608156 610261 613860 616442 617631 622416 623254 624472 624895 625283 630978 637183 640530 642307 646097 646413 646927 647640 656472 656761 661390 678201 679380 689542 693600 693656 695469 696115 709413 710510 712346 719923 720365 720380 721128 721798 726529 726686 726734 727739 728308 732990 736775 737932 741779 742817 742865 750729 751006 751118 753192 757277 760058 760683 762329 765307 766148 766165 768078 768558 771571 775770 776532 778702 780410 780772 783162 784286 786182 786277 787891 788442 788952 790101 790813 792421 795304 796169 797806 801026 801873 803244 804609 808680 811445 813275 813742 814041 ] |
||||||||||||||||||||||||||||||
|
11.90 ms (8.30%) |
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 476674 719923 617631 768078 771571 637183 766165 787891 630978 780772 709413 712346 537289 695469 646097 689542 693600 449910 788442 678201 527116 538497 554275 721128 608156 751118 801873 570701 796169 768558 570403 584381 720380 642307 603800 778702 786182 742865 610261 775770 790813 811445 726686 728308 813742 696115 562622 600828 605471 616442 792421 726734 753192 622416 494151 495937 693656 784286 732990 606655 790101 600669 623254 741779 567403 555076 780410 766148 737932 765307 425496 486544 510405 564672 555096 661390 656472 624472 783162 762329 751006 721798 494669 647640 656761 710510 646927 679380 720365 601714 624895 804609 797806 760683 786277 795304 477973 640530 506342 554867 606346 808680 757277 803244 484458 814041 646413 750729 742817 727739 510310 776532 813275 736775 760058 726529 625283 613860 801026 788952 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.64%) |
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 425496 449910 476674 477973 484458 486544 494151 494669 495937 506342 510310 510405 527116 537289 538497 554275 554867 555076 555096 562622 564672 567403 570403 570701 584381 600669 600828 601714 603800 605471 606346 606655 608156 610261 613860 616442 617631 622416 623254 624472 624895 625283 630978 637183 640530 642307 646097 646413 646927 647640 656472 656761 661390 678201 679380 689542 693600 693656 695469 696115 709413 710510 712346 719923 720365 720380 721128 721798 726529 726686 726734 727739 728308 732990 736775 737932 741779 742817 742865 750729 751006 751118 753192 757277 760058 760683 762329 765307 766148 766165 768078 768558 771571 775770 776532 778702 780410 780772 783162 784286 786182 786277 787891 788442 788952 790101 790813 792421 795304 796169 797806 801026 801873 803244 804609 808680 811445 813275 813742 814041 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex extreme"
]
|
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.