Query Metrics
7
Database Queries
7
Different statements
188.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.22 ms (83.76%) |
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 339285 441802 460365 531374 533226 544722 549401 555735 585940 588893 602494 603326 604900 619620 629573 629957 636482 636500 638174 639871 642536 648741 649107 652529 660779 662401 665952 670214 670407 682820 693795 697177 701773 706554 712418 712426 714065 715449 717117 717155 718356 724458 724567 725239 726123 728810 728893 728953 730679 731186 732184 733448 734071 734089 734491 734657 739912 741319 741789 744564 747680 748445 749448 751266 752511 755041 757134 757605 763095 763474 764570 766105 766483 767734 769179 769182 769223 778810 779645 781106 781145 781488 781546 782674 787083 790949 791478 794519 794577 795975 796755 797258 797286 800263 801424 801478 801501 802265 802268 802309 803922 804662 808514 812140 813308 813995 819313 823862 824080 824093 824799 825892 826224 826378 826677 826683 828179 828517 828790 ] |
||||||||||||||||||||||||||||||
|
20.33 ms (10.77%) |
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 824080 828179 828790 828517 649107 697177 718356 781488 769223 732184 714065 778810 781106 794519 531374 670214 619620 636482 642536 629957 824093 824799 533226 670407 682820 701773 706554 652529 544722 549401 779645 782674 796755 749448 752511 795975 801478 744564 747680 751266 767734 730679 763095 764570 728810 733448 741319 748445 757605 791478 812140 712426 717155 724458 826683 665952 588893 790949 801424 802265 741789 766483 769182 766105 769179 734089 781145 787083 797286 441802 826378 662401 660779 603326 604900 629573 813308 804662 725239 763474 755041 726123 757134 800263 460365 712418 715449 585940 638174 734071 826224 826677 813995 819313 825892 823862 555735 717117 693795 648741 636500 639871 794577 802268 802309 781546 797258 801501 734657 767890 734491 724567 728893 731186 728953 803922 339285 602494 808514 739912 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.53%) |
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 339285 441802 460365 531374 533226 544722 549401 555735 585940 588893 602494 603326 604900 619620 629573 629957 636482 636500 638174 639871 642536 648741 649107 652529 660779 662401 665952 670214 670407 682820 693795 697177 701773 706554 712418 712426 714065 715449 717117 717155 718356 724458 724567 725239 726123 728810 728893 728953 730679 731186 732184 733448 734071 734089 734491 734657 739912 741319 741789 744564 747680 748445 749448 751266 752511 755041 757134 757605 763095 763474 764570 766105 766483 767734 769179 769182 769223 778810 779645 781106 781145 781488 781546 782674 787083 790949 791478 794519 794577 795975 796755 797258 797286 800263 801424 801478 801501 802265 802268 802309 803922 804662 808514 812140 813308 813995 819313 823862 824080 824093 824799 825892 826224 826378 826677 826683 828179 828517 828790 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot tits"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot сиськ"
]
|
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.