Query Metrics
7
Database Queries
7
Different statements
158.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.14 ms (82.82%) |
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 9021 382184 391491 392599 397068 397883 397912 397918 397919 401981 404078 407648 407685 416056 417990 421970 422198 422261 422821 426940 427285 428073 432650 433249 437336 439608 439753 442932 443712 443747 443812 444171 448975 449702 450181 450812 453273 456000 458554 459947 460745 460748 461358 462710 463481 463701 465331 465342 466129 467662 468355 468945 471419 474780 475881 476271 476353 477114 477981 477989 478377 479019 479027 485017 492333 493179 496101 498321 502326 505843 506222 507829 508450 509485 510074 512017 514042 518267 518852 521220 521401 521634 523902 532063 532135 532825 538329 539611 555825 562975 567038 567074 569994 571254 609422 625493 661913 676591 694105 710202 721462 726753 729625 736977 751672 757201 765025 772093 776933 780795 786269 788142 792287 793282 795360 796197 796208 800936 805063 809307 ] |
||||||||||||||||||||||||||||||
|
17.39 ms (10.98%) |
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 467662 567038 710202 555825 562975 569994 800936 772093 465342 468945 476353 477989 421970 439608 474780 401981 465331 466129 475881 509485 518267 493179 485017 506222 521220 477114 502326 625493 9021 397068 392599 407685 416056 496101 462710 518852 453273 538329 532135 721462 776933 788142 795360 809307 729625 786269 751672 765025 793282 508450 510074 444171 514042 492333 479019 443812 460745 442932 476271 479027 477981 382184 443712 407648 676591 422198 505843 391491 397918 428073 417990 422261 432650 450181 450812 459947 449702 471419 571254 726753 397883 443747 437336 456000 422821 426940 448975 460748 439753 463481 478377 468355 512017 498321 523902 507829 463701 532825 539611 532063 694105 661913 609422 780795 736977 757201 521634 521401 567074 397912 397919 404078 433249 427285 458554 461358 796208 805063 792287 796197 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.62%) |
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 9021 382184 391491 392599 397068 397883 397912 397918 397919 401981 404078 407648 407685 416056 417990 421970 422198 422261 422821 426940 427285 428073 432650 433249 437336 439608 439753 442932 443712 443747 443812 444171 448975 449702 450181 450812 453273 456000 458554 459947 460745 460748 461358 462710 463481 463701 465331 465342 466129 467662 468355 468945 471419 474780 475881 476271 476353 477114 477981 477989 478377 479019 479027 485017 492333 493179 496101 498321 502326 505843 506222 507829 508450 509485 510074 512017 514042 518267 518852 521220 521401 521634 523902 532063 532135 532825 538329 539611 555825 562975 567038 567074 569994 571254 609422 625493 661913 676591 694105 710202 721462 726753 729625 736977 751672 757201 765025 772093 776933 780795 786269 788142 792287 793282 795360 796197 796208 800936 805063 809307 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom парен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom парен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom boy amateurs"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.