Query Metrics
7
Database Queries
7
Different statements
138.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
112.87 ms (81.50%) |
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 233369 382518 391581 392077 392678 405116 411682 422993 424720 425249 428701 430313 430713 432086 436438 444343 445062 452344 452385 455600 456319 461367 467165 475625 478712 482225 491489 506529 510675 514353 527785 531078 549296 550102 551166 551175 557596 559030 560169 562824 564083 564602 565100 566171 569503 574247 582218 587431 587532 595451 595864 596585 599436 599791 600060 602929 604084 605395 605929 606822 610600 611336 612819 614849 621418 621578 622977 623851 623855 623860 624829 626535 631186 638233 638327 638623 638665 641120 641739 664614 672408 673261 673297 673299 673333 673751 676579 689693 696309 698451 701325 705752 712158 714491 723933 728328 746045 756622 759658 761290 793901 794021 798984 799002 801587 807322 815981 817432 817615 818737 818739 818770 821719 821798 823180 825377 825847 828027 828068 ] |
||||||||||||||||||||||||||||||
|
16.04 ms (11.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 424720 392678 557596 527785 482225 551166 478712 817615 821798 676579 673297 638665 623851 604084 621418 614849 801587 233369 391581 422993 560169 582218 599436 491489 531078 818739 828027 631186 452344 606822 600060 821719 696309 623855 610600 510675 452385 602929 605395 461367 551175 425249 456319 817432 828068 664614 807322 430713 445062 432086 815981 822502 823180 549296 673299 689693 698451 714491 673751 701325 595864 596585 621578 622977 638623 641739 587532 595451 611336 624829 626535 587431 641120 728328 761290 638233 799002 411682 564083 436438 428701 506529 444343 392077 825377 818770 673261 798984 673333 565100 564602 475625 550102 574247 712158 672408 562824 599791 623860 605929 793901 723933 756622 759658 612819 638327 818737 825847 566171 705752 746045 794021 382518 405116 514353 467165 569503 559030 455600 430313 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.61%) |
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 233369 382518 391581 392077 392678 405116 411682 422993 424720 425249 428701 430313 430713 432086 436438 444343 445062 452344 452385 455600 456319 461367 467165 475625 478712 482225 491489 506529 510675 514353 527785 531078 549296 550102 551166 551175 557596 559030 560169 562824 564083 564602 565100 566171 569503 574247 582218 587431 587532 595451 595864 596585 599436 599791 600060 602929 604084 605395 605929 606822 610600 611336 612819 614849 621418 621578 622977 623851 623855 623860 624829 626535 631186 638233 638327 638623 638665 641120 641739 664614 672408 673261 673297 673299 673333 673751 676579 689693 696309 698451 701325 705752 712158 714491 723933 728328 746045 756622 759658 761290 793901 794021 798984 799002 801587 807322 815981 817432 817615 818737 818739 818770 821719 821798 823180 825377 825847 828027 828068 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car young"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин young"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вмашин young"
]
|
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.