Query Metrics
7
Database Queries
7
Different statements
190.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.05 ms (79.27%) |
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 191474 233486 385010 390775 397083 401388 403725 410229 410660 413161 414662 417823 421345 423148 424486 425643 427898 428516 429416 430278 432696 432731 437006 437044 439655 443144 445709 446011 455322 457190 462271 464260 476814 480518 483146 483205 488130 490098 494068 498075 501518 503241 506080 510029 512421 513530 514936 516945 518077 518484 521226 522968 523663 535698 537550 539463 542500 542541 544747 544893 545292 547733 547800 549292 559704 567110 568310 569166 573312 575942 583022 585731 589414 593112 610112 615709 620057 625150 629940 631870 669196 669867 671901 683158 695367 695415 705424 721707 725231 725442 725514 729826 729829 730965 735948 738276 738851 754300 759768 760079 771650 777522 778986 786545 789144 794128 799091 800063 801480 801963 803355 803887 811029 812114 814288 814828 816783 824169 824758 828455 ] |
||||||||||||||||||||||||||||||
|
29.82 ms (15.65%) |
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 735948 439655 480518 385010 233486 430278 437006 814288 510029 512421 483205 593112 760079 778986 799091 423148 476814 513530 824758 390775 428516 414662 814828 535698 445709 539463 494068 516945 514936 583022 542500 544747 544893 568310 585731 625150 811029 725231 725442 801963 730965 759768 771650 410660 429416 403725 547733 620057 671901 432696 410229 518484 521226 501518 462271 483146 559704 567110 683158 569166 615709 729826 725514 629940 424486 432731 464260 537550 786545 397083 488130 573312 695367 669867 721707 425643 413161 523663 503241 518077 545292 547800 610112 729829 446011 455322 427898 669196 803887 777522 801480 816783 794128 421345 417823 490098 522968 542541 705424 437044 498075 575942 812114 191474 401388 443144 695415 589414 631870 738276 800063 506080 824169 828455 457190 549292 803355 789144 738851 754300 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.54%) |
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 191474 233486 385010 390775 397083 401388 403725 410229 410660 413161 414662 417823 421345 423148 424486 425643 427898 428516 429416 430278 432696 432731 437006 437044 439655 443144 445709 446011 455322 457190 462271 464260 476814 480518 483146 483205 488130 490098 494068 498075 501518 503241 506080 510029 512421 513530 514936 516945 518077 518484 521226 522968 523663 535698 537550 539463 542500 542541 544747 544893 545292 547733 547800 549292 559704 567110 568310 569166 573312 575942 583022 585731 589414 593112 610112 615709 620057 625150 629940 631870 669196 669867 671901 683158 695367 695415 705424 721707 725231 725442 725514 729826 729829 730965 735948 738276 738851 754300 759768 760079 771650 777522 778986 786545 789144 794128 799091 800063 801480 801963 803355 803887 811029 812114 814288 814828 816783 824169 824758 828455 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gorgeous milf"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"шикарная milf"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шикарная milf"
]
|
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.