Query Metrics
7
Database Queries
7
Different statements
204.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.36 ms (87.10%) |
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 13646 389700 394648 421166 426399 429900 429958 438316 446373 446446 451337 452253 454180 454568 458391 460804 464815 465429 468241 474847 478215 486126 487342 489210 500292 501557 508778 510948 513214 514240 514927 515464 522797 523196 525302 526228 530142 534548 537091 539326 545294 553277 554490 555988 556899 559289 562418 567321 568261 569575 572535 574023 581873 584029 585358 589680 592993 593540 594110 596235 596796 596927 598189 598899 603772 604631 607716 610039 614829 615741 618410 619703 620260 623284 623684 632121 642481 658784 660400 663353 663987 669057 670367 670372 671043 671049 685843 695691 697628 702352 705451 715420 716201 716543 721992 727455 729696 735998 741688 741739 741749 757492 758792 760079 765657 770200 770610 772714 772717 780653 781309 786873 795420 796816 796999 800473 802742 803543 819410 825751 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (7.66%) |
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 632121 446373 508778 594110 760079 474847 537091 523196 623284 596927 465429 501557 695691 780653 796816 770200 741688 741739 741749 464815 438316 581873 553277 802742 614829 513214 562418 394648 596796 795420 598189 574023 615741 452253 13646 522797 526228 569575 592993 478215 454568 702352 593540 607716 454180 554490 796999 446446 642481 781309 735998 572535 596235 421166 468241 555988 584029 598899 604631 429958 460804 500292 525302 486126 515464 514927 487342 451337 716201 567321 458391 514240 619703 426399 429900 618410 623684 585358 610039 819410 539326 530142 534548 545294 559289 556899 658784 671049 705451 660400 663353 715420 663987 685843 568261 603772 620260 786873 727455 772714 800473 803543 729696 770610 772717 757492 765657 697628 389700 825751 489210 510948 670367 671043 716543 670372 721992 669057 589680 758792 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.36%) |
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 13646 389700 394648 421166 426399 429900 429958 438316 446373 446446 451337 452253 454180 454568 458391 460804 464815 465429 468241 474847 478215 486126 487342 489210 500292 501557 508778 510948 513214 514240 514927 515464 522797 523196 525302 526228 530142 534548 537091 539326 545294 553277 554490 555988 556899 559289 562418 567321 568261 569575 572535 574023 581873 584029 585358 589680 592993 593540 594110 596235 596796 596927 598189 598899 603772 604631 607716 610039 614829 615741 618410 619703 620260 623284 623684 632121 642481 658784 660400 663353 663987 669057 670367 670372 671043 671049 685843 695691 697628 702352 705451 715420 716201 716543 721992 727455 729696 735998 741688 741739 741749 757492 758792 760079 765657 770200 770610 772714 772717 780653 781309 786873 795420 796816 796999 800473 802742 803543 819410 825751 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мастурбация зрелой в чулках"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац зрелая женщин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.87%) |
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.