Query Metrics
7
Database Queries
7
Different statements
201.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.69 ms (88.74%) |
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 194398 385315 389675 390782 391350 392655 393881 394818 535664 541787 546294 547172 548595 551051 559208 564278 565835 590156 590504 593887 611817 617754 625743 628750 630877 631166 633908 633995 634043 639501 642110 642639 643854 648787 649548 650048 652092 660328 671490 678711 679269 681198 686752 688880 689207 690214 693618 703106 708716 709913 712062 713042 713767 714914 725767 727786 729786 730218 730221 730794 738907 738925 739016 739062 744123 748063 748671 751022 751943 752581 756461 757556 758726 758851 762136 762628 767460 768628 768834 774640 775626 777126 778630 779057 780387 781070 783637 783714 783827 784339 786200 786274 787458 789464 791448 792003 792108 792338 793135 795847 796785 799285 800133 807088 810498 810889 811055 812039 813697 818831 819191 819595 821161 821810 822227 825297 826842 826851 826941 ] |
||||||||||||||||||||||||||||||
|
12.51 ms (6.21%) |
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 778630 780387 781070 783637 783714 784339 786801 789464 807088 391350 392655 194398 385315 394818 393881 389675 390782 818831 825297 826842 826851 826941 821810 813697 819191 819595 821161 822227 535664 548595 565835 547172 541787 546294 551051 559208 564278 648787 686752 712062 713767 649548 671490 688880 690214 703106 708716 714914 650048 652092 660328 678711 679269 681198 689207 693618 709913 713042 590504 633995 634043 642110 617754 639501 642639 633908 590156 593887 611817 625743 628750 630877 631166 643854 777126 779057 783827 786274 795847 796785 812039 774640 775626 787458 792108 793135 800133 810498 727786 730221 739016 748671 751943 752581 758726 767460 786200 791448 792003 792338 799285 810889 811055 730794 738925 744123 748063 756461 757556 758851 768628 768834 729786 730218 738907 751022 762136 762628 725767 739062 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.50%) |
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 194398 385315 389675 390782 391350 392655 393881 394818 535664 541787 546294 547172 548595 551051 559208 564278 565835 590156 590504 593887 611817 617754 625743 628750 630877 631166 633908 633995 634043 639501 642110 642639 643854 648787 649548 650048 652092 660328 671490 678711 679269 681198 686752 688880 689207 690214 693618 703106 708716 709913 712062 713042 713767 714914 725767 727786 729786 730218 730221 730794 738907 738925 739016 739062 744123 748063 748671 751022 751943 752581 756461 757556 758726 758851 762136 762628 767460 768628 768834 774640 775626 777126 778630 779057 780387 781070 783637 783714 783827 784339 786200 786274 787458 789464 791448 792003 792108 792338 793135 795847 796785 799285 800133 807088 810498 810889 811055 812039 813697 818831 819191 819595 821161 821810 822227 825297 826842 826851 826941 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite xxx"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite xxx"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite xxx"
]
|
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.