Query Metrics
7
Database Queries
7
Different statements
167.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.16 ms (85.43%) |
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 314552 388392 396353 428259 437486 440902 444657 446098 450338 452971 469261 487188 493665 495364 531821 533995 543127 543846 554956 555082 558342 562228 564103 564557 568477 588433 590029 594267 597165 598805 601550 604138 606251 609875 619442 621174 629092 633611 642232 642689 652274 652954 654097 656597 665392 680472 682924 683303 692816 694142 694917 700925 702046 704178 710368 712481 713098 715121 716121 717921 718934 726297 727653 728260 733846 733887 735028 736592 737553 742185 743436 744450 745341 746555 749669 750275 750307 750710 753638 755341 755937 758096 759914 761098 761192 761594 766611 766910 767050 771203 776287 776524 777940 778989 782429 782745 786356 789532 789672 791006 791809 792142 795628 796106 796162 796652 800247 800531 800554 800721 802732 804638 806331 807510 809656 811663 813539 813627 814417 815116 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (8.79%) |
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 656597 710368 717921 554956 606251 594267 588433 776524 778989 796162 802732 782429 789532 792142 727653 737553 750710 755937 759914 761594 811663 813539 733887 743436 750307 755341 766910 746555 753638 767050 728260 745341 749669 766611 609875 715121 789672 791006 809656 388392 531821 562228 702046 712481 683303 713098 642232 795628 806331 744450 735028 314552 452971 396353 558342 800554 800531 642689 437486 814417 568477 692816 680472 704178 804638 733846 791809 807510 450338 495364 813627 815116 533995 564103 652954 654097 718934 652274 700925 629092 619442 590029 601550 776287 786356 777940 782745 796652 800721 761098 736592 771203 726297 750275 758096 761192 800247 428259 440902 444657 446098 487188 469261 493665 555082 543846 543127 665392 682924 694917 694142 716121 564557 598805 633611 597165 604138 621174 796106 742185 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.61%) |
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 314552 388392 396353 428259 437486 440902 444657 446098 450338 452971 469261 487188 493665 495364 531821 533995 543127 543846 554956 555082 558342 562228 564103 564557 568477 588433 590029 594267 597165 598805 601550 604138 606251 609875 619442 621174 629092 633611 642232 642689 652274 652954 654097 656597 665392 680472 682924 683303 692816 694142 694917 700925 702046 704178 710368 712481 713098 715121 716121 717921 718934 726297 727653 728260 733846 733887 735028 736592 737553 742185 743436 744450 745341 746555 749669 750275 750307 750710 753638 755341 755937 758096 759914 761098 761192 761594 766611 766910 767050 771203 776287 776524 777940 778989 782429 782745 786356 789532 789672 791006 791809 792142 795628 796106 796162 796652 800247 800531 800554 800721 802732 804638 806331 807510 809656 811663 813539 813627 814417 815116 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"горячий анальный секс…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горяч анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"горяч анал"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.93%) |
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.