Query Metrics
7
Database Queries
7
Different statements
205.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.87 ms (89.98%) |
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 4208 4451 21109 29374 82143 82289 309276 387106 389668 391246 410356 417683 420900 422231 446345 458647 469775 529498 530426 536110 538717 539486 550638 558919 561725 563356 571756 573326 585898 589377 595229 595598 598308 599091 604084 607755 607805 616018 618919 620737 621117 627636 627755 648540 650118 650723 651801 652522 657066 657758 658192 659623 665906 665993 666996 671350 676579 677349 678772 683720 690424 692024 696472 699552 709916 710847 712273 717322 719210 719813 720205 722854 725282 727906 728217 733809 735597 736342 739053 739519 740503 742504 742833 743079 746802 751792 754528 757184 757829 758528 761265 764560 764861 766861 767857 773044 774146 776982 777132 780393 782578 782985 786899 786928 789835 791384 791450 796410 797104 798265 799980 804228 810182 812145 814098 817994 819624 826309 827341 ] |
||||||||||||||||||||||||||||||
|
11.16 ms (5.43%) |
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 717322 571756 607805 616018 595229 595655 607755 621117 598308 780393 751792 754528 761265 796410 757184 764861 742504 739053 774146 733809 776982 782578 782985 810182 604084 585898 683720 710847 791384 773044 648540 671350 804228 797104 766861 21109 4208 391246 536110 550638 719210 589377 627636 786928 740503 410356 469775 529498 709916 777132 727906 422231 739519 742833 746802 758528 743079 420900 539486 573326 650118 652522 692024 665906 719813 657758 659623 595598 620737 627755 789835 725282 736342 728217 735597 767857 561725 657066 676579 799980 389668 819624 826309 446345 458647 530426 538717 558919 677349 665993 563356 786899 791450 798265 757829 764560 618919 812145 82289 82143 387106 309276 417683 599091 4451 814098 817994 827341 29374 650723 651801 658192 666996 696472 712273 690424 720205 722854 678772 699552 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.19%) |
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 4208 4451 21109 29374 82143 82289 309276 387106 389668 391246 410356 417683 420900 422231 446345 458647 469775 529498 530426 536110 538717 539486 550638 558919 561725 563356 571756 573326 585898 589377 595229 595598 598308 599091 604084 607755 607805 616018 618919 620737 621117 627636 627755 648540 650118 650723 651801 652522 657066 657758 658192 659623 665906 665993 666996 671350 676579 677349 678772 683720 690424 692024 696472 699552 709916 710847 712273 717322 719210 719813 720205 722854 725282 727906 728217 733809 735597 736342 739053 739519 740503 742504 742833 743079 746802 751792 754528 757184 757829 758528 761265 764560 764861 766861 767857 773044 774146 776982 777132 780393 782578 782985 786899 786928 789835 791384 791450 796410 797104 798265 799980 804228 810182 812145 814098 817994 819624 826309 827341 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк cute 18"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl cute 18"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк cute 18"
]
|
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.