Query Metrics
7
Database Queries
7
Different statements
165.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.75 ms (83.60%) |
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 6670 239808 395651 396245 396863 398701 399551 400698 401810 416634 416668 417940 422420 426104 432760 432782 437084 437364 444193 447642 448325 451529 451554 453793 454726 458456 459397 461292 463266 465237 468773 469775 472974 478184 479759 485325 492649 500551 504303 504393 511268 511836 512298 515744 516695 517175 521809 525432 529133 535618 535622 536750 542944 543659 544206 554114 556580 560348 564184 566505 568507 569427 574826 597607 602626 604051 612082 619367 632576 635578 636943 641781 643593 646129 652125 657567 659215 662084 671396 679957 680740 684812 685425 688885 698912 701439 701500 710722 715144 721710 724030 729933 731890 739764 750143 750498 752735 756690 757906 758819 759581 760828 761089 761185 777488 778773 778935 787936 791181 796789 797325 800175 800282 809784 814518 814711 816762 817322 821851 827535 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (10.18%) |
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 453793 479759 416668 400698 516695 817322 827535 816762 715144 791181 756690 731890 398701 556580 684812 646129 636943 511836 544206 619367 757906 417940 465237 463266 504303 659215 604051 437364 566505 515744 444193 759581 416634 657567 724030 739764 761089 796789 750143 777488 787936 422420 401810 437084 529133 542944 685425 543659 447642 6670 554114 698912 679957 688885 662084 643593 469775 797325 800282 492649 568507 569427 574826 632576 612082 448325 468773 485325 521809 525432 426104 458456 500551 239808 395651 396245 671396 399551 504393 451529 396863 564184 641781 778935 800175 778773 758819 752735 760828 721710 461292 652125 432782 821851 472974 451554 511268 560348 432760 459397 535618 536750 680740 701439 710722 597607 635578 602626 512298 729933 750498 454726 814711 814518 809784 761185 478184 535622 701500 517175 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.80%) |
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 6670 239808 395651 396245 396863 398701 399551 400698 401810 416634 416668 417940 422420 426104 432760 432782 437084 437364 444193 447642 448325 451529 451554 453793 454726 458456 459397 461292 463266 465237 468773 469775 472974 478184 479759 485325 492649 500551 504303 504393 511268 511836 512298 515744 516695 517175 521809 525432 529133 535618 535622 536750 542944 543659 544206 554114 556580 560348 564184 566505 568507 569427 574826 597607 602626 604051 612082 619367 632576 635578 636943 641781 643593 646129 652125 657567 659215 662084 671396 679957 680740 684812 685425 688885 698912 701439 701500 710722 715144 721710 724030 729933 731890 739764 750143 750498 752735 756690 757906 758819 759581 760828 761089 761185 777488 778773 778935 787936 791181 796789 797325 800175 800282 809784 814518 814711 816762 817322 821851 827535 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen homemade"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen домашн любительск"
]
|
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.