Query Metrics
7
Database Queries
7
Different statements
199.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.17 ms (87.42%) |
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 1117 80365 80999 181334 372986 385874 387870 392739 396717 397777 398617 398906 398977 398985 400985 401157 401268 408812 466894 489255 547950 621990 649596 718324 719801 719829 729860 732133 733316 757740 763623 764485 765036 765410 766051 766800 767398 768190 777990 778740 779502 779585 779845 779853 779869 779884 780037 780353 780426 780460 781408 782634 782640 782882 783065 783220 783225 783294 783318 783546 783783 783786 784683 785301 786576 786638 787585 787781 787785 788097 789763 789865 790286 791031 791056 791156 791702 791703 791965 791982 791988 792124 792217 792355 793722 793737 793752 795005 795599 796019 797391 797395 797919 798714 798999 799813 802283 802608 802822 803694 804307 805066 805349 805351 806864 807281 808247 810129 810873 811637 813991 814283 814314 814322 814368 814662 814903 825077 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (6.49%) |
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 392739 398977 814368 781408 791702 732133 547950 786576 766177 784683 802283 649596 779845 783225 779502 396717 401157 797919 805351 793752 814322 466894 718324 779585 780037 788097 791982 795005 778740 780460 782882 789763 791031 764485 767398 806864 808247 733316 777990 780426 783318 791156 811637 397777 1117 814903 792217 792355 798714 802822 802608 729860 783294 80999 814662 813991 489255 786638 791988 796019 803694 782634 783546 791703 791965 805349 783786 785301 797391 797395 763623 766051 765036 787785 401268 763224 80365 398906 408812 814314 825077 719829 719801 780353 782640 790286 783065 787781 789865 807281 779869 791056 398617 757740 814283 621990 787585 783783 768190 765410 385874 398985 400985 181334 387870 805066 795599 779884 779853 372986 783220 792124 793722 804307 793737 810873 798999 799813 810129 766800 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"камшот минет"
]
|
||||||||||||||||||||||||||||||
|
2.89 ms (1.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.41 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 1117 80365 80999 181334 372986 385874 387870 392739 396717 397777 398617 398906 398977 398985 400985 401157 401268 408812 466894 489255 547950 621990 649596 718324 719801 719829 729860 732133 733316 757740 763623 764485 765036 765410 766051 766800 767398 768190 777990 778740 779502 779585 779845 779853 779869 779884 780037 780353 780426 780460 781408 782634 782640 782882 783065 783220 783225 783294 783318 783546 783783 783786 784683 785301 786576 786638 787585 787781 787785 788097 789763 789865 790286 791031 791056 791156 791702 791703 791965 791982 791988 792124 792217 792355 793722 793737 793752 795005 795599 796019 797391 797395 797919 798714 798999 799813 802283 802608 802822 803694 804307 805066 805349 805351 806864 807281 808247 810129 810873 811637 813991 814283 814314 814322 814368 814662 814903 825077 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.