Query Metrics
7
Database Queries
7
Different statements
259.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.47 ms (90.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 4510 47079 78760 79683 224590 233862 271093 351650 383477 386389 386940 389859 390521 391575 397502 398105 398331 407159 434465 453591 476470 483839 489260 490519 493250 497372 501998 511943 514211 518477 526338 534507 537403 540745 541157 547950 554581 558954 558988 559497 568892 569626 571433 575238 579029 580004 580050 590555 590582 593691 600768 601437 610473 610880 610893 614617 615185 624960 625283 628203 628213 632882 634588 639911 646980 651746 651795 655457 657800 661618 667168 676767 680786 683478 683649 685432 687717 689266 695454 697549 701894 708326 711052 711071 715844 717118 726313 735029 735362 736643 738222 738341 740835 749882 754700 754742 757740 762737 762740 764667 765028 767972 777511 777808 778136 779583 779735 782325 786576 787598 790299 791168 792255 792349 793174 798619 799851 802015 802341 810548 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (5.86%) |
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 632882 434465 676767 490519 79683 554581 501998 489260 569626 541157 4510 453591 625283 386389 736643 762737 782325 540745 600768 792255 754742 779735 657800 526338 593691 386940 534507 661618 701894 695454 575238 610880 792349 738341 610893 78760 579029 777511 735362 518477 497372 646980 493250 651746 407159 558988 624960 639911 590582 802341 790299 726313 711052 711071 777808 383477 483839 547950 778136 786576 793174 738222 791168 754700 762740 224590 634588 683649 651795 787598 390521 47079 601437 397502 511943 717118 715844 708326 628213 614617 799851 271093 398331 559497 558954 689266 667168 697549 580004 580050 757740 389859 610473 767972 740835 391575 735029 764667 398105 514211 571433 655457 351650 568892 810548 615185 537403 687717 685432 628203 590555 802015 779583 765028 749882 798619 233862 476470 680786 683478 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.35%) |
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 4510 47079 78760 79683 224590 233862 271093 351650 383477 386389 386940 389859 390521 391575 397502 398105 398331 407159 434465 453591 476470 483839 489260 490519 493250 497372 501998 511943 514211 518477 526338 534507 537403 540745 541157 547950 554581 558954 558988 559497 568892 569626 571433 575238 579029 580004 580050 590555 590582 593691 600768 601437 610473 610880 610893 614617 615185 624960 625283 628203 628213 632882 634588 639911 646980 651746 651795 655457 657800 661618 667168 676767 680786 683478 683649 685432 687717 689266 695454 697549 701894 708326 711052 711071 715844 717118 726313 735029 735362 736643 738222 738341 740835 749882 754700 754742 757740 762737 762740 764667 765028 767972 777511 777808 778136 779583 779735 782325 786576 787598 790299 791168 792255 792349 793174 798619 799851 802015 802341 810548 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс рот"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут рот"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.54%) |
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.