Query Metrics
7
Database Queries
7
Different statements
145.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.17 ms (83.46%) |
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 478902 495407 506133 511799 514145 531889 533714 537484 544625 545900 552532 555669 558170 564301 565239 566465 585214 585467 586205 590182 590193 602431 602876 610726 613715 615414 622537 628101 628143 630797 631520 635605 647797 661473 678817 679234 679512 687051 688393 691662 698820 698879 708085 710678 716986 716995 720039 720566 722351 723973 724031 724650 726964 729293 729907 734795 737946 742986 746949 747041 756677 757300 759029 761682 761961 764103 774884 775283 775644 778203 779781 779859 787392 787681 788503 789331 789348 789422 789804 790317 793526 793602 793867 794476 794535 794707 795460 796061 796218 796884 797702 800576 801177 804075 804946 807736 808096 811838 816679 817206 817551 817643 819753 820055 820198 823856 824237 824552 824557 824736 825087 825170 825473 825764 825785 825838 826176 826788 827386 827685 ] |
||||||||||||||||||||||||||||||
|
13.17 ms (9.07%) |
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 825170 823856 824552 824557 478902 565239 566465 722351 564301 615414 602876 779859 788503 793602 794707 796061 801177 789422 804946 723973 724650 726964 747041 761961 756677 737946 610726 631520 778203 787681 811838 537484 807736 742986 746949 514145 506133 817551 824237 825087 817643 819753 820198 824736 825785 826788 827386 816679 820055 825838 826176 817206 825473 825764 827685 531889 533714 511799 495407 552532 555669 558170 544625 647797 661473 679234 679512 708085 687051 688393 691662 698879 710678 716995 720566 678817 698820 716986 720039 545900 585214 586205 590182 590193 602431 613715 628143 630797 635605 585467 622537 628101 774884 779781 787392 789804 793867 794476 794535 795460 796218 800576 804075 808096 775283 775644 789331 789348 790317 793526 796884 797702 724031 729293 729907 734795 757300 759029 761682 764103 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (2.02%) |
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 478902 495407 506133 511799 514145 531889 533714 537484 544625 545900 552532 555669 558170 564301 565239 566465 585214 585467 586205 590182 590193 602431 602876 610726 613715 615414 622537 628101 628143 630797 631520 635605 647797 661473 678817 679234 679512 687051 688393 691662 698820 698879 708085 710678 716986 716995 720039 720566 722351 723973 724031 724650 726964 729293 729907 734795 737946 742986 746949 747041 756677 757300 759029 761682 761961 764103 774884 775283 775644 778203 779781 779859 787392 787681 788503 789331 789348 789422 789804 790317 793526 793602 793867 794476 794535 794707 795460 796061 796218 796884 797702 800576 801177 804075 804946 807736 808096 811838 816679 817206 817551 817643 819753 820055 820198 823856 824237 824552 824557 824736 825087 825170 825473 825764 825785 825838 826176 826788 827386 827685 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard wife"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard жен"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard жен"
]
|
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.