Query Metrics
7
Database Queries
7
Different statements
196.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.42 ms (86.10%) |
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 4205 65700 383462 391150 420328 420333 423346 444614 446502 452344 468232 472357 474721 482913 485014 488203 490162 490169 490380 492991 503745 522420 539962 542030 547058 552756 553206 557937 560883 574115 576540 577599 579808 583115 584678 584681 585645 591097 593509 598640 602023 606919 608529 613498 614592 616993 618429 629828 630991 632340 632564 638750 641444 647048 664483 665094 669583 669587 679415 680969 689833 689849 689898 694862 695413 698497 702557 703339 704984 705459 706642 709504 712228 723637 733434 734264 737804 738928 745872 746001 747376 755961 758158 759316 761142 768053 768092 773182 773326 778452 781108 783933 784048 787078 788690 791297 796515 799734 800707 800754 801810 805037 805073 809800 810322 810638 817146 818215 819670 819810 823506 823576 824914 825201 825432 825582 826493 827578 827654 827722 ] |
||||||||||||||||||||||||||||||
|
17.92 ms (9.11%) |
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 602023 488203 492991 391150 591097 423346 490162 383462 444614 689833 712228 702557 689849 641444 787078 805037 733434 784048 759316 773326 810638 823576 723637 825582 827578 827722 819670 824914 818215 823506 825432 474721 472357 539962 522420 490169 552756 577599 579808 576540 583115 669587 689898 694862 695413 664483 703339 705459 680969 704984 553206 614592 632340 593509 608529 613498 618429 606919 616993 629828 598640 638750 781108 796515 799734 805073 747376 791297 734264 737804 755961 768053 745872 746001 768092 773182 630991 632564 778452 783933 801810 809800 810322 4205 420328 706642 468232 490380 800754 738928 758158 420333 452344 560883 585645 788690 761142 800707 485014 446502 557937 482913 65700 826493 819810 817146 825201 827654 503745 542030 574115 584678 584681 547058 647048 665094 669583 679415 698497 709504 ] |
||||||||||||||||||||||||||||||
|
2.56 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 4205 65700 383462 391150 420328 420333 423346 444614 446502 452344 468232 472357 474721 482913 485014 488203 490162 490169 490380 492991 503745 522420 539962 542030 547058 552756 553206 557937 560883 574115 576540 577599 579808 583115 584678 584681 585645 591097 593509 598640 602023 606919 608529 613498 614592 616993 618429 629828 630991 632340 632564 638750 641444 647048 664483 665094 669583 669587 679415 680969 689833 689849 689898 694862 695413 698497 702557 703339 704984 705459 706642 709504 712228 723637 733434 734264 737804 738928 745872 746001 747376 755961 758158 759316 761142 768053 768092 773182 773326 778452 781108 783933 784048 787078 788690 791297 796515 799734 800707 800754 801810 805037 805073 809800 810322 810638 817146 818215 819670 819810 823506 823576 824914 825201 825432 825582 826493 827578 827654 827722 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation hidden"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
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.