Query Metrics
7
Database Queries
7
Different statements
149.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.04 ms (82.24%) |
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 397485 478091 496061 506303 510556 511904 543085 548957 549559 550464 550466 550806 551556 569354 569971 572538 576241 580119 584145 584261 584517 616747 625065 630222 633758 636983 640088 647043 653493 656488 656545 656643 664409 664532 671665 678012 682920 690737 696164 698891 700047 706727 710189 710479 710979 713855 714622 714986 715886 717235 717886 719454 719582 720232 723421 724193 725132 725645 725748 726287 727042 728432 729072 731247 735338 736219 737321 738981 739071 742233 745912 747474 749793 750771 751361 754027 755843 756685 757298 757740 759439 759648 761077 761384 762766 765215 765464 765647 766610 767000 767565 768208 768392 768760 769496 769631 772229 773381 773481 774171 779747 784083 784600 789273 790554 791399 793009 793976 794075 794442 796178 796880 797661 803013 804381 809808 810098 813850 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (10.85%) |
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 742233 754027 759439 767565 784600 790554 793009 794075 794442 803013 804381 725132 731247 739071 750771 755843 759648 761077 761384 767000 728432 729072 737321 765464 769496 769631 774171 724193 725645 725748 726287 745912 756685 757298 762766 765215 768392 768760 772229 773381 773481 727042 735338 736219 738981 747474 749793 751361 757740 765647 766610 768208 625065 630222 636983 640088 700047 710189 710479 710979 714622 714986 715886 717886 719582 723421 779747 784083 789273 791399 793976 796178 796880 797661 809808 810098 616747 633758 397485 813850 478091 510556 496061 511904 506303 550466 550806 572538 543085 551556 569354 584261 549559 550464 576241 584145 584517 653493 656488 664532 671665 678012 698891 706727 713291 719454 647043 656643 664409 713855 720232 656545 664379 682920 690737 696164 717235 548957 569971 580119 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.65%) |
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 397485 478091 496061 506303 510556 511904 543085 548957 549559 550464 550466 550806 551556 569354 569971 572538 576241 580119 584145 584261 584517 616747 625065 630222 633758 636983 640088 647043 653493 656488 656545 656643 664409 664532 671665 678012 682920 690737 696164 698891 700047 706727 710189 710479 710979 713855 714622 714986 715886 717235 717886 719454 719582 720232 723421 724193 725132 725645 725748 726287 727042 728432 729072 731247 735338 736219 737321 738981 739071 742233 745912 747474 749793 750771 751361 754027 755843 756685 757298 757740 759439 759648 761077 761384 762766 765215 765464 765647 766610 767000 767565 768208 768392 768760 769496 769631 772229 773381 773481 774171 779747 784083 784600 789273 790554 791399 793009 793976 794075 794442 796178 796880 797661 803013 804381 809808 810098 813850 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"перв секс"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вперв"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.10%) |
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.