Query Metrics
7
Database Queries
7
Different statements
231.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.96 ms (90.43%) |
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 382490 392923 409383 424721 452936 456312 470621 472698 475680 479148 486778 509659 513635 513672 516491 530199 530740 534634 535363 536295 536467 537447 540556 540567 541790 542726 543998 547416 549675 554864 555005 555047 555227 555497 555780 558102 558264 561531 563086 564281 565082 570885 574395 576478 576540 576597 577002 583727 585498 585612 587272 591162 593039 593042 599238 599489 605173 605265 605535 607963 618985 619638 631461 634027 634883 650524 651651 652881 664556 668561 668706 714309 719389 725492 738427 740553 740555 741773 742680 749023 759124 759806 787512 787677 788753 790825 794706 795933 800528 802162 803487 803490 803507 803508 803886 804241 804264 804456 807723 810095 811112 812408 812548 813605 817575 817590 819671 823992 824089 824212 824311 826957 827296 827394 827395 827396 827616 827665 827692 827734 ] |
||||||||||||||||||||||||||||||
|
11.86 ms (5.13%) |
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 741773 475680 479148 409383 456312 513635 513672 516491 392923 819671 813605 824311 817575 817590 824212 827665 486778 530199 536467 536295 509659 558264 576478 555497 561531 570885 574395 555227 558102 563086 577002 605173 619638 593039 631461 795933 803487 812408 790825 794706 803490 803507 810095 749023 804241 804456 811112 812548 738427 759124 740555 759806 803508 804264 714309 725492 470621 634027 593042 634883 605535 742680 591162 607963 587272 452936 599489 549675 554864 555047 555005 424721 472698 664556 382490 823992 824089 826957 827296 827616 827394 827395 827396 827734 827692 534634 540556 540567 535363 537447 530740 541790 564281 565082 542726 543998 547416 576540 650524 651651 652881 668561 668706 719389 555780 576597 583727 618985 585498 585612 599238 605265 787512 800528 788753 802162 803886 807723 740553 787677 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.33%) |
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 382490 392923 409383 424721 452936 456312 470621 472698 475680 479148 486778 509659 513635 513672 516491 530199 530740 534634 535363 536295 536467 537447 540556 540567 541790 542726 543998 547416 549675 554864 555005 555047 555227 555497 555780 558102 558264 561531 563086 564281 565082 570885 574395 576478 576540 576597 577002 583727 585498 585612 587272 591162 593039 593042 599238 599489 605173 605265 605535 607963 618985 619638 631461 634027 634883 650524 651651 652881 664556 668561 668706 714309 719389 725492 738427 740553 740555 741773 742680 749023 759124 759806 787512 787677 788753 790825 794706 795933 800528 802162 803487 803490 803507 803508 803886 804241 804264 804456 807723 810095 811112 812408 812548 813605 817575 817590 819671 823992 824089 824212 824311 826957 827296 827394 827395 827396 827616 827665 827692 827734 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur solo mature"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск соло mature"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск соло mature"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.63%) |
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.