Query Metrics
7
Database Queries
7
Different statements
396.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.43 ms (52.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
166.46 ms (42.03%) |
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 17180 65228 86313 88614 96431 193662 251147 381963 382368 382824 413730 418346 486209 502109 516646 526954 535789 542489 545096 547980 551181 554876 561442 571268 587819 593885 595741 595811 600005 603572 605049 606471 606516 615001 615307 623335 625307 627125 632683 637716 644246 644912 649542 649627 651323 652865 653175 653624 659339 663902 663977 665114 665346 665479 665486 667273 669417 669744 670471 670479 670493 670504 672449 673028 673050 677584 678576 679549 681342 689310 689571 695059 695932 696167 699531 702344 703825 708494 710363 714410 718869 722443 724207 729659 732597 732730 733045 736727 737132 739547 740967 741118 741207 744640 749012 755848 758298 763852 767168 770244 770837 770840 782014 789108 798930 801093 805991 807180 809028 811513 817618 817663 818666 818932 820357 822981 823447 824228 825690 827178 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (3.66%) |
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 817663 818666 545096 551181 670504 653175 670471 672449 677584 665486 669744 670479 670493 673028 593885 606471 600005 605049 627125 805991 741118 770837 732730 733045 744640 737132 382824 96431 736727 822981 644912 526954 673050 625307 632683 770244 807180 86313 17180 823447 827178 695059 689571 722443 644246 763852 88614 486209 714410 718869 615307 755848 724207 418346 382368 535789 571268 649542 652865 659339 587819 739547 702344 381963 502109 665479 681342 703825 708494 651323 710363 595811 606516 615001 809028 740967 749012 65228 251147 818932 678576 663977 699531 689310 801093 811513 758298 732597 767168 770840 741207 637716 193662 413730 817618 820357 824228 825690 516646 542489 547980 554876 561442 653624 663902 665114 669417 679549 695932 649627 665346 667273 696167 595741 623335 603572 798930 782014 789108 729659 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (0.64%) |
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 17180 65228 86313 88614 96431 193662 251147 381963 382368 382824 413730 418346 486209 502109 516646 526954 535789 542489 545096 547980 551181 554876 561442 571268 587819 593885 595741 595811 600005 603572 605049 606471 606516 615001 615307 623335 625307 627125 632683 637716 644246 644912 649542 649627 651323 652865 653175 653624 659339 663902 663977 665114 665346 665479 665486 667273 669417 669744 670471 670479 670493 670504 672449 673028 673050 677584 678576 679549 681342 689310 689571 695059 695932 696167 699531 702344 703825 708494 710363 714410 718869 722443 724207 729659 732597 732730 733045 736727 737132 739547 740967 741118 741207 744640 749012 755848 758298 763852 767168 770244 770837 770840 782014 789108 798930 801093 805991 807180 809028 811513 817618 817663 818666 818932 820357 822981 823447 824228 825690 827178 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"two fuck"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"two секс"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"two секс"
]
|
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.