Query Metrics
7
Database Queries
7
Different statements
188.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.64 ms (87.86%) |
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 55903 314850 392558 397971 451748 477746 531758 532879 540287 541920 542643 543674 543701 549550 549909 550626 552152 552568 566465 587108 596232 597056 597725 598360 616705 617126 623689 631386 635021 636224 643254 644041 644043 645447 647817 651882 664420 670414 673017 676483 677337 680485 681733 687361 687802 688937 696304 701413 702461 706761 714088 715687 716362 717674 718616 719228 723712 723848 725773 734922 736814 736818 738437 740720 748977 749845 750447 750536 753169 753178 753209 754202 754915 756138 758738 758821 758870 758939 758975 760918 762215 768327 769194 769197 773142 773707 778247 778568 779251 779323 782175 782746 782904 783884 784672 786987 788503 791793 792159 792445 792906 796265 799868 800688 801380 805213 810413 813941 817909 818414 821374 824144 825006 825312 825526 826680 826737 827164 828168 ] |
||||||||||||||||||||||||||||||
|
11.79 ms (6.25%) |
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 676483 597056 643254 805213 754202 792445 754915 773707 736818 749845 750447 762215 631386 779323 55903 826737 813941 540287 531758 532879 543674 550626 552152 543701 541920 670414 687361 651882 706761 719228 677337 680485 688937 696304 549550 597725 596232 623689 587108 616705 598360 792159 799868 778247 782746 792906 796265 756138 758738 782904 784672 723848 734922 750536 758821 758975 738437 644041 644043 702461 715687 810413 397971 451748 314850 817909 821374 825006 826137 826680 825526 827164 818414 825312 828168 824144 566465 542643 552568 647817 673017 687802 714088 645447 701413 716362 718616 664420 681733 549909 617126 635021 636224 788503 801380 779251 783884 723712 748977 753169 753178 753209 758939 768327 800688 740720 758870 769194 769197 760918 773142 725773 717674 778568 782175 786987 791793 477746 736814 392558 ] |
||||||||||||||||||||||||||||||
|
3.59 ms (1.91%) |
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 55903 314850 392558 397971 451748 477746 531758 532879 540287 541920 542643 543674 543701 549550 549909 550626 552152 552568 566465 587108 596232 597056 597725 598360 616705 617126 623689 631386 635021 636224 643254 644041 644043 645447 647817 651882 664420 670414 673017 676483 677337 680485 681733 687361 687802 688937 696304 701413 702461 706761 714088 715687 716362 717674 718616 719228 723712 723848 725773 734922 736814 736818 738437 740720 748977 749845 750447 750536 753169 753178 753209 754202 754915 756138 758738 758821 758870 758939 758975 760918 762215 768327 769194 769197 773142 773707 778247 778568 779251 779323 782175 782746 782904 783884 784672 786987 788503 791793 792159 792445 792906 796265 799868 800688 801380 805213 810413 813941 817909 818414 821374 824144 825006 825312 825526 826680 826737 827164 828168 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl hot"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк hot"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк hot"
]
|
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.