Query Metrics
7
Database Queries
7
Different statements
167.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.22 ms (86.79%) |
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 396471 461997 466940 476923 516061 516738 537628 548994 550546 552103 564007 565202 567933 590654 591939 594359 617642 624935 628027 629441 632483 638524 641200 647192 652551 652554 653564 660455 667820 670079 685259 685429 685612 688394 690494 690925 691351 691405 693433 693437 694164 694175 695467 697675 699162 701038 701400 702350 702623 704432 704434 705008 706439 707298 708457 710027 712812 714105 714572 714693 718356 719283 720987 722438 725766 730792 730974 732336 737250 738052 739913 740211 740738 742207 745888 745899 748832 748844 749474 749779 749997 755066 759051 762019 763413 766303 767678 772865 772868 773834 775407 776679 777633 781339 781568 782084 786158 786804 788649 789097 790395 790718 791481 791795 793557 794145 794523 795186 795223 796533 796761 804708 804912 810545 813456 813872 813876 813881 813885 ] |
||||||||||||||||||||||||||||||
|
11.70 ms (6.99%) |
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 516738 714572 670079 795223 730792 796533 796761 693437 694164 694175 768748 794523 742207 725766 766303 772868 793557 564007 788649 739913 740738 624935 567933 702350 707298 714105 712812 720987 714693 628027 629441 591939 790395 810545 748832 745888 749997 641200 719283 660455 685429 691405 647192 695467 804708 763413 772865 781339 781568 461997 466940 476923 804912 552103 632483 786804 749474 737250 548994 685612 691351 693433 396471 813872 813881 813885 516061 550546 690925 697675 699162 701038 690494 704434 705008 706439 718356 667820 704432 590654 594359 638524 790718 775407 786158 755066 767678 789097 794145 730974 740211 749779 762019 773834 748844 759051 732336 738052 745899 701400 776679 791795 795186 813456 708457 702623 777633 791481 813876 537628 652551 685259 710027 653564 652554 688394 722438 565202 617642 782084 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.06%) |
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 396471 461997 466940 476923 516061 516738 537628 548994 550546 552103 564007 565202 567933 590654 591939 594359 617642 624935 628027 629441 632483 638524 641200 647192 652551 652554 653564 660455 667820 670079 685259 685429 685612 688394 690494 690925 691351 691405 693433 693437 694164 694175 695467 697675 699162 701038 701400 702350 702623 704432 704434 705008 706439 707298 708457 710027 712812 714105 714572 714693 718356 719283 720987 722438 725766 730792 730974 732336 737250 738052 739913 740211 740738 742207 745888 745899 748832 748844 749474 749779 749997 755066 759051 762019 763413 766303 767678 772865 772868 773834 775407 776679 777633 781339 781568 782084 786158 786804 788649 789097 790395 790718 791481 791795 793557 794145 794523 795186 795223 796533 796761 804708 804912 810545 813456 813872 813876 813881 813885 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодые девушки с пар%…"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк пар"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.77%) |
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.