Query Metrics
7
Database Queries
7
Different statements
156.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.54 ms (84.15%) |
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 233147 304698 396768 397255 400143 401103 403236 421491 448362 450795 464661 481734 521176 535365 539117 539464 540691 554967 556798 563898 563920 568651 572568 578291 580361 581600 590067 590238 599991 600241 601147 606417 607149 610962 613813 630233 635446 638574 639801 642354 649936 660745 663436 666733 669206 677825 698983 699313 705741 709396 710368 714156 714644 716279 716818 718793 721167 721632 726588 727015 727398 728218 734688 737086 737315 738508 742232 743866 743904 751007 756223 758512 758896 765867 765884 766728 767030 770841 771792 772552 772605 775880 785433 786002 787726 788160 788798 790897 795521 799071 799440 801368 801438 801741 801757 802316 803078 803467 807134 808340 809038 809297 811915 813767 814660 814851 815094 815123 815189 815807 815819 815848 817526 817904 817920 820061 820417 821284 822740 824011 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (9.61%) |
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 795521 727398 765884 772605 635446 721632 785433 304698 233147 705741 801757 450795 601147 815807 817904 815819 660745 606417 613813 642354 590067 610962 807134 737086 770841 737315 756223 758896 728218 734688 751007 727015 699313 709396 716818 788160 710368 639801 758512 815123 540691 539117 535365 568651 554967 563898 572568 666733 721167 649936 556798 599991 590238 630233 775880 799071 802316 809038 809297 786002 790897 803078 808340 801368 801438 803467 765867 743904 767030 766728 607149 718793 787726 801741 811915 397255 481734 401103 400143 464661 821284 822740 824011 563920 714644 663436 677825 714156 638574 600241 799440 726588 738508 742232 743866 772552 771792 788798 396768 521176 403236 421491 814851 820061 813767 815848 817920 815094 815189 817526 814660 820417 448362 539464 578291 580361 581600 669206 698983 716279 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.49%) |
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 233147 304698 396768 397255 400143 401103 403236 421491 448362 450795 464661 481734 521176 535365 539117 539464 540691 554967 556798 563898 563920 568651 572568 578291 580361 581600 590067 590238 599991 600241 601147 606417 607149 610962 613813 630233 635446 638574 639801 642354 649936 660745 663436 666733 669206 677825 698983 699313 705741 709396 710368 714156 714644 716279 716818 718793 721167 721632 726588 727015 727398 728218 734688 737086 737315 738508 742232 743866 743904 751007 756223 758512 758896 765867 765884 766728 767030 770841 771792 772552 772605 775880 785433 786002 787726 788160 788798 790897 795521 799071 799440 801368 801438 801741 801757 802316 803078 803467 807134 808340 809038 809297 811915 813767 814660 814851 815094 815123 815189 815807 815819 815848 817526 817904 817920 820061 820417 821284 822740 824011 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big hot mom"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие hot mom"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие hot mom"
]
|
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.