Query Metrics
7
Database Queries
7
Different statements
126.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
108.16 ms (85.52%) |
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 70636 124327 171995 173805 253654 400885 429545 499339 532093 536983 538602 539367 546486 555473 564220 591057 603291 603680 605629 607752 618033 618124 621622 629838 629843 630680 637497 641293 652332 658434 665974 668576 669262 670377 670723 670754 681747 696254 702355 713425 715587 716476 724002 725205 725664 726331 727655 732123 733157 733508 734153 734177 735556 737906 738301 740740 741208 743043 744764 749893 759698 760188 761406 765963 769555 770189 788010 788653 789903 795736 795861 796781 796784 796815 801381 802045 802093 802300 809873 810019 811602 813719 818755 819402 823601 823731 823843 824129 824155 824214 824238 824727 825061 825135 825189 825252 826201 826693 826726 826755 826877 826922 826967 827030 827137 827358 827378 827401 827448 827477 827561 827687 828074 ] |
||||||||||||||||||||||||||||||
|
8.69 ms (6.87%) |
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 725664 749893 725205 738301 823874 827378 665974 605629 733508 670723 546486 603680 811602 70636 253654 823731 824599 826967 827030 789903 810019 724002 740740 743043 733157 796815 171995 825189 825135 652332 124327 802300 802045 429545 732123 670377 761406 809873 741208 769555 716476 681747 621622 539367 825061 827358 823921 818755 825252 824129 532093 499339 555473 564220 670754 658434 669262 713425 715587 603291 637497 591057 607752 618124 630680 737906 727655 759698 734177 702355 796784 827477 536983 538602 668576 696254 641293 726331 629838 795861 801381 173805 824238 826201 825780 826755 826877 827137 827448 827561 823843 826056 819402 824214 824727 826093 828074 788010 795736 788653 802093 744764 761367 796781 734153 765963 770189 629843 400885 760188 618033 735556 824155 826693 826726 826922 827401 813719 823601 827687 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (2.09%) |
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 70636 124327 171995 173805 253654 400885 429545 499339 532093 536983 538602 539367 546486 555473 564220 591057 603291 603680 605629 607752 618033 618124 621622 629838 629843 630680 637497 641293 652332 658434 665974 668576 669262 670377 670723 670754 681747 696254 702355 713425 715587 716476 724002 725205 725664 726331 727655 732123 733157 733508 734153 734177 735556 737906 738301 740740 741208 743043 744764 749893 759698 760188 761406 765963 769555 770189 788010 788653 789903 795736 795861 796781 796784 796815 801381 802045 802093 802300 809873 810019 811602 813719 818755 819402 823601 823731 823843 824129 824155 824214 824238 824727 825061 825135 825189 825252 826201 826693 826726 826755 826877 826922 826967 827030 827137 827358 827378 827401 827448 827477 827561 827687 828074 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск жен"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade wife"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.19%) |
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.