Query Metrics
7
Database Queries
7
Different statements
161.04 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.02 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.91 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy vintage anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.25 ms |
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 571056 644280 524986 567424 541895 562841 541636 581302 571240 572544 576700 606778 622976 592440 620130 622953 622978 624468 592456 615735 592530 577366 566693 620157 634071 541884 573764 576634 593441 600316 562836 573765 576691 576704 566503 577371 541366 541828 576630 622979 603247 727812 541698 541699 541592 628327 619483 577368 541738 689702 662137 576623 576720 583533 541886 541651 574258 541661 541665 541874 541633 560086 513025 541614 541640 541888 542196 574244 576723 576710 562825 541643 541683 541667 543496 538848 716078 541688 541871 541671 541588 541804 559127 541611 ] |
||||||||||||||||||||||||||||||
| 4 | 3.10 ms |
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 524986 538848 541366 541588 541592 541611 541614 541633 541636 541640 541643 541651 541661 541665 541667 541671 541683 541688 541698 541699 541738 541804 541828 541871 541874 541884 541886 541888 541895 542196 543496 559127 560086 562825 562836 562841 566503 566693 567424 571056 571240 572544 573764 573765 574244 574258 576623 576630 576634 576691 576700 576704 576710 576720 576723 577366 577368 577371 581302 583533 592440 592456 592530 593441 600316 603247 606778 615735 619483 620130 620157 622953 622976 622978 622979 624468 628327 634071 644280 662137 689702 716078 727812 ] |
||||||||||||||||||||||||||||||
| 5 | 134.00 ms |
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 524986 538848 541366 541588 541592 541611 541614 541633 541636 541640 541643 541651 541661 541665 541667 541671 541683 541688 541698 541699 541738 541804 541828 541871 541874 541884 541886 541888 541895 542196 543496 559127 560086 562825 562836 562841 566503 566693 567424 571056 571240 572544 573764 573765 574244 574258 576623 576630 576634 576691 576700 576704 576710 576720 576723 577366 577368 577371 581302 583533 592440 592456 592530 593441 600316 603247 606778 615735 619483 620130 620157 622953 622976 622978 622979 624468 628327 634071 644280 662137 689702 716078 727812 ] |
||||||||||||||||||||||||||||||
| 6 | 1.96 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая vintage анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.81 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.