Query Metrics
7
Database Queries
7
Different statements
144.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.30 ms (82.73%) |
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 584961 586100 589383 590297 591572 591753 591904 592638 593834 601955 606034 607965 610484 616500 616569 626133 626163 627455 628261 634066 644217 699207 703279 705153 707606 708167 709322 714286 719449 719944 720593 723889 725439 728564 730102 730355 731762 734069 734155 734184 735776 736972 738068 738499 738514 739740 739950 740418 741857 741930 744002 744067 744238 746175 747083 747333 749979 750211 752111 755613 756771 758358 759198 761164 763794 763931 767483 767654 768350 768660 768745 769165 770048 772125 773187 773315 773322 777815 777862 777883 777942 778005 778817 780185 782047 782150 782565 783009 783278 783830 783964 784889 785241 786929 787282 787815 788011 790724 792993 793005 793271 793669 794004 794442 794700 795523 795970 795976 799090 799892 801537 801724 803367 803566 807424 809028 810754 812580 813464 813537 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (9.89%) |
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 705153 709322 714286 719449 584961 606034 607965 610484 626133 628261 634066 644217 590297 591572 592638 626163 627455 586100 591753 593834 616500 616569 589383 591904 777862 783830 787815 793271 794004 799892 803367 807424 777942 782150 783009 783964 790724 792993 793005 794700 795970 795976 799090 801537 813537 725439 728564 734155 744002 744238 746175 749979 752111 767483 768660 773187 782047 782565 783278 784889 785241 786929 787282 788011 793669 794442 795523 801724 803566 809028 810754 812580 813464 730355 731762 734069 734184 735776 738514 739740 741857 768350 723889 730102 738499 739950 747083 750211 755613 763931 773315 773322 741930 744067 747333 768745 769165 770048 772125 736972 738068 740418 756771 758358 759198 761164 763794 767654 601955 699207 703279 707606 708167 719944 720593 777815 777883 778005 778817 780185 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.99%) |
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 584961 586100 589383 590297 591572 591753 591904 592638 593834 601955 606034 607965 610484 616500 616569 626133 626163 627455 628261 634066 644217 699207 703279 705153 707606 708167 709322 714286 719449 719944 720593 723889 725439 728564 730102 730355 731762 734069 734155 734184 735776 736972 738068 738499 738514 739740 739950 740418 741857 741930 744002 744067 744238 746175 747083 747333 749979 750211 752111 755613 756771 758358 759198 761164 763794 763931 767483 767654 768350 768660 768745 769165 770048 772125 773187 773315 773322 777815 777862 777883 777942 778005 778817 780185 782047 782150 782565 783009 783278 783830 783964 784889 785241 786929 787282 787815 788011 790724 792993 793005 793271 793669 794004 794442 794700 795523 795970 795976 799090 799892 801537 801724 803367 803566 807424 809028 810754 812580 813464 813537 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation cum"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац cum"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац cum"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
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.