Query Metrics
7
Database Queries
7
Different statements
141.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.30 ms (82.25%) |
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 390508 396372 396744 398828 417881 419765 423339 430748 465040 482793 503194 511008 517605 517691 531536 532178 532234 533779 533976 535083 537102 540439 541287 542278 546296 548826 556091 556146 563284 563964 571357 572642 575862 576588 577654 586320 591033 593588 596210 596574 597681 597863 605541 606524 613664 615291 616178 616571 616578 616618 616920 630873 633427 633922 633929 633945 634039 634062 639078 641881 642596 645213 654221 654973 659234 668145 669970 674312 694905 696407 706859 710935 711268 711392 711536 711639 712374 716346 716963 717156 717175 723859 732619 732646 732888 732912 733096 733203 734996 737300 737306 737392 738391 738987 739568 739720 740673 745447 747986 750277 764748 769702 769704 771052 773853 784402 784455 784461 793133 796709 801773 804026 810424 819764 823758 823877 827851 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (9.97%) |
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 827851 531536 535083 540439 541287 542278 546296 556091 669970 711268 645213 654221 668145 696407 654973 596574 605541 616178 634062 639078 641881 593588 597681 616618 616920 633929 642596 616571 630873 633427 634039 586320 613664 616578 626934 633922 633945 606524 615291 710935 398828 591033 503194 823758 511008 517691 576588 575862 716963 717175 711392 548826 563284 784402 737392 762326 771052 769704 738987 733096 740673 711639 796709 801773 804026 810424 674312 532234 533976 533779 537102 659234 694905 596210 738391 712374 390508 396372 419765 423339 482793 465040 597863 417881 396744 430748 819764 823877 517605 532178 571357 556146 563964 711536 717156 706859 716346 572642 577654 784461 784463 723859 737306 739568 745447 750277 784455 793133 747986 732888 732912 734996 737300 732619 732646 733203 769702 773853 739720 764748 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.17%) |
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 390508 396372 396744 398828 417881 419765 423339 430748 465040 482793 503194 511008 517605 517691 531536 532178 532234 533779 533976 535083 537102 540439 541287 542278 546296 548826 556091 556146 563284 563964 571357 572642 575862 576588 577654 586320 591033 593588 596210 596574 597681 597863 605541 606524 613664 615291 616178 616571 616578 616618 616920 630873 633427 633922 633929 633945 634039 634062 639078 641881 642596 645213 654221 654973 659234 668145 669970 674312 694905 696407 706859 710935 711268 711392 711536 711639 712374 716346 716963 717156 717175 723859 732619 732646 732888 732912 733096 733203 734996 737300 737306 737392 738391 738987 739568 739720 740673 745447 747986 750277 764748 769702 769704 771052 773853 784402 784455 784461 793133 796709 801773 804026 810424 819764 823758 823877 827851 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc in homemade"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc домашн любительск"
]
|
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.