Query Metrics
7
Database Queries
7
Different statements
163.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.90 ms (85.49%) |
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 387908 390289 396066 406949 413029 432414 432483 434848 438053 441845 454503 455244 467659 474316 501333 586268 587629 593250 605440 610163 615146 617254 632140 685492 687384 703252 708528 709364 710329 717922 719038 723668 723965 724375 724458 724471 725239 725413 725432 726123 726406 726976 727980 729342 730078 730382 731007 733403 733409 734461 735029 735654 736685 737315 737318 737674 738914 739646 739891 742101 742228 745323 746840 747989 756373 756779 757120 757133 757134 757290 757294 757298 757602 758572 759382 759648 759747 759812 760160 761314 762452 762656 762915 763474 764139 764194 765389 765408 767073 768657 769176 769340 772345 773150 773381 773423 776270 778741 784340 786147 786634 787172 787750 793752 793836 794403 794539 795937 798602 798619 800263 801459 801993 804662 804929 805626 807305 811538 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (8.52%) |
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 804662 723668 730078 731007 734461 742228 756373 758572 769176 772345 773150 784340 787750 793752 793836 794539 801459 801993 805626 807305 811538 724471 725239 726976 735654 739646 742101 759648 762656 765408 768657 723965 727980 730382 733409 735029 736685 737315 757120 759812 760160 763474 764139 764194 769831 724458 729342 737318 737674 747989 757290 757298 762915 765389 767073 769340 773381 773423 726123 726406 739891 756779 757133 757134 757294 761314 770445 615146 617254 703252 709364 717922 719038 776270 778741 786147 786634 787172 794403 798602 798619 800263 804929 390289 432414 432483 441845 396066 438053 467659 474316 387908 434848 406949 685492 708528 587629 795937 725413 759382 725432 738914 745323 710329 454503 413029 687384 586268 632140 605440 610163 759747 501333 593250 757602 762452 724375 455244 746840 733403 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.83%) |
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 387908 390289 396066 406949 413029 432414 432483 434848 438053 441845 454503 455244 467659 474316 501333 586268 587629 593250 605440 610163 615146 617254 632140 685492 687384 703252 708528 709364 710329 717922 719038 723668 723965 724375 724458 724471 725239 725413 725432 726123 726406 726976 727980 729342 730078 730382 731007 733403 733409 734461 735029 735654 736685 737315 737318 737674 738914 739646 739891 742101 742228 745323 746840 747989 756373 756779 757120 757133 757134 757290 757294 757298 757602 758572 759382 759648 759747 759812 760160 761314 762452 762656 762915 763474 764139 764194 765389 765408 767073 768657 769176 769340 772345 773150 773381 773423 776270 778741 784340 786147 786634 787172 787750 793752 793836 794403 794539 795937 798602 798619 800263 801459 801993 804662 804929 805626 807305 811538 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
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.