Query Metrics
7
Database Queries
7
Different statements
199.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.22 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 16974 383315 392386 396439 406945 408988 417162 429024 437616 448045 451495 453451 454942 457153 462369 465055 466105 467022 480513 482585 485039 492644 493119 496304 496668 496923 506010 507006 509353 509874 510841 511638 513117 513821 516069 516988 518932 520257 523071 524741 525146 526856 532321 533264 534466 536432 537164 538794 540403 545104 545137 545623 546517 547581 547954 549656 550642 551688 551689 558367 559255 564393 566118 568637 568654 568976 571312 572719 575250 575315 577876 581425 583799 584686 587394 592324 593289 595308 597618 598762 604005 604997 605667 606035 609990 616551 619370 620992 622309 626356 627202 630088 639982 644119 644160 645621 668015 668776 669247 670811 681501 713641 726653 736928 743240 749611 750301 750666 763861 765220 769448 770544 777154 778423 794192 795752 804249 809297 810464 811060 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (6.85%) |
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 763861 794192 810464 795752 811060 406945 587394 437616 493119 480513 496668 778423 749611 736928 509874 770544 485039 516069 516988 518932 545137 769448 496304 392386 526856 568976 571312 581425 644160 598762 408988 558367 743240 448045 532321 513117 534466 537164 538794 511638 513821 551689 546517 668776 668015 713641 575250 606035 630088 619370 622309 644119 605667 620992 604997 777154 809297 750666 765220 726653 804249 383315 507006 568637 627202 639982 465055 457153 547581 550642 681501 597618 545104 533264 592324 496923 525146 536432 551688 559255 568654 577876 566118 564393 595308 604005 616551 16974 454942 453451 509353 572719 626356 609990 593289 750301 451495 466105 462369 492644 506010 396439 417162 429024 510841 524741 540403 523071 520257 467022 482585 583799 547954 549656 575315 584686 545623 669247 645621 670811 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.33%) |
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 16974 383315 392386 396439 406945 408988 417162 429024 437616 448045 451495 453451 454942 457153 462369 465055 466105 467022 480513 482585 485039 492644 493119 496304 496668 496923 506010 507006 509353 509874 510841 511638 513117 513821 516069 516988 518932 520257 523071 524741 525146 526856 532321 533264 534466 536432 537164 538794 540403 545104 545137 545623 546517 547581 547954 549656 550642 551688 551689 558367 559255 564393 566118 568637 568654 568976 571312 572719 575250 575315 577876 581425 583799 584686 587394 592324 593289 595308 597618 598762 604005 604997 605667 606035 609990 616551 619370 620992 622309 626356 627202 630088 639982 644119 644160 645621 668015 668776 669247 670811 681501 713641 726653 736928 743240 749611 750301 750666 763861 765220 769448 770544 777154 778423 794192 795752 804249 809297 810464 811060 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопой трется"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп трет"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп трет"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.76%) |
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.