Query Metrics
7
Database Queries
7
Different statements
178.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.35 ms (85.99%) |
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 533820 535706 536170 536490 537318 542990 544774 547979 556023 558102 571093 575999 578866 578907 585310 585635 588756 589191 591044 591162 591967 592498 592717 593039 593317 598955 599765 600486 601849 602585 604882 606055 607143 609976 612388 613958 616018 617524 619606 619863 628511 628570 632230 635231 635930 637523 641627 644550 645910 668511 668703 668899 674493 687313 710878 714215 714283 714388 715472 720275 722005 723279 726829 728466 728616 730988 732385 733396 733433 734265 735998 747899 749019 749613 751421 752189 752193 753663 753777 754607 754773 754782 754818 755060 756043 759146 760077 760171 760172 762560 769482 772329 774098 778527 780708 781124 781765 787335 787654 788319 790740 790825 795027 797177 798419 801977 802005 802381 803456 804069 808034 808126 808494 808948 810315 810523 811240 812187 812281 812527 ] |
||||||||||||||||||||||||||||||
|
15.53 ms (8.71%) |
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 537318 535706 542990 544774 547979 558102 575999 674493 715472 720275 645910 668899 710878 714215 714283 714388 571093 578866 585310 599765 600486 602585 616018 635231 641627 591967 592498 592717 593317 598955 604882 606055 612388 635930 637523 644550 591044 601849 585635 589191 593039 607143 613958 628570 798419 811240 812187 778527 780708 787654 790825 804069 810523 812281 733396 752189 754607 760077 760171 762560 795027 797177 808948 812527 728466 760172 730988 733433 749019 753663 772329 728616 752193 754773 754818 769482 749613 751421 753777 755060 617524 632230 722005 723279 787335 790740 802381 803456 808034 808126 808494 536170 533820 536490 556023 578907 687313 668511 588756 619863 619606 628511 609976 781124 781765 734265 774098 732385 754782 788319 810315 668703 591162 801977 802005 735998 756043 759146 726829 747899 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.48%) |
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 533820 535706 536170 536490 537318 542990 544774 547979 556023 558102 571093 575999 578866 578907 585310 585635 588756 589191 591044 591162 591967 592498 592717 593039 593317 598955 599765 600486 601849 602585 604882 606055 607143 609976 612388 613958 616018 617524 619606 619863 628511 628570 632230 635231 635930 637523 641627 644550 645910 668511 668703 668899 674493 687313 710878 714215 714283 714388 715472 720275 722005 723279 726829 728466 728616 730988 732385 733396 733433 734265 735998 747899 749019 749613 751421 752189 752193 753663 753777 754607 754773 754782 754818 755060 756043 759146 760077 760171 760172 762560 769482 772329 774098 778527 780708 781124 781765 787335 787654 788319 790740 790825 795027 797177 798419 801977 802005 802381 803456 804069 808034 808126 808494 808948 810315 810523 811240 812187 812281 812527 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy tits masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy сиськ мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy сиськ мастурбац"
]
|
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.