Query Metrics
7
Database Queries
7
Different statements
253.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
230.71 ms (91.04%) |
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 2332 156487 181315 384095 387324 401531 401627 401652 401794 402689 413223 442318 459730 464442 471629 505843 509881 510074 516985 529718 530470 538831 538940 542344 543184 547265 549271 551710 553841 556654 562884 562911 570788 570851 574183 583847 596488 600311 606846 614529 616117 616209 618285 628297 636883 639310 639841 641810 644656 645917 649859 671654 681002 681022 682534 688100 689606 691561 691830 693127 694485 695919 708095 712564 714586 715662 717060 719994 720939 721141 723731 726319 727436 729649 735404 740113 740842 741077 743019 745696 750074 751508 751610 752539 753251 755463 755474 756310 756394 757525 758634 759776 760668 761555 768552 769894 770885 770925 771002 771620 775605 779616 787914 789735 789984 791248 795163 795513 795973 800885 801474 802678 804478 805264 806054 808079 815902 817929 824491 828872 ] |
||||||||||||||||||||||||||||||
|
11.36 ms (4.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 538940 547265 551710 649859 693127 714586 717060 719994 553841 570851 616117 628297 636883 795513 802678 806054 791248 753251 760668 770925 771002 800885 805264 727436 750074 751610 769894 726319 740842 745696 755463 759776 740113 756310 756394 771620 618285 779616 808079 401531 402689 562884 639310 543184 689606 795163 509881 741077 770885 828872 743019 556654 715662 712564 645917 596488 815902 583847 570788 775605 752539 789735 795973 606846 817929 691561 708095 616209 600311 614529 761555 464442 505843 442318 401794 824491 529718 691830 681022 688100 681002 682534 694485 720939 644656 787914 801474 804478 768552 723731 758634 735404 2332 401652 471629 401627 459730 530470 538831 516985 542344 549271 574183 695919 671654 562911 641810 639841 789984 729649 757525 751508 755474 721141 181315 387324 413223 156487 384095 510074 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.35%) |
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 2332 156487 181315 384095 387324 401531 401627 401652 401794 402689 413223 442318 459730 464442 471629 505843 509881 510074 516985 529718 530470 538831 538940 542344 543184 547265 549271 551710 553841 556654 562884 562911 570788 570851 574183 583847 596488 600311 606846 614529 616117 616209 618285 628297 636883 639310 639841 641810 644656 645917 649859 671654 681002 681022 682534 688100 689606 691561 691830 693127 694485 695919 708095 712564 714586 715662 717060 719994 720939 721141 723731 726319 727436 729649 735404 740113 740842 741077 743019 745696 750074 751508 751610 752539 753251 755463 755474 756310 756394 757525 758634 759776 760668 761555 768552 769894 770885 770925 771002 771620 775605 779616 787914 789735 789984 791248 795163 795513 795973 800885 801474 802678 804478 805264 806054 808079 815902 817929 824491 828872 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom beauty"
]
|
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.