Query Metrics
7
Database Queries
7
Different statements
175.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.96 ms (85.63%) |
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 170225 459708 464801 465591 490849 492966 494894 496261 516119 523045 528314 546629 551594 563284 565105 573354 584869 584964 588058 588858 593745 599318 605534 615533 616133 618495 619854 621600 622286 623108 623280 627077 636925 637210 637347 637481 639111 641128 647108 658939 661320 672310 676673 678249 678858 679499 680268 681514 684433 685509 691466 693669 693677 693695 693765 706024 708594 711094 712574 712939 715118 716934 716952 719573 720547 720579 723293 724961 728652 729069 731267 733412 736702 739798 740883 748693 748747 748773 749046 749427 749542 750391 763431 763876 765678 765940 767716 769043 772262 773368 773761 774667 774671 775590 777815 777836 779889 779946 780219 781132 786088 786729 790829 790929 791542 792340 792341 792487 793186 795099 795247 795257 796351 796988 800636 801478 804932 808529 808601 812282 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (7.56%) |
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 678858 693677 637210 773368 588858 615533 170225 693669 716952 775590 605534 563284 588058 801478 748693 573354 623108 680268 715118 731267 639111 684433 693695 676673 720579 636925 627077 637347 616133 465591 551594 767716 637481 565105 516119 781132 779889 772262 792341 796988 729069 681514 792340 584964 678249 711094 647108 739798 599318 584869 716934 774671 749046 748773 800636 777836 790929 496261 774667 779946 740883 808529 720547 621600 619854 706024 792487 733412 749427 723293 765678 750391 786729 712574 658939 790829 812282 804932 808601 793186 736702 763431 795099 693765 622286 672310 712939 786088 773761 780219 795247 749542 777815 679499 523045 728652 494894 593745 618495 691466 528314 748747 769043 459708 492966 641128 719573 661320 708594 546629 685509 796351 763876 795257 791542 724961 765940 623280 490849 464801 ] |
||||||||||||||||||||||||||||||
|
3.73 ms (2.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"крупный план домашнеÐâ…"
]
|
||||||||||||||||||||||||||||||
|
3.50 ms (2.00%) |
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 170225 459708 464801 465591 490849 492966 494894 496261 516119 523045 528314 546629 551594 563284 565105 573354 584869 584964 588058 588858 593745 599318 605534 615533 616133 618495 619854 621600 622286 623108 623280 627077 636925 637210 637347 637481 639111 641128 647108 658939 661320 672310 676673 678249 678858 679499 680268 681514 684433 685509 691466 693669 693677 693695 693765 706024 708594 711094 712574 712939 715118 716934 716952 719573 720547 720579 723293 724961 728652 729069 731267 733412 736702 739798 740883 748693 748747 748773 749046 749427 749542 750391 763431 763876 765678 765940 767716 769043 772262 773368 773761 774667 774671 775590 777815 777836 779889 779946 780219 781132 786088 786729 790829 790929 791542 792340 792341 792487 793186 795099 795247 795257 796351 796988 800636 801478 804932 808529 808601 812282 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крупныйпла домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.73%) |
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.