Query Metrics
7
Database Queries
7
Different statements
173.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.73 ms (80.03%) |
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 387510 396768 400359 401637 402997 407567 409226 410563 415266 415451 416263 426003 426129 426183 426535 428653 428853 431793 432351 432810 442771 443801 446789 448356 449622 450654 454053 458378 460191 461051 464388 466192 470280 471195 471461 474791 481668 481942 481970 482239 486533 486539 489082 490117 492333 496066 496118 498061 506830 509309 510466 511422 513151 513619 515734 518156 519573 522879 524896 526888 541626 547930 550354 560075 581173 585127 585155 586445 586858 588411 590932 592501 593086 593397 596134 597018 601115 611345 619857 620159 622650 625181 630782 633091 644323 684232 724855 725578 725579 728114 731544 732029 733178 748153 752950 755426 756642 756816 775282 775551 781946 783777 787274 792529 792642 793886 794606 800052 800197 803760 807154 808385 808636 809548 814910 814926 815866 817131 818459 825304 ] |
||||||||||||||||||||||||||||||
|
23.80 ms (13.73%) |
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 586445 592501 593086 593397 596134 597018 630782 585155 590932 619857 620159 807154 775551 792642 800052 803760 809548 748153 752950 781946 787274 728114 733178 724855 725578 755426 756642 725579 731544 756816 633091 644323 775282 783777 794606 800197 808385 808636 396768 407567 426003 387510 432351 515734 541626 442771 814926 482239 518156 684232 601115 625181 586858 792529 793886 732029 622650 410563 415266 449622 460191 481668 498061 513151 524896 489082 588411 431793 510466 611345 486533 486539 496118 492333 428653 409226 448356 454053 458378 490117 461051 464388 560075 550354 547930 581173 428853 400359 402997 416263 426535 474791 481942 466192 470280 481970 443801 511422 513619 506830 519573 526888 509309 496066 401637 426129 432810 415451 426183 818459 825304 585127 814910 817131 815866 446789 450654 471461 471195 522879 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.96%) |
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 387510 396768 400359 401637 402997 407567 409226 410563 415266 415451 416263 426003 426129 426183 426535 428653 428853 431793 432351 432810 442771 443801 446789 448356 449622 450654 454053 458378 460191 461051 464388 466192 470280 471195 471461 474791 481668 481942 481970 482239 486533 486539 489082 490117 492333 496066 496118 498061 506830 509309 510466 511422 513151 513619 515734 518156 519573 522879 524896 526888 541626 547930 550354 560075 581173 585127 585155 586445 586858 588411 590932 592501 593086 593397 596134 597018 601115 611345 619857 620159 622650 625181 630782 633091 644323 684232 724855 725578 725579 728114 731544 732029 733178 748153 752950 755426 756642 756816 775282 775551 781946 783777 787274 792529 792642 793886 794606 800052 800197 803760 807154 808385 808636 809548 814910 814926 815866 817131 818459 825304 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy mom milf"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая mom milf"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая mom milf"
]
|
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.