Query Metrics
7
Database Queries
7
Different statements
377.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.61 ms (56.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал vintage анал"
]
|
||||||||||||||||||||||||||||||
|
138.38 ms (36.65%) |
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 513025 538848 541588 541592 541611 541614 541632 541633 541634 541639 541640 541642 541643 541644 541646 541647 541650 541651 541656 541661 541664 541665 541667 541671 541673 541683 541688 541690 541721 541752 541774 541780 541804 541808 541831 541833 541864 541871 541874 541885 541888 542187 542189 542191 542192 542193 542194 542195 542196 542199 542956 543496 544288 544472 544529 551919 559120 559127 559378 560086 562825 562831 562840 563420 563536 564519 566688 567416 568519 571213 571244 574244 576629 576638 576710 576717 576723 576726 577350 577362 581349 583690 589204 600316 610108 614745 619394 619483 621317 621683 628327 636268 644005 644324 649196 652539 652542 663546 671726 672122 672372 692485 699574 716078 724135 ] |
||||||||||||||||||||||||||||||
|
19.12 ms (5.06%) |
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 541633 576638 566688 551919 563536 541634 541656 541690 581349 541592 544288 576629 628327 619483 541831 541885 541661 541665 541874 544529 571213 577350 671726 571244 541643 576717 541639 542189 541650 541632 692485 649196 672122 644324 541871 542194 559120 541651 541647 577362 541614 541640 541673 541833 541888 542196 541664 541774 574244 576723 576710 576726 636268 544472 541721 562831 538848 542956 621317 513025 663546 600316 724135 542191 542195 542192 563420 541688 541752 541780 541808 541683 542193 541642 541644 541667 543496 542187 542199 541804 652539 541611 699574 559127 541864 562825 541671 541588 559378 716078 589204 614745 541646 562840 672372 619394 568519 560086 583690 610108 564519 644005 621683 567416 652542 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (0.72%) |
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 513025 538848 541588 541592 541611 541614 541632 541633 541634 541639 541640 541642 541643 541644 541646 541647 541650 541651 541656 541661 541664 541665 541667 541671 541673 541683 541688 541690 541721 541752 541774 541780 541804 541808 541831 541833 541864 541871 541874 541885 541888 542187 542189 542191 542192 542193 542194 542195 542196 542199 542956 543496 544288 544472 544529 551919 559120 559127 559378 560086 562825 562831 562840 563420 563536 564519 566688 567416 568519 571213 571244 574244 576629 576638 576710 576717 576723 576726 577350 577362 581349 583690 589204 600316 610108 614745 619394 619483 621317 621683 628327 636268 644005 644324 649196 652539 652542 663546 671726 672122 672372 692485 699574 716078 724135 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal vintage anal"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал vintage анал"
]
|
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.