Query Metrics
8
Database Queries
8
Different statements
152.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.60 ms (83.77%) |
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 253445 383057 393253 458656 476993 478421 479969 492693 526293 530289 531592 537389 540808 542673 543978 547220 548270 549020 550949 566393 581581 583868 586752 587673 590242 593837 593913 594579 596188 598239 601206 602005 603621 605816 606497 606869 606922 613896 613953 618260 624996 625307 627768 633615 637507 638430 642562 642950 644190 644335 648622 650888 651314 654236 655243 666721 671439 675885 676433 693486 693492 693776 694158 695773 701489 702001 705343 705649 711354 712361 712755 716082 716442 718457 719035 720086 722104 724035 726129 726593 727681 728049 731400 741058 741401 741566 741572 743888 750372 752122 752646 753501 757640 761953 777178 777862 780792 789493 790817 791966 793939 794408 794585 796788 796789 801260 802401 803778 803802 805361 805533 806706 806708 807476 809879 813157 817657 820313 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (8.28%) |
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 724035 741566 789493 762176 726129 731400 741572 716442 720086 802401 813157 805533 753501 705649 693486 693492 650888 655243 593837 593913 606922 625307 601206 633615 644190 605816 606497 606869 526293 613896 712755 548270 587673 596188 602005 540808 479969 651314 648622 393253 820313 478421 566393 549020 718457 806706 803778 791966 752122 726593 530289 817657 581581 719035 644335 794585 741058 796789 761953 728049 750372 773636 716082 383057 492693 712361 741401 743888 542673 671439 675885 702001 701489 613953 253445 476993 695773 618260 711354 583868 531592 722104 777862 794408 805361 757640 809879 594579 801260 547220 796788 807476 694158 642562 624996 627768 642950 543978 803802 777178 793939 752646 586752 806708 780792 458656 654236 693776 727681 537389 676433 705343 550949 590242 603621 638430 598239 637507 790817 666721 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.04%) |
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 253445 383057 393253 458656 476993 478421 479969 492693 526293 530289 531592 537389 540808 542673 543978 547220 548270 549020 550949 566393 581581 583868 586752 587673 590242 593837 593913 594579 596188 598239 601206 602005 603621 605816 606497 606869 606922 613896 613953 618260 624996 625307 627768 633615 637507 638430 642562 642950 644190 644335 648622 650888 651314 654236 655243 666721 671439 675885 676433 693486 693492 693776 694158 695773 701489 702001 705343 705649 711354 712361 712755 716082 716442 718457 719035 720086 722104 724035 726129 726593 727681 728049 731400 741058 741401 741566 741572 743888 750372 752122 752646 753501 757640 761953 777178 777862 780792 789493 790817 791966 793939 794408 794585 796788 796789 801260 802401 803778 803802 805361 805533 806706 806708 807476 809879 813157 817657 820313 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife homemade"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01’ò\x00VÃrâ+\x04âÔ\x16FÞ"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.01%) |
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.