Query Metrics
7
Database Queries
7
Different statements
164.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.93 ms (83.47%) |
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 369753 402154 418078 438023 440659 454514 457530 458160 476496 479361 480028 481352 481764 482306 483146 486197 486939 489001 491570 491793 494658 496308 498914 499045 508576 509633 515215 515774 517521 517766 522545 525771 526259 526550 527044 527339 533403 533480 533960 534673 536469 540724 545232 545500 545768 547653 548239 548312 552602 552675 555011 555636 555965 558106 558448 559186 559674 559689 559785 561260 562289 562844 563715 564019 566639 566726 569108 570195 570843 571010 573274 574648 575392 575440 575846 576289 578572 581946 583285 583336 584660 588750 589485 590660 591243 591938 592372 594824 595674 600653 600941 602030 602671 605425 606095 607632 608320 608705 613797 614396 617073 618656 619159 619663 621040 624116 626217 626607 634223 634736 635480 639686 642269 643669 655275 656321 672343 682417 684402 689436 ] |
||||||||||||||||||||||||||||||
|
16.14 ms (9.84%) |
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 555965 566726 547653 559186 559689 569108 583285 584660 555636 563715 570195 575846 578572 672343 656321 682417 545500 552675 562289 566639 571010 575440 576289 583336 595674 605425 591243 600941 602030 618656 626217 642269 590660 592372 639686 617073 480028 369753 479361 454514 440659 438023 540724 491570 508576 496308 527339 558448 559785 491793 499045 509633 515774 525771 534673 486197 545768 548239 555011 634736 517521 482306 481352 515215 526550 526259 533480 517766 483146 655275 689436 591938 634223 600653 607632 619663 608320 621040 481764 418078 476496 522545 548312 574648 545232 581946 561260 684402 558106 573274 613797 594824 619159 614396 527044 498914 402154 489001 486939 533403 533960 536469 494658 564019 570843 559674 552602 562844 575392 606095 635480 602671 626607 588750 643669 589485 624116 608705 457530 458160 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.10%) |
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 369753 402154 418078 438023 440659 454514 457530 458160 476496 479361 480028 481352 481764 482306 483146 486197 486939 489001 491570 491793 494658 496308 498914 499045 508576 509633 515215 515774 517521 517766 522545 525771 526259 526550 527044 527339 533403 533480 533960 534673 536469 540724 545232 545500 545768 547653 548239 548312 552602 552675 555011 555636 555965 558106 558448 559186 559674 559689 559785 561260 562289 562844 563715 564019 566639 566726 569108 570195 570843 571010 573274 574648 575392 575440 575846 576289 578572 581946 583285 583336 584660 588750 589485 590660 591243 591938 592372 594824 595674 600653 600941 602030 602671 605425 606095 607632 608320 608705 613797 614396 617073 618656 619159 619663 621040 624116 626217 626607 634223 634736 635480 639686 642269 643669 655275 656321 672343 682417 684402 689436 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на руке"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на рук"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
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.