Query Metrics
7
Database Queries
7
Different statements
145.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.19 ms (81.37%) |
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 550857 554100 567905 574211 585272 586100 588157 589526 590831 597663 600031 600916 607487 616117 620957 621382 629711 629732 638693 639315 640081 640266 640306 640353 642158 644219 649372 652788 654978 656879 656888 657567 671194 671531 675397 678757 684487 689566 690630 693398 705349 706894 710434 713940 714205 715168 720448 729327 735535 738468 739084 739130 739791 739804 741186 743174 743208 744018 744963 745066 745101 749603 750145 751706 752592 752646 753105 756309 756779 756828 758098 760200 761191 761430 766945 767731 772242 772272 776034 777752 777760 777838 778449 778760 780151 780266 780274 780339 782047 782861 783056 783743 785960 786017 786232 786904 787469 787815 789234 791080 791380 791389 792148 796326 796673 796685 796992 796996 803367 803633 804937 806460 806657 807122 807170 807560 808969 809686 810870 813485 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (11.10%) |
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 715168 649372 656879 671531 678757 684487 693398 705349 710434 713940 652788 654978 656888 657567 671194 675397 689566 690630 706894 714205 720448 550857 554100 567905 574211 588157 589526 597663 616117 639315 642158 620957 621382 629732 640081 640266 640306 644219 585272 586100 600916 607487 629711 590831 600031 638693 640353 776034 777760 778760 780274 780339 783743 787815 792148 796326 803367 807122 777752 777838 778449 780151 780266 782861 786904 791080 791380 796673 796685 796992 796996 803633 806657 807170 808969 739791 741186 744018 751706 756828 761430 772272 782047 783056 785960 786017 786232 787469 789234 791389 804937 806460 807560 809686 810870 813485 729327 767731 738468 739130 745066 749603 756309 766945 735535 739084 739804 743208 745101 758098 760200 761191 772242 743174 744963 750145 752592 752646 753105 756779 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (2.39%) |
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 550857 554100 567905 574211 585272 586100 588157 589526 590831 597663 600031 600916 607487 616117 620957 621382 629711 629732 638693 639315 640081 640266 640306 640353 642158 644219 649372 652788 654978 656879 656888 657567 671194 671531 675397 678757 684487 689566 690630 693398 705349 706894 710434 713940 714205 715168 720448 729327 735535 738468 739084 739130 739791 739804 741186 743174 743208 744018 744963 745066 745101 749603 750145 751706 752592 752646 753105 756309 756779 756828 758098 760200 761191 761430 766945 767731 772242 772272 776034 777752 777760 777838 778449 778760 780151 780266 780274 780339 782047 782861 783056 783743 785960 786017 786232 786904 787469 787815 789234 791080 791380 791389 792148 796326 796673 796685 796992 796996 803367 803633 804937 806460 806657 807122 807170 807560 808969 809686 810870 813485 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation solo dildo"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац соло дилд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац соло дилд"
]
|
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.