Query Metrics
7
Database Queries
7
Different statements
248.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
224.85 ms (90.53%) |
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 393271 398077 428570 429890 515293 529741 530394 531815 531852 537141 541793 542396 543200 543258 543546 543600 543862 543896 544131 544707 544988 545808 545878 547411 547448 547515 548391 548462 550945 551728 552019 552642 554088 555249 555769 555779 556944 557060 558010 558264 558657 559420 561520 564232 565148 565575 568545 570134 571114 571379 575862 575919 576588 577610 582494 584031 586021 588668 590314 594251 604105 614759 622160 623964 638507 645835 647957 656124 662812 663228 663337 663339 663529 665450 669655 675513 690855 693041 696108 713504 714622 715877 720195 720610 730744 745123 748371 751025 760549 771326 790025 792796 797096 801175 802715 809907 810305 813547 813820 814484 815930 817347 817964 819244 819671 819805 821033 823789 824771 825351 825454 825461 825991 826209 826244 826322 827219 827298 827377 827507 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (5.37%) |
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 565575 690855 647957 696108 693041 552642 590314 622160 638507 623964 586021 588668 801175 792796 802715 810305 730744 745123 771326 748371 760549 604105 614759 713504 714622 715877 720195 797096 531852 720610 790025 751025 809907 429890 428570 594251 393271 398077 813820 817964 819671 824771 813547 815930 817347 826209 826244 826322 827219 827298 827377 827507 814484 819244 819805 821033 823789 825991 825454 825461 825351 530394 531815 515293 529741 537141 541793 543600 543862 544131 547515 548391 548462 555769 558264 565148 570134 571379 576588 582494 542396 543200 543546 544707 545808 547411 550945 551728 552019 555249 557060 558657 561520 564232 571114 575919 584031 543258 543896 544988 545878 547448 554088 555779 556944 558010 559420 568545 575862 577610 645835 656124 662812 663228 663337 663339 663529 665450 669655 675513 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.24%) |
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 393271 398077 428570 429890 515293 529741 530394 531815 531852 537141 541793 542396 543200 543258 543546 543600 543862 543896 544131 544707 544988 545808 545878 547411 547448 547515 548391 548462 550945 551728 552019 552642 554088 555249 555769 555779 556944 557060 558010 558264 558657 559420 561520 564232 565148 565575 568545 570134 571114 571379 575862 575919 576588 577610 582494 584031 586021 588668 590314 594251 604105 614759 622160 623964 638507 645835 647957 656124 662812 663228 663337 663339 663529 665450 669655 675513 690855 693041 696108 713504 714622 715877 720195 720610 730744 745123 748371 751025 760549 771326 790025 792796 797096 801175 802715 809907 810305 813547 813820 814484 815930 817347 817964 819244 819671 819805 821033 823789 824771 825351 825454 825461 825991 826209 826244 826322 827219 827298 827377 827507 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass gape"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.