Query Metrics
7
Database Queries
7
Different statements
146.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.26 ms (83.64%) |
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 182036 400802 413008 415874 429892 432683 434361 434903 435136 443432 446251 448008 449930 451044 459028 467588 467875 468148 475426 477496 485472 495765 500288 507243 511053 513220 513223 522579 523058 536914 547470 562578 569345 578731 584046 584362 586876 588169 589166 601460 602281 607683 613690 617577 619570 622720 626082 634750 640242 659057 666974 667045 680754 696584 697543 700042 704072 708546 713186 715797 715802 716001 726066 730461 730781 738461 738501 739126 739146 739158 739802 739821 739827 740169 744021 744795 746177 751044 753120 756694 756776 756841 757483 758322 760598 767267 772230 772654 774883 776032 777761 777982 778105 778498 778695 779720 779765 782052 785979 785982 788528 791129 791600 792700 796872 797773 798243 798291 801627 803134 803543 803880 806822 807050 808036 811690 811705 817575 824771 ] |
||||||||||||||||||||||||||||||
|
13.45 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 607683 634750 588169 617577 619570 774883 778105 779765 801627 778695 738501 760598 797773 726066 739146 751044 772654 730781 739126 753120 738461 739158 739821 756694 767267 772230 739802 602281 777761 782052 785979 791600 796872 803880 182036 511053 477496 434361 435136 443432 468148 451044 513220 485472 589166 798243 811690 730461 626082 798291 446251 467588 467875 429892 715802 713186 432683 434903 413008 562578 659057 666974 704072 696584 716001 680754 697543 700042 578731 640242 601460 613690 778498 788528 791129 811705 776032 785982 808036 756841 758322 803543 807050 807147 746177 756776 744021 744795 739827 757483 622720 715797 779720 792700 803134 806822 459028 500288 415874 824771 817575 708546 740169 777982 400802 475426 448008 449930 495765 522579 536914 507243 513223 523058 569345 584046 547470 584362 667045 586876 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.76%) |
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 182036 400802 413008 415874 429892 432683 434361 434903 435136 443432 446251 448008 449930 451044 459028 467588 467875 468148 475426 477496 485472 495765 500288 507243 511053 513220 513223 522579 523058 536914 547470 562578 569345 578731 584046 584362 586876 588169 589166 601460 602281 607683 613690 617577 619570 622720 626082 634750 640242 659057 666974 667045 680754 696584 697543 700042 704072 708546 713186 715797 715802 716001 726066 730461 730781 738461 738501 739126 739146 739158 739802 739821 739827 740169 744021 744795 746177 751044 753120 756694 756776 756841 757483 758322 760598 767267 772230 772654 774883 776032 777761 777982 778105 778498 778695 779720 779765 782052 785979 785982 788528 791129 791600 792700 796872 797773 798243 798291 801627 803134 803543 803880 806822 807050 808036 811690 811705 817575 824771 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy dildo"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy дилд"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"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.