Query Metrics
7
Database Queries
7
Different statements
169.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.53 ms (86.66%) |
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 4338 33602 353299 387993 396546 396619 400540 403258 433014 465749 476614 481116 482216 483771 488806 489228 498761 504828 512364 514039 514190 514191 526328 530302 530463 532189 533084 533702 534870 535567 537254 537276 537283 538044 539392 540137 540789 541494 542618 542659 543328 546294 553878 564290 572636 575563 575862 575919 578808 578905 579671 583175 585605 590119 595151 607000 608961 613372 613684 616640 630873 631376 633233 635585 640671 646610 647661 648433 648481 648600 649348 650358 653156 653832 655491 657236 657247 658170 665939 668737 671234 673242 686719 687666 688830 690697 691953 693916 695454 698763 700823 701173 716807 718118 718348 719741 720049 721268 725058 729758 731133 734495 736497 739585 741061 742995 743630 744064 746181 747947 747950 748112 748633 749417 760515 762953 786092 787546 819899 ] |
||||||||||||||||||||||||||||||
|
13.41 ms (7.93%) |
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 819899 734495 739585 719741 744064 665939 579671 653832 653156 748633 630873 540137 533084 575919 575862 646610 716807 631376 403258 396546 542618 543328 564290 649348 655491 658170 671234 688830 718348 648600 657236 686719 691953 693916 700823 701173 648433 650358 668737 673242 695454 718118 575563 578905 585605 590119 608961 613372 613684 640671 741061 749417 725058 736497 742995 729758 731133 635585 721268 786092 690697 572636 33602 647661 648481 616640 760515 607000 538044 387993 396619 433014 540789 488806 481116 483771 489228 498761 514191 530302 530463 533702 534870 535567 504828 532189 537254 537276 526328 537283 539392 512364 514039 514190 535845 465749 476614 482216 553878 542659 541494 546294 720049 583175 595151 787546 743630 746181 747950 747947 762953 748112 633233 698763 353299 400540 4338 578808 657247 687666 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.65%) |
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 4338 33602 353299 387993 396546 396619 400540 403258 433014 465749 476614 481116 482216 483771 488806 489228 498761 504828 512364 514039 514190 514191 526328 530302 530463 532189 533084 533702 534870 535567 537254 537276 537283 538044 539392 540137 540789 541494 542618 542659 543328 546294 553878 564290 572636 575563 575862 575919 578808 578905 579671 583175 585605 590119 595151 607000 608961 613372 613684 616640 630873 631376 633233 635585 640671 646610 647661 648433 648481 648600 649348 650358 653156 653832 655491 657236 657247 658170 665939 668737 671234 673242 686719 687666 688830 690697 691953 693916 695454 698763 700823 701173 716807 718118 718348 719741 720049 721268 725058 729758 731133 734495 736497 739585 741061 742995 743630 744064 746181 747947 747950 748112 748633 749417 760515 762953 786092 787546 819899 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife big dick"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.