Query Metrics
7
Database Queries
7
Different statements
158.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.33 ms (79.93%) |
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 48366 53932 198305 350665 382656 392075 397152 401392 412537 414295 472130 482737 494903 531003 545974 546370 547655 549841 551388 555016 561837 562361 564070 564079 564137 566587 567380 568055 568848 569602 569912 571137 571423 572164 572422 572434 574223 578357 579003 580869 581527 583706 588957 590569 591247 593154 595454 596672 597025 598810 598920 600489 601110 601409 601647 603023 604038 607150 608242 608549 610404 610625 610628 613210 617060 618806 618924 620203 620712 620882 621515 624430 628202 628620 630051 634289 634495 645685 648325 648478 654479 655615 655705 666914 671104 684412 687522 689613 691957 696867 697104 697598 698936 709366 717263 722957 723156 724735 729071 729405 729446 731030 731217 739553 747975 751950 754785 758833 762895 765548 765595 768974 776322 782664 786643 789038 790138 790788 793767 811747 ] |
||||||||||||||||||||||||||||||
|
21.14 ms (13.37%) |
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 198305 392075 350665 382656 48366 53932 397152 401392 414295 412537 531003 494903 472130 564070 569912 574223 578357 581527 571423 572434 579003 648478 666914 684412 691957 709366 645685 648325 696867 697598 717263 698936 722957 723156 545974 547655 588957 601647 628620 603023 590569 601409 610625 634289 789038 793767 811747 782664 790788 729071 731030 747975 754785 768974 729446 758833 762895 729405 731217 739553 751950 765548 765595 724735 628202 630051 697104 776322 786643 790138 482737 549841 567380 569602 561837 562361 564079 546370 555016 564137 566587 568848 572164 572422 580869 689613 671104 654479 655615 655705 687522 551388 568055 571137 583706 596672 597025 598920 604038 607150 621515 595454 608242 610628 617060 618806 618924 591247 598810 600489 601110 608549 610404 613210 620203 620712 620882 624430 634495 593154 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.80%) |
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 48366 53932 198305 350665 382656 392075 397152 401392 412537 414295 472130 482737 494903 531003 545974 546370 547655 549841 551388 555016 561837 562361 564070 564079 564137 566587 567380 568055 568848 569602 569912 571137 571423 572164 572422 572434 574223 578357 579003 580869 581527 583706 588957 590569 591247 593154 595454 596672 597025 598810 598920 600489 601110 601409 601647 603023 604038 607150 608242 608549 610404 610625 610628 613210 617060 618806 618924 620203 620712 620882 621515 624430 628202 628620 630051 634289 634495 645685 648325 648478 654479 655615 655705 666914 671104 684412 687522 689613 691957 696867 697104 697598 698936 709366 717263 722957 723156 724735 729071 729405 729446 731030 731217 739553 747975 751950 754785 758833 762895 765548 765595 768974 776322 782664 786643 789038 790138 790788 793767 811747 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сучк"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.