Query Metrics
7
Database Queries
7
Different statements
152.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.26 ms (80.16%) |
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 12282 117687 154512 381908 385238 397538 401688 408597 410702 410847 421605 424011 443248 446798 452922 454741 454749 477169 493317 500308 510542 529149 530981 538015 541063 556745 559199 577100 607931 615697 616837 617068 617585 618930 622568 626092 630988 640997 648286 650670 653206 663181 663719 667913 670737 682367 683720 684678 684850 687375 687786 689879 692041 695814 696961 703255 711096 712967 713294 716036 722068 730827 736070 739316 739439 741660 743985 744110 744555 746967 747592 748511 749054 750536 751030 752573 753778 754643 754682 755100 755215 758506 758821 758881 764354 764775 765221 766158 768711 774118 777339 777665 778376 778439 779335 779336 781401 782098 783183 784879 785069 785090 785221 786481 787081 788499 792370 793921 796381 801994 802263 803119 810610 811299 811514 813724 813760 824327 827612 ] |
||||||||||||||||||||||||||||||
|
19.40 ms (12.72%) |
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 650670 670737 687375 713294 684678 684850 687786 689879 556745 626092 616837 617068 617585 607931 618930 777665 785069 778439 785221 786481 803119 730827 783183 793921 741660 748511 766158 768711 774118 753778 754643 739316 739439 747592 751030 755215 764354 749054 696961 703255 777339 781401 782098 796381 12282 577100 824327 779335 744555 778376 744110 385238 401688 559199 663181 765221 454741 452922 421605 529149 716036 454749 663719 692041 695814 630988 736070 754682 381908 397538 813760 712967 648286 653206 667913 615697 622568 802263 743985 785090 810610 811299 755100 746967 750536 758506 758821 779336 541063 711096 640997 788499 424011 410847 446798 510542 443248 500308 813724 530981 752573 682367 784879 758881 768748 801994 722068 787081 410702 477169 792370 764775 154512 117687 408597 538015 811514 827612 493317 683720 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.26%) |
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 12282 117687 154512 381908 385238 397538 401688 408597 410702 410847 421605 424011 443248 446798 452922 454741 454749 477169 493317 500308 510542 529149 530981 538015 541063 556745 559199 577100 607931 615697 616837 617068 617585 618930 622568 626092 630988 640997 648286 650670 653206 663181 663719 667913 670737 682367 683720 684678 684850 687375 687786 689879 692041 695814 696961 703255 711096 712967 713294 716036 722068 730827 736070 739316 739439 741660 743985 744110 744555 746967 747592 748511 749054 750536 751030 752573 753778 754643 754682 755100 755215 758506 758821 758881 764354 764775 765221 766158 768711 774118 777339 777665 778376 778439 779335 779336 781401 782098 783183 784879 785069 785090 785221 786481 787081 788499 792370 793921 796381 801994 802263 803119 810610 811299 811514 813724 813760 824327 827612 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen girl masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.03%) |
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.