Query Metrics
7
Database Queries
7
Different statements
163.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.56 ms (84.95%) |
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 282649 415520 417336 419383 426444 436577 439837 443467 444574 449118 449697 451589 452987 457844 462687 462854 464610 465773 478357 478644 495008 495824 500065 509605 518887 529083 531286 534127 540276 540659 540983 542842 542990 543728 552641 554113 554792 556932 557262 558916 563813 566700 568995 569012 579589 580606 584074 584106 589318 594289 594503 594535 597498 600485 618928 622935 630490 630943 639222 639720 641560 646079 646137 650722 651979 652338 655290 655293 697460 724048 765743 770929 774799 788838 804878 810189 813551 813703 814549 815011 815014 815058 815102 815133 815930 817051 817402 817505 820213 820444 821089 821116 821482 821511 821576 821599 821694 821750 821917 822086 822209 822619 823192 823398 824083 825468 825636 825890 826067 826728 827357 827433 828128 828441 828443 828764 828765 ] |
||||||||||||||||||||||||||||||
|
14.34 ms (8.79%) |
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 415520 419383 436577 443467 452987 495824 478644 569012 554792 568995 630490 589318 594503 597498 600485 594289 774799 444574 462687 439837 449118 462854 465773 417336 464610 426444 449697 451589 457844 509605 282649 815133 815102 815058 518887 495008 651979 556932 639222 618928 594535 630943 639720 641560 810189 770929 724048 765743 622935 697460 788838 804878 815011 822129 823192 823398 825468 813551 774419 826728 815014 815930 822209 827357 814549 817051 817505 821599 821694 821750 822086 824083 813703 817402 820213 820444 821089 821116 821482 821511 821576 821917 822619 825636 825890 828765 828764 828128 827433 826067 828652 828441 828443 478357 500065 529083 531286 540659 534127 540276 540983 542842 557262 566700 579589 584106 542990 543728 552641 554113 580606 584074 558916 563813 646079 646137 650722 652338 655290 655293 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.60%) |
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 282649 415520 417336 419383 426444 436577 439837 443467 444574 449118 449697 451589 452987 457844 462687 462854 464610 465773 478357 478644 495008 495824 500065 509605 518887 529083 531286 534127 540276 540659 540983 542842 542990 543728 552641 554113 554792 556932 557262 558916 563813 566700 568995 569012 579589 580606 584074 584106 589318 594289 594503 594535 597498 600485 618928 622935 630490 630943 639222 639720 641560 646079 646137 650722 651979 652338 655290 655293 697460 724048 765743 770929 774799 788838 804878 810189 813551 813703 814549 815011 815014 815058 815102 815133 815930 817051 817402 817505 820213 820444 821089 821116 821482 821511 821576 821599 821694 821750 821917 822086 822209 822619 823192 823398 824083 825468 825636 825890 826067 826728 827357 827433 828128 828441 828443 828764 828765 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov teen"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов teen"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов teen"
]
|
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.