Query Metrics
7
Database Queries
7
Different statements
190.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.95 ms (84.97%) |
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 389590 400365 406040 413288 417765 419013 424054 429941 432525 436476 436478 438979 443867 445053 445465 450383 455103 455678 457133 457506 462053 462338 463250 466362 466922 469216 469844 470238 470644 472795 473947 474033 476156 476161 477645 477794 478852 479481 491084 491104 491438 491983 494656 510649 513399 517548 522548 522682 525908 526036 533739 534124 534170 547627 548676 548703 552163 552183 552410 552843 554877 558324 558831 561718 561721 562323 563417 563570 564994 566088 567523 567877 568304 569862 570669 571591 571634 571924 572515 572523 573844 574732 579991 581558 590406 603876 609159 616699 621949 625568 630904 634804 650076 656077 678539 679058 679098 682964 692150 693145 694157 698880 699248 715397 715455 721421 721500 726734 734192 739886 750452 755101 781648 781704 782204 782287 789117 792214 804877 809342 ] |
||||||||||||||||||||||||||||||
|
18.51 ms (9.71%) |
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 804877 417765 472795 470644 558324 564994 561721 566088 570669 406040 476161 477794 413288 432525 438979 443867 445053 462053 463250 478852 479481 476156 491983 526036 491104 469216 445465 547627 656077 561718 567877 436478 466922 474033 400365 455678 477645 455103 491438 522548 457133 533739 534124 517548 568304 574732 389590 462338 436476 473947 469844 429941 450383 513399 457506 579991 534170 466362 491084 562323 558831 572523 552163 552183 552410 694157 571634 590406 603876 419013 470238 522682 510649 525908 494656 554877 571591 548676 548703 563570 567523 569862 571924 573844 581558 679058 699248 721500 650076 679098 682964 692150 715397 721421 678539 693145 715455 552843 563417 572515 621949 616699 630904 625568 634804 781704 782204 792214 726734 734192 750452 755101 782287 789117 809342 739886 609159 698880 781648 424054 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.35%) |
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 389590 400365 406040 413288 417765 419013 424054 429941 432525 436476 436478 438979 443867 445053 445465 450383 455103 455678 457133 457506 462053 462338 463250 466362 466922 469216 469844 470238 470644 472795 473947 474033 476156 476161 477645 477794 478852 479481 491084 491104 491438 491983 494656 510649 513399 517548 522548 522682 525908 526036 533739 534124 534170 547627 548676 548703 552163 552183 552410 552843 554877 558324 558831 561718 561721 562323 563417 563570 564994 566088 567523 567877 568304 569862 570669 571591 571634 571924 572515 572523 573844 574732 579991 581558 590406 603876 609159 616699 621949 625568 630904 634804 650076 656077 678539 679058 679098 682964 692150 693145 694157 698880 699248 715397 715455 721421 721500 726734 734192 739886 750452 755101 781648 781704 782204 782287 789117 792214 804877 809342 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐÇÐâÐüÐüð║ð©ðÁ ð¢ð░ÐéÐâÐÇð░ð╗Ðîð¢ÐïðÁ Ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.