Query Metrics
7
Database Queries
7
Different statements
165.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.43 ms (84.03%) |
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 154707 182895 209726 325910 328446 382793 389806 393289 396055 398824 399223 399628 403028 408586 435785 443800 447621 451882 462501 466044 468163 479026 480357 492081 503946 510890 579668 580705 586582 594283 594950 598049 598435 613246 615451 618404 623608 645938 660523 662575 670769 675370 681526 684947 697988 698372 699578 700028 701302 702173 705744 708605 709555 714002 715152 721070 724702 727811 727970 728101 728348 728428 728903 730159 731998 739529 742092 742161 743136 743658 744843 755470 757910 759670 760114 767325 769747 769863 770759 772579 773247 775615 776180 776881 778676 780041 781166 784954 786462 786791 789659 789987 790987 791213 795612 797817 799775 800344 800573 800766 800990 801081 801250 801271 801864 802453 802493 802519 802851 802884 802885 803171 804187 806693 808236 809654 810482 810527 811711 812673 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (9.20%) |
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 702173 705744 721070 645938 660523 662575 670769 675370 714002 681526 684947 697988 698372 699578 700028 579668 580705 598049 598435 613246 594950 615451 618404 623608 586582 594283 776180 780041 784954 789659 789987 791213 795612 799775 800344 801864 804187 809654 775615 786791 800573 800766 800990 801271 802453 802519 810482 810527 811711 812673 730159 739529 743136 744843 757910 772579 786462 797817 801081 802851 802884 802885 803171 806693 808236 724702 728101 728348 728903 731998 742161 755470 727811 727970 728428 769747 769863 742092 743658 759670 760114 767325 770759 773247 701302 708605 709555 715152 776881 778676 781166 790987 801250 802493 403028 408586 443800 468163 389806 451882 466044 447621 462501 480357 435785 479026 503946 492081 510890 382793 209726 154707 182895 393289 328446 325910 396055 398824 399223 399628 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.77%) |
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 154707 182895 209726 325910 328446 382793 389806 393289 396055 398824 399223 399628 403028 408586 435785 443800 447621 451882 462501 466044 468163 479026 480357 492081 503946 510890 579668 580705 586582 594283 594950 598049 598435 613246 615451 618404 623608 645938 660523 662575 670769 675370 681526 684947 697988 698372 699578 700028 701302 702173 705744 708605 709555 714002 715152 721070 724702 727811 727970 728101 728348 728428 728903 730159 731998 739529 742092 742161 743136 743658 744843 755470 757910 759670 760114 767325 769747 769863 770759 772579 773247 775615 776180 776881 778676 780041 781166 784954 786462 786791 789659 789987 790987 791213 795612 797817 799775 800344 800573 800766 800990 801081 801250 801271 801864 802453 802493 802519 802851 802884 802885 803171 804187 806693 808236 809654 810482 810527 811711 812673 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red pussy"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red pussy"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red pussy"
]
|
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.