Query Metrics
7
Database Queries
7
Different statements
395.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.57 ms (52.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son mature"
]
|
||||||||||||||||||||||||||||||
|
157.19 ms (39.75%) |
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 310672 346210 394258 395701 397894 400134 400481 400486 407414 409093 412262 421814 421830 421884 422158 422295 424125 427452 430313 433375 439457 439571 439616 439641 439676 439681 439696 439699 439726 439727 439787 439798 439812 443166 445459 449717 450161 451826 452629 454552 455337 457191 457465 462351 462569 464329 464391 464436 466003 466138 467012 469367 470293 470762 470774 472176 474401 474498 474784 474785 474800 475266 475632 477110 477987 480283 480833 482629 489330 490180 491983 491991 502816 507884 512541 512556 515018 518858 520878 521473 523031 524267 524271 524330 524655 526728 526729 539759 541889 542957 549644 549824 549829 549833 550643 554897 555889 559173 561378 561577 562517 563423 563445 565659 565983 571129 571708 586314 604681 620245 662140 684308 688083 724156 726871 731204 753722 764698 793294 794654 ] |
||||||||||||||||||||||||||||||
|
19.81 ms (5.01%) |
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 524267 467012 549644 562517 571708 542957 554897 549833 550643 561378 563445 662140 684308 688083 555889 563423 571129 604681 620245 586314 793294 726871 731204 794654 724156 753722 764698 422295 443166 477987 394258 397894 400134 400481 439727 457191 400486 421814 450161 464436 470293 472176 474498 310672 346210 424125 427452 452629 477110 480833 409093 421830 521473 524330 491991 523031 491983 524271 526728 490180 524655 518858 541889 439641 470774 474784 439676 439681 439696 439812 395701 433375 439726 430313 412262 482629 449717 451826 474785 480283 464391 466003 507884 502816 512541 526729 512556 515018 520878 539759 462569 489330 565983 559173 565659 549824 549829 561577 407414 454552 457465 470762 474401 475266 421884 439571 439699 462351 466138 474800 422158 439457 439616 464329 439787 439798 445459 469367 455337 475632 ] |
||||||||||||||||||||||||||||||
|
6.41 ms (1.62%) |
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 310672 346210 394258 395701 397894 400134 400481 400486 407414 409093 412262 421814 421830 421884 422158 422295 424125 427452 430313 433375 439457 439571 439616 439641 439676 439681 439696 439699 439726 439727 439787 439798 439812 443166 445459 449717 450161 451826 452629 454552 455337 457191 457465 462351 462569 464329 464391 464436 466003 466138 467012 469367 470293 470762 470774 472176 474401 474498 474784 474785 474800 475266 475632 477110 477987 480283 480833 482629 489330 490180 491983 491991 502816 507884 512541 512556 515018 518858 520878 521473 523031 524267 524271 524330 524655 526728 526729 539759 541889 542957 549644 549824 549829 549833 550643 554897 555889 559173 561378 561577 562517 563423 563445 565659 565983 571129 571708 586314 604681 620245 662140 684308 688083 724156 726871 731204 753722 764698 793294 794654 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son mature"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son mature"
]
|
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.