Query Metrics
7
Database Queries
7
Different statements
208.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.65 ms (86.96%) |
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 149538 420208 456851 475655 495017 502384 509313 517703 530569 531374 532295 532392 535251 538133 538782 542259 544965 545935 546513 547094 547162 548030 548516 549503 550272 551677 552970 553426 556543 556572 563241 564490 565131 565236 566672 568128 578643 588495 589852 594067 595110 595116 604041 604989 612467 615285 616958 618678 620510 622299 624403 626248 626261 627363 628523 629757 631636 631648 632367 633460 634633 636251 636256 637250 640302 643051 644225 644543 644605 644710 645704 648005 648579 648955 650412 650503 651074 662441 663844 667365 668834 669703 670713 672807 680519 692135 693582 697625 701427 701704 702615 706202 707519 707520 707527 707886 712418 714046 717437 717644 719530 726948 731519 731968 740442 742634 742693 743778 743788 746359 747975 756864 757315 789063 796262 798732 800481 807851 816151 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (7.48%) |
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 565236 746359 731519 495017 645704 697625 707520 707527 546513 589852 620510 631636 640302 742693 149538 538782 712418 636256 538133 548030 547162 549503 553426 545935 552970 636251 648579 707886 668834 616958 531374 789063 568128 798732 743778 800481 742634 756864 542259 717437 719530 566672 757315 740442 420208 548516 547094 650503 556543 604041 634633 644225 624403 588495 643051 644543 701704 530569 544965 550272 651074 692135 702615 595116 629757 633460 618678 615285 663844 628523 475655 456851 662441 669703 680519 706202 595110 631648 607641 717644 637250 807851 670713 816151 563241 650412 517703 714046 743788 532392 532295 578643 556572 648955 731968 565131 672807 626248 626261 648005 564490 502384 535251 509313 707519 632367 796262 747975 612467 726948 551677 667365 644710 627363 594067 604989 644605 701427 693582 622299 ] |
||||||||||||||||||||||||||||||
|
4.19 ms (2.01%) |
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 149538 420208 456851 475655 495017 502384 509313 517703 530569 531374 532295 532392 535251 538133 538782 542259 544965 545935 546513 547094 547162 548030 548516 549503 550272 551677 552970 553426 556543 556572 563241 564490 565131 565236 566672 568128 578643 588495 589852 594067 595110 595116 604041 604989 612467 615285 616958 618678 620510 622299 624403 626248 626261 627363 628523 629757 631636 631648 632367 633460 634633 636251 636256 637250 640302 643051 644225 644543 644605 644710 645704 648005 648579 648955 650412 650503 651074 662441 663844 667365 668834 669703 670713 672807 680519 692135 693582 697625 701427 701704 702615 706202 707519 707520 707527 707886 712418 714046 717437 717644 719530 726948 731519 731968 740442 742634 742693 743778 743788 746359 747975 756864 757315 789063 796262 798732 800481 807851 816151 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits homemade"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.