Query Metrics
7
Database Queries
7
Different statements
178.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.28 ms (85.98%) |
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 381887 435934 439626 463034 466779 467325 486904 509440 510092 510727 511919 514989 527132 532573 534799 535791 536101 537140 546525 549215 554244 564122 576118 576436 579468 583273 592170 606356 615335 615414 616237 619261 631307 632055 638817 639615 645047 651737 689407 703737 703780 703784 703789 708064 710361 714597 715440 715569 720266 722083 725649 726235 726397 729853 729968 730842 737842 739009 742254 748116 754531 755199 758161 758683 760868 761330 764429 765072 768577 769238 773052 775726 782492 783141 788644 792020 793147 793526 793767 795228 795952 797214 799581 800351 800405 801435 802349 810932 816117 816704 817105 817214 818107 818115 818159 818584 819116 819205 819318 819709 823724 823866 823952 824026 824385 824511 825169 825669 825889 826391 826403 826894 827135 827348 827374 827456 827703 827731 827867 ] |
||||||||||||||||||||||||||||||
|
14.68 ms (8.23%) |
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 511919 827348 576118 435934 466779 592170 616237 739009 768577 793147 509440 819116 818107 824385 825669 825889 689407 775726 730842 715440 823724 826894 827374 827703 645047 714597 619261 527132 510092 514989 564122 632055 439626 463034 467325 742254 579468 703737 703780 546525 615414 606356 795228 755199 703784 726235 824026 826403 824511 817214 818159 825169 827135 816704 818115 818584 823952 819205 823866 827456 510727 535791 534799 720266 651737 672297 703789 708064 710361 639615 631307 792020 793767 795952 799581 782492 783141 793526 801435 810932 725649 729853 729968 758683 760868 765072 788644 800405 802349 748116 754531 758161 764429 769238 737842 761330 773052 726397 638817 722083 797214 800351 715569 615335 486904 381887 819709 827731 817105 819318 816117 826391 827867 536101 537140 532573 549215 554244 576436 583273 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.71%) |
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 381887 435934 439626 463034 466779 467325 486904 509440 510092 510727 511919 514989 527132 532573 534799 535791 536101 537140 546525 549215 554244 564122 576118 576436 579468 583273 592170 606356 615335 615414 616237 619261 631307 632055 638817 639615 645047 651737 689407 703737 703780 703784 703789 708064 710361 714597 715440 715569 720266 722083 725649 726235 726397 729853 729968 730842 737842 739009 742254 748116 754531 755199 758161 758683 760868 761330 764429 765072 768577 769238 773052 775726 782492 783141 788644 792020 793147 793526 793767 795228 795952 797214 799581 800351 800405 801435 802349 810932 816117 816704 817105 817214 818107 818115 818159 818584 819116 819205 819318 819709 823724 823866 823952 824026 824385 824511 825169 825669 825889 826391 826403 826894 827135 827348 827374 827456 827703 827731 827867 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"your wife"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"your жен"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"your жен"
]
|
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.