Query Metrics
7
Database Queries
7
Different statements
162.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.14 ms (85.51%) |
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 150461 392508 397977 422350 479446 487528 496247 536972 544713 552993 553244 555010 561487 572464 588481 588885 593193 595107 596394 601855 606539 616438 616475 619602 619689 627567 633748 643569 644757 650728 664671 669315 684865 689807 690633 698918 706784 709707 710210 710244 710416 714392 717089 719065 721755 721831 723454 724662 725025 725646 726097 726308 728412 730078 731027 731646 738517 740666 746320 746680 754654 755765 756396 757083 757602 757686 758128 758310 758604 758988 759506 760092 760677 764678 765027 765823 766934 767899 768721 768930 770098 770722 770729 771785 773809 777572 778572 779035 779729 779790 780954 781348 782067 783178 785617 787161 791491 791684 793213 793347 795599 795821 796490 796580 796714 796752 797357 797601 797713 798019 800041 801309 801692 803161 803194 803464 808448 809716 810544 811968 ] |
||||||||||||||||||||||||||||||
|
12.96 ms (7.97%) |
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 758128 765027 765823 767899 726308 731027 731646 738517 754654 757686 758604 771785 759506 760092 760677 766934 768721 768930 770098 740666 756396 758988 770729 773809 644757 710416 714392 779035 782067 783178 787161 797357 797601 803161 422350 397977 593193 633748 553244 698918 650728 595107 616475 730078 746320 791491 795599 150461 392508 479446 487528 536972 496247 544713 552993 572464 561487 706784 717089 689807 690633 709707 710210 721755 664671 669315 684865 710244 719065 721831 723454 555010 588481 601855 588885 619689 596394 606539 616438 619602 627567 643569 778572 780954 795821 796580 796714 797713 803194 810544 777572 779729 779790 781348 796752 798019 800041 801309 803464 811968 725646 755765 757083 758310 764678 770722 785617 791684 793213 793347 796490 801692 808448 809716 724662 725025 726097 728412 746680 757602 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.52%) |
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 150461 392508 397977 422350 479446 487528 496247 536972 544713 552993 553244 555010 561487 572464 588481 588885 593193 595107 596394 601855 606539 616438 616475 619602 619689 627567 633748 643569 644757 650728 664671 669315 684865 689807 690633 698918 706784 709707 710210 710244 710416 714392 717089 719065 721755 721831 723454 724662 725025 725646 726097 726308 728412 730078 731027 731646 738517 740666 746320 746680 754654 755765 756396 757083 757602 757686 758128 758310 758604 758988 759506 760092 760677 764678 765027 765823 766934 767899 768721 768930 770098 770722 770729 771785 773809 777572 778572 779035 779729 779790 780954 781348 782067 783178 785617 787161 791491 791684 793213 793347 795599 795821 796490 796580 796714 796752 797357 797601 797713 798019 800041 801309 801692 803161 803194 803464 808448 809716 810544 811968 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot sperm"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot сперм"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot сперм"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.13%) |
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.