Query Metrics
7
Database Queries
7
Different statements
148.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.97 ms (82.68%) |
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 394335 404394 478902 490491 513173 522716 531689 534947 538791 540106 541587 541912 547116 548024 555172 566397 567624 570815 571176 578419 581927 585315 594533 597762 602726 605021 612987 615414 619134 621366 626507 627482 630314 641427 641648 644524 645259 648059 648236 649646 653320 661429 661494 671119 684783 686733 687771 690588 696314 697716 701230 702372 708042 713951 716611 716955 719746 723966 724616 729869 729989 730114 732193 732827 733318 735167 736390 736752 736892 738469 738895 739795 739932 741078 744496 745313 745883 745889 748867 749928 749997 750038 750860 755116 760508 762344 765698 765723 765796 766090 767762 768587 770712 771705 773465 774207 775998 778546 779695 785799 787177 787661 790468 791163 793747 793748 793809 794401 795338 796737 797564 798163 810034 810615 810751 814290 817655 820368 825121 826630 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (8.96%) |
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 732827 762344 723966 724616 767762 729989 765698 736390 738895 770712 790468 796737 394335 775998 798163 793747 738469 817655 820368 825121 826630 814290 671119 716611 648236 578419 793748 810751 810034 733318 793809 779695 810615 541587 404394 490491 513173 531689 538791 522716 534947 540106 478902 541912 547116 548024 571176 555172 566397 581927 648059 653320 697716 702372 645259 661429 661494 684783 686733 687771 690588 701230 713951 649646 696314 708042 567624 570815 585315 605021 615414 619134 626507 641648 612987 621366 641427 594533 597762 630314 778546 787177 791163 794401 797564 729869 741078 755116 766090 774207 785799 787661 795338 735167 736752 736892 744496 749928 750038 739932 765723 773465 730114 739795 745313 745889 748867 750860 768587 732193 745883 749997 760508 765796 771705 602726 627482 644524 716955 719746 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking секс"
]
|
||||||||||||||||||||||||||||||
|
3.06 ms (2.06%) |
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 394335 404394 478902 490491 513173 522716 531689 534947 538791 540106 541587 541912 547116 548024 555172 566397 567624 570815 571176 578419 581927 585315 594533 597762 602726 605021 612987 615414 619134 621366 626507 627482 630314 641427 641648 644524 645259 648059 648236 649646 653320 661429 661494 671119 684783 686733 687771 690588 696314 697716 701230 702372 708042 713951 716611 716955 719746 723966 724616 729869 729989 730114 732193 732827 733318 735167 736390 736752 736892 738469 738895 739795 739932 741078 744496 745313 745883 745889 748867 749928 749997 750038 750860 755116 760508 762344 765698 765723 765796 766090 767762 768587 770712 771705 773465 774207 775998 778546 779695 785799 787177 787661 790468 791163 793747 793748 793809 794401 795338 796737 797564 798163 810034 810615 810751 814290 817655 820368 825121 826630 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking sex"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.19%) |
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.