Query Metrics
7
Database Queries
7
Different statements
196.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.16 ms (85.95%) |
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 28786 72305 98410 121555 123769 145288 145612 145677 172224 172925 176394 191406 232995 246527 268637 325706 341118 382325 383274 383431 384315 384977 385323 385964 389174 389925 393497 395905 407697 411223 413708 418747 422203 439723 439780 439781 440713 444298 444679 445377 446173 446457 453448 454256 454420 457605 457665 463790 466288 469347 470474 472142 477227 477260 478372 482094 485712 501506 511314 514693 519589 521838 523152 523213 525610 529355 532999 533889 535433 537127 540469 543388 546459 549824 550163 552883 557475 559067 560804 568132 569581 571057 591004 591489 602741 621217 621347 644344 648470 697000 746715 752798 774138 786120 788714 795207 803799 816510 816712 817657 817848 818184 818785 818895 819232 819635 819650 819761 820057 820373 820381 820680 820815 822489 822688 823511 823582 824453 824484 825327 ] |
||||||||||||||||||||||||||||||
|
17.73 ms (9.01%) |
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 385964 145288 818184 820381 533889 644344 172224 383274 121555 418747 466288 501506 532999 521838 559067 549824 569581 697000 444298 463790 472142 482094 439780 454256 454420 469347 514693 535433 519589 523213 384315 191406 98410 820373 822489 820057 823511 537127 511314 440713 446457 525610 523152 571057 591004 621347 786120 439781 446173 422203 470474 477260 439723 485712 550163 325706 816712 817848 822688 819761 540469 774138 28786 407697 232995 477227 560804 444679 478372 529355 385323 145612 176394 341118 389925 413708 445377 819635 819650 824453 824484 820815 816510 825327 552883 591489 788714 803799 795207 393497 383431 123769 457605 568132 557475 602741 453448 246527 145677 172925 395905 268637 382325 72305 389174 411223 819232 818785 818895 817657 820680 823582 457665 546459 543388 648470 621217 752798 746715 384977 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.69%) |
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 28786 72305 98410 121555 123769 145288 145612 145677 172224 172925 176394 191406 232995 246527 268637 325706 341118 382325 383274 383431 384315 384977 385323 385964 389174 389925 393497 395905 407697 411223 413708 418747 422203 439723 439780 439781 440713 444298 444679 445377 446173 446457 453448 454256 454420 457605 457665 463790 466288 469347 470474 472142 477227 477260 478372 482094 485712 501506 511314 514693 519589 521838 523152 523213 525610 529355 532999 533889 535433 537127 540469 543388 546459 549824 550163 552883 557475 559067 560804 568132 569581 571057 591004 591489 602741 621217 621347 644344 648470 697000 746715 752798 774138 786120 788714 795207 803799 816510 816712 817657 817848 818184 818785 818895 819232 819635 819650 819761 820057 820373 820381 820680 820815 822489 822688 823511 823582 824453 824484 825327 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen boobs"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн boobs"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн boobs"
]
|
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.