Query Metrics
7
Database Queries
7
Different statements
161.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.28 ms (82.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 198001 383616 389440 401159 401351 407222 409881 414198 415005 415172 415655 416867 426409 435054 442201 444652 445514 446618 447601 447677 447867 448042 448792 451877 452987 453379 454778 457597 457863 461466 461543 462070 462910 463385 465875 468238 476029 480365 483543 486288 487134 495292 501507 503577 504340 504584 504840 504997 505326 507596 515450 515554 518254 519561 519592 527920 528034 530373 543218 545545 558217 558861 561720 567763 572237 576087 581967 583622 586931 592330 595956 599964 599969 600002 601150 601584 606560 621794 621798 624367 637726 647666 650158 651080 652934 659432 667760 675034 678876 681215 699505 713320 719022 725609 725640 731485 731893 732878 735778 742188 743433 745384 756206 776025 785092 787488 787544 793558 795899 805925 811500 812271 821184 821625 822005 822079 822719 823173 825812 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (10.25%) |
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 675034 558217 545545 389440 414198 415005 600002 732878 825812 435054 426409 416867 601150 415655 599964 601584 448792 650158 599969 583622 451877 745384 530373 483543 383616 519592 822005 447677 519561 681215 504840 624367 735778 793558 776019 637726 821625 795899 621798 822079 678876 713320 507596 699505 457863 731485 743433 719022 812271 652934 725609 776025 731893 659432 592330 742188 756206 543218 576087 785092 822719 567763 821184 805925 823173 561720 505326 407222 504584 462070 461543 606560 446618 476029 528034 787488 401351 725640 462910 457597 621794 558861 572237 442201 409881 495292 647666 448042 486288 501507 811500 198001 787544 454778 595956 468238 651080 586931 401159 453379 465875 515450 480365 503577 415172 447867 452987 527920 445514 504997 487134 461466 667760 463385 444652 515554 504340 518254 581967 447601 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (2.06%) |
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 198001 383616 389440 401159 401351 407222 409881 414198 415005 415172 415655 416867 426409 435054 442201 444652 445514 446618 447601 447677 447867 448042 448792 451877 452987 453379 454778 457597 457863 461466 461543 462070 462910 463385 465875 468238 476029 480365 483543 486288 487134 495292 501507 503577 504340 504584 504840 504997 505326 507596 515450 515554 518254 519561 519592 527920 528034 530373 543218 545545 558217 558861 561720 567763 572237 576087 581967 583622 586931 592330 595956 599964 599969 600002 601150 601584 606560 621794 621798 624367 637726 647666 650158 651080 652934 659432 667760 675034 678876 681215 699505 713320 719022 725609 725640 731485 731893 732878 735778 742188 743433 745384 756206 776025 785092 787488 787544 793558 795899 805925 811500 812271 821184 821625 822005 822079 822719 823173 825812 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gymnast sex"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"гимнастк девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"гимнастк девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
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.