Query Metrics
7
Database Queries
7
Different statements
151.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.81 ms (86.45%) |
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 479373 481636 491751 495418 504751 507557 510428 534661 559933 577510 580471 583319 585752 587997 592799 593704 597429 600855 602835 621619 627983 630721 634914 635712 637543 638889 644141 652708 653368 668786 668791 674474 700833 706797 709098 710912 712700 712775 714829 717790 721981 724044 724816 726242 728488 731030 731260 731499 732178 732232 732907 735473 738791 742263 745969 746213 746789 754845 757176 757651 757774 757992 758565 760858 762189 762344 762387 762779 764842 766468 770075 772429 772744 773312 773963 776608 778162 778219 781581 782162 782345 783809 787428 788492 788678 789134 789144 789554 790070 790317 792452 792699 794049 794535 794882 794999 795436 795467 797033 797126 798804 799752 800280 800436 800652 800817 800819 800892 801315 802348 804419 806190 811227 811712 812272 813739 818182 818314 ] |
||||||||||||||||||||||||||||||
|
9.97 ms (6.59%) |
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 600855 627983 630721 635712 637543 592799 593704 597429 776608 778162 783809 787428 794535 794882 794999 800280 800436 800652 788492 789134 789144 790317 800819 801315 724044 742263 770075 781581 782162 789554 792452 794049 795467 797033 799752 802348 811227 726242 728488 731030 732232 732907 745969 757774 762344 724816 738791 746789 757992 760858 766468 732178 762189 762387 762779 768523 731499 757651 764842 772744 773312 621619 706797 710912 717790 721981 778107 778219 788678 790070 792699 798804 800817 804419 806190 811712 510428 495418 507557 712775 559933 818182 818314 813739 534661 583319 668791 714829 709098 712700 668786 602835 644141 638889 800892 782345 772429 812272 731260 754845 735473 757176 758565 634914 795436 577510 653368 491751 700833 481636 504751 580471 652708 674474 585752 587997 746213 773963 797126 479373 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.93%) |
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 479373 481636 491751 495418 504751 507557 510428 534661 559933 577510 580471 583319 585752 587997 592799 593704 597429 600855 602835 621619 627983 630721 634914 635712 637543 638889 644141 652708 653368 668786 668791 674474 700833 706797 709098 710912 712700 712775 714829 717790 721981 724044 724816 726242 728488 731030 731260 731499 732178 732232 732907 735473 738791 742263 745969 746213 746789 754845 757176 757651 757774 757992 758565 760858 762189 762344 762387 762779 764842 766468 770075 772429 772744 773312 773963 776608 778162 778219 781581 782162 782345 783809 787428 788492 788678 789134 789144 789554 790070 790317 792452 792699 794049 794535 794882 794999 795436 795467 797033 797126 798804 799752 800280 800436 800652 800817 800819 800892 801315 802348 804419 806190 811227 811712 812272 813739 818182 818314 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dogging my wife"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dogging my жен"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dogging my жен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.17%) |
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.