Query Metrics
7
Database Queries
7
Different statements
184.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.66 ms (85.55%) |
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 455989 464545 465839 467905 468855 470480 472131 477120 477208 477870 479970 490181 493214 497652 500056 500886 503071 505201 507222 514095 514885 519459 521079 524243 524267 524409 524488 527456 527508 528851 528889 530365 538361 545926 547450 549570 549743 550776 551924 552794 553489 556472 557463 559558 559848 560827 561253 562036 562649 562974 563612 564369 565007 565350 566360 566537 566905 567572 568166 568341 569577 569902 571391 571579 571708 572303 572851 575017 577563 578031 578065 578088 578100 579568 580393 584259 586580 586647 591552 598222 599640 601241 601503 603773 606655 609870 610995 611854 614215 615707 617647 617848 618995 623841 624002 624045 624359 629681 629947 634276 641743 642934 651192 652892 653287 655656 655730 656463 658353 659658 666436 666475 670747 672677 672975 673074 684223 687163 691224 809603 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (7.96%) |
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 528889 514095 524409 524488 528851 530365 538361 505201 514885 524243 524267 477208 547450 551924 556472 561253 562649 563612 564369 566360 566537 571708 572851 549570 559848 562974 566905 567572 568341 575017 577563 578065 559558 562036 568166 569902 578088 652892 653287 655730 666436 673074 655656 658353 670747 684223 656463 659658 672677 672975 691224 552794 565350 572303 578100 579568 580393 609870 641743 599640 601503 614215 618995 586647 598222 601241 606655 623841 624002 629947 603773 617647 617848 624045 629681 809603 468855 477870 464545 479970 465839 472131 500886 519459 500056 490181 507222 521079 455989 477120 470480 497652 503071 527508 527456 493214 571391 584259 557463 560827 569577 545926 549743 553489 565007 571579 666475 651192 687163 550776 578031 611854 615707 591552 634276 624359 586580 610995 642934 467905 ] |
||||||||||||||||||||||||||||||
|
3.94 ms (2.14%) |
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 455989 464545 465839 467905 468855 470480 472131 477120 477208 477870 479970 490181 493214 497652 500056 500886 503071 505201 507222 514095 514885 519459 521079 524243 524267 524409 524488 527456 527508 528851 528889 530365 538361 545926 547450 549570 549743 550776 551924 552794 553489 556472 557463 559558 559848 560827 561253 562036 562649 562974 563612 564369 565007 565350 566360 566537 566905 567572 568166 568341 569577 569902 571391 571579 571708 572303 572851 575017 577563 578031 578065 578088 578100 579568 580393 584259 586580 586647 591552 598222 599640 601241 601503 603773 606655 609870 610995 611854 614215 615707 617647 617848 618995 623841 624002 624045 624359 629681 629947 634276 641743 642934 651192 652892 653287 655656 655730 656463 658353 659658 666436 666475 670747 672677 672975 673074 684223 687163 691224 809603 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð│ÐÇÐÅðÀð¢ÐïðÁ ÐÇð░ðÀð│ð¥ð▓ð¥ÐÇÐï ð▓ ÐüðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"разговор в"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"разговор в"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.