Query Metrics
7
Database Queries
7
Different statements
175.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.40 ms (87.03%) |
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 401296 458689 503991 504726 506192 510534 512757 517346 518305 518819 519395 523061 533019 546695 546907 560363 563895 565849 565876 565882 567245 577793 587895 591158 601925 603749 617294 622319 625065 628287 664229 664272 691205 698709 698721 708072 709201 709481 709718 712228 712393 712766 713841 714565 717408 723143 724019 724901 725686 726294 728779 729115 729263 730039 732996 735592 736558 737574 738955 740241 741536 741940 744372 749365 749543 753726 755727 758185 759627 760520 761838 762220 762238 762246 763402 764020 765900 766313 768960 770589 771992 788039 788095 788613 789128 789139 789146 792048 794192 794538 795329 796199 797369 798265 798754 799558 800282 800888 800934 802371 805632 806622 809698 811159 811160 811529 811785 813957 815001 817188 817280 819871 819884 823439 823440 824636 824838 826354 827360 ] |
||||||||||||||||||||||||||||||
|
12.31 ms (7.03%) |
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 760520 625065 713841 795329 817188 824838 796199 729263 730039 770589 753726 765900 735592 736558 768960 799558 712393 732996 728779 819871 823439 824636 826354 827360 817280 506192 519395 518305 805632 798754 762246 794192 797369 741940 759627 726294 763402 792048 800282 802371 712766 714565 504726 518819 523061 503991 546907 565876 577793 560363 565849 565882 709481 563895 603749 617294 628287 567245 546695 691205 762220 819884 712228 698709 723143 789146 744372 788095 789139 737574 761838 755727 729115 764020 771992 772594 740241 749365 758185 698721 709718 800888 800934 517346 512757 587895 533019 664229 709201 401296 813957 815001 823440 717408 788039 789128 794538 798265 811529 725686 749543 788613 806622 809698 811159 811160 811785 724901 762238 724019 738955 741536 766313 458689 510534 664272 708072 601925 622319 591158 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.93%) |
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 401296 458689 503991 504726 506192 510534 512757 517346 518305 518819 519395 523061 533019 546695 546907 560363 563895 565849 565876 565882 567245 577793 587895 591158 601925 603749 617294 622319 625065 628287 664229 664272 691205 698709 698721 708072 709201 709481 709718 712228 712393 712766 713841 714565 717408 723143 724019 724901 725686 726294 728779 729115 729263 730039 732996 735592 736558 737574 738955 740241 741536 741940 744372 749365 749543 753726 755727 758185 759627 760520 761838 762220 762238 762246 763402 764020 765900 766313 768960 770589 771992 788039 788095 788613 789128 789139 789146 792048 794192 794538 795329 796199 797369 798265 798754 799558 800282 800888 800934 802371 805632 806622 809698 811159 811160 811529 811785 813957 815001 817188 817280 819871 819884 823439 823440 824636 824838 826354 827360 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepdaughter amateur"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepdaughter любительск"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepdaughter любительск"
]
|
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.