Query Metrics
7
Database Queries
7
Different statements
162.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.91 ms (87.27%) |
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 411436 413958 423497 425279 440895 453833 460305 467947 477618 495336 505287 529337 531571 536305 536995 544161 545669 547609 552638 555103 564301 578509 581194 584364 603847 604260 606251 627358 656580 656916 657223 670254 675416 680312 680434 680435 680454 709545 715807 716780 717193 720442 720631 726239 726994 727743 727778 728262 728266 728393 728779 729226 729287 729907 731084 735027 735353 736237 736242 738639 740115 740844 740865 742637 742738 754034 755076 756462 756677 759623 759838 759914 759928 759947 761015 761025 761036 761116 761119 761594 762272 762301 765327 765547 765723 766670 766985 767052 767095 767203 776829 776968 783042 784162 784209 786550 791006 792654 793835 794070 794858 794897 795977 796126 796156 796158 797183 797392 800372 800455 801254 801450 802025 802142 804524 804674 810318 813539 824028 824883 ] |
||||||||||||||||||||||||||||||
|
10.26 ms (6.31%) |
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 584364 796158 802142 801254 767052 531571 545669 581194 680312 716780 604260 792654 411436 657223 656916 670254 606251 776968 735027 756462 759914 761594 761036 765547 761116 603847 715807 680435 735353 740865 776829 578509 656580 529337 797183 736237 742637 765723 766985 756677 505287 728779 810318 802025 800455 767095 460305 797392 796156 784209 728262 423497 824883 720631 680434 762272 765327 729226 467947 627358 766670 824028 761119 801450 536305 720442 759623 726239 740844 742738 759947 761025 794897 453833 727743 759928 729287 727778 440895 477618 495336 536995 564301 759838 547609 544161 717193 783042 784162 729907 767203 736242 755076 728266 728393 762301 794070 680454 675416 555103 740115 709545 804524 793835 738639 754034 413958 425279 552638 794858 795977 800372 813539 761015 726994 731084 791006 796126 804674 786550 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.98%) |
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 411436 413958 423497 425279 440895 453833 460305 467947 477618 495336 505287 529337 531571 536305 536995 544161 545669 547609 552638 555103 564301 578509 581194 584364 603847 604260 606251 627358 656580 656916 657223 670254 675416 680312 680434 680435 680454 709545 715807 716780 717193 720442 720631 726239 726994 727743 727778 728262 728266 728393 728779 729226 729287 729907 731084 735027 735353 736237 736242 738639 740115 740844 740865 742637 742738 754034 755076 756462 756677 759623 759838 759914 759928 759947 761015 761025 761036 761116 761119 761594 762272 762301 765327 765547 765723 766670 766985 767052 767095 767203 776829 776968 783042 784162 784209 786550 791006 792654 793835 794070 794858 794897 795977 796126 796156 796158 797183 797392 800372 800455 801254 801450 802025 802142 804524 804674 810318 813539 824028 824883 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск milf анал"
]
|
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.