Query Metrics
7
Database Queries
7
Different statements
159.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.66 ms (86.49%) |
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 145667 154512 323393 387753 394577 420170 456850 461683 469243 516758 517497 523146 528675 530094 530547 534569 537570 538768 539598 541579 543307 550164 557461 560884 570942 575663 579455 594872 601854 605225 606640 607316 619655 628623 629642 629825 634452 638407 638426 641252 642962 644872 649581 649904 651178 652573 662410 663893 667471 668281 672764 677749 687616 696432 700304 707884 709405 711905 715449 723108 723971 724781 724804 725417 725864 732113 733430 734071 738352 739646 744974 746329 748346 748483 749424 753028 757245 757688 758926 769995 771498 772556 776672 781133 782060 782121 786403 789048 789069 789265 789424 789669 790158 792925 792927 797335 798169 798783 799709 802735 803684 803840 804389 804596 808295 809761 811987 812232 812530 813070 814185 814377 818657 820646 821618 821748 822441 822981 823351 824179 ] |
||||||||||||||||||||||||||||||
|
13.19 ms (8.29%) |
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 789669 802735 812530 732113 758926 769995 757688 797335 323393 530547 541579 672764 789265 725417 812232 746329 749424 798783 145667 528675 629642 733430 649904 776672 771498 824179 724804 638426 154512 820646 823351 644872 821618 818657 821748 651178 638407 804596 744974 725864 723108 534569 814185 814377 517497 530094 543307 570942 709405 652573 700304 707884 641252 792927 799709 757245 629825 809761 711905 813070 461683 469243 634452 789048 792925 803684 822441 822981 516758 649581 668281 781133 739646 772556 607316 628623 687616 523146 560884 662410 667471 786403 803840 789424 790158 782060 394577 738352 420170 734071 557461 789069 539598 748483 387753 606640 696432 748346 538768 663893 723971 456850 715449 619655 753028 575663 804389 811987 550164 601854 782121 642962 537570 579455 594872 798169 808295 724781 605225 677749 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.53%) |
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 145667 154512 323393 387753 394577 420170 456850 461683 469243 516758 517497 523146 528675 530094 530547 534569 537570 538768 539598 541579 543307 550164 557461 560884 570942 575663 579455 594872 601854 605225 606640 607316 619655 628623 629642 629825 634452 638407 638426 641252 642962 644872 649581 649904 651178 652573 662410 663893 667471 668281 672764 677749 687616 696432 700304 707884 709405 711905 715449 723108 723971 724781 724804 725417 725864 732113 733430 734071 738352 739646 744974 746329 748346 748483 749424 753028 757245 757688 758926 769995 771498 772556 776672 781133 782060 782121 786403 789048 789069 789265 789424 789669 790158 792925 792927 797335 798169 798783 799709 802735 803684 803840 804389 804596 808295 809761 811987 812232 812530 813070 814185 814377 818657 820646 821618 821748 822441 822981 823351 824179 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public big tits"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.