Query Metrics
7
Database Queries
7
Different statements
174.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.76 ms (87.50%) |
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 79570 391102 400653 402887 402941 418425 420824 423148 423155 426011 426624 427425 434470 435833 436938 441815 443958 450155 452719 455597 457079 457093 457309 463807 469333 470489 472095 480561 486230 536989 539263 542444 542509 561809 568462 574096 580748 585176 588284 588472 598300 599176 607253 621099 624295 626798 630707 641171 653330 666418 667972 675628 677128 677581 682359 682857 685805 697588 705804 717914 718026 718478 724728 725425 726173 726933 728619 728660 730404 736850 738335 742761 744490 752505 753726 758737 759400 760844 761257 761415 763298 763378 764319 765953 766057 769422 769610 772292 775662 777526 777531 777814 778420 778832 779437 779686 780676 783080 784388 784667 784880 787236 787429 787754 790398 791247 791250 791969 795575 796264 797394 807663 808203 809168 810201 810344 813304 814582 825018 826555 ] |
||||||||||||||||||||||||||||||
|
13.05 ms (7.48%) |
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 826555 718026 778832 784880 810201 779686 772292 787236 808203 463807 775662 736850 677128 682857 697588 607253 667972 761415 760844 685805 726173 79570 626798 752505 457093 599176 391102 539263 790398 791969 796264 810344 769610 724728 728660 418425 717914 728619 766057 787429 436938 598300 780676 778420 675628 435833 759400 457309 423148 470489 434470 777531 726933 480561 744490 763298 779437 426624 682359 705804 588472 630707 791247 585176 795575 761257 561809 783080 777526 621099 457079 814582 588284 624295 400653 536989 725425 420824 574096 653330 763378 402941 486230 568462 718478 784388 753726 765953 825018 450155 738335 426011 427425 730404 472095 469333 455597 807663 452719 580748 784667 797394 764319 758737 777814 441815 791250 666418 443958 542444 769422 742761 813304 542509 787754 677581 641171 809168 402887 423155 ] |
||||||||||||||||||||||||||||||
|
2.83 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 79570 391102 400653 402887 402941 418425 420824 423148 423155 426011 426624 427425 434470 435833 436938 441815 443958 450155 452719 455597 457079 457093 457309 463807 469333 470489 472095 480561 486230 536989 539263 542444 542509 561809 568462 574096 580748 585176 588284 588472 598300 599176 607253 621099 624295 626798 630707 641171 653330 666418 667972 675628 677128 677581 682359 682857 685805 697588 705804 717914 718026 718478 724728 725425 726173 726933 728619 728660 730404 736850 738335 742761 744490 752505 753726 758737 759400 760844 761257 761415 763298 763378 764319 765953 766057 769422 769610 772292 775662 777526 777531 777814 778420 778832 779437 779686 780676 783080 784388 784667 784880 787236 787429 787754 790398 791247 791250 791969 795575 796264 797394 807663 808203 809168 810201 810344 813304 814582 825018 826555 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade blowjob swallow"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск минет оральн секс глота"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.