Query Metrics
7
Database Queries
7
Different statements
193.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.67 ms (88.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 80699 191679 229528 382947 400034 415537 415937 442037 448890 454953 524150 532103 533154 536141 537875 539215 540438 540554 542878 545662 547024 547038 548042 548472 549880 556572 556592 557513 562597 563997 567114 570824 575334 576000 578794 582852 585475 593792 607184 607436 614391 618659 618662 620522 638493 642301 644147 650431 650435 650509 664622 668544 670220 682850 696586 710538 710783 714416 718234 721868 722105 723046 725793 726135 732132 737650 744195 744342 744481 745308 748088 748355 751978 752844 753947 754640 759098 759112 759149 768734 769434 771430 774591 778568 778598 780533 784923 795277 795976 799629 801497 801712 802986 804268 805337 806361 806537 806984 811262 813602 814391 816151 817092 817195 817555 817627 817668 817694 819773 821139 823185 823522 824988 825707 825822 826219 826239 826893 826902 828145 ] |
||||||||||||||||||||||||||||||
|
11.98 ms (6.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 806537 744481 752844 759098 759112 732132 726135 753947 618662 778568 802986 229528 191679 80699 816151 824988 817555 826219 826893 814391 823185 826239 533154 539215 540438 540554 563997 567114 576000 547038 548472 547024 570824 650431 670220 710538 714416 718234 618659 644147 805337 769434 801497 806361 748355 768734 725793 759149 607184 811262 382947 400034 415537 545662 664622 771430 556572 448890 607436 668544 806984 795976 524150 562597 593792 819773 817627 821139 823522 804268 813602 817092 817195 825822 826902 817668 817694 825707 828145 532103 542878 549880 650509 682850 696586 548042 578794 642301 614391 638493 778598 780533 784923 795277 801712 737650 744195 748088 754640 744342 721868 722105 723046 799629 415937 454953 442037 536141 537875 575334 556592 557513 582852 710783 650435 585475 620522 774591 745308 751978 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural saggy tits"
]
|
||||||||||||||||||||||||||||||
|
2.54 ms (1.32%) |
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 80699 191679 229528 382947 400034 415537 415937 442037 448890 454953 524150 532103 533154 536141 537875 539215 540438 540554 542878 545662 547024 547038 548042 548472 549880 556572 556592 557513 562597 563997 567114 570824 575334 576000 578794 582852 585475 593792 607184 607436 614391 618659 618662 620522 638493 642301 644147 650431 650435 650509 664622 668544 670220 682850 696586 710538 710783 714416 718234 721868 722105 723046 725793 726135 732132 737650 744195 744342 744481 745308 748088 748355 751978 752844 753947 754640 759098 759112 759149 768734 769434 771430 774591 778568 778598 780533 784923 795277 795976 799629 801497 801712 802986 804268 805337 806361 806537 806984 811262 813602 814391 816151 817092 817195 817555 817627 817668 817694 819773 821139 823185 823522 824988 825707 825822 826219 826239 826893 826902 828145 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные saggy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные saggy сиськ"
]
|
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.