Query Metrics
7
Database Queries
7
Different statements
151.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.26 ms (82.00%) |
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 384857 392477 452743 456022 467028 469978 516016 522700 525917 529329 538619 542976 545957 551145 558576 561460 565789 565881 574444 578738 593147 593179 598632 605765 607589 610393 615759 617625 618506 631479 633479 638117 651231 651926 653388 664215 667805 670904 671499 671569 682951 700201 702223 703684 707145 707446 707572 716180 722060 722088 724168 727101 729036 729316 731197 733555 735528 736483 737144 740093 740879 742149 746070 747858 750613 757328 757631 759180 759747 761889 765083 767391 767810 768928 768997 769828 772421 772516 776106 778461 780630 781840 785246 786754 786851 786937 787851 790632 791222 791250 794143 795521 799774 801028 801183 802078 802402 802756 803212 804030 805094 805672 809322 809743 811289 811956 812980 813077 816622 818666 819431 819708 820987 822231 822846 825016 825103 826557 828453 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (10.48%) |
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 787851 746070 761889 757631 384857 826557 818666 822846 825016 819431 828453 467028 469978 538619 522700 565789 682951 667805 716180 598632 631479 610393 615759 593179 618506 780630 791222 794143 802402 809322 811289 802078 805672 724168 747858 769828 799774 803212 811956 767391 729316 731197 737144 759180 757328 772516 727101 768997 702223 703684 722060 529329 574444 542976 578738 653388 633479 776106 801028 785246 786851 729036 763699 768928 700201 786754 801183 812980 452743 558576 651231 670904 671499 722088 593147 790632 735528 765083 767810 772421 809743 813077 733555 759747 736483 638117 802756 525917 456022 545957 651926 565881 791250 740093 740879 742149 392477 816622 819708 825103 820987 822231 516016 561460 551145 707446 664215 671569 707145 707572 605765 607589 617625 778461 786937 804030 781840 805094 750613 795521 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.92%) |
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 384857 392477 452743 456022 467028 469978 516016 522700 525917 529329 538619 542976 545957 551145 558576 561460 565789 565881 574444 578738 593147 593179 598632 605765 607589 610393 615759 617625 618506 631479 633479 638117 651231 651926 653388 664215 667805 670904 671499 671569 682951 700201 702223 703684 707145 707446 707572 716180 722060 722088 724168 727101 729036 729316 731197 733555 735528 736483 737144 740093 740879 742149 746070 747858 750613 757328 757631 759180 759747 761889 765083 767391 767810 768928 768997 769828 772421 772516 776106 778461 780630 781840 785246 786754 786851 786937 787851 790632 791222 791250 794143 795521 799774 801028 801183 802078 802402 802756 803212 804030 805094 805672 809322 809743 811289 811956 812980 813077 816622 818666 819431 819708 820987 822231 822846 825016 825103 826557 828453 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм out"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm out"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм out"
]
|
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.