Query Metrics
7
Database Queries
7
Different statements
172.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.63 ms (84.19%) |
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 95673 381928 386460 391537 395706 396708 400270 400912 405178 411078 411745 426386 448982 451559 468672 470092 476112 499543 523333 530484 530500 531085 531179 531237 531989 532263 533870 534034 534041 534201 534386 534977 534986 535039 536283 536636 536787 537186 537187 537673 537886 537890 539174 547576 556016 562834 577429 597243 597257 599885 600175 601514 601609 604310 619466 619467 620768 628422 630493 631962 633454 633773 633804 634786 634793 637413 638552 640525 643047 643127 643935 649154 649583 650982 660148 666877 670112 671753 678125 678942 678943 678967 680691 681587 681982 695117 696951 707280 714500 716027 720301 720840 722504 722770 722809 723580 733854 741275 741540 742428 748945 750568 751589 770672 775476 775788 785059 799990 801965 807958 810839 813082 814069 814360 814505 814553 814861 814975 818165 820682 ] |
||||||||||||||||||||||||||||||
|
17.23 ms (9.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 637413 537187 547576 523333 381928 396708 405178 411745 426386 723580 814553 818165 820682 814360 814861 814975 814069 476112 448982 531237 537186 531989 534034 534977 535039 537673 531085 531179 532263 537890 499543 537886 562834 577429 649154 650982 707280 722504 649583 660148 670112 678942 678943 680691 681587 720301 720840 722809 671753 681982 695117 716027 556016 643935 597243 597257 601609 619467 633454 600175 630493 633804 640525 643047 604310 619466 631962 638552 643127 775788 775476 801965 748945 770672 785059 810839 742428 733854 741275 741540 750568 620768 634786 696951 722770 799990 807958 813082 386460 400912 395706 391537 400270 468672 451559 95673 411078 814505 470092 530500 534041 534986 539174 533870 534201 530484 536636 536787 534386 536283 666877 678967 678125 599885 601514 628422 634793 751589 633773 714500 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.91%) |
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 95673 381928 386460 391537 395706 396708 400270 400912 405178 411078 411745 426386 448982 451559 468672 470092 476112 499543 523333 530484 530500 531085 531179 531237 531989 532263 533870 534034 534041 534201 534386 534977 534986 535039 536283 536636 536787 537186 537187 537673 537886 537890 539174 547576 556016 562834 577429 597243 597257 599885 600175 601514 601609 604310 619466 619467 620768 628422 630493 631962 633454 633773 633804 634786 634793 637413 638552 640525 643047 643127 643935 649154 649583 650982 660148 666877 670112 671753 678125 678942 678943 678967 680691 681587 681982 695117 696951 707280 714500 716027 720301 720840 722504 722770 722809 723580 733854 741275 741540 742428 748945 750568 751589 770672 775476 775788 785059 799990 801965 807958 810839 813082 814069 814360 814505 814553 814861 814975 818165 820682 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double anal dp"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double анал dp"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double анал dp"
]
|
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.