Query Metrics
7
Database Queries
7
Different statements
408.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.00 ms (51.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade old young"
]
|
||||||||||||||||||||||||||||||
|
172.96 ms (42.37%) |
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 392903 396734 418649 458025 463166 466247 467320 470926 473913 486821 492649 503870 503922 509054 510758 517273 517867 522443 527513 539423 542934 544749 545420 546695 547656 565286 566505 567942 569427 569665 569675 574589 578465 593847 602390 605022 606260 615612 617358 618030 623943 624334 624664 630155 635247 640922 641006 644989 652988 665221 667242 669606 677569 677604 691205 692641 693381 693410 693433 694585 695849 701195 702137 702522 702672 704010 705462 707786 708082 708399 708405 712674 722443 724752 726082 730367 730404 739934 741998 743800 744637 746993 748684 749896 749940 754450 757200 757846 759581 761007 761171 763629 767565 771344 780628 783138 787948 789829 789879 794990 795089 804376 810316 810587 810711 810894 816747 817861 818083 820079 821861 821862 823910 825078 825492 825502 825682 826734 826911 827465 ] |
||||||||||||||||||||||||||||||
|
14.68 ms (3.60%) |
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 693433 606260 617358 724752 739934 754450 635247 787948 810587 418649 542934 593847 624664 470926 473913 503922 708082 708399 695849 780628 744637 746993 810316 730404 702672 667242 669606 692641 702137 630155 615612 641006 517867 623943 794990 458025 704010 463166 503870 486821 759581 574589 693410 730367 566505 569675 569665 527513 509054 818083 825078 644989 826734 820079 821861 823910 825682 827465 545420 547656 722443 544749 810711 810894 749940 757846 743800 763629 771344 702522 783138 789829 804376 510758 705462 741998 605022 826911 677569 567942 624334 795089 757200 767565 789879 761171 749896 396734 539423 701195 677604 565286 640922 618030 726082 761007 712674 392903 694585 467320 578465 517273 546695 652988 691205 693381 708405 707786 602390 492649 569427 748684 466247 522443 665221 825492 825502 816747 817861 821862 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (0.73%) |
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 392903 396734 418649 458025 463166 466247 467320 470926 473913 486821 492649 503870 503922 509054 510758 517273 517867 522443 527513 539423 542934 544749 545420 546695 547656 565286 566505 567942 569427 569665 569675 574589 578465 593847 602390 605022 606260 615612 617358 618030 623943 624334 624664 630155 635247 640922 641006 644989 652988 665221 667242 669606 677569 677604 691205 692641 693381 693410 693433 694585 695849 701195 702137 702522 702672 704010 705462 707786 708082 708399 708405 712674 722443 724752 726082 730367 730404 739934 741998 743800 744637 746993 748684 749896 749940 754450 757200 757846 759581 761007 761171 763629 767565 771344 780628 783138 787948 789829 789879 794990 795089 804376 810316 810587 810711 810894 816747 817861 818083 820079 821861 821862 823910 825078 825492 825502 825682 826734 826911 827465 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск old young"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск old young"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.41%) |
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.