Query Metrics
7
Database Queries
7
Different statements
164.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.03 ms (82.16%) |
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 37057 45306 120432 187723 225519 381903 383237 397062 398364 400923 407433 416969 423459 439727 462763 474724 478498 483570 523198 534748 549851 558301 565267 566791 572181 579762 586006 588898 590360 590506 594226 602283 604447 605167 605405 623608 635250 643619 647957 660467 665678 668672 674001 674216 682924 695319 695464 703970 712714 718934 720762 721444 722782 726273 727844 735029 740373 741556 742161 742729 743197 746070 747384 748715 751610 751622 751761 753446 753477 762203 762216 763798 765431 765493 765573 766637 766642 766851 769045 769747 769863 770582 772730 776281 776317 777417 778882 786014 786377 789672 789997 790859 791858 794892 797843 798986 799272 800554 800573 801175 801271 801450 803019 804013 804326 805266 809654 812351 813946 814982 815941 817009 821016 821062 823331 823333 823433 823510 824028 827257 ] |
||||||||||||||||||||||||||||||
|
18.47 ms (11.24%) |
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 674001 674216 695319 549851 635250 605167 586006 789997 803019 776317 790859 804326 812351 727844 740373 743197 753446 770582 772730 797843 746070 753477 762203 741556 751761 765573 748715 747384 763798 720762 722782 789672 791858 187723 45306 483570 565267 383237 37057 823433 824028 821062 660467 765431 762216 778882 801450 407433 120432 400923 416969 534748 668672 572181 588898 777417 800554 766642 769747 769863 462763 397062 579762 695464 766637 765493 439727 423459 813946 814982 821016 823331 827257 817009 823333 815941 478498 712714 718934 647957 721444 558301 643619 776281 786014 801175 786377 804013 805266 769045 726273 735029 751610 751622 523198 225519 381903 398364 823510 474724 566791 682924 703970 665678 602283 623608 590360 594226 590506 604447 605405 794892 799272 809654 800573 801271 742729 766851 798986 742161 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.81%) |
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 37057 45306 120432 187723 225519 381903 383237 397062 398364 400923 407433 416969 423459 439727 462763 474724 478498 483570 523198 534748 549851 558301 565267 566791 572181 579762 586006 588898 590360 590506 594226 602283 604447 605167 605405 623608 635250 643619 647957 660467 665678 668672 674001 674216 682924 695319 695464 703970 712714 718934 720762 721444 722782 726273 727844 735029 740373 741556 742161 742729 743197 746070 747384 748715 751610 751622 751761 753446 753477 762203 762216 763798 765431 765493 765573 766637 766642 766851 769045 769747 769863 770582 772730 776281 776317 777417 778882 786014 786377 789672 789997 790859 791858 794892 797843 798986 799272 800554 800573 801175 801271 801450 803019 804013 804326 805266 809654 812351 813946 814982 815941 817009 821016 821062 823331 823333 823433 823510 824028 827257 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red anal"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red анал"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red анал"
]
|
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.