Query Metrics
7
Database Queries
7
Different statements
168.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.70 ms (80.72%) |
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 13767 27635 329500 401560 421432 425128 427057 446061 447376 454516 456894 459265 497125 497324 523049 523940 526539 528988 530405 534339 534353 535432 537615 537828 541669 541762 542144 544956 545761 548510 550013 556093 558145 562953 563535 568721 576317 576480 577493 579123 580710 584593 585896 606792 611485 613629 614766 614848 619094 633034 634432 634463 647219 661378 680933 680945 680968 683435 683766 688999 692713 698819 699859 702143 713167 713187 714004 717601 718520 719094 719563 721882 721906 721918 728713 732923 734028 734069 734071 737144 738421 738909 739220 743653 750982 757026 757548 768017 768057 768969 768983 771393 772844 776637 778523 778765 781413 785103 785526 785540 789045 789265 791491 792186 792434 792456 792757 793050 793973 798842 801637 802704 804353 805138 805190 808849 809537 811897 812485 813296 ] |
||||||||||||||||||||||||||||||
|
20.74 ms (12.34%) |
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 680968 683766 699859 634432 619094 613629 614848 785526 805138 778765 789265 813296 792434 793050 808849 734069 732923 737144 702143 789045 791491 809537 454516 534353 541669 556093 713167 568721 585896 739220 768057 768969 523940 456894 534339 576480 541762 544956 713187 719094 661378 680933 692713 717601 719563 721918 801637 728713 792456 750982 721882 804353 329500 421432 579123 459265 425128 562953 812485 781413 528988 446061 580710 447376 497324 718520 611485 542144 633034 776637 738909 738421 401560 27635 427057 497125 530405 537828 577493 558145 647219 714004 683435 698819 680945 688999 606792 614766 805190 811897 743653 757026 772844 793973 802704 734028 768983 771393 734071 757548 768017 634463 721906 778523 785103 785540 792186 792757 798842 523049 526539 535432 576317 563535 13767 537615 584593 545761 548510 550013 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.88%) |
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 13767 27635 329500 401560 421432 425128 427057 446061 447376 454516 456894 459265 497125 497324 523049 523940 526539 528988 530405 534339 534353 535432 537615 537828 541669 541762 542144 544956 545761 548510 550013 556093 558145 562953 563535 568721 576317 576480 577493 579123 580710 584593 585896 606792 611485 613629 614766 614848 619094 633034 634432 634463 647219 661378 680933 680945 680968 683435 683766 688999 692713 698819 699859 702143 713167 713187 714004 717601 718520 719094 719563 721882 721906 721918 728713 732923 734028 734069 734071 737144 738421 738909 739220 743653 750982 757026 757548 768017 768057 768969 768983 771393 772844 776637 778523 778765 781413 785103 785526 785540 789045 789265 791491 792186 792434 792456 792757 793050 793973 798842 801637 802704 804353 805138 805190 808849 809537 811897 812485 813296 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк пляж природ"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl beach"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.01%) |
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.