Query Metrics
7
Database Queries
7
Different statements
208.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.75 ms (88.63%) |
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 31604 88760 190735 204376 285885 329296 383898 385925 387279 387632 389588 391133 392890 394768 394772 395530 400668 401464 403543 405973 408912 414156 415412 419124 428804 428810 430003 430560 435487 445582 446329 446701 447997 448678 448907 450673 450840 453565 457950 465034 466658 469561 472274 475291 475756 479786 493815 494758 500949 510403 522143 529190 545269 549881 565232 565573 578505 583114 583554 621369 643645 644754 677279 690326 696046 696514 711662 715098 720874 724379 729674 742688 752407 752460 758123 760122 766613 767085 767189 771243 771255 774601 774698 780553 784550 789962 795260 796982 798361 798365 799052 800208 800666 801383 801527 803327 807385 808086 809287 810048 810227 813676 817940 817942 818899 819370 821673 821997 822177 822700 823118 823193 823997 825996 827679 827837 827912 828172 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (6.69%) |
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 395530 405973 447997 453565 457950 448678 494758 469561 825995 549881 808086 729674 767085 742688 190735 88760 389588 387632 428810 430560 821673 822700 825996 818899 819370 823193 827679 715098 795260 789962 408912 466658 329296 401464 392890 285885 31604 387279 391133 430003 414156 822177 813676 446701 450840 475756 465034 475291 472274 493815 500949 522143 529190 545269 565573 578505 696046 711662 696514 583554 621369 644754 798365 799052 801527 809287 810048 810227 774601 780553 800666 803327 807385 752407 767189 771243 784550 798361 760122 766613 771255 724379 758123 720874 800208 400668 445582 428804 204376 823681 435487 446329 510403 583114 415412 419124 479786 677279 403543 823997 817940 823118 821997 827837 827912 828172 448907 774698 796982 752460 394772 450673 817942 690326 565232 643645 801383 385925 383898 394768 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.59%) |
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 31604 88760 190735 204376 285885 329296 383898 385925 387279 387632 389588 391133 392890 394768 394772 395530 400668 401464 403543 405973 408912 414156 415412 419124 428804 428810 430003 430560 435487 445582 446329 446701 447997 448678 448907 450673 450840 453565 457950 465034 466658 469561 472274 475291 475756 479786 493815 494758 500949 510403 522143 529190 545269 549881 565232 565573 578505 583114 583554 621369 643645 644754 677279 690326 696046 696514 711662 715098 720874 724379 729674 742688 752407 752460 758123 760122 766613 767085 767189 771243 771255 774601 774698 780553 784550 789962 795260 796982 798361 798365 799052 800208 800666 801383 801527 803327 807385 808086 809287 810048 810227 813676 817940 817942 818899 819370 821673 821997 822177 822700 823118 823193 823997 825996 827679 827837 827912 828172 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina boobs"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская boobs"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская boobs"
]
|
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.