Query Metrics
7
Database Queries
7
Different statements
206.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.28 ms (87.85%) |
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 263917 385427 396952 400191 404692 409080 413090 413097 414036 417662 417990 421825 421829 421857 421859 422211 422295 428822 428853 428858 433361 434044 435931 439660 439666 439763 439809 442444 443185 444298 445056 445459 445620 453452 457298 458731 460677 461371 464389 464410 464423 466049 466145 466180 467675 474776 474790 476337 477337 483496 485057 492115 493175 493185 493195 495222 495226 507884 511790 513362 515849 516281 516637 517526 518046 519821 519938 521130 521138 521140 523848 524289 525152 528347 528390 528826 528847 532056 534722 535050 549823 550219 550220 551923 557924 562990 563123 568344 589628 608415 610235 611332 628081 630630 689936 714171 715786 717797 724476 726831 736402 743738 748892 758174 761275 771742 772466 777228 777729 779734 779903 781795 796759 803437 806084 808496 810472 813922 826560 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (7.34%) |
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 414036 417990 474776 517526 589628 772466 421829 439809 445620 806084 761275 433361 466145 495226 495222 550219 493185 521140 521138 404692 826560 813922 464410 781795 796759 803437 442444 435931 443185 453452 464423 524289 534722 528390 532056 464389 608415 779905 758174 515849 528826 507884 385427 396952 726831 428822 263917 777729 771742 779903 457298 445459 528347 460677 562990 715786 428853 413090 523848 493175 493195 413097 461371 483496 516637 551923 477337 492115 518046 422211 445056 724476 736402 568344 466180 466049 525152 521130 439660 717797 810472 476337 748892 458731 511790 400191 439666 549823 550220 516281 714171 808496 422295 474790 444298 434044 421825 689936 628081 611332 777228 779734 743738 421859 417662 563123 428858 439763 421857 467675 519821 528847 519938 535050 557924 630630 610235 409080 513362 485057 ] |
||||||||||||||||||||||||||||||
|
3.81 ms (1.84%) |
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 263917 385427 396952 400191 404692 409080 413090 413097 414036 417662 417990 421825 421829 421857 421859 422211 422295 428822 428853 428858 433361 434044 435931 439660 439666 439763 439809 442444 443185 444298 445056 445459 445620 453452 457298 458731 460677 461371 464389 464410 464423 466049 466145 466180 467675 474776 474790 476337 477337 483496 485057 492115 493175 493185 493195 495222 495226 507884 511790 513362 515849 516281 516637 517526 518046 519821 519938 521130 521138 521140 523848 524289 525152 528347 528390 528826 528847 532056 534722 535050 549823 550219 550220 551923 557924 562990 563123 568344 589628 608415 610235 611332 628081 630630 689936 714171 715786 717797 724476 726831 736402 743738 748892 758174 761275 771742 772466 777228 777729 779734 779903 781795 796759 803437 806084 808496 810472 813922 826560 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son fuck"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин son секс"
]
|
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.