Query Metrics
7
Database Queries
7
Different statements
214.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.20 ms (88.18%) |
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 170069 232048 238575 272725 385014 386798 390264 390272 393339 413398 415956 416512 419609 423187 423964 429793 429900 433747 435652 436095 441213 444538 444780 446037 446356 449397 449421 450255 450994 452968 453470 454922 457474 460894 461842 471528 471929 479743 479746 479749 483380 486660 488520 490380 493837 493871 495793 510175 510292 510543 513578 513806 513812 515317 517928 519368 520220 521290 523680 525075 527256 528663 529191 529882 530459 546321 550676 552336 553442 568809 573748 575418 580391 581121 585885 588215 592440 602056 612602 615692 616818 619102 623624 626541 630083 637494 638525 642378 666503 674204 678934 707900 727381 733357 734062 738432 741853 741856 742765 745914 746123 746457 756526 769828 771235 779635 779702 780146 783126 783127 787732 787741 787766 792238 793123 793158 796875 810653 826617 827064 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.18%) |
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 452968 413398 450255 519368 416512 483380 513578 446356 444538 490380 429793 573748 429900 419609 495793 436095 433747 493837 626541 232048 471528 525075 441213 581121 450994 479743 792238 733357 746457 423187 742765 779635 552336 460894 771235 623624 479746 170069 779702 787741 527256 585885 423964 612602 529882 780146 666503 616818 787766 642378 528663 520220 674204 787732 741853 510543 568809 444780 471929 486660 390264 746123 738432 810653 580391 449397 513812 461842 510175 385014 550676 793158 238575 446037 479749 530459 521290 769828 793123 756526 745914 515317 386798 592440 783127 734062 393339 513806 575418 796875 741856 272725 454922 529191 493871 517928 619102 727381 783126 637494 588215 826617 435652 449421 678934 638525 707900 488520 453470 546321 415956 523680 553442 602056 510292 390272 457474 615692 630083 827064 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.38%) |
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 170069 232048 238575 272725 385014 386798 390264 390272 393339 413398 415956 416512 419609 423187 423964 429793 429900 433747 435652 436095 441213 444538 444780 446037 446356 449397 449421 450255 450994 452968 453470 454922 457474 460894 461842 471528 471929 479743 479746 479749 483380 486660 488520 490380 493837 493871 495793 510175 510292 510543 513578 513806 513812 515317 517928 519368 520220 521290 523680 525075 527256 528663 529191 529882 530459 546321 550676 552336 553442 568809 573748 575418 580391 581121 585885 588215 592440 602056 612602 615692 616818 619102 623624 626541 630083 637494 638525 642378 666503 674204 678934 707900 727381 733357 734062 738432 741853 741856 742765 745914 746123 746457 756526 769828 771235 779635 779702 780146 783126 783127 787732 787741 787766 792238 793123 793158 796875 810653 826617 827064 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк игрушк"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочка игрушки"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.69%) |
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.