Query Metrics
7
Database Queries
7
Different statements
184.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.89 ms (86.30%) |
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 130641 382804 384906 389657 415539 505745 521659 522825 531202 531205 531215 531928 534799 534892 539528 543694 546251 549417 564753 574957 586924 592908 596558 597905 598181 600022 600312 603703 607414 623123 625577 632635 637858 638511 644339 645284 654416 654701 655099 655201 655352 656998 657052 657063 657401 657652 657693 658736 670946 677975 678131 683426 693700 694347 695122 698803 699121 706857 707515 707726 717108 719248 719283 721568 724534 726262 728633 730400 730596 731141 732336 734318 735334 735475 738654 743824 745534 747416 750136 752789 753674 755611 759671 762299 762781 764286 764505 767310 768047 772143 773462 773803 777855 780162 794580 801032 810618 811952 814560 817003 817016 817105 817631 817633 817635 818412 818880 819149 819792 820153 820983 821491 822475 823379 826004 826113 826131 827438 828463 828472 ] |
||||||||||||||||||||||||||||||
|
15.06 ms (8.18%) |
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 773462 773803 801032 574957 600022 632635 818412 818880 534892 683426 655352 753674 828472 654416 657401 717108 656998 657693 743824 726262 767310 644339 531215 531202 600312 384906 817631 814560 826131 521659 531928 694347 677975 693700 794580 772143 645284 817633 531205 678131 826004 415539 695122 603703 522825 819149 817635 724534 823379 821491 819792 822475 539528 658736 719248 698803 706857 625577 637858 731141 759671 738654 764286 735334 707515 719283 382804 820153 564753 638511 811952 768047 810618 130641 817016 827438 817003 828463 534799 549417 654701 655201 707726 657063 657652 699121 655099 657052 721568 597905 623123 596558 777855 728633 747416 755611 762299 730400 735475 745534 762781 764505 730596 732336 734318 752789 750136 389657 820983 817105 826113 505745 543694 546251 670946 586924 607414 598181 592908 780162 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.86%) |
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 130641 382804 384906 389657 415539 505745 521659 522825 531202 531205 531215 531928 534799 534892 539528 543694 546251 549417 564753 574957 586924 592908 596558 597905 598181 600022 600312 603703 607414 623123 625577 632635 637858 638511 644339 645284 654416 654701 655099 655201 655352 656998 657052 657063 657401 657652 657693 658736 670946 677975 678131 683426 693700 694347 695122 698803 699121 706857 707515 707726 717108 719248 719283 721568 724534 726262 728633 730400 730596 731141 732336 734318 735334 735475 738654 743824 745534 747416 750136 752789 753674 755611 759671 762299 762781 764286 764505 767310 768047 772143 773462 773803 777855 780162 794580 801032 810618 811952 814560 817003 817016 817105 817631 817633 817635 818412 818880 819149 819792 820153 820983 821491 822475 823379 826004 826113 826131 827438 828463 828472 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big love"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие love"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие love"
]
|
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.