Query Metrics
7
Database Queries
7
Different statements
161.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.24 ms (86.09%) |
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 388213 400677 420126 428623 429273 429618 444840 454335 458408 463239 470345 479368 491696 499285 521009 533729 534085 534459 537066 538250 542179 546575 558404 559015 559655 560166 576751 580690 589358 601948 604641 606280 607171 608683 616554 616839 617036 623439 626269 631136 631284 631293 634279 636124 640827 649913 659063 663836 667051 667065 680786 694424 696052 697865 704034 705802 717767 725864 728713 735851 737046 745795 757082 757688 758013 761527 763840 764868 765534 765890 766054 768017 768965 769019 771612 772765 772844 777266 777553 778406 778542 779476 779538 780786 783268 783661 784289 785930 786388 786403 786672 787708 788367 789033 789037 789065 789142 789593 792354 792456 793000 795302 797818 798628 798735 798882 804323 805022 805063 806400 808295 809741 813284 813979 814715 815071 820495 821717 822127 827104 ] |
||||||||||||||||||||||||||||||
|
12.60 ms (7.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 631284 626269 616554 617036 606280 631293 777553 779476 786403 793000 798628 805063 778542 783661 792354 813284 763840 783268 784289 789142 797818 735851 761527 764868 757688 725864 758013 765890 771612 623439 777266 780786 786672 789593 795302 798882 805022 806400 444840 454335 814715 560166 649913 663836 696052 616839 631136 785930 786388 769019 400677 815071 589358 601948 757082 813979 470345 705802 608683 607171 778406 808295 765534 737046 768017 804323 429618 388213 428623 463239 499285 789033 821717 822127 538250 537066 534085 479368 559015 542179 697865 704034 717767 659063 667051 694424 604641 636124 640827 789037 789065 792456 798735 766054 768965 634279 429273 491696 521009 580690 788367 772765 787708 745795 534459 533729 820495 827104 779538 558404 559655 458408 576751 546575 680786 667065 809741 728713 772844 420126 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.78%) |
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 388213 400677 420126 428623 429273 429618 444840 454335 458408 463239 470345 479368 491696 499285 521009 533729 534085 534459 537066 538250 542179 546575 558404 559015 559655 560166 576751 580690 589358 601948 604641 606280 607171 608683 616554 616839 617036 623439 626269 631136 631284 631293 634279 636124 640827 649913 659063 663836 667051 667065 680786 694424 696052 697865 704034 705802 717767 725864 728713 735851 737046 745795 757082 757688 758013 761527 763840 764868 765534 765890 766054 768017 768965 769019 771612 772765 772844 777266 777553 778406 778542 779476 779538 780786 783268 783661 784289 785930 786388 786403 786672 787708 788367 789033 789037 789065 789142 789593 792354 792456 793000 795302 797818 798628 798735 798882 804323 805022 805063 806400 808295 809741 813284 813979 814715 815071 820495 821717 822127 827104 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov public"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.96%) |
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.