Query Metrics
7
Database Queries
7
Different statements
153.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.51 ms (82.97%) |
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 53553 96118 97290 192814 221091 233686 269876 350861 382654 382756 382929 390116 391687 396903 397893 402667 423518 443903 448036 453512 460830 470593 479087 488576 492689 498276 501173 506800 510427 529881 530287 531915 538112 543685 543950 545067 546675 546839 552783 558423 560454 566423 566442 566463 571308 577215 579959 582772 602684 603620 605029 605305 605624 612245 622822 635853 635855 636567 639726 645894 648943 648952 649626 651262 653174 653366 654184 654282 654491 654680 657293 661270 663551 664521 665450 666826 669441 670496 670514 671708 675752 681719 695177 701638 703229 706602 707306 711904 721847 722871 732213 732721 735492 739062 742874 742911 744867 750741 754659 755121 775026 781762 785047 788105 790996 796457 798695 799674 799929 800285 804110 805376 805781 807602 807914 820523 825501 828175 828756 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (10.77%) |
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 602684 781762 805376 402667 97290 582772 501173 639726 382929 96118 221091 799929 799674 739062 350861 53553 695177 571308 664521 396903 566442 543685 790996 732721 233686 397893 382756 269876 382654 825501 822402 828175 828756 538112 488576 545067 645894 648943 654491 657293 665450 666826 721847 648952 653174 669441 706602 654680 670496 675752 701638 605624 622822 612245 635855 635853 805781 775026 742911 744867 788105 798695 807602 735492 755121 703229 804110 577215 530287 654184 663551 636567 732213 390116 531915 558423 546839 546675 579959 649626 654282 681719 653366 651262 661270 566423 566463 605029 750741 722871 448036 510427 605305 807914 470593 711904 800285 453512 506800 460830 560454 423518 479087 492689 443903 552783 707306 498276 785047 754659 796457 603620 742874 529881 543950 670514 671708 391687 192814 820523 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.97%) |
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 53553 96118 97290 192814 221091 233686 269876 350861 382654 382756 382929 390116 391687 396903 397893 402667 423518 443903 448036 453512 460830 470593 479087 488576 492689 498276 501173 506800 510427 529881 530287 531915 538112 543685 543950 545067 546675 546839 552783 558423 560454 566423 566442 566463 571308 577215 579959 582772 602684 603620 605029 605305 605624 612245 622822 635853 635855 636567 639726 645894 648943 648952 649626 651262 653174 653366 654184 654282 654491 654680 657293 661270 663551 664521 665450 666826 669441 670496 670514 671708 675752 681719 695177 701638 703229 706602 707306 711904 721847 722871 732213 732721 735492 739062 742874 742911 744867 750741 754659 755121 775026 781762 785047 788105 790996 796457 798695 799674 799929 800285 804110 805376 805781 807602 807914 820523 825501 828175 828756 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм 2009"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.04%) |
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.