Query Metrics
7
Database Queries
7
Different statements
365.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.02 ms (58.00%) |
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 30208 30791 37495 72386 178567 191246 251476 381942 383110 391701 395584 396365 397708 407187 411621 418739 440908 454410 459257 466703 475387 478035 510830 523904 529701 561213 578200 596795 596969 600543 601618 607405 607607 607650 614726 614733 623638 630370 633824 641794 647645 664227 664275 666712 667751 669652 675964 678806 690480 691180 697184 697391 698125 698128 699441 707642 709623 716164 716331 716883 723189 728429 735836 736465 738209 738297 740985 748523 753783 754191 755363 758791 760406 761244 764414 769501 773579 774294 775558 776176 776557 781978 782408 784794 784961 786600 788230 788490 793683 799872 800005 800543 800869 801416 802445 802671 802834 803176 804800 805737 807769 808037 808531 810000 810105 810410 813620 814282 814293 814722 815991 817116 819262 819351 823536 823585 823887 825405 826235 ] |
||||||||||||||||||||||||||||||
|
133.09 ms (36.40%) |
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 30208 30791 37495 72386 178567 191246 251476 381942 383110 391701 395584 396365 397708 407187 411621 418739 440908 454410 459257 466703 475387 478035 510830 523904 529701 561213 578200 596795 596969 600543 601618 607405 607607 607650 614726 614733 623638 630370 633824 641794 647645 664227 664275 666712 667751 669652 675964 678806 690480 691180 697184 697391 698125 698128 699441 707642 709623 716164 716331 716883 723189 728429 735836 736465 738209 738297 740985 748523 753783 754191 755363 758791 760406 761244 764414 769501 773579 774294 775558 776176 776557 781978 782408 784794 784961 786600 788230 788490 793683 799872 800005 800543 800869 801416 802445 802671 802834 803176 804800 805737 807769 808037 808531 810000 810105 810410 813620 814282 814293 814722 815991 817116 819262 819351 823536 823585 823887 825405 826235 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (3.76%) |
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 735836 754191 728648 716164 191246 391701 814722 819351 478035 523904 716883 697391 709623 675964 600543 607405 596795 607607 775558 776557 802834 736465 773579 800005 760406 764414 738297 753783 707642 782408 788230 803176 383110 178567 440908 815991 823536 825405 691180 596969 810105 633824 814282 397708 411621 454410 510830 690480 776176 807769 748523 728429 799872 30791 823887 813620 817116 475387 647645 664275 698125 698128 614726 601618 623638 761244 808531 810000 784961 72386 396365 30208 407187 819262 826235 814293 664227 667751 666712 697184 716331 561213 641794 630370 784794 802445 740985 758791 793683 800543 801416 774294 769501 800869 802671 804800 805737 808037 459257 381942 823585 529701 678806 699441 723189 781978 810410 788490 755363 738209 607650 614733 37495 251476 395584 418739 466703 578200 669652 786600 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big curvy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие curvy"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие curvy"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.41%) |
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.