Query Metrics
7
Database Queries
7
Different statements
206.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.83 ms (84.86%) |
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 448497 454077 515006 517496 524270 524338 526242 528034 529326 533200 537136 537140 537508 545226 546315 552881 553726 553964 557724 558132 562222 569298 574015 580222 581978 583801 584421 585516 591277 594152 596960 597450 600799 603321 605404 606762 607070 607276 607685 612276 614600 617580 618388 626911 628632 630150 630558 635253 636461 638408 638727 638955 641387 643201 662550 667344 675654 675660 675696 684681 690300 692711 709654 709693 709917 710504 718063 721112 724508 727992 733406 745542 746201 750813 765954 771993 772068 773823 773926 776869 776907 778613 784012 784059 787104 787529 788342 788434 789645 792088 792270 796804 799081 799667 799704 803036 803047 803534 803600 803825 804007 807597 808547 808728 808896 810852 812612 813150 813210 816157 819615 819634 819650 820656 824731 825369 825677 825824 826385 826665 ] |
||||||||||||||||||||||||||||||
|
19.39 ms (9.41%) |
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 607685 641387 594152 600799 605404 614600 776907 788342 799704 784059 799081 803534 803600 803825 807597 750813 773926 787104 792270 799667 803036 803047 812612 724508 745542 746201 727992 771993 772068 773823 618388 630150 709654 710504 718063 721112 784012 804007 808547 816157 819615 524270 825824 454077 820656 533200 526242 537508 553726 574015 552881 562222 675654 692711 553964 583801 635253 638727 607276 612276 636461 585516 603321 630558 638955 643201 776869 792088 810852 778613 808728 617580 808896 825677 819634 825369 537140 515006 557724 545226 788434 765954 813210 824731 826665 733406 606762 517496 529326 580222 581978 667344 675660 709917 591277 628632 607070 626911 789645 796804 638408 709693 528034 524338 819650 826385 448497 537136 662550 787529 813150 569298 584421 675696 684681 690300 546315 558132 596960 597450 ] |
||||||||||||||||||||||||||||||
|
4.32 ms (2.10%) |
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 448497 454077 515006 517496 524270 524338 526242 528034 529326 533200 537136 537140 537508 545226 546315 552881 553726 553964 557724 558132 562222 569298 574015 580222 581978 583801 584421 585516 591277 594152 596960 597450 600799 603321 605404 606762 607070 607276 607685 612276 614600 617580 618388 626911 628632 630150 630558 635253 636461 638408 638727 638955 641387 643201 662550 667344 675654 675660 675696 684681 690300 692711 709654 709693 709917 710504 718063 721112 724508 727992 733406 745542 746201 750813 765954 771993 772068 773823 773926 776869 776907 778613 784012 784059 787104 787529 788342 788434 789645 792088 792270 796804 799081 799667 799704 803036 803047 803534 803600 803825 804007 807597 808547 808728 808896 810852 812612 813150 813210 816157 819615 819634 819650 820656 824731 825369 825677 825824 826385 826665 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov solo"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов соло"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.78%) |
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.