Query Metrics
7
Database Queries
7
Different statements
181.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.85 ms (87.29%) |
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 406621 416928 420719 443396 444774 445267 445616 451907 452201 462111 462740 477196 478208 478681 479248 481059 481150 485796 490855 494991 496636 499572 504713 506579 508612 509558 510142 511048 511481 511689 514400 516517 520783 521896 523987 525300 527250 528378 529048 529349 529426 534590 534600 538984 539889 540985 541686 541727 541948 546332 547911 548043 548690 549458 551456 551478 553650 553784 555651 559824 560672 560799 560971 561633 561861 562120 562211 562284 563575 564348 566836 567402 567646 567701 568629 568687 568701 569058 569466 569471 569638 570988 574731 575535 578108 578865 579875 581133 583512 584087 584131 584867 588568 588726 589200 589729 591921 595226 595512 598874 599261 602651 605986 610121 610300 612055 614935 616939 617899 617969 619340 626080 627578 637418 648939 664630 678620 764654 779193 812697 ] |
||||||||||||||||||||||||||||||
|
14.33 ms (7.87%) |
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 499572 523987 529048 527250 534590 511481 534600 538984 481059 541948 548690 551478 553784 560799 562211 567402 567646 568629 569471 569638 578865 548043 549458 559824 560971 561633 561861 562120 564348 566836 568701 541686 547911 560672 567701 569466 581133 583512 584131 584867 648939 664630 678620 555651 562284 563575 568687 569058 570988 578108 579875 588568 598874 610121 617969 626080 589729 591921 595512 602651 612055 614935 637418 588726 599261 616939 589200 610300 617899 812697 764654 619340 627578 779193 462111 444774 477196 479248 445616 462740 478208 511689 521896 525300 528378 508612 511048 509558 510142 516517 496636 553650 574731 595226 584087 575535 406621 551456 605986 445267 506579 514400 529349 443396 416928 420719 451907 478681 481150 485796 452201 539889 504713 520783 494991 529426 490855 540985 541727 546332 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.30%) |
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 406621 416928 420719 443396 444774 445267 445616 451907 452201 462111 462740 477196 478208 478681 479248 481059 481150 485796 490855 494991 496636 499572 504713 506579 508612 509558 510142 511048 511481 511689 514400 516517 520783 521896 523987 525300 527250 528378 529048 529349 529426 534590 534600 538984 539889 540985 541686 541727 541948 546332 547911 548043 548690 549458 551456 551478 553650 553784 555651 559824 560672 560799 560971 561633 561861 562120 562211 562284 563575 564348 566836 567402 567646 567701 568629 568687 568701 569058 569466 569471 569638 570988 574731 575535 578108 578865 579875 581133 583512 584087 584131 584867 588568 588726 589200 589729 591921 595226 595512 598874 599261 602651 605986 610121 610300 612055 614935 616939 617899 617969 619340 626080 627578 637418 648939 664630 678620 764654 779193 812697 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy pov худые"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак пов худые"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак пов худые"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.82%) |
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.