Query Metrics
7
Database Queries
7
Different statements
168.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.47 ms (86.74%) |
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 31602 280493 335978 382141 382480 383171 385148 387925 389346 390949 391528 396790 398911 408446 416666 420208 443406 447982 448907 465647 522166 529766 529804 530749 532392 533816 533820 536521 536523 537312 537332 543862 544965 545962 547033 548516 553429 555021 565117 565199 567542 567546 574711 575285 575897 576599 577395 578748 593206 601079 612237 618343 618409 624403 634855 634866 634868 637978 643051 645693 648111 648579 651253 658991 665374 667234 675534 680630 687206 694394 707360 714169 714176 714180 714399 715267 715268 715419 715448 720915 725518 728074 728238 729076 732247 734073 736760 737569 740172 740955 740964 742024 743784 745312 747363 751502 762565 769410 771634 774098 776244 776733 778486 781966 788049 788319 789545 792820 795260 797124 797314 800414 803063 803219 804506 805320 806312 806359 811865 812791 ] |
||||||||||||||||||||||||||||||
|
12.15 ms (7.20%) |
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 728074 715448 612237 382141 389346 536521 522166 529804 544965 565117 567542 601079 593206 789545 803063 806359 762565 725518 747363 715419 812791 465647 776244 771634 447982 745312 390949 634866 729076 545962 797124 737569 732247 416666 385148 31602 408446 795260 728238 443406 420208 448907 533820 537332 547033 548516 565199 694394 714176 714399 714169 714180 651253 707360 715267 555021 618343 624403 634855 634868 643051 778486 788049 803219 804506 811865 736760 805320 740172 769410 774098 742024 751502 788319 806312 776733 792820 734073 781966 800414 536523 383171 575285 396790 530749 533816 537312 553429 575897 574711 576599 578748 645693 648579 687206 648111 665374 675534 680630 567546 637978 740955 740964 743784 797314 387925 391528 532392 658991 715268 577395 335978 280493 382480 398911 529766 543862 720915 667234 618409 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.58%) |
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 31602 280493 335978 382141 382480 383171 385148 387925 389346 390949 391528 396790 398911 408446 416666 420208 443406 447982 448907 465647 522166 529766 529804 530749 532392 533816 533820 536521 536523 537312 537332 543862 544965 545962 547033 548516 553429 555021 565117 565199 567542 567546 574711 575285 575897 576599 577395 578748 593206 601079 612237 618343 618409 624403 634855 634866 634868 637978 643051 645693 648111 648579 651253 658991 665374 667234 675534 680630 687206 694394 707360 714169 714176 714180 714399 715267 715268 715419 715448 720915 725518 728074 728238 729076 732247 734073 736760 737569 740172 740955 740964 742024 743784 745312 747363 751502 762565 769410 771634 774098 776244 776733 778486 781966 788049 788319 789545 792820 795260 797124 797314 800414 803063 803219 804506 805320 806312 806359 811865 812791 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð┐ð¥ÐÇð¢ð¥ ð¥ð│ÐÇð¥ð╝ð¢ÐïðÁ Ðüð©ÐüÐîð║ðÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"порн огромные сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
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.