Query Metrics
7
Database Queries
7
Different statements
189.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.12 ms (87.64%) |
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 398588 456276 510348 529608 548511 575627 629518 633009 634619 636475 649773 675167 689425 692433 697724 697733 701425 705746 707583 709346 710930 714745 718853 719087 721996 722117 722151 722165 723138 723216 724798 726316 726356 728711 728832 728834 728920 728936 729255 731218 731441 733096 733196 733386 735769 738222 739592 741184 741390 743364 743846 744417 747010 749913 753641 755184 756296 761546 763223 763370 763776 765117 765369 767721 768151 770026 772357 772376 773375 773378 773502 777489 777564 777817 778079 778094 778153 778753 779045 779403 779410 781553 783726 784685 787040 787230 787232 787430 787694 789755 790252 793929 795796 795975 796001 796032 796051 797208 798937 800757 800918 803692 805010 814050 817175 819332 819892 823876 824001 825218 825364 825977 826634 826907 827141 827407 827690 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (6.97%) |
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 781553 793929 795796 795975 796001 797208 800918 803692 741390 747010 753641 765117 770026 772376 726316 726356 728920 733196 733386 735769 743846 756296 728711 729255 739592 743364 765369 724798 728832 728834 728936 731218 731441 733096 741184 749913 763370 763776 767721 768151 773375 773378 773502 633009 697724 697733 709346 710930 714745 719087 721996 722117 722151 723216 777489 777564 777817 784685 787230 787232 787316 787430 790252 796032 798937 800757 456276 575627 689425 705746 649773 636475 779045 778079 778153 789755 796051 805010 738222 744417 766177 763223 772357 761546 778094 783726 787040 510348 814050 529608 675167 755184 398588 819892 825218 825364 825977 826634 824001 823876 817175 826907 827141 816149 819332 827407 827690 548511 692433 722165 701425 707583 718853 723138 629518 634619 778753 779403 779410 787694 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.64%) |
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 398588 456276 510348 529608 548511 575627 629518 633009 634619 636475 649773 675167 689425 692433 697724 697733 701425 705746 707583 709346 710930 714745 718853 719087 721996 722117 722151 722165 723138 723216 724798 726316 726356 728711 728832 728834 728920 728936 729255 731218 731441 733096 733196 733386 735769 738222 739592 741184 741390 743364 743846 744417 747010 749913 753641 755184 756296 761546 763223 763370 763776 765117 765369 767721 768151 770026 772357 772376 773375 773378 773502 777489 777564 777817 778079 778094 778153 778753 779045 779403 779410 781553 783726 784685 787040 787230 787232 787430 787694 789755 790252 793929 795796 795975 796001 796032 796051 797208 798937 800757 800918 803692 805010 814050 817175 819332 819892 823876 824001 825218 825364 825977 826634 826907 827141 827407 827690 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm in mouth"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм mouth"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм mouth"
]
|
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.