Query Metrics
7
Database Queries
7
Different statements
143.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.41 ms (80.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 51972 365871 391468 391959 397397 417293 420877 421618 422185 424096 427091 427186 427204 427207 429960 432738 433614 435376 439012 439727 441527 441535 441562 441587 443902 443905 444338 444932 448080 450684 454163 456558 457137 458083 458138 459659 460773 461619 462019 462352 462985 463328 465522 468338 468363 470683 471643 472075 473932 475968 481824 483901 486209 486365 487682 490846 493681 496733 498638 503292 503499 503756 505252 506470 526465 530289 533673 533734 543540 544161 569573 579210 580242 588916 589608 598088 605829 643590 655150 660466 663166 685466 685524 688939 728247 733661 734330 735330 745716 766670 766885 767973 768042 777575 779005 782294 782991 784162 786093 786493 789099 790488 792455 793064 794070 794360 794368 794896 796526 798688 799914 803242 804814 809885 826127 827432 828555 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (11.95%) |
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 487682 439727 828555 493681 643590 799914 804814 793064 391468 483901 391959 463328 803242 472075 397397 503292 503499 794309 744999 827432 735330 429960 543540 365871 468363 544161 688939 660466 605829 792455 777575 779005 784162 798688 782991 766885 782294 794070 461619 470683 471643 481824 533734 663166 443902 526465 490846 794896 498638 450684 433614 444338 794368 441562 673919 685466 685524 796526 786093 733661 768042 417293 766670 786493 427186 51972 530289 789099 794360 460773 458083 465522 589608 598088 468338 456558 505252 435376 441527 588916 444932 432738 443905 826127 486209 427204 728247 421618 441535 441587 454163 462985 569573 448080 457137 458138 506470 767973 439012 580242 503756 424096 473932 475968 462019 579210 462352 496733 734330 422185 486365 790488 420877 533673 655150 745716 809885 427207 427091 459659 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.11%) |
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 51972 365871 391468 391959 397397 417293 420877 421618 422185 424096 427091 427186 427204 427207 429960 432738 433614 435376 439012 439727 441527 441535 441562 441587 443902 443905 444338 444932 448080 450684 454163 456558 457137 458083 458138 459659 460773 461619 462019 462352 462985 463328 465522 468338 468363 470683 471643 472075 473932 475968 481824 483901 486209 486365 487682 490846 493681 496733 498638 503292 503499 503756 505252 506470 526465 530289 533673 533734 543540 544161 569573 579210 580242 588916 589608 598088 605829 643590 655150 660466 663166 685466 685524 688939 728247 733661 734330 735330 745716 766670 766885 767973 768042 777575 779005 782294 782991 784162 786093 786493 789099 790488 792455 793064 794070 794360 794368 794896 796526 798688 799914 803242 804814 809885 826127 827432 828555 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал русской жены"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал русск жен"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.29%) |
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.