Query Metrics
7
Database Queries
7
Different statements
145.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.62 ms (81.71%) |
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 396088 409685 422305 434470 435213 447692 451240 451791 454541 460330 469500 473166 475305 484520 486147 488628 488995 499860 508167 509704 513843 515808 516963 527372 529526 529710 530908 536682 539225 554248 563778 585627 595832 600439 600442 600669 610091 610148 611028 613805 616650 619597 621477 625605 627307 632294 640905 643132 644722 645626 674815 678180 682259 684980 701613 703977 710805 711542 711552 711555 714515 714521 718011 729181 732428 733142 733498 737130 737177 738480 738748 742100 744370 745980 746100 746117 752308 754124 756703 758847 759015 759754 763626 764307 765357 767607 770954 770964 771221 771564 772385 774794 776080 784793 785624 787864 788828 790844 790862 794609 795701 796168 799523 800211 802364 806797 809670 810906 811079 811906 812827 814212 814257 814497 815208 817320 818072 822042 823275 824174 ] |
||||||||||||||||||||||||||||||
|
17.38 ms (11.97%) |
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 486147 814212 814257 814497 817320 822042 460330 454541 475305 484520 527372 529526 530908 516963 563778 674815 678180 682259 701613 711542 711555 684980 703977 645626 710805 711552 554248 600669 621477 600442 613805 644722 595832 600439 610091 616650 625605 643132 585627 619597 627307 787864 790844 796168 776080 784793 790862 794609 799523 810906 811906 812827 745980 754124 767607 772385 802364 732428 742100 746117 752308 759754 738480 738748 765357 770954 771221 729181 733142 737177 746100 756703 771564 733498 737130 758847 759015 763626 764307 770964 610148 632294 640905 714515 714521 718011 774794 785624 788828 795701 800211 806797 809670 811079 434470 396088 513843 451240 435213 515808 529710 488995 744370 611028 409685 422305 818072 823275 815208 824174 447692 469500 473166 451791 488628 508167 499860 509704 536682 539225 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.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 396088 409685 422305 434470 435213 447692 451240 451791 454541 460330 469500 473166 475305 484520 486147 488628 488995 499860 508167 509704 513843 515808 516963 527372 529526 529710 530908 536682 539225 554248 563778 585627 595832 600439 600442 600669 610091 610148 611028 613805 616650 619597 621477 625605 627307 632294 640905 643132 644722 645626 674815 678180 682259 684980 701613 703977 710805 711542 711552 711555 714515 714521 718011 729181 732428 733142 733498 737130 737177 738480 738748 742100 744370 745980 746100 746117 752308 754124 756703 758847 759015 759754 763626 764307 765357 767607 770954 770964 771221 771564 772385 774794 776080 784793 785624 787864 788828 790844 790862 794609 795701 796168 799523 800211 802364 806797 809670 810906 811079 811906 812827 814212 814257 814497 815208 817320 818072 822042 823275 824174 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum latina"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum латинская"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum латинская"
]
|
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.