Query Metrics
7
Database Queries
7
Different statements
185.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.30 ms (85.70%) |
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 382043 391923 424165 428235 430369 439028 452567 452791 458867 460351 460384 479839 484953 517655 529574 530149 530425 530692 530698 530958 531370 544147 546152 554858 555407 556166 565575 576539 581058 584298 584348 584961 585898 592633 594340 595623 601550 604105 611437 620219 623184 628112 630423 636651 639307 639821 642158 643619 651060 652274 652954 655184 657567 660577 662162 665976 668663 670404 676969 677428 680472 680802 681515 683496 690062 691808 692000 692985 695464 696108 700924 700997 702336 702342 702357 709916 713287 723003 743208 745101 747705 749391 749979 750123 750145 751013 752659 752758 753031 753681 756828 756838 758276 759087 760756 761164 765221 765248 765262 766945 774712 783693 783743 785544 786872 787519 790133 790575 791896 792065 793009 799938 801313 801540 803383 805647 820048 822304 823333 824352 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (8.73%) |
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 630423 700997 479839 660577 430369 428235 458867 460351 452567 452791 484953 691808 581058 765221 460384 424165 382043 651060 824352 822304 820048 823333 517655 530149 530958 529574 530425 530692 531370 554858 544147 565575 576539 584298 584348 652954 655184 670404 680802 681515 683496 702336 652274 676969 692985 696108 700924 709916 713287 657567 665976 677428 690062 692000 546152 556166 584961 585898 642158 620219 639821 592633 595623 601550 623184 636651 643619 611437 774712 783743 790133 801540 803383 787519 792065 801313 805647 749979 751013 753031 756828 760756 765248 765262 785544 786872 793009 756838 752659 758276 766945 743208 745101 747705 752758 753681 749391 750123 750145 759087 761164 604105 628112 639307 702342 702357 723003 783693 791896 799938 391923 530698 555407 662162 668663 695464 680472 594340 790575 439028 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.41%) |
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 382043 391923 424165 428235 430369 439028 452567 452791 458867 460351 460384 479839 484953 517655 529574 530149 530425 530692 530698 530958 531370 544147 546152 554858 555407 556166 565575 576539 581058 584298 584348 584961 585898 592633 594340 595623 601550 604105 611437 620219 623184 628112 630423 636651 639307 639821 642158 643619 651060 652274 652954 655184 657567 660577 662162 665976 668663 670404 676969 677428 680472 680802 681515 683496 690062 691808 692000 692985 695464 696108 700924 700997 702336 702342 702357 709916 713287 723003 743208 745101 747705 749391 749979 750123 750145 751013 752659 752758 753031 753681 756828 756838 758276 759087 760756 761164 765221 765248 765262 766945 774712 783693 783743 785544 786872 787519 790133 790575 791896 792065 793009 799938 801313 801540 803383 805647 820048 822304 823333 824352 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal solo masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал соло мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
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.