Query Metrics
7
Database Queries
7
Different statements
440.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.32 ms (47.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов анал кастинг"
]
|
||||||||||||||||||||||||||||||
|
205.53 ms (46.64%) |
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 415618 446529 483319 489424 497870 521829 530026 530053 530060 530499 530503 530696 530744 530805 531126 531135 531202 531204 531534 532343 532674 532703 532751 533372 533773 536310 536752 537203 537660 537675 537894 540217 540572 543731 545305 545368 545393 545537 545698 599854 599861 599862 599890 599899 599955 599977 600026 600171 600206 601046 601595 601613 606508 610555 614858 614993 615716 617410 624270 628091 630297 631163 631200 631972 632639 632646 632657 632678 633111 633451 633753 633795 633796 633799 634115 634778 635220 636284 636293 636308 637036 637093 639759 639790 640813 641678 645993 646841 646930 648560 648868 650774 651209 666528 666586 666853 666902 668526 672710 674927 674968 674986 676087 676112 676623 676632 678052 678063 678089 678135 678495 678529 679810 680118 687158 701348 704523 708441 716892 720298 ] |
||||||||||||||||||||||||||||||
|
15.78 ms (3.58%) |
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 537660 530060 531135 531204 533372 540217 532674 533773 483319 545305 545368 545537 646930 687158 666528 672710 704523 646841 666902 701348 545393 545698 600171 637093 599955 636284 599862 614993 615716 633451 601595 601613 636293 614858 521829 497870 489424 532751 540572 530696 530026 648560 674968 610555 634115 640813 637036 632678 636308 624270 415618 446529 530499 530503 531202 532343 537203 530053 530744 531126 531534 532703 536310 537675 537894 530805 536752 543731 650774 674927 674986 676087 678052 678089 679810 651209 666853 668526 676112 676632 678063 678495 645993 648868 666586 676623 678135 678529 680118 708441 720298 599861 599890 606508 630297 631972 633795 641678 599977 600026 600206 601046 632657 639759 599854 599899 631200 634778 639790 617410 628091 631163 632639 632646 633111 633753 633796 633799 635220 716892 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (0.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 415618 446529 483319 489424 497870 521829 530026 530053 530060 530499 530503 530696 530744 530805 531126 531135 531202 531204 531534 532343 532674 532703 532751 533372 533773 536310 536752 537203 537660 537675 537894 540217 540572 543731 545305 545368 545393 545537 545698 599854 599861 599862 599890 599899 599955 599977 600026 600171 600206 601046 601595 601613 606508 610555 614858 614993 615716 617410 624270 628091 630297 631163 631200 631972 632639 632646 632657 632678 633111 633451 633753 633795 633796 633799 634115 634778 635220 636284 636293 636308 637036 637093 639759 639790 640813 641678 645993 646841 646930 648560 648868 650774 651209 666528 666586 666853 666902 668526 672710 674927 674968 674986 676087 676112 676623 676632 678052 678063 678089 678135 678495 678529 679810 680118 687158 701348 704523 708441 716892 720298 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial anal casting"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.33%) |
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.