Query Metrics
7
Database Queries
7
Different statements
142.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.05 ms (82.91%) |
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 145635 150016 388135 470994 510422 525334 527821 529346 529362 534083 537127 546384 547941 554675 554689 554919 555541 555547 558082 559414 565517 589123 599529 600325 615157 620369 637890 638811 639109 644638 667468 668423 689493 706579 708974 709694 712615 713779 719401 729172 733384 733404 733670 738949 739813 740270 740834 743254 743256 743266 746801 746826 747957 749570 750632 751052 751254 754458 754540 755273 757193 757827 761937 764042 766091 766173 767937 770325 773180 774824 782056 783847 784833 784842 785649 786024 787601 787741 789144 789492 790109 792061 792405 792865 801658 801980 802260 802922 803976 804789 805472 805488 809139 809963 810173 810328 810519 813626 813753 813895 814171 816698 816881 818378 819489 823994 824630 824859 824959 825799 826358 826386 826404 826496 826665 827055 827529 827922 828296 ] |
||||||||||||||||||||||||||||||
|
13.39 ms (9.41%) |
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 145635 470994 747957 764042 790109 754540 600325 510422 527821 785649 558082 826404 599529 826358 388135 733384 826496 828296 668423 826386 565517 824959 805472 787601 827529 819489 637890 792865 740834 757827 827055 801658 805488 816698 816881 818378 708974 719401 547941 827922 529346 802922 709694 620369 786024 782056 746801 766091 743266 773180 743254 784833 784842 787741 150016 828293 534083 559414 789144 802260 810173 761937 755273 739813 770325 810328 783847 713779 546384 743256 554675 809139 809963 766173 738949 740270 746826 803976 825799 824859 529362 712615 639109 792405 750632 733670 751052 757193 644638 801980 789492 810519 792061 824630 813753 823994 525334 537127 554919 667468 689493 589123 733404 749570 729172 751254 615157 804789 813895 767937 814171 555541 554689 754458 774824 813626 826665 555547 706579 638811 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (2.13%) |
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 145635 150016 388135 470994 510422 525334 527821 529346 529362 534083 537127 546384 547941 554675 554689 554919 555541 555547 558082 559414 565517 589123 599529 600325 615157 620369 637890 638811 639109 644638 667468 668423 689493 706579 708974 709694 712615 713779 719401 729172 733384 733404 733670 738949 739813 740270 740834 743254 743256 743266 746801 746826 747957 749570 750632 751052 751254 754458 754540 755273 757193 757827 761937 764042 766091 766173 767937 770325 773180 774824 782056 783847 784833 784842 785649 786024 787601 787741 789144 789492 790109 792061 792405 792865 801658 801980 802260 802922 803976 804789 805472 805488 809139 809963 810173 810328 810519 813626 813753 813895 814171 816698 816881 818378 819489 823994 824630 824859 824959 825799 826358 826386 826404 826496 826665 827055 827529 827922 828296 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbate girl"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"masturbate девушк"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"masturbate девушк"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.22%) |
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.