Query Metrics
7
Database Queries
7
Different statements
198.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.25 ms (85.66%) |
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 362615 383315 385322 391440 396429 416112 431986 432374 433434 441439 445864 453964 463403 463522 463591 465248 478485 480977 488410 489829 494917 499569 499955 500456 505984 508215 510299 515046 515581 516741 516900 517027 517518 518459 518460 520022 523030 525627 525965 526303 528381 531481 535315 535335 535919 544024 547035 551783 552537 558223 560147 561755 562977 566922 568676 574171 575371 576951 584099 585325 587248 588563 589202 589816 590763 592382 594307 597690 601023 601340 601684 602576 609220 611645 613803 613932 614502 615787 621327 622633 623421 623940 634345 648285 650749 652196 691626 709533 712307 715115 716203 716253 724931 731526 736655 738921 739904 741782 742611 743946 750195 752263 752268 758553 761507 767478 768401 768906 770128 779774 784510 791035 795877 800666 800756 803734 811910 814438 828445 828548 ] |
||||||||||||||||||||||||||||||
|
18.47 ms (9.29%) |
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 558223 523030 623940 480977 441439 465248 621327 623421 516741 576951 568676 531481 525965 431986 611645 488410 510299 560147 587248 601340 716203 520022 716253 383315 731526 416112 588563 562977 516900 800666 463591 828548 613932 795877 601023 791035 391440 650749 494917 535315 715115 499569 528381 634345 585325 761507 535919 589202 517518 615787 574171 601684 385322 828445 752268 738921 803734 547035 478485 652196 758553 739904 515581 743946 535335 396429 433434 622633 741782 800756 489829 463522 499955 525627 518459 518460 517027 505984 602576 779774 515046 752263 811910 736655 767478 768906 613803 453964 609220 584099 566922 561755 770128 814438 784510 750195 500456 712307 526303 508215 551783 552537 575371 594307 597690 724931 590763 614502 742611 445864 648285 362615 544024 432374 709533 691626 589816 592382 768401 463403 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.56%) |
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 362615 383315 385322 391440 396429 416112 431986 432374 433434 441439 445864 453964 463403 463522 463591 465248 478485 480977 488410 489829 494917 499569 499955 500456 505984 508215 510299 515046 515581 516741 516900 517027 517518 518459 518460 520022 523030 525627 525965 526303 528381 531481 535315 535335 535919 544024 547035 551783 552537 558223 560147 561755 562977 566922 568676 574171 575371 576951 584099 585325 587248 588563 589202 589816 590763 592382 594307 597690 601023 601340 601684 602576 609220 611645 613803 613932 614502 615787 621327 622633 623421 623940 634345 648285 650749 652196 691626 709533 712307 715115 716203 716253 724931 731526 736655 738921 739904 741782 742611 743946 750195 752263 752268 758553 761507 767478 768401 768906 770128 779774 784510 791035 795877 800666 800756 803734 811910 814438 828445 828548 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big panties"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.76%) |
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.