Query Metrics
7
Database Queries
7
Different statements
151.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.10 ms (85.39%) |
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 427488 443359 517758 533193 546434 576992 589191 589633 610779 616464 618363 626948 631024 641870 680342 680346 718641 725020 725082 725430 726925 726978 726989 727569 727578 728779 728907 729157 730128 730482 731088 733176 734300 734604 734706 734851 735900 736419 736726 738322 738332 738356 738803 739521 742567 742592 743356 743921 745227 748063 751269 753057 753216 755172 757038 757925 757995 759088 759171 760787 760888 761023 761679 761983 762443 764850 765692 766110 767555 768110 768203 768628 769068 769196 769314 770079 770153 770564 771187 771229 771923 771941 773682 773927 775168 775618 776028 776040 776228 778457 779241 779730 781366 781758 782168 783572 785900 786156 786747 786816 787111 787458 787769 788621 791825 791827 792348 792659 792668 793939 797057 797472 799894 800798 802386 802619 810083 ] |
||||||||||||||||||||||||||||||
|
11.60 ms (7.67%) |
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 576992 589633 589191 631024 775168 775618 776228 778457 779241 779730 781758 792348 797057 799894 800798 776028 781366 782168 783572 787458 792659 793939 802619 730482 731088 734300 736419 743921 751269 753216 760787 760888 764850 769068 769196 770153 770564 771941 773927 786816 788621 792668 797472 810083 725020 725082 734706 748063 757995 759171 761679 767555 768628 771229 771923 725430 726925 726978 729157 730128 734851 736726 738332 738803 745227 753057 759088 761023 764896 766110 768110 769314 770079 771187 735900 738322 739521 755172 762443 726989 727569 727578 728907 734604 738356 742567 742592 743356 757038 761983 765692 765782 768203 773682 626948 718641 776040 785900 786156 786747 787111 787389 787769 791825 791827 802386 427488 443359 641870 616464 533193 680346 610779 618363 733176 757925 728779 517758 546434 680342 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (2.59%) |
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 427488 443359 517758 533193 546434 576992 589191 589633 610779 616464 618363 626948 631024 641870 680342 680346 718641 725020 725082 725430 726925 726978 726989 727569 727578 728779 728907 729157 730128 730482 731088 733176 734300 734604 734706 734851 735900 736419 736726 738322 738332 738356 738803 739521 742567 742592 743356 743921 745227 748063 751269 753057 753216 755172 757038 757925 757995 759088 759171 760787 760888 761023 761679 761983 762443 764850 765692 766110 767555 768110 768203 768628 769068 769196 769314 770079 770153 770564 771187 771229 771923 771941 773682 773927 775168 775618 776028 776040 776228 778457 779241 779730 781366 781758 782168 783572 785900 786156 786747 786816 787111 787458 787769 788621 791825 791827 792348 792659 792668 793939 797057 797472 799894 800798 802386 802619 810083 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home made creampie"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск creampie"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск creampie"
]
|
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.