Query Metrics
7
Database Queries
7
Different statements
115.92 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.67 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.33 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom big mom"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.51 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 606806 621645 422195 446173 439735 433323 492121 505018 557558 426987 520793 481910 564824 471639 482555 531431 531513 534000 520639 483417 486198 671348 673960 632010 421000 430828 430204 518751 524897 416841 446631 573234 562355 584703 682531 573806 605461 605298 582531 421882 525263 506908 527669 471824 447677 613316 603703 603035 565235 562007 564687 587192 613275 609085 504908 504922 508860 403939 532129 562906 573759 541244 562894 587901 586681 407597 492472 528089 585721 614906 599177 428854 582624 573805 481881 531920 561478 573754 573742 684305 587220 591065 464328 590723 585725 430018 584720 ] |
||||||||||||||||||||||||||||||
| 4 | 2.57 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 403939 407597 416841 421000 421882 422195 426987 428854 430018 430204 430828 433323 439735 446173 446631 447677 464328 471639 471824 481881 481910 482555 483417 486198 492121 492472 504908 504922 505018 506908 508860 518751 520639 520793 524897 525263 527669 528089 531431 531513 531920 532129 534000 541244 557558 561478 562007 562355 562894 562906 564687 564824 565235 573234 573742 573754 573759 573805 573806 582531 582624 584703 584720 585721 585725 586681 587192 587220 587901 590723 591065 599177 603035 603703 605298 605461 606806 609085 613275 613316 614906 621645 632010 671348 673960 682531 684305 ] |
||||||||||||||||||||||||||||||
| 5 | 90.58 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 403939 407597 416841 421000 421882 422195 426987 428854 430018 430204 430828 433323 439735 446173 446631 447677 464328 471639 471824 481881 481910 482555 483417 486198 492121 492472 504908 504922 505018 506908 508860 518751 520639 520793 524897 525263 527669 528089 531431 531513 531920 532129 534000 541244 557558 561478 562007 562355 562894 562906 564687 564824 565235 573234 573742 573754 573759 573805 573806 582531 582624 584703 584720 585721 585725 586681 587192 587220 587901 590723 591065 599177 603035 603703 605298 605461 606806 609085 613275 613316 614906 621645 632010 671348 673960 682531 684305 ] |
||||||||||||||||||||||||||||||
| 6 | 1.80 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom большие mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.47 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom большие mom"
]
|
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.