Query Metrics
7
Database Queries
7
Different statements
398.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.98 ms (52.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video big tits"
]
|
||||||||||||||||||||||||||||||
|
163.16 ms (40.95%) |
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 88549 261891 286475 329606 382669 382877 385280 387180 412578 425573 426256 429830 444630 447834 468926 474893 485635 496661 510628 513143 519615 529812 530547 530929 532038 532273 533732 534368 535144 535859 536280 537876 538753 539611 542438 543057 545125 545628 558722 565137 565991 566016 568216 578433 604929 611530 614480 619393 621369 621615 629837 633480 635030 636556 636786 653577 655449 661701 669902 672867 676422 682841 687453 687896 692123 693040 694172 694188 694465 695204 695213 696134 696687 699274 699431 700953 709504 713285 714634 715546 715862 723087 726904 727681 736930 738376 739533 742762 746128 747426 749394 750387 751313 752275 752458 756488 765143 765146 765404 765561 768093 768101 784022 792104 792108 801713 803533 804489 809195 812328 814379 816586 820511 821039 822553 822747 823131 826405 827624 827998 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (4.02%) |
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 727681 566016 565137 655449 822553 88549 820511 821039 653577 692123 695204 723087 621615 749394 537876 611530 814379 519615 513143 545628 827998 538753 636786 792104 804489 429830 822747 529812 543057 669902 604929 535859 687896 687453 694188 629837 726904 286475 826405 816586 535144 534368 542438 699431 713285 682841 693040 619393 636556 792108 739533 768101 738376 747426 765404 752275 635030 801713 261891 578433 532273 468926 533732 714634 545125 558722 614480 803533 784022 809195 750387 742762 746128 382877 823131 672867 765561 736930 756488 696687 387180 412578 474893 532038 661701 539611 696134 715546 812328 633480 510628 827624 530547 694172 709504 765143 752458 765146 751313 768093 536280 676422 621369 382669 565991 385280 329606 485635 426256 568216 444630 425573 530929 699274 700953 447834 496661 694465 695213 715862 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (0.67%) |
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 88549 261891 286475 329606 382669 382877 385280 387180 412578 425573 426256 429830 444630 447834 468926 474893 485635 496661 510628 513143 519615 529812 530547 530929 532038 532273 533732 534368 535144 535859 536280 537876 538753 539611 542438 543057 545125 545628 558722 565137 565991 566016 568216 578433 604929 611530 614480 619393 621369 621615 629837 633480 635030 636556 636786 653577 655449 661701 669902 672867 676422 682841 687453 687896 692123 693040 694172 694188 694465 695204 695213 696134 696687 699274 699431 700953 709504 713285 714634 715546 715862 723087 726904 727681 736930 738376 739533 742762 746128 747426 749394 750387 751313 752275 752458 756488 765143 765146 765404 765561 768093 768101 784022 792104 792108 801713 803533 804489 809195 812328 814379 816586 820511 821039 822553 822747 823131 826405 827624 827998 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video большие сиськ"
]
|
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.