Query Metrics
7
Database Queries
7
Different statements
171.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.81 ms (85.74%) |
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 74842 108029 250587 382409 385243 386128 391610 395189 395203 395794 396093 396361 397101 398308 398742 400930 400968 402980 403163 405744 405805 407130 412841 413663 416882 417100 417930 418063 418797 418996 419248 419940 422207 423899 425532 425540 425547 425563 425597 426091 426739 427045 427472 428467 435130 435289 437255 437325 441866 442447 443190 444674 445306 446042 447013 447390 447753 447757 447758 448089 448483 451636 453710 453902 454497 456186 459676 460129 472108 484321 489668 490221 490749 492813 494543 496115 498178 499993 502636 507584 509388 516724 518937 521494 523244 525183 525400 526423 528445 532157 547086 548119 551072 553102 567203 570878 573742 579192 601164 619184 622408 663259 668761 673349 703293 707380 712041 715465 726555 730115 748066 748404 753783 761112 766484 782522 799783 812181 824660 824719 ] |
||||||||||||||||||||||||||||||
|
15.24 ms (8.90%) |
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 518937 445306 507584 453710 528445 447390 673349 570878 663259 622408 619184 573742 715465 748404 423899 703293 405805 427472 417930 425597 441866 456186 499993 74842 425563 799783 403163 428467 459676 402980 446042 489668 418063 753783 400930 525183 435289 426091 425547 416882 425540 391610 548119 707380 395189 490221 601164 437255 386128 730115 525400 824660 712041 397101 447757 413663 454497 426739 523244 496115 547086 250587 395794 108029 782522 490749 407130 442447 447013 396093 444674 418797 448089 748066 668761 396361 412841 395203 425532 419940 385243 579192 453902 502636 492813 405744 812181 761112 509388 824719 419248 498178 417100 418996 460129 567203 726555 437325 448483 435130 443190 447758 398308 398742 551072 422207 400968 447753 472108 532157 766484 526423 427045 494543 484321 516724 553102 451636 521494 382409 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.51%) |
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 74842 108029 250587 382409 385243 386128 391610 395189 395203 395794 396093 396361 397101 398308 398742 400930 400968 402980 403163 405744 405805 407130 412841 413663 416882 417100 417930 418063 418797 418996 419248 419940 422207 423899 425532 425540 425547 425563 425597 426091 426739 427045 427472 428467 435130 435289 437255 437325 441866 442447 443190 444674 445306 446042 447013 447390 447753 447757 447758 448089 448483 451636 453710 453902 454497 456186 459676 460129 472108 484321 489668 490221 490749 492813 494543 496115 498178 499993 502636 507584 509388 516724 518937 521494 523244 525183 525400 526423 528445 532157 547086 548119 551072 553102 567203 570878 573742 579192 601164 619184 622408 663259 668761 673349 703293 707380 712041 715465 726555 730115 748066 748404 753783 761112 766484 782522 799783 812181 824660 824719 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur sleeping"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск спящ"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск спящ"
]
|
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.