Query Metrics
7
Database Queries
7
Different statements
150.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.97 ms (84.23%) |
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 414212 423498 424679 426632 426911 434491 441110 448078 456215 456333 456743 456818 460209 470087 476652 481357 481920 482573 482616 484023 486969 487422 487768 497904 499042 500146 500494 507780 507945 508989 509066 512766 514088 514147 516985 521211 522521 525869 526233 529870 531574 533056 533118 534466 534928 535076 535606 538269 538919 539131 539788 542347 542386 542391 543657 544783 544869 546252 550557 558620 565890 567223 574431 575596 576131 576556 576901 577023 579851 582728 588048 588798 593003 593843 598859 601472 615658 618531 620843 622746 634850 637486 647003 683012 686271 687021 697494 700895 704180 704955 719829 726241 728482 729666 731444 732816 747597 751411 751437 754424 754700 755237 763276 764034 765356 765752 767033 775587 779468 787820 796727 796734 810582 813253 817101 825516 825762 826863 827308 827488 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (8.58%) |
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 817101 826863 827308 827488 825516 476652 487422 516985 535606 538919 499042 500494 509066 539131 577023 542347 546252 550557 574431 719829 576556 593843 634850 622746 618531 775587 796727 732816 751437 754424 767033 728482 731444 754700 726241 755237 765356 729666 751411 763276 779468 787820 810582 426632 487768 434491 456743 470087 514147 567223 576901 582728 601472 588048 813253 500146 526233 484023 508989 514088 507945 796734 481920 764034 423498 448078 529870 531574 544783 647003 576131 588798 426911 507780 414212 441110 424679 825762 456818 456215 460209 579851 542386 558620 593003 615658 765752 456333 486969 522521 497904 598859 535076 512766 747597 482573 482616 481357 521211 534466 538269 525869 533118 534928 539788 533056 542391 543657 544869 575596 565890 700895 683012 686271 687021 704180 697494 704955 620843 637486 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (2.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 414212 423498 424679 426632 426911 434491 441110 448078 456215 456333 456743 456818 460209 470087 476652 481357 481920 482573 482616 484023 486969 487422 487768 497904 499042 500146 500494 507780 507945 508989 509066 512766 514088 514147 516985 521211 522521 525869 526233 529870 531574 533056 533118 534466 534928 535076 535606 538269 538919 539131 539788 542347 542386 542391 543657 544783 544869 546252 550557 558620 565890 567223 574431 575596 576131 576556 576901 577023 579851 582728 588048 588798 593003 593843 598859 601472 615658 618531 620843 622746 634850 637486 647003 683012 686271 687021 697494 700895 704180 704955 719829 726241 728482 729666 731444 732816 747597 751411 751437 754424 754700 755237 763276 764034 765356 765752 767033 775587 779468 787820 796727 796734 810582 813253 817101 825516 825762 826863 827308 827488 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее частное бдсм…"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск любительск бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.17%) |
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.