Query Metrics
7
Database Queries
7
Different statements
171.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.02 ms (87.88%) |
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 66264 389199 400409 400484 425894 426124 446447 455924 465723 468303 469147 474748 494740 501541 516149 530038 532879 536124 538770 542723 546837 551541 551912 554436 560826 582648 583795 586228 590067 592227 592297 594183 595478 598284 605067 610923 614759 614793 615260 619648 620737 621289 627794 627796 632101 634902 637389 639982 642426 644583 646312 652235 673111 679283 691834 699518 702305 710379 717942 720195 721706 722340 722403 725035 725487 726229 726582 733221 734661 736106 736359 736918 737533 739896 740749 740815 742321 742983 744016 744210 744260 744775 748901 756661 757521 761568 764884 765522 767798 768640 769100 771163 771290 779254 780977 781512 781568 782604 786202 788153 790229 795915 795918 797467 798891 799830 800661 801604 802551 803404 804420 805665 816608 825143 826589 826827 827218 827431 827932 ] |
||||||||||||||||||||||||||||||
|
11.18 ms (6.50%) |
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 816608 764884 66264 455924 742983 786202 532879 691834 780977 797467 805665 736359 739896 781568 494740 501541 583795 632101 744260 554436 637389 734661 400409 530038 634902 598284 798891 733221 765522 744210 762206 615260 801604 827431 722403 782604 721706 673111 595478 781512 474748 737533 827218 546837 827932 736106 389199 679283 779254 744775 740749 761568 767798 551541 748901 804420 826827 516149 717942 619648 627796 725487 757521 614759 720195 802551 465723 826589 590067 620737 803404 771290 446447 795915 426124 582648 652235 586228 744016 725035 726229 768640 771163 722340 742321 400484 825143 551912 639982 538770 542723 560826 699518 702305 646312 594183 621289 605067 592227 627794 642426 799830 788153 769100 736918 740815 610923 644583 710379 469147 425894 726582 536124 468303 592297 614793 790229 756661 795918 800661 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.66%) |
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 66264 389199 400409 400484 425894 426124 446447 455924 465723 468303 469147 474748 494740 501541 516149 530038 532879 536124 538770 542723 546837 551541 551912 554436 560826 582648 583795 586228 590067 592227 592297 594183 595478 598284 605067 610923 614759 614793 615260 619648 620737 621289 627794 627796 632101 634902 637389 639982 642426 644583 646312 652235 673111 679283 691834 699518 702305 710379 717942 720195 721706 722340 722403 725035 725487 726229 726582 733221 734661 736106 736359 736918 737533 739896 740749 740815 742321 742983 744016 744210 744260 744775 748901 756661 757521 761568 764884 765522 767798 768640 769100 771163 771290 779254 780977 781512 781568 782604 786202 788153 790229 795915 795918 797467 798891 799830 800661 801604 802551 803404 804420 805665 816608 825143 826589 826827 827218 827431 827932 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп pussy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп pussy"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass pussy"
]
|
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.