Query Metrics
7
Database Queries
7
Different statements
277.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
255.33 ms (91.92%) |
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 443351 504813 540939 629891 711924 713082 714943 715006 715098 716153 716820 717221 717755 718752 719407 719629 719759 719770 720841 723472 727071 729003 729296 729860 730993 733801 734463 736912 737040 738768 739587 742807 749168 754966 755803 755814 762029 762371 762452 762453 762473 762493 762964 763042 763074 763249 763311 763488 763558 763570 764562 765001 766093 766309 766371 766645 768206 768821 769686 769693 769702 776372 776504 780145 780400 781438 781444 782032 782299 782925 784006 784013 784024 787800 787834 788917 788968 789345 789416 789873 790150 790294 790999 791970 792219 793324 794740 796835 798691 799777 799833 799929 802023 802334 804858 804873 804875 807076 808128 808303 811453 812254 813063 817209 817763 817864 819192 821810 824116 824283 824896 825279 825664 826656 827526 827591 827677 828069 828343 ] |
||||||||||||||||||||||||||||||
|
11.84 ms (4.26%) |
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 727071 813063 825279 790150 804875 789345 729860 766645 763249 764562 781444 802334 790999 629891 817209 824116 817864 711924 716153 719759 723472 776372 781438 782299 784024 799833 804858 787834 788917 799777 729296 733801 734463 737040 762964 763488 763570 766093 808128 730993 742807 762029 762452 762473 765001 729003 738768 762453 762493 762511 763558 769702 719770 780145 780400 792219 804873 824896 713082 791970 788968 799929 827526 504813 789873 717755 790294 796835 808303 793324 719407 736912 443351 811453 755803 787800 817763 719629 715098 720841 784006 798691 812254 739587 784013 766371 762371 763042 768821 766309 717221 782032 807076 824283 827591 718752 715006 794740 749168 755814 763074 782925 763311 769693 769686 754966 768206 776504 802023 789416 828069 826656 821810 819192 825664 828343 827677 540939 714943 716820 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.06%) |
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 443351 504813 540939 629891 711924 713082 714943 715006 715098 716153 716820 717221 717755 718752 719407 719629 719759 719770 720841 723472 727071 729003 729296 729860 730993 733801 734463 736912 737040 738768 739587 742807 749168 754966 755803 755814 762029 762371 762452 762453 762473 762493 762964 763042 763074 763249 763311 763488 763558 763570 764562 765001 766093 766309 766371 766645 768206 768821 769686 769693 769702 776372 776504 780145 780400 781438 781444 782032 782299 782925 784006 784013 784024 787800 787834 788917 788968 789345 789416 789873 790150 790294 790999 791970 792219 793324 794740 796835 798691 799777 799833 799929 802023 802334 804858 804873 804875 807076 808128 808303 811453 812254 813063 817209 817763 817864 819192 821810 824116 824283 824896 825279 825664 826656 827526 827591 827677 828069 828343 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tik tok минет"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.57%) |
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.