Query Metrics
7
Database Queries
7
Different statements
155.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.72 ms (85.10%) |
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 421392 476539 482420 487541 489728 490490 495388 495841 500378 501118 506486 508921 510606 513811 513956 516356 518616 526140 530815 531365 533535 533770 533825 535739 537012 542402 543373 553498 553533 556579 557728 558455 559354 559632 560720 562392 563046 570930 575288 578758 602447 602597 615299 617394 619279 622872 625493 630616 631598 632537 641346 643211 653823 657864 658177 659469 660074 660650 661679 663175 664276 664623 665332 666391 668778 669319 669851 670701 671876 673908 674550 677553 679273 679564 681764 685909 688183 688252 688407 688728 689404 689571 690654 692096 692463 693984 694831 695600 696209 696521 696980 697023 699681 701214 703994 704641 704996 705177 711611 712393 713840 716313 716692 719768 730394 738131 744975 747632 752461 769069 769138 778657 778709 789076 793835 796007 813846 824070 824715 824719 ] |
||||||||||||||||||||||||||||||
|
12.26 ms (7.86%) |
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 664623 688252 688728 719768 602447 630616 752461 535739 482420 553533 542402 562392 670701 679273 688183 696521 694831 704996 657864 661679 701214 578758 602597 643211 619279 632537 796007 778657 730394 738131 769138 671876 641346 793835 744975 513811 711611 668778 673908 622872 631598 769069 516356 495388 518616 506486 500378 824715 824070 824719 537012 695600 658177 693984 716313 681764 789076 778709 747632 615299 692463 625493 712393 533770 557728 617394 421392 813846 490490 487541 489728 476539 530815 533535 526140 495841 510606 513956 531365 501118 508921 533825 543373 553498 563046 570930 558455 559632 556579 559354 560720 575288 659469 660650 664276 677553 688407 689404 696980 699681 705177 713840 653823 663175 665332 669319 669851 679564 690654 696209 703994 704641 716692 660074 666391 674550 685909 689571 692096 697023 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.88%) |
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 421392 476539 482420 487541 489728 490490 495388 495841 500378 501118 506486 508921 510606 513811 513956 516356 518616 526140 530815 531365 533535 533770 533825 535739 537012 542402 543373 553498 553533 556579 557728 558455 559354 559632 560720 562392 563046 570930 575288 578758 602447 602597 615299 617394 619279 622872 625493 630616 631598 632537 641346 643211 653823 657864 658177 659469 660074 660650 661679 663175 664276 664623 665332 666391 668778 669319 669851 670701 671876 673908 674550 677553 679273 679564 681764 685909 688183 688252 688407 688728 689404 689571 690654 692096 692463 693984 694831 695600 696209 696521 696980 697023 699681 701214 703994 704641 704996 705177 711611 712393 713840 716313 716692 719768 730394 738131 744975 747632 752461 769069 769138 778657 778709 789076 793835 796007 813846 824070 824715 824719 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"частное любительское%…"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск любительск"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.18%) |
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.