Query Metrics
7
Database Queries
7
Different statements
171.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.30 ms (86.66%) |
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 408590 441814 461132 517671 522166 527332 529753 530932 539672 539954 540285 542039 542673 544965 546836 547592 553680 553807 556583 559790 560890 565116 565117 576193 576426 576483 579288 595963 599776 617541 617688 618278 626174 627200 627941 628686 630961 631265 637608 652958 653304 655620 657561 658719 660577 665048 669920 670318 670448 671239 679701 680278 697223 700081 700237 702988 717437 720482 722952 729315 731572 733363 734360 735798 739734 740253 740506 742225 742745 743164 743234 745059 749045 749561 750351 754153 754423 754568 759039 759697 761473 762889 767929 769093 770931 774567 774751 777877 779649 780414 782998 783168 783787 785221 785994 786069 786336 787113 788506 788658 791350 791568 792918 793477 796638 797232 797305 799822 800957 802924 803791 803798 805065 805394 807242 809920 810163 811901 812730 ] |
||||||||||||||||||||||||||||||
|
12.54 ms (7.33%) |
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 599776 626174 628686 595963 627941 617541 777877 779649 780414 785994 791568 793477 799822 774567 774751 785221 786069 796638 797232 800957 803791 803798 805394 807242 809920 812730 733363 742225 743164 749045 754153 754568 764302 767929 783787 786336 787113 788658 797305 802924 810163 811901 729315 731572 740506 749561 734360 735798 740253 742745 750351 754423 759039 770931 739734 743234 745059 762889 769093 759697 761473 617688 618278 627200 630961 631265 637608 700081 722952 782998 783168 788506 791350 792918 805065 408590 441814 461132 539672 540285 517671 522166 530932 527332 529753 539954 542039 546836 553680 553807 556583 565116 576426 576483 579288 542673 544965 565117 576193 547592 559790 560890 653304 657561 658719 660577 669920 670318 670448 680278 700237 717437 720482 652958 655620 665048 671239 679701 697223 702988 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.71%) |
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 408590 441814 461132 517671 522166 527332 529753 530932 539672 539954 540285 542039 542673 544965 546836 547592 553680 553807 556583 559790 560890 565116 565117 576193 576426 576483 579288 595963 599776 617541 617688 618278 626174 627200 627941 628686 630961 631265 637608 652958 653304 655620 657561 658719 660577 665048 669920 670318 670448 671239 679701 680278 697223 700081 700237 702988 717437 720482 722952 729315 731572 733363 734360 735798 739734 740253 740506 742225 742745 743164 743234 745059 749045 749561 750351 754153 754423 754568 759039 759697 761473 762889 767929 769093 770931 774567 774751 777877 779649 780414 782998 783168 783787 785221 785994 786069 786336 787113 788506 788658 791350 791568 792918 793477 796638 797232 797305 799822 800957 802924 803791 803798 805065 805394 807242 809920 810163 811901 812730 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"играли"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"игра"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.90%) |
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.