Query Metrics
7
Database Queries
7
Different statements
213.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.65 ms (89.70%) |
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 58516 278472 326189 388005 391315 402381 411304 413560 426631 486002 500035 500252 518508 522177 530459 539169 540895 550911 566775 581555 586608 590412 592566 600842 601249 604659 608706 613642 615506 617215 617972 618304 618367 619668 619979 620957 626069 630941 632929 632954 638038 638052 640868 642547 652212 661051 661554 667140 667471 673426 686816 688172 694362 701611 712572 716149 718971 721934 725181 725760 729441 729564 731539 732622 734542 738451 738510 739150 739487 739922 740218 743403 745329 746442 747033 748908 749151 749593 751318 751426 751486 752411 752453 753422 755608 755958 758413 762007 762475 764597 772789 777935 778184 780232 782690 783038 785714 786929 787724 787727 787821 788628 789922 792608 795591 796515 796531 796536 798870 798926 798971 798977 798978 798980 799005 803212 804277 818746 818777 827194 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (6.17%) |
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 798980 777935 796515 725181 746442 751486 799005 738451 739150 751426 753422 762007 762475 772789 738510 740218 755958 764597 729564 734542 748908 749151 752453 725760 731539 732622 743403 749593 751318 613642 630941 632929 632954 638052 718971 721934 778184 780232 787727 787821 796531 798926 798977 391315 402381 278472 326189 58516 388005 411304 413560 426631 827194 818746 818777 530459 500252 518508 539169 500035 522177 486002 550911 566775 540895 581555 661051 661554 667140 667471 686816 712572 652212 673426 694362 688172 701611 716149 608706 615506 617972 619979 640868 618367 620957 642547 590412 592566 601249 617215 619668 638038 586608 600842 604659 618304 626069 782690 785714 798971 798978 795591 796536 798870 729441 739487 747033 752411 755608 783038 786929 787724 788628 789922 792608 803212 804277 739922 745329 758413 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.11%) |
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 58516 278472 326189 388005 391315 402381 411304 413560 426631 486002 500035 500252 518508 522177 530459 539169 540895 550911 566775 581555 586608 590412 592566 600842 601249 604659 608706 613642 615506 617215 617972 618304 618367 619668 619979 620957 626069 630941 632929 632954 638038 638052 640868 642547 652212 661051 661554 667140 667471 673426 686816 688172 694362 701611 712572 716149 718971 721934 725181 725760 729441 729564 731539 732622 734542 738451 738510 739150 739487 739922 740218 743403 745329 746442 747033 748908 749151 749593 751318 751426 751486 752411 752453 753422 755608 755958 758413 762007 762475 764597 772789 777935 778184 780232 782690 783038 785714 786929 787724 787727 787821 788628 789922 792608 795591 796515 796531 796536 798870 798926 798971 798977 798978 798980 799005 803212 804277 818746 818777 827194 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"машин"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"машин"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.65%) |
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.