Query Metrics
7
Database Queries
7
Different statements
203.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.24 ms (87.08%) |
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 7373 72589 96347 234584 236863 341546 386477 388392 388492 389987 396568 396595 399688 400739 401115 402876 403141 408499 414108 416236 424841 425601 466426 467120 468480 468484 468829 469579 469582 470400 471814 478006 482780 488464 493752 496724 509204 519107 520211 520217 531298 532708 536404 537671 537885 537941 538749 545220 556043 563989 567340 571015 576727 586021 586031 599834 600429 630043 634528 634550 637450 637567 639731 641914 642315 646451 649964 666575 666591 673767 674984 678940 683875 683932 690885 695621 696983 699689 699735 704558 711606 716784 727751 728718 733571 733572 740641 740874 744597 746837 750275 750277 755843 756394 757661 774605 778038 780601 782040 785669 785802 788169 790859 796904 796941 797734 800296 802293 814240 815837 815849 815911 817062 817163 817241 817318 817781 824938 824940 826135 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (7.15%) |
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 389987 396595 817781 824940 649964 236863 72589 96347 424841 466426 468484 493752 536404 520211 469582 744597 727751 733572 478006 416236 496724 815911 817062 817241 817163 538749 699689 683932 750277 802293 728718 733571 780601 408499 817318 637450 7373 468480 399688 471814 537885 519107 646451 639731 414108 425601 567340 563989 673767 683875 696983 716784 796904 796941 800296 740874 634528 388492 396568 341546 400739 509204 234584 402876 488464 468829 482780 469579 666591 599834 403141 386477 388392 824938 532708 571015 690885 641914 401115 815837 814240 815849 826135 467120 531298 537941 545220 695621 704558 711606 634550 586021 586031 785669 785802 746837 740641 755843 750275 756394 757661 699735 774605 782040 788169 520217 537671 674984 666575 642315 600429 576727 470400 556043 678940 630043 637567 778038 797734 790859 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (1.86%) |
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 7373 72589 96347 234584 236863 341546 386477 388392 388492 389987 396568 396595 399688 400739 401115 402876 403141 408499 414108 416236 424841 425601 466426 467120 468480 468484 468829 469579 469582 470400 471814 478006 482780 488464 493752 496724 509204 519107 520211 520217 531298 532708 536404 537671 537885 537941 538749 545220 556043 563989 567340 571015 576727 586021 586031 599834 600429 630043 634528 634550 637450 637567 639731 641914 642315 646451 649964 666575 666591 673767 674984 678940 683875 683932 690885 695621 696983 699689 699735 704558 711606 716784 727751 728718 733571 733572 740641 740874 744597 746837 750275 750277 755843 756394 757661 774605 778038 780601 782040 785669 785802 788169 790859 796904 796941 797734 800296 802293 814240 815837 815849 815911 817062 817163 817241 817318 817781 824938 824940 826135 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал межрасов"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal interracial"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
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.