Query Metrics
7
Database Queries
7
Different statements
166.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.82 ms (84.21%) |
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 123416 305824 383495 385112 399717 405426 409226 417773 428605 428917 432325 438536 441809 444400 446097 448982 451029 452648 459180 461569 464360 465924 470778 471352 475411 476916 495303 496650 497017 497074 499098 500927 502106 502738 504894 506816 511732 516245 518017 523032 526749 528522 533534 540905 541050 543392 546564 546724 555831 559484 562220 567383 573755 574404 574792 575161 575488 576113 577537 583303 597128 603560 605631 611289 614665 621980 623817 625122 628520 631901 634495 637232 639598 640152 648575 650602 652281 655097 655714 656370 656834 656868 657051 657329 658661 659714 665999 675405 687471 688100 701296 708903 718499 721125 721887 722276 723164 725579 732323 739898 741277 742022 752908 753734 757866 769776 771288 773454 774413 783140 786719 787056 792075 794005 796012 797162 797565 799749 803575 810017 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (10.08%) |
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 732323 603560 405426 441809 385112 417773 500927 516245 796012 657329 655097 528522 452648 465924 448982 502106 470778 511732 499098 540905 496650 753734 526749 409226 464360 497017 518017 567383 562220 555831 723164 675405 640152 797162 451029 476916 497074 495303 546724 575161 444400 471352 506816 752908 573755 575488 543392 428917 504894 657051 659714 399717 783140 773454 523032 658661 574792 741277 428605 621980 656868 656834 459180 461569 634495 502738 546564 623817 305824 665999 792075 574404 123416 475411 774413 687471 721125 628520 786719 799749 625122 718499 648575 655714 656370 446097 541050 721887 631901 637232 614665 797565 771288 739898 708903 576113 533534 383495 438536 583303 559484 650602 577537 605631 794005 639598 810017 611289 652281 432325 688100 722276 701296 803575 757866 769776 742022 787056 597128 725579 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.63%) |
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 123416 305824 383495 385112 399717 405426 409226 417773 428605 428917 432325 438536 441809 444400 446097 448982 451029 452648 459180 461569 464360 465924 470778 471352 475411 476916 495303 496650 497017 497074 499098 500927 502106 502738 504894 506816 511732 516245 518017 523032 526749 528522 533534 540905 541050 543392 546564 546724 555831 559484 562220 567383 573755 574404 574792 575161 575488 576113 577537 583303 597128 603560 605631 611289 614665 621980 623817 625122 628520 631901 634495 637232 639598 640152 648575 650602 652281 655097 655714 656370 656834 656868 657051 657329 658661 659714 665999 675405 687471 688100 701296 708903 718499 721125 721887 722276 723164 725579 732323 739898 741277 742022 752908 753734 757866 769776 771288 773454 774413 783140 786719 787056 792075 794005 796012 797162 797565 799749 803575 810017 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с другом парня"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"друг парен"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.88%) |
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.