Query Metrics
7
Database Queries
7
Different statements
192.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.31 ms (86.80%) |
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 399908 418131 418132 418671 420874 421759 434382 435625 436055 436116 437369 439240 441046 446176 453216 454641 457376 457383 459563 462948 464852 465454 467923 471110 472548 487254 497720 497909 498303 500745 502447 510331 516548 527469 541802 541858 559199 564755 571350 574198 577458 579611 580379 580500 589150 595524 607692 612715 617606 619636 628610 634742 636488 641534 643380 661590 662425 662438 668623 675402 681359 697242 704687 707478 708594 708748 739827 740123 740848 744178 747432 751337 753193 756480 756776 757057 757483 762153 767351 770261 773298 776031 777287 778869 782079 782094 782855 782891 783486 783709 783927 784113 784121 784126 784127 785012 785857 786662 786687 786895 787095 787516 787771 787774 791441 793116 793127 795402 796999 797048 802255 804678 806444 806623 806714 806834 806958 813136 824769 ] |
||||||||||||||||||||||||||||||
|
14.06 ms (7.29%) |
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 399908 471110 436055 487254 467923 435625 437369 418132 457376 500745 527469 541802 668623 708594 681359 707478 708748 628610 636488 782855 786662 787095 787771 802255 804678 778869 786895 791441 740123 740848 747432 785857 797048 806444 806505 806623 806958 744178 762153 767351 756480 756776 739827 753193 757483 704687 777287 782079 783927 785012 796999 459563 472548 436116 418671 824769 453216 464852 516548 497720 574198 541858 564755 577458 661590 662425 697242 607692 617606 619636 641534 776031 787774 786687 793127 795402 757057 782891 784113 784126 784127 787516 793116 806714 770261 773298 751337 782094 783709 784121 806834 813136 434382 510331 502447 498303 571350 420874 421759 418131 439240 441046 454641 462948 446176 457383 465454 497909 559199 580379 662438 675402 579611 580500 589150 612715 634742 643380 595524 783486 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.56%) |
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 399908 418131 418132 418671 420874 421759 434382 435625 436055 436116 437369 439240 441046 446176 453216 454641 457376 457383 459563 462948 464852 465454 467923 471110 472548 487254 497720 497909 498303 500745 502447 510331 516548 527469 541802 541858 559199 564755 571350 574198 577458 579611 580379 580500 589150 595524 607692 612715 617606 619636 628610 634742 636488 641534 643380 661590 662425 662438 668623 675402 681359 697242 704687 707478 708594 708748 739827 740123 740848 744178 747432 751337 753193 756480 756776 757057 757483 762153 767351 770261 773298 776031 777287 778869 782079 782094 782855 782891 783486 783709 783927 784113 784121 784126 784127 785012 785857 786662 786687 786895 787095 787516 787771 787774 791441 793116 793127 795402 796999 797048 802255 804678 806444 806623 806714 806834 806958 813136 824769 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo creamy"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло creamy"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло creamy"
]
|
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.