Query Metrics
7
Database Queries
7
Different statements
162.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.70 ms (84.37%) |
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 16882 42536 146800 154157 188561 233517 346054 352187 382410 386798 387026 387337 392843 394590 397882 402619 408613 415874 416597 417348 418121 421993 431385 432970 436186 446446 470473 473437 486772 486829 493411 497471 513963 521540 521829 521831 530024 530110 530425 530451 530679 530688 531929 532943 536783 541442 542524 545428 545439 547490 550262 550897 550917 555004 561346 564255 564288 566035 573204 576951 577684 583714 584351 586933 588436 588520 601789 604105 604781 609804 619590 623275 634027 634071 634108 642165 651647 660043 661653 666855 666857 669057 674995 686183 698405 705459 705479 709693 713500 713503 713504 713506 716086 720101 729193 745101 745113 745114 748309 750145 752592 752705 761430 762975 766945 770405 782446 787467 788529 792706 792729 796949 799683 799693 800318 800537 805046 822975 827967 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (9.68%) |
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 486829 493411 421993 446446 576951 416597 564310 669057 545439 634071 799693 470473 583714 561346 588436 542524 521829 545428 566035 588520 387026 634108 436186 352187 666857 573204 709693 601789 42536 796949 386798 418121 513963 770405 532943 651647 827967 584351 713500 619590 547490 822975 745113 752705 536783 541442 604781 530110 792729 530024 674995 586933 782446 346054 716086 634027 623275 788529 745114 431385 705459 705479 805046 146800 402619 521831 550897 609804 762975 531929 16882 432970 415874 473437 604105 233517 188561 397882 392843 387337 530451 530688 564255 713503 686183 417348 799683 761430 752592 787467 800537 394590 530425 713506 800318 766945 745101 750145 713504 382410 577684 550262 661653 729193 748309 497471 666855 720101 550917 154157 408613 792706 698405 486772 521540 530679 564288 660043 555004 642165 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.43%) |
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 16882 42536 146800 154157 188561 233517 346054 352187 382410 386798 387026 387337 392843 394590 397882 402619 408613 415874 416597 417348 418121 421993 431385 432970 436186 446446 470473 473437 486772 486829 493411 497471 513963 521540 521829 521831 530024 530110 530425 530451 530679 530688 531929 532943 536783 541442 542524 545428 545439 547490 550262 550897 550917 555004 561346 564255 564288 566035 573204 576951 577684 583714 584351 586933 588436 588520 601789 604105 604781 609804 619590 623275 634027 634071 634108 642165 651647 660043 661653 666855 666857 669057 674995 686183 698405 705459 705479 709693 713500 713503 713504 713506 716086 720101 729193 745101 745113 745114 748309 750145 752592 752705 761430 762975 766945 770405 782446 787467 788529 792706 792729 796949 799683 799693 800318 800537 805046 822975 827967 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дылдо в жопе"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.00%) |
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.