Query Metrics
7
Database Queries
7
Different statements
253.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.62 ms (90.67%) |
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 387588 392527 396676 416933 418732 421653 422957 424637 444660 456333 461111 467684 472350 477042 477550 481319 484464 489603 492110 499042 500494 505451 509066 514662 515884 516844 517264 517620 525778 525957 526223 527625 527769 531264 532673 533019 533977 534199 537806 539435 542754 543441 546255 546823 552732 556580 560460 565890 571280 574562 575481 579872 582985 600575 613319 621433 621986 622658 622978 646682 652129 656633 659952 661652 673053 693988 700895 709804 709814 712514 713126 713320 713970 719829 722551 722993 726241 738818 751860 758178 761494 764485 765356 766461 768952 778357 779468 784215 790819 793104 793301 793722 793739 794945 797724 798200 798704 805334 806044 806864 807685 810350 810582 814269 814312 816998 817028 817182 817280 817727 817750 818522 819563 819606 824051 824150 824438 825516 827308 827488 ] |
||||||||||||||||||||||||||||||
|
13.56 ms (5.35%) |
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 467684 422957 456333 424637 472350 525957 527625 489603 492110 517264 526223 392527 824051 817182 819563 827308 817028 824150 814312 818522 827488 825516 527769 532673 515884 533019 499042 500494 509066 537806 546823 552732 646682 656633 659952 661652 713320 722551 673053 693988 709814 719829 722993 546255 579872 621986 790819 793104 793722 805334 798200 798704 764485 766461 806864 726241 765356 622658 713970 779468 806044 810582 387588 778357 793301 761494 477042 652129 621433 738818 484464 505451 516844 565890 582985 700895 709804 560460 600575 793739 794945 807685 768952 784215 797724 758178 810350 461111 542754 622978 613319 444660 418732 571280 751860 481319 396676 421653 416933 817750 824438 816998 817280 817727 814269 819606 477550 517620 525778 531264 534199 533977 539435 514662 543441 575481 556580 574562 712514 713126 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.20%) |
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 387588 392527 396676 416933 418732 421653 422957 424637 444660 456333 461111 467684 472350 477042 477550 481319 484464 489603 492110 499042 500494 505451 509066 514662 515884 516844 517264 517620 525778 525957 526223 527625 527769 531264 532673 533019 533977 534199 537806 539435 542754 543441 546255 546823 552732 556580 560460 565890 571280 574562 575481 579872 582985 600575 613319 621433 621986 622658 622978 646682 652129 656633 659952 661652 673053 693988 700895 709804 709814 712514 713126 713320 713970 719829 722551 722993 726241 738818 751860 758178 761494 764485 765356 766461 768952 778357 779468 784215 790819 793104 793301 793722 793739 794945 797724 798200 798704 805334 806044 806864 807685 810350 810582 814269 814312 816998 817028 817182 817280 817727 817750 818522 819563 819606 824051 824150 824438 825516 827308 827488 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм сперм"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gag on sperm"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм сперм"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.