Query Metrics
7
Database Queries
7
Different statements
171.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.01 ms (87.71%) |
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 156348 396903 424910 525921 530008 534477 535753 537229 539550 547172 555658 555787 563407 563663 566440 584529 591094 592283 593228 595645 599281 602041 602200 602863 603798 610513 611312 612533 615184 615377 617461 618194 623105 623378 625295 627268 628739 631994 632938 633900 634264 635019 636908 638150 640202 644101 645745 647185 648477 648653 650102 651828 652480 653914 665999 669997 673934 674396 675299 676652 682232 685515 690591 691676 691699 692085 692441 692929 694143 697496 698091 698106 698347 701878 703786 704347 707093 709397 713438 717258 723565 730772 732144 740082 740193 740707 741765 741797 745373 745553 746215 746230 746639 747501 748472 748779 750784 756761 759689 760500 760751 761487 766236 767019 767324 768723 769535 778083 778106 784327 789506 794383 796623 796792 799377 801512 805561 818899 826647 826995 ] |
||||||||||||||||||||||||||||||
|
10.53 ms (6.16%) |
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 690591 692929 703786 648477 665999 674396 675299 692085 647185 648653 650102 651828 676652 691699 599281 615377 592283 610513 602041 602863 633900 638150 746215 750784 612533 618194 707093 713438 778106 698106 566440 424910 525921 591094 645745 615184 778083 767324 768723 746639 747501 694143 653914 537229 530008 547172 555787 682232 697496 669997 698091 673934 685515 692441 623105 640202 602200 635019 617461 627268 740707 732144 631994 632938 634264 611312 623378 563663 826647 555658 784327 789506 760500 760751 730772 759689 766236 717258 794383 796623 801512 805561 396903 709397 818899 534477 636908 745373 741765 748779 746230 535753 563407 584529 603798 595645 593228 628739 704347 691676 156348 723565 826995 539550 652480 698347 625295 644101 799377 740193 756761 769535 741797 745553 748472 740082 761487 767019 701878 796792 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.91%) |
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 156348 396903 424910 525921 530008 534477 535753 537229 539550 547172 555658 555787 563407 563663 566440 584529 591094 592283 593228 595645 599281 602041 602200 602863 603798 610513 611312 612533 615184 615377 617461 618194 623105 623378 625295 627268 628739 631994 632938 633900 634264 635019 636908 638150 640202 644101 645745 647185 648477 648653 650102 651828 652480 653914 665999 669997 673934 674396 675299 676652 682232 685515 690591 691676 691699 692085 692441 692929 694143 697496 698091 698106 698347 701878 703786 704347 707093 709397 713438 717258 723565 730772 732144 740082 740193 740707 741765 741797 745373 745553 746215 746230 746639 747501 748472 748779 750784 756761 759689 760500 760751 761487 766236 767019 767324 768723 769535 778083 778106 784327 789506 794383 796623 796792 799377 801512 805561 818899 826647 826995 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur condom sex"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск condom секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск condom секс"
]
|
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.