Query Metrics
7
Database Queries
7
Different statements
194.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.33 ms (88.98%) |
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 391773 391891 391949 398639 398747 443359 449855 470161 470584 470926 477353 486118 490434 495020 500389 516803 523171 524803 526906 539331 540948 543132 549616 554025 555680 555689 563291 563779 565572 566463 567938 569800 575614 578803 590693 607370 617245 617388 619387 621995 622368 623217 625760 628678 631865 636972 638962 647005 647192 648699 652552 653914 662443 663839 664698 668585 671249 685262 685318 685429 687447 693425 693431 693454 700644 701557 701752 703602 703702 707148 708432 710884 711802 712102 715529 715777 722052 722444 723655 726899 726972 728464 731076 732974 733764 734097 734672 735118 736608 738732 739459 745873 745876 745891 754255 758074 759933 762276 768066 777618 778217 778818 779426 783809 785047 794345 795786 798744 800024 800768 800938 811562 819941 823973 825000 825645 825794 827327 827894 ] |
||||||||||||||||||||||||||||||
|
12.02 ms (6.17%) |
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 647005 703602 622368 631865 745891 516803 783809 798744 722444 539331 735118 500389 495020 578803 567938 823973 827894 540948 563291 638962 693431 523171 768748 708432 662443 628678 555689 778818 758074 647192 563779 811562 731076 736608 693454 754255 443359 827327 825794 819941 470926 710884 685262 800024 549616 668585 687447 607370 636972 745876 701557 671249 470584 652552 566463 391949 825645 732974 779426 762276 619387 575614 685318 685429 524803 590693 554025 569800 700644 707148 703702 722052 486118 398639 825000 543132 745873 768066 726972 794345 648699 653914 621995 715529 625760 785047 734097 733764 778217 391891 693425 663839 526906 711802 664698 617245 617388 555680 723655 712102 795786 449855 470161 565572 623217 701752 759933 800938 391773 398747 477353 777618 715777 800768 734672 726899 728464 738732 739459 490434 ] |
||||||||||||||||||||||||||||||
|
2.70 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 391773 391891 391949 398639 398747 443359 449855 470161 470584 470926 477353 486118 490434 495020 500389 516803 523171 524803 526906 539331 540948 543132 549616 554025 555680 555689 563291 563779 565572 566463 567938 569800 575614 578803 590693 607370 617245 617388 619387 621995 622368 623217 625760 628678 631865 636972 638962 647005 647192 648699 652552 653914 662443 663839 664698 668585 671249 685262 685318 685429 687447 693425 693431 693454 700644 701557 701752 703602 703702 707148 708432 710884 711802 712102 715529 715777 722052 722444 723655 726899 726972 728464 731076 732974 733764 734097 734672 735118 736608 738732 739459 745873 745876 745891 754255 758074 759933 762276 768066 777618 778217 778818 779426 783809 785047 794345 795786 798744 800024 800768 800938 811562 819941 823973 825000 825645 825794 827327 827894 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"любительский секс с с%…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.