Query Metrics
7
Database Queries
7
Different statements
151.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.37 ms (79.69%) |
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 68967 91254 387393 395193 397184 398166 401287 416299 456794 464137 468872 471887 492693 502613 521860 532243 533224 537624 537630 539541 544917 546168 547917 549705 549716 558996 562232 565827 571260 578431 583641 590464 594872 596051 603190 604883 605433 614078 615691 621364 628609 628682 635197 635312 635847 637504 638059 642275 644119 651800 663899 665696 666390 667903 668154 675990 680745 685672 696820 699446 701581 705339 706668 711624 714712 716278 716468 716482 717614 718491 719890 721217 730134 731036 738395 739783 740472 743350 746095 753933 755589 759726 769163 771660 771824 772107 772629 774597 775350 776148 780943 784194 791196 795415 797018 797042 801268 802702 802801 802869 808591 808671 810134 813706 813888 817020 817544 817639 817883 818559 820419 820713 824054 824342 824688 825202 825818 826698 826703 827253 ] |
||||||||||||||||||||||||||||||
|
13.17 ms (8.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 780943 395193 387393 401287 817639 818559 824342 824688 826703 826698 813706 820419 820713 456794 464137 502613 549705 549716 675990 680745 711624 718491 651800 668154 699446 716278 717614 667903 714712 578431 590464 596051 628682 635197 594872 621364 638059 644119 604883 628609 635312 635847 605433 774597 791196 801268 802801 775350 776148 797018 797042 731036 743350 753933 755589 772107 772629 795415 802702 808671 810134 738395 769163 740472 759726 739783 746095 771660 771824 730134 615691 642275 784194 802869 808591 397184 68967 91254 398166 416299 817544 825202 817020 817883 827253 813888 824054 825818 471887 492693 521860 532243 537630 533224 539541 537624 468872 547917 571260 583641 562232 565827 666390 705339 716468 716482 663899 665696 701581 685672 696820 706668 719890 721217 544917 546168 558996 614078 603190 637504 ] |
||||||||||||||||||||||||||||||
|
9.49 ms (6.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ fucking"
]
|
||||||||||||||||||||||||||||||
|
3.12 ms (2.07%) |
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 68967 91254 387393 395193 397184 398166 401287 416299 456794 464137 468872 471887 492693 502613 521860 532243 533224 537624 537630 539541 544917 546168 547917 549705 549716 558996 562232 565827 571260 578431 583641 590464 594872 596051 603190 604883 605433 614078 615691 621364 628609 628682 635197 635312 635847 637504 638059 642275 644119 651800 663899 665696 666390 667903 668154 675990 680745 685672 696820 699446 701581 705339 706668 711624 714712 716278 716468 716482 717614 718491 719890 721217 730134 731036 738395 739783 740472 743350 746095 753933 755589 759726 769163 771660 771824 772107 772629 774597 775350 776148 780943 784194 791196 795415 797018 797042 801268 802702 802801 802869 808591 808671 810134 813706 813888 817020 817544 817639 817883 818559 820419 820713 824054 824342 824688 825202 825818 826698 826703 827253 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits fucking"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ fucking"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.91%) |
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.