Query Metrics
7
Database Queries
7
Different statements
159.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.20 ms (82.36%) |
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 323352 384562 387393 391820 395101 395193 401287 408776 437417 443143 455129 491864 516641 523212 531448 546026 552425 553433 556864 557352 561076 563966 565991 567430 568171 591560 599604 600855 608900 612520 617236 617392 618048 618712 622019 622488 624106 626653 631253 635384 635559 635719 637450 638426 645268 651835 653047 662911 667846 668136 677114 690494 699638 702542 716681 718200 721974 724616 725093 726609 732979 734650 734653 736219 738081 738836 738895 740627 741729 742815 744194 745354 745968 749367 755151 756256 758298 759805 760763 760764 762439 770712 777175 780943 781776 783498 788349 789053 792273 792938 794695 795157 796295 798127 799664 799807 800663 800777 800994 801791 804606 808215 812924 813706 817404 817549 817639 818502 818559 818657 819870 820024 820419 824342 824688 825841 826273 826698 826703 827624 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (12.05%) |
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 690494 651835 668136 721974 568171 635559 622019 624106 600855 635719 617236 617392 631253 799807 812924 742815 789053 804606 725093 724616 738081 734653 726609 732979 734650 738895 749367 770712 618048 699638 788349 799664 800663 491864 546026 565991 618712 622488 740627 758298 798127 800777 756256 745968 781776 792938 455129 523212 531448 563966 608900 783498 395101 323352 443143 826273 817404 817549 825841 818657 819870 820024 818502 827624 516641 552425 567430 677114 702542 645268 662911 718200 556864 557352 635384 637450 612520 794695 792273 796295 801791 744194 755151 759805 760764 762439 736219 738836 760763 638426 716681 777175 795157 800994 808215 408776 384562 391820 437417 553433 561076 653047 667846 591560 626653 599604 745354 741729 780943 395193 387393 401287 817639 818559 824342 824688 826703 826698 813706 820419 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.39%) |
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 323352 384562 387393 391820 395101 395193 401287 408776 437417 443143 455129 491864 516641 523212 531448 546026 552425 553433 556864 557352 561076 563966 565991 567430 568171 591560 599604 600855 608900 612520 617236 617392 618048 618712 622019 622488 624106 626653 631253 635384 635559 635719 637450 638426 645268 651835 653047 662911 667846 668136 677114 690494 699638 702542 716681 718200 721974 724616 725093 726609 732979 734650 734653 736219 738081 738836 738895 740627 741729 742815 744194 745354 745968 749367 755151 756256 758298 759805 760763 760764 762439 770712 777175 780943 781776 783498 788349 789053 792273 792938 794695 795157 796295 798127 799664 799807 800663 800777 800994 801791 804606 808215 812924 813706 817404 817549 817639 818502 818559 818657 819870 820024 820419 824342 824688 825841 826273 826698 826703 827624 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking tits"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking сиськ"
]
|
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.