Query Metrics
7
Database Queries
7
Different statements
160.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.68 ms (84.44%) |
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 324241 382874 385411 386369 395192 397923 428810 435180 444009 449972 462265 463135 464521 464561 469443 470762 476352 481662 488073 493225 498621 499785 507595 507805 508682 515893 519138 523451 523752 527266 530329 534186 544577 544663 549148 549277 549393 555715 557712 558916 559166 560105 564682 568051 568787 573742 588124 588942 602573 603458 611296 619918 620374 621707 621730 624235 652910 659170 676554 679067 679144 681663 682353 684224 688279 688411 699564 700914 701315 705256 706298 710574 723981 730477 730481 730524 731187 731916 741989 742812 743157 746708 751608 753693 754268 757126 758145 758874 764621 766524 768105 771742 772076 777755 779918 780512 783794 784636 787040 787149 790306 790914 795631 798869 799799 800234 802892 806856 808012 810650 811117 814895 817737 818135 824229 824643 824913 825199 826546 826942 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (9.40%) |
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 444009 559166 435180 464521 523752 534186 493225 469443 544663 499785 508682 395192 826546 825199 814895 481662 507595 530329 549148 564682 568051 544577 652910 682353 706298 681663 710574 676554 705256 549393 611296 588942 619918 588124 780512 783794 810650 779918 799799 811117 723981 741989 784636 787149 800234 802892 730481 730524 746708 730477 731916 742812 768105 758145 771742 621707 624235 787040 324241 386369 397923 679067 519138 568787 498621 515893 470762 523451 573742 824229 560105 688279 679144 751608 766524 462265 464561 488073 476352 385411 382874 428810 818135 824643 826942 817737 824913 449972 463135 507805 527266 557712 555715 558916 688411 659170 700914 684224 549277 603458 620374 621730 602573 790306 790914 795631 808012 754268 757126 758874 798869 753693 764621 772076 731187 743157 699564 701315 777755 806856 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.83%) |
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 324241 382874 385411 386369 395192 397923 428810 435180 444009 449972 462265 463135 464521 464561 469443 470762 476352 481662 488073 493225 498621 499785 507595 507805 508682 515893 519138 523451 523752 527266 530329 534186 544577 544663 549148 549277 549393 555715 557712 558916 559166 560105 564682 568051 568787 573742 588124 588942 602573 603458 611296 619918 620374 621707 621730 624235 652910 659170 676554 679067 679144 681663 682353 684224 688279 688411 699564 700914 701315 705256 706298 710574 723981 730477 730481 730524 731187 731916 741989 742812 743157 746708 751608 753693 754268 757126 758145 758874 764621 766524 768105 771742 772076 777755 779918 780512 783794 784636 787040 787149 790306 790914 795631 798869 799799 800234 802892 806856 808012 810650 811117 814895 817737 818135 824229 824643 824913 825199 826546 826942 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck sleep"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс спящ"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.96%) |
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.