Query Metrics
7
Database Queries
7
Different statements
160.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.89 ms (85.48%) |
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 229210 233473 251147 381963 382368 382824 383227 413730 418346 486209 502109 516646 526954 531860 535789 542489 546544 547980 554876 555677 561442 587819 595811 603740 606516 615001 615307 623335 625307 627125 632683 637716 644246 644912 649542 649627 651323 652865 653624 659339 663902 663977 665114 665346 665479 667273 669417 673050 678576 679549 681342 689310 689571 691616 695932 696167 699531 699802 702344 703211 703825 708494 710363 713449 714410 718869 722443 724207 725096 729659 731950 732597 732730 733045 736727 737132 738484 739547 740124 740967 741118 741207 744256 744640 749012 750080 755848 758298 761344 763852 767168 770244 770837 770840 771755 778137 782443 789108 791283 798930 801093 805991 807148 807180 807200 809028 811513 817618 819624 820357 822981 823447 824228 825690 827178 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (7.47%) |
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 627125 805991 741118 770837 732730 733045 744640 737132 382824 96431 736727 822981 644912 526954 673050 625307 632683 770244 807180 86313 17180 823447 827178 689571 722443 644246 763852 88614 486209 714410 718869 615307 755848 724207 418346 382368 535789 649542 652865 659339 587819 739547 702344 381963 502109 665479 681342 703825 708494 651323 710363 595811 606516 615001 809028 740967 749012 65228 251147 678576 663977 699531 689310 801093 811513 758298 732597 767168 770840 741207 637716 413730 817618 820357 824228 825690 516646 542489 547980 554876 561442 653624 663902 665114 669417 679549 695932 649627 665346 667273 696167 623335 798930 789108 729659 744256 807148 725096 740124 750080 699802 233473 713449 778137 807200 738484 731950 229210 383227 819624 531860 546544 555677 703211 691616 603740 782443 791283 761344 771755 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (2.28%) |
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 229210 233473 251147 381963 382368 382824 383227 413730 418346 486209 502109 516646 526954 531860 535789 542489 546544 547980 554876 555677 561442 587819 595811 603740 606516 615001 615307 623335 625307 627125 632683 637716 644246 644912 649542 649627 651323 652865 653624 659339 663902 663977 665114 665346 665479 667273 669417 673050 678576 679549 681342 689310 689571 691616 695932 696167 699531 699802 702344 703211 703825 708494 710363 713449 714410 718869 722443 724207 725096 729659 731950 732597 732730 733045 736727 737132 738484 739547 740124 740967 741118 741207 744256 744640 749012 750080 755848 758298 761344 763852 767168 770244 770837 770840 771755 778137 782443 789108 791283 798930 801093 805991 807148 807180 807200 809028 811513 817618 819624 820357 822981 823447 824228 825690 827178 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex two"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс two"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.90%) |
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.