Query Metrics
7
Database Queries
7
Different statements
379.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
353.74 ms (93.17%) |
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 6694 104990 361665 382499 383480 385111 389925 393986 397015 397113 397739 400005 401510 403500 404052 409180 477444 479446 482884 484153 489321 492310 493107 496247 511241 511687 517419 524282 529210 531963 534710 536852 546428 548499 552291 552993 553263 555010 558357 574227 577054 584066 596301 597108 620995 644879 645849 651177 658523 662097 662125 665076 667527 668389 669604 670488 671935 674373 674865 677750 699253 702094 702936 704100 704629 709707 714563 716238 717133 717611 718328 718856 718868 719967 721607 721959 726119 726649 727681 728877 735106 743350 745315 756424 760140 763586 774215 776407 779066 787148 798837 799465 799558 801366 801419 801750 805007 806411 807854 812655 813026 815411 816737 816756 817931 818709 818734 818910 819052 820990 822180 822768 822872 824488 825036 826417 826508 827513 827981 ] |
||||||||||||||||||||||||||||||
|
15.57 ms (4.10%) |
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 620995 383480 393986 397015 401510 409180 815411 825036 817931 818734 818910 524282 531963 529210 536852 477444 552291 645849 716238 717133 717611 718868 667527 670488 721607 658523 666803 674373 596301 597108 776407 779066 801750 806411 812655 799465 813026 726119 787148 801366 727681 745315 760140 726649 735106 774215 728877 756424 763586 699253 719967 721959 799558 801419 805007 6694 361665 104990 382499 397739 702094 743350 798837 807854 385111 389925 397113 400005 404052 403500 644879 826508 819052 820990 822768 827513 816737 816756 822872 824488 826417 818709 822180 827981 479446 482884 484153 489321 511241 511687 496247 517419 534710 492310 493107 546428 548499 552993 553263 584066 558357 577054 662097 662125 665076 671935 718856 668389 674865 704100 704629 709707 714563 718328 651177 669604 677750 702936 555010 574227 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие hot"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (0.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие hot"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.55%) |
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 6694 104990 361665 382499 383480 385111 389925 393986 397015 397113 397739 400005 401510 403500 404052 409180 477444 479446 482884 484153 489321 492310 493107 496247 511241 511687 517419 524282 529210 531963 534710 536852 546428 548499 552291 552993 553263 555010 558357 574227 577054 584066 596301 597108 620995 644879 645849 651177 658523 662097 662125 665076 667527 668389 669604 670488 671935 674373 674865 677750 699253 702094 702936 704100 704629 709707 714563 716238 717133 717611 718328 718856 718868 719967 721607 721959 726119 726649 727681 728877 735106 743350 745315 756424 760140 763586 774215 776407 779066 787148 798837 799465 799558 801366 801419 801750 805007 806411 807854 812655 813026 815411 816737 816756 817931 818709 818734 818910 819052 820990 822180 822768 822872 824488 825036 826417 826508 827513 827981 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big hot"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.