Query Metrics
7
Database Queries
7
Different statements
174.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.18 ms (82.41%) |
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 370949 383065 403924 406882 407771 411121 411592 411734 417875 418079 420580 420585 421795 421819 421853 422193 424032 424118 424274 425947 425983 426864 428839 428841 428855 434763 439743 439809 448745 448751 449693 453438 453660 453681 453719 454415 459892 459910 459970 460136 462198 462202 462657 465308 466801 468307 469449 471621 474155 476345 476346 476721 478934 481791 482301 483590 488749 496565 498437 502742 509336 510296 510297 513584 513597 513857 514108 514273 514275 516233 516728 523457 523618 525805 526589 529240 536891 545645 546113 546896 548264 549670 549746 549748 551072 551123 552757 554376 554377 554917 555614 556609 559165 561288 561289 562031 563034 564265 564377 564555 565632 566228 569408 569425 573760 574417 585084 619362 675405 682269 696557 703900 703902 715234 716307 716351 761047 799962 803297 807479 ] |
||||||||||||||||||||||||||||||
|
20.93 ms (11.97%) |
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 761047 619362 703900 799962 803297 807479 407771 420585 422193 424032 428839 428841 439743 448751 476721 420580 421795 424118 439809 411734 421819 424274 462657 476346 428855 468307 406882 417875 421853 426864 513584 529240 514273 525805 483590 523618 498437 514275 536891 383065 370949 403924 411121 425983 425947 411592 418079 434763 585084 453660 459910 471621 488749 448745 449693 453438 453681 453719 454415 462198 462202 465308 478934 459892 466801 469449 474155 476345 481791 482301 496565 509336 523457 526589 510296 513597 516233 514108 516728 502742 510297 513857 459970 460136 546113 551072 554376 559165 564377 565632 549746 549748 554917 562031 566228 569408 569425 574417 545645 548264 561288 561289 563034 564265 564555 573760 682269 675405 696557 716307 716351 703902 715234 546896 549670 551123 552757 554377 555614 556609 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.72%) |
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 370949 383065 403924 406882 407771 411121 411592 411734 417875 418079 420580 420585 421795 421819 421853 422193 424032 424118 424274 425947 425983 426864 428839 428841 428855 434763 439743 439809 448745 448751 449693 453438 453660 453681 453719 454415 459892 459910 459970 460136 462198 462202 462657 465308 466801 468307 469449 471621 474155 476345 476346 476721 478934 481791 482301 483590 488749 496565 498437 502742 509336 510296 510297 513584 513597 513857 514108 514273 514275 516233 516728 523457 523618 525805 526589 529240 536891 545645 546113 546896 548264 549670 549746 549748 551072 551123 552757 554376 554377 554917 555614 556609 559165 561288 561289 562031 563034 564265 564377 564555 565632 566228 569408 569425 573760 574417 585084 619362 675405 682269 696557 703900 703902 715234 716307 716351 761047 799962 803297 807479 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepson stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepson stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepson stepmom"
]
|
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.