Query Metrics
7
Database Queries
7
Different statements
164.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.19 ms (85.84%) |
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 73293 193895 381740 383541 386725 386870 391270 396130 439812 458203 461248 464120 503745 515783 531836 533410 534209 537216 541207 541680 548415 549355 553478 564075 565148 565354 565359 565363 591803 596906 613643 618751 622376 623207 646154 656514 665872 666388 673973 676679 693870 695495 699196 700038 702943 706410 713104 716198 716796 717105 725025 725196 729209 729431 733736 736374 736606 737049 738382 740284 741961 743939 744885 747716 759480 759767 764628 766371 768394 771020 773686 774030 776089 776228 780663 781931 783197 785807 785835 787392 788240 789651 792065 793898 794102 794446 794628 800788 801201 801538 802368 805385 805768 806204 811254 811530 814410 814751 815942 817073 817381 817807 817962 818212 818487 819031 819917 821029 821367 821807 822103 822610 822677 822698 823193 823317 823608 823633 824483 826938 ] |
||||||||||||||||||||||||||||||
|
12.35 ms (7.51%) |
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 736374 736606 774030 553478 564075 565354 817073 802368 464120 776228 534209 695495 787392 733736 794102 548415 673973 737049 805768 541207 565359 822610 821029 822677 819031 821367 815942 823633 646154 665872 699196 706410 713104 676679 702943 591803 801201 794628 725196 741961 773686 789651 73293 824483 439812 386725 503745 541680 716796 622376 693870 391270 533410 717105 193895 826938 814751 383541 729209 386870 822103 700038 549355 788240 805385 811254 396130 792065 806204 738382 793898 794446 565363 785807 743939 821807 537216 817381 818487 823317 817962 817807 818212 819917 823193 565148 666388 716198 623207 781931 811530 744885 771020 785835 766371 759480 764628 381740 822698 823608 515783 613643 776089 780663 729431 768394 783197 801538 461248 740284 759767 814410 458203 531836 656514 596906 618751 800788 725025 747716 ] |
||||||||||||||||||||||||||||||
|
4.06 ms (2.47%) |
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 73293 193895 381740 383541 386725 386870 391270 396130 439812 458203 461248 464120 503745 515783 531836 533410 534209 537216 541207 541680 548415 549355 553478 564075 565148 565354 565359 565363 591803 596906 613643 618751 622376 623207 646154 656514 665872 666388 673973 676679 693870 695495 699196 700038 702943 706410 713104 716198 716796 717105 725025 725196 729209 729431 733736 736374 736606 737049 738382 740284 741961 743939 744885 747716 759480 759767 764628 766371 768394 771020 773686 774030 776089 776228 780663 781931 783197 785807 785835 787392 788240 789651 792065 793898 794102 794446 794628 800788 801201 801538 802368 805385 805768 806204 811254 811530 814410 814751 815942 817073 817381 817807 817962 818212 818487 819031 819917 821029 821367 821807 822103 822610 822677 822698 823193 823317 823608 823633 824483 826938 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toilet ass fuck"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.