Query Metrics
7
Database Queries
7
Different statements
140.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.54 ms (82.06%) |
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 417452 420304 435643 450682 450866 458887 460544 460774 468928 470400 475818 488295 488466 496617 500505 503472 508444 516211 523061 540917 542082 545892 554412 554741 560363 565300 595829 603404 605604 606772 610599 613238 613301 617353 618752 626285 632313 632549 641463 649692 656876 659197 673133 678807 684705 695182 696070 696992 699836 701228 708297 710091 716172 716188 717298 718089 720318 721068 721773 721968 721998 722024 723144 724079 725441 725467 725477 726409 729673 731127 731164 731165 735914 736548 736595 737632 737996 738770 743037 743896 745535 746280 751479 758158 759316 763182 764028 767384 771922 774339 774345 779607 780230 783009 783024 786736 790305 790464 792344 794494 795198 797296 799476 800084 800188 800464 800687 800716 800760 800934 801002 803094 803256 803348 803873 805309 807670 811159 811160 820023 ] |
||||||||||||||||||||||||||||||
|
14.87 ms (10.56%) |
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 684705 723144 626285 610599 783009 786736 800760 803094 746280 783024 795198 800687 803256 807670 743896 745535 743037 731127 751479 632313 721998 820023 523061 516211 488466 554741 560363 701228 710091 656876 673133 716172 716188 720318 722024 606772 617353 603404 595829 780230 790305 800084 803348 794494 803873 724079 764028 800188 800716 811159 811160 759316 774345 729673 735914 696992 800934 805309 475818 460544 488295 435643 470400 540917 678807 695182 696070 708297 718089 605604 613301 736595 790464 800464 801002 726409 736548 737632 737996 632549 717298 797296 450866 508444 460774 450682 496617 500505 565300 545892 554412 659197 721068 721968 649692 721773 613238 641463 792344 799476 725477 767384 725467 774339 725441 731165 758158 763182 771922 731164 738770 618752 699836 779607 420304 503472 542082 417452 458887 468928 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (2.26%) |
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 417452 420304 435643 450682 450866 458887 460544 460774 468928 470400 475818 488295 488466 496617 500505 503472 508444 516211 523061 540917 542082 545892 554412 554741 560363 565300 595829 603404 605604 606772 610599 613238 613301 617353 618752 626285 632313 632549 641463 649692 656876 659197 673133 678807 684705 695182 696070 696992 699836 701228 708297 710091 716172 716188 717298 718089 720318 721068 721773 721968 721998 722024 723144 724079 725441 725467 725477 726409 729673 731127 731164 731165 735914 736548 736595 737632 737996 738770 743037 743896 745535 746280 751479 758158 759316 763182 764028 767384 771922 774339 774345 779607 780230 783009 783024 786736 790305 790464 792344 794494 795198 797296 799476 800084 800188 800464 800687 800716 800760 800934 801002 803094 803256 803348 803873 805309 807670 811159 811160 820023 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum hidden"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.