Query Metrics
7
Database Queries
7
Different statements
139.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.42 ms (81.47%) |
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 520879 525945 544232 545403 545418 548389 552601 553692 553696 554841 555601 560493 579783 579866 585350 599987 604636 604715 605512 610771 613958 618177 618867 618870 618902 630536 630821 633244 637511 639741 639751 642226 642774 647822 647860 650634 666850 667354 670779 671773 672764 678780 684318 685511 685701 686265 690942 692621 693985 704582 704896 705351 710935 714599 715888 716582 719649 719829 726729 727534 728276 728860 729187 729236 729253 733119 733122 734350 734360 736534 737598 738118 739919 740846 741402 744832 745998 746616 748973 751437 751453 753656 753707 756461 758145 759313 760446 760939 765812 775815 781358 782745 783930 784246 788643 791003 793601 795924 795974 796803 800119 800949 801810 802194 804371 811658 817207 817613 817864 817879 820347 824438 824896 826541 826849 827190 827279 827490 827591 827592 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (11.23%) |
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 685701 599987 684318 686265 802194 759313 741402 826541 827490 555601 800949 737598 781358 788643 727534 729236 734360 824896 670779 784246 733119 729253 705351 827279 553692 553696 579783 552601 714599 647822 693985 633244 618867 765812 756461 728860 783930 795974 716582 545403 719649 719829 800119 726729 817864 520879 554841 692621 791003 804371 751453 729187 710935 630536 545418 704582 613958 744832 739919 639741 817613 827592 827591 544232 685511 642226 618902 610771 630821 751437 760939 758145 647860 666850 642774 639751 618177 820347 826849 548389 579866 671773 667354 678780 690942 585350 795924 796803 811658 740846 753656 753707 801810 672764 650634 604636 604715 736534 817207 560493 704896 605512 793601 775815 824438 525945 618870 782745 760446 748973 733122 734350 746616 728276 637511 715888 827190 738118 745998 817879 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.14%) |
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 520879 525945 544232 545403 545418 548389 552601 553692 553696 554841 555601 560493 579783 579866 585350 599987 604636 604715 605512 610771 613958 618177 618867 618870 618902 630536 630821 633244 637511 639741 639751 642226 642774 647822 647860 650634 666850 667354 670779 671773 672764 678780 684318 685511 685701 686265 690942 692621 693985 704582 704896 705351 710935 714599 715888 716582 719649 719829 726729 727534 728276 728860 729187 729236 729253 733119 733122 734350 734360 736534 737598 738118 739919 740846 741402 744832 745998 746616 748973 751437 751453 753656 753707 756461 758145 759313 760446 760939 765812 775815 781358 782745 783930 784246 788643 791003 793601 795924 795974 796803 800119 800949 801810 802194 804371 811658 817207 817613 817864 817879 820347 824438 824896 826541 826849 827190 827279 827490 827591 827592 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss fuck"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.11%) |
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.