Query Metrics
7
Database Queries
7
Different statements
385.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.51 ms (54.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
154.76 ms (40.17%) |
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 105168 223019 382193 382361 383318 383388 384533 386797 387423 390754 391269 401352 405481 410201 412776 414072 425508 425670 431639 444430 445019 446005 447091 451598 454012 474159 476052 478798 478986 482309 492405 495472 512881 517142 519912 543022 548045 557511 563953 571350 574076 580782 589596 590479 601099 602181 609183 610127 614533 614601 628511 629778 643078 643087 643283 645921 651116 664622 668603 678421 680573 694199 704067 712234 712423 719535 720540 724508 726643 727048 731691 732567 738280 740167 741243 741782 742454 742652 744481 744799 746098 751427 751511 752186 753674 753738 753745 754318 754647 755551 756283 759112 759123 762208 771082 772554 774085 774753 776160 776455 777419 779645 780998 783291 796799 797784 800736 801681 802897 804529 804639 804644 812304 814188 819811 823989 825342 826438 826600 826602 ] |
||||||||||||||||||||||||||||||
|
11.73 ms (3.04%) |
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 741243 755551 762208 609183 704067 589596 801681 776160 812304 732567 741782 390754 826602 744481 759112 771082 783291 386797 563953 754318 800736 383318 401352 774753 740167 752186 756283 804529 826600 414072 384533 712423 614601 802897 751511 777419 664622 651116 779645 431639 454012 482309 382193 512881 724508 772554 614533 444430 425670 580782 474159 742652 742454 754647 383388 495472 543022 571350 557511 602181 590479 445019 694199 643283 738280 628511 223019 774085 105168 780998 797784 727048 492405 668603 823989 819811 825342 548045 645921 712234 610127 643087 776455 759123 726643 753674 753738 796799 519912 478798 451598 643078 629778 720540 382361 410201 405481 517142 814188 680573 751427 746098 391269 447091 574076 678421 719535 753745 731691 476052 387423 804644 804639 412776 478986 446005 826438 601099 744799 425508 ] |
||||||||||||||||||||||||||||||
|
4.20 ms (1.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 105168 223019 382193 382361 383318 383388 384533 386797 387423 390754 391269 401352 405481 410201 412776 414072 425508 425670 431639 444430 445019 446005 447091 451598 454012 474159 476052 478798 478986 482309 492405 495472 512881 517142 519912 543022 548045 557511 563953 571350 574076 580782 589596 590479 601099 602181 609183 610127 614533 614601 628511 629778 643078 643087 643283 645921 651116 664622 668603 678421 680573 694199 704067 712234 712423 719535 720540 724508 726643 727048 731691 732567 738280 740167 741243 741782 742454 742652 744481 744799 746098 751427 751511 752186 753674 753738 753745 754318 754647 755551 756283 759112 759123 762208 771082 772554 774085 774753 776160 776455 777419 779645 780998 783291 796799 797784 800736 801681 802897 804529 804639 804644 812304 814188 819811 823989 825342 826438 826600 826602 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.33%) |
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.