Query Metrics
7
Database Queries
7
Different statements
186.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.01 ms (83.82%) |
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 9732 396794 461755 490638 495117 496347 499514 500413 502799 503747 505311 512408 516553 517170 518455 519807 520241 520573 524352 524828 524889 524909 525080 525733 525787 526758 526848 527286 527867 528566 530193 532200 532409 533229 534000 535713 536015 538767 538963 540396 540436 540753 543227 543732 544407 544552 547433 549504 550929 551662 553881 555559 556180 556790 557020 557582 560275 562758 563551 571003 571131 576446 577179 578023 578780 579518 579550 583741 585193 588416 589657 591785 593561 593923 595047 597637 598662 600518 605667 606165 607996 608542 609294 610485 612168 613907 613994 616429 616503 616508 618942 622562 626002 634660 634956 635342 639164 643098 643832 643835 649263 652132 653051 660346 661060 663389 666721 669895 682409 683595 687155 723656 728597 736454 736705 738321 738445 739085 757589 813033 ] |
||||||||||||||||||||||||||||||
|
20.25 ms (10.88%) |
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 503747 533229 571003 652132 653051 591785 495117 538767 551662 622562 600518 616429 597637 527867 534000 616503 532200 461755 661060 555559 643098 518455 643835 723656 543732 544407 579550 738321 757589 524828 538963 520573 526848 536015 540753 609294 736705 738445 736454 562758 9732 544552 687155 649263 579518 616508 543227 547433 553881 813033 682409 556790 639164 728597 549504 606165 500413 557582 525080 528566 635342 643832 585193 608542 613907 524909 634660 396794 524889 519807 526758 512408 663389 589657 605667 613994 739085 490638 525787 527286 516553 540436 517170 550929 556180 607996 560275 576446 577179 660346 666721 610485 593923 535713 683595 669895 598662 612168 505311 557020 634956 499514 524352 540396 502799 530193 532409 563551 578780 593561 496347 618942 525733 520241 578023 583741 588416 595047 626002 571131 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.44%) |
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 9732 396794 461755 490638 495117 496347 499514 500413 502799 503747 505311 512408 516553 517170 518455 519807 520241 520573 524352 524828 524889 524909 525080 525733 525787 526758 526848 527286 527867 528566 530193 532200 532409 533229 534000 535713 536015 538767 538963 540396 540436 540753 543227 543732 544407 544552 547433 549504 550929 551662 553881 555559 556180 556790 557020 557582 560275 562758 563551 571003 571131 576446 577179 578023 578780 579518 579550 583741 585193 588416 589657 591785 593561 593923 595047 597637 598662 600518 605667 606165 607996 608542 609294 610485 612168 613907 613994 616429 616503 616508 618942 622562 626002 634660 634956 635342 639164 643098 643832 643835 649263 652132 653051 660346 661060 663389 666721 669895 682409 683595 687155 723656 728597 736454 736705 738321 738445 739085 757589 813033 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пизда с большими яйца%…"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин большие яйц"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.