Query Metrics
7
Database Queries
7
Different statements
156.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.79 ms (82.22%) |
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 233333 233532 382808 386973 391149 392603 398999 409291 411366 411421 418792 422197 425482 427135 433599 438607 444106 444147 448975 454265 456724 458488 459747 462156 463504 466079 466285 469896 469937 470316 470499 470706 473673 474194 477610 479959 483055 483286 483600 484381 484781 485223 485425 486375 486385 502938 504194 505068 506356 506670 513336 514464 526111 538603 545662 546448 549642 549785 568847 570314 572662 575160 586603 589560 595459 596579 598665 598815 616958 623936 656737 657367 657587 659401 659803 659849 660892 660901 660921 663260 667025 673550 675860 683278 695087 695109 696449 701247 704021 704174 716013 716583 719443 722434 731216 735567 737028 739956 741042 741588 743479 745949 749951 758175 766523 788377 793592 796300 803639 806973 811275 818084 818089 819884 825172 826379 828540 828544 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (11.05%) |
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 444106 466079 486375 505068 514464 483055 484781 470499 470316 454265 502938 485223 696449 391149 485425 818084 819884 745949 484381 572662 456724 386973 411421 444147 568847 575160 596579 589560 506670 473673 418792 448975 463504 469937 474194 422197 433599 459747 486385 504194 513336 483286 483600 506356 470706 788377 427135 438607 458488 466285 479959 526111 546448 657367 663260 673550 695109 656737 660921 735567 545662 722434 818089 716583 586603 825172 826379 828544 828540 549642 570314 660892 660901 683278 659803 704021 657587 659849 616958 741042 382808 462156 549785 659401 667025 695087 719443 662145 675860 701247 704174 716013 595459 598665 598815 803639 766523 749951 739956 743479 751259 758175 731216 737028 741588 425482 469896 538603 623936 796300 806973 793592 811275 398999 477610 392603 409291 411366 233333 233532 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.72%) |
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 233333 233532 382808 386973 391149 392603 398999 409291 411366 411421 418792 422197 425482 427135 433599 438607 444106 444147 448975 454265 456724 458488 459747 462156 463504 466079 466285 469896 469937 470316 470499 470706 473673 474194 477610 479959 483055 483286 483600 484381 484781 485223 485425 486375 486385 502938 504194 505068 506356 506670 513336 514464 526111 538603 545662 546448 549642 549785 568847 570314 572662 575160 586603 589560 595459 596579 598665 598815 616958 623936 656737 657367 657587 659401 659803 659849 660892 660901 660921 663260 667025 673550 675860 683278 695087 695109 696449 701247 704021 704174 716013 716583 719443 722434 731216 735567 737028 739956 741042 741588 743479 745949 749951 758175 766523 788377 793592 796300 803639 806973 811275 818084 818089 819884 825172 826379 828540 828544 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big natural russian"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие натуральная натуральные русск"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
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.