Query Metrics
7
Database Queries
7
Different statements
215.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.65 ms (88.06%) |
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 91570 391133 392415 396041 396482 398389 399043 399652 402122 403477 403759 407322 407681 408912 410452 420143 420146 428810 430560 432737 438959 445553 445955 446329 451849 452745 453323 453325 454403 458104 463726 464006 467997 468956 469105 475329 485066 486690 492065 509110 518055 521841 528721 529230 530574 541270 545835 550065 565909 569199 573301 574439 575833 576772 584066 591809 593389 610701 618565 622061 634873 635184 635268 638084 671470 675633 687908 697585 702571 709723 710690 719647 748751 750691 750722 756800 758540 771243 772001 774559 797375 798361 798517 799595 800208 800492 800666 803327 809428 810222 810225 810246 810860 811513 812797 812811 812825 813074 814957 814958 817246 817940 818853 818899 820342 820576 820965 821425 821673 821972 822297 822608 822679 822700 822951 823118 823407 825377 825412 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (7.47%) |
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 635184 812811 410452 91570 822951 818853 810222 446329 821972 820576 825412 407681 485066 814957 814958 454403 509110 675633 809428 420143 463726 569199 573301 671470 591809 634873 810225 799595 812825 772001 798517 399043 403477 392415 451849 574439 709723 812797 464006 710690 610701 593389 758540 756800 797375 428810 430560 821673 822700 408912 403759 719647 687908 528721 530574 618565 445955 565909 458104 822608 820342 402122 396041 545835 575833 702571 541270 576772 638084 810246 810860 811513 750722 584066 774559 467997 407322 438959 529230 469105 622061 635268 800492 750691 521841 399652 391133 486690 775033 800666 803327 813074 771243 798361 748751 800208 452745 445553 468956 550065 817940 823118 432737 453323 475329 518055 492065 398389 817246 822679 821425 697585 396482 420146 453325 822297 825377 820965 823407 818899 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.16%) |
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 91570 391133 392415 396041 396482 398389 399043 399652 402122 403477 403759 407322 407681 408912 410452 420143 420146 428810 430560 432737 438959 445553 445955 446329 451849 452745 453323 453325 454403 458104 463726 464006 467997 468956 469105 475329 485066 486690 492065 509110 518055 521841 528721 529230 530574 541270 545835 550065 565909 569199 573301 574439 575833 576772 584066 591809 593389 610701 618565 622061 634873 635184 635268 638084 671470 675633 687908 697585 702571 709723 710690 719647 748751 750691 750722 756800 758540 771243 772001 774559 797375 798361 798517 799595 800208 800492 800666 803327 809428 810222 810225 810246 810860 811513 812797 812811 812825 813074 814957 814958 817246 817940 818853 818899 820342 820576 820965 821425 821673 821972 822297 822608 822679 822700 822951 823118 823407 825377 825412 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская жоп большие"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская жоп большие"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina ass big"
]
|
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.