Query Metrics
7
Database Queries
7
Different statements
194.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.83 ms (89.44%) |
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 38292 113322 142832 358837 384857 385915 401597 414688 414734 425887 447493 533204 533896 549307 570774 581357 600374 622354 640125 645344 648213 652904 652906 653258 662038 663963 672105 677114 678565 678572 678576 678578 678586 679044 679049 679060 679061 679062 679078 679079 679081 679096 679132 679135 682802 690800 690834 690842 690855 690913 691523 691530 692253 692261 692330 693041 693057 693860 694023 694052 694073 694083 694222 694455 694458 694476 694522 694540 694562 695196 695621 695631 695635 695919 695928 695941 696278 696354 697273 697373 697790 698517 699689 699708 699719 699731 699743 699767 699778 703437 717735 724016 747312 755836 780541 781155 790025 798969 800944 802218 810922 811489 814280 814763 815238 815309 815399 815494 815573 815721 815774 815793 815965 815979 816082 816252 816544 817828 818895 828845 ] |
||||||||||||||||||||||||||||||
|
10.51 ms (5.41%) |
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 802218 724016 781155 384857 142832 696278 679081 678572 697373 38292 690842 358837 401597 816082 816252 549307 679062 694562 679049 755836 699719 414688 815399 818895 815573 815494 815721 828845 533204 581357 679132 679135 696354 699767 640125 747312 703437 425887 447493 385915 815774 814280 815238 692261 694083 695919 699689 652904 678565 693057 694476 694540 800944 698517 699708 699731 814763 815309 816544 815793 815965 677114 678578 679044 690800 690855 690913 691523 694522 695196 695631 678586 679060 679096 693860 695621 695928 697273 697790 652906 662038 693041 694073 600374 780541 414734 113322 817828 815979 533896 570774 692253 694052 694455 648213 663963 690834 691530 694023 695941 699743 645344 653258 672105 682802 694458 695635 699778 717735 622354 790025 798969 811489 810922 692330 678576 679061 679078 679079 694222 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.21%) |
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 38292 113322 142832 358837 384857 385915 401597 414688 414734 425887 447493 533204 533896 549307 570774 581357 600374 622354 640125 645344 648213 652904 652906 653258 662038 663963 672105 677114 678565 678572 678576 678578 678586 679044 679049 679060 679061 679062 679078 679079 679081 679096 679132 679135 682802 690800 690834 690842 690855 690913 691523 691530 692253 692261 692330 693041 693057 693860 694023 694052 694073 694083 694222 694455 694458 694476 694522 694540 694562 695196 695621 695631 695635 695919 695928 695941 696278 696354 697273 697373 697790 698517 699689 699708 699719 699731 699743 699767 699778 703437 717735 724016 747312 755836 780541 781155 790025 798969 800944 802218 810922 811489 814280 814763 815238 815309 815399 815494 815573 815721 815774 815793 815965 815979 816082 816252 816544 817828 818895 828845 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс scene"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2023 sex scene"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс scene"
]
|
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.