Query Metrics
7
Database Queries
7
Different statements
151.53 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.78 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy group fuck"
]
|
||||||||||||||||||||||||||||||
| 3 | 20.35 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 485700 501242 466097 466733 577368 662137 642063 639824 444831 450386 451951 541886 463122 647854 531117 541593 401919 606577 599160 541661 541665 552306 643103 617422 646176 556797 639796 474024 485703 526553 484463 578397 562825 403141 541888 541667 541633 541614 421287 508518 451957 524879 430404 482527 532975 639739 642016 506801 588244 625423 406381 524952 467611 646901 574258 591882 430621 519588 532661 647948 613174 470596 549225 422741 541588 601324 605521 541643 528361 541671 591314 535016 612434 513949 541688 647860 598806 641978 485313 484017 559127 635275 609196 541611 516842 519285 ] |
||||||||||||||||||||||||||||||
| 4 | 3.85 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 401919 403141 406381 421287 422741 430404 430621 444831 450386 451951 451957 463122 466097 466733 467611 470596 474024 482527 484017 484463 485313 485700 485703 501242 506801 508518 513949 516842 519285 519588 524879 524952 526553 528361 531117 532661 532975 535016 541588 541593 541611 541614 541633 541643 541661 541665 541667 541671 541688 541886 541888 549225 552306 556797 559127 562825 574258 577368 578397 588244 591314 591882 598806 599160 601324 605521 606577 609196 612434 613174 617422 625423 635275 639739 639796 639824 641978 642016 642063 643103 646176 646901 647854 647860 647948 662137 ] |
||||||||||||||||||||||||||||||
| 5 | 120.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 401919 403141 406381 421287 422741 430404 430621 444831 450386 451951 451957 463122 466097 466733 467611 470596 474024 482527 484017 484463 485313 485700 485703 501242 506801 508518 513949 516842 519285 519588 524879 524952 526553 528361 531117 532661 532975 535016 541588 541593 541611 541614 541633 541643 541661 541665 541667 541671 541688 541886 541888 549225 552306 556797 559127 562825 574258 577368 578397 588244 591314 591882 598806 599160 601324 605521 606577 609196 612434 613174 617422 625423 635275 639739 639796 639824 641978 642016 642063 643103 646176 646901 647854 647860 647948 662137 ] |
||||||||||||||||||||||||||||||
| 6 | 1.94 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая group секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.60 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая group секс"
]
|
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.