Query Metrics
7
Database Queries
7
Different statements
138.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.40 ms (84.13%) |
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 382986 403147 470315 507848 549351 550677 556583 570776 577463 583102 585553 587908 591063 601436 613670 614354 620529 626853 627623 631547 631816 634301 642689 643257 643520 646370 651404 653042 658121 660455 665263 668595 678985 682841 683715 685180 686091 689431 698226 702062 702332 702988 703003 705247 711094 712397 712477 715692 716970 717726 718301 720962 721648 722195 728898 731669 734934 737525 740045 740726 741909 746299 749003 750512 750854 751228 751370 752841 753239 753878 757795 765229 765997 767614 768834 768966 769018 770086 774678 775715 776203 777210 779177 780730 781037 781212 781549 785097 786624 787319 788689 791678 792535 792683 792720 792940 794339 795474 795475 795905 796231 797434 797453 798863 799253 799608 801682 802588 802788 805029 806133 808778 809971 810167 811364 811533 812215 813314 820561 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (8.64%) |
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 507848 556583 549351 570776 651404 653042 660455 665263 685180 702062 712397 712477 717726 668595 678985 689431 702988 705247 711094 721648 646370 658121 682841 683715 686091 698226 715692 718301 720962 722195 577463 583102 601436 642689 643520 585553 591063 631816 587908 613670 614354 620529 626853 627623 631547 634301 643257 774678 777210 780730 781037 781212 781549 791678 792720 795905 811533 794339 799253 805029 809971 812215 731669 740045 740726 750512 752841 753878 765229 765997 785097 787319 788689 792535 795474 797434 799608 802588 808778 749003 750854 768834 768966 738923 746299 728898 751370 757795 767614 770086 734934 737525 741909 751228 753239 769018 702332 703003 716970 775715 776203 779177 786624 792683 792940 795475 796231 797453 798863 801682 802788 806133 810167 811364 813314 403147 550677 382986 470315 820561 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.90%) |
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 382986 403147 470315 507848 549351 550677 556583 570776 577463 583102 585553 587908 591063 601436 613670 614354 620529 626853 627623 631547 631816 634301 642689 643257 643520 646370 651404 653042 658121 660455 665263 668595 678985 682841 683715 685180 686091 689431 698226 702062 702332 702988 703003 705247 711094 712397 712477 715692 716970 717726 718301 720962 721648 722195 728898 731669 734934 737525 740045 740726 741909 746299 749003 750512 750854 751228 751370 752841 753239 753878 757795 765229 765997 767614 768834 768966 769018 770086 774678 775715 776203 777210 779177 780730 781037 781212 781549 785097 786624 787319 788689 791678 792535 792683 792720 792940 794339 795474 795475 795905 796231 797434 797453 798863 799253 799608 801682 802588 802788 805029 806133 808778 809971 810167 811364 811533 812215 813314 820561 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot girls teens"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot девушк teens"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot девушк teens"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.18%) |
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.