Query Metrics
7
Database Queries
7
Different statements
397.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
371.61 ms (93.57%) |
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 25721 41050 114313 136203 181994 188450 193761 213017 213113 213396 213819 265933 270290 383590 385595 385880 387279 387477 387753 388568 391166 394420 398499 398684 400599 402941 416305 423774 426125 432387 432390 432480 432502 432508 432519 432528 432537 432559 432576 432595 433450 433455 433487 433620 433716 433855 436075 439571 445007 450682 453397 453435 464880 470898 475954 480563 482078 483663 484183 507341 508230 510856 514449 519742 519892 520924 530436 533459 536440 540746 547813 547828 555189 555705 563632 583182 584469 584483 588373 592552 595145 608288 608905 616199 636429 641531 644623 663716 672880 677357 680242 687382 689693 692767 700831 705152 728225 732408 754783 757805 758323 758510 758695 765892 767699 769017 770099 771392 782418 788425 788867 804567 804936 811114 811925 812505 812506 814435 825920 828567 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (3.68%) |
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 812506 732408 758323 782418 41050 114313 520924 432387 398499 432537 193761 530436 265933 432390 583182 584469 672880 687382 644623 758695 754783 387753 402941 758510 482078 391166 728225 453397 825920 811114 213017 445007 416305 547813 608905 398684 432528 423774 470898 433455 385880 663716 700831 608288 616199 592552 387477 400599 767699 188450 510856 213819 181994 555189 705152 788425 771392 769017 436075 432502 439571 383590 270290 433450 814435 453435 536440 540746 464880 689693 547828 584483 595145 636429 804567 433620 475954 480563 394420 432576 432595 432519 426125 433855 508230 483663 514449 136203 533459 677357 680242 692767 555705 432508 433716 519742 484183 432480 25721 387279 433487 450682 519892 563632 641531 588373 788867 388568 385595 507341 828567 812505 770099 811925 804936 765892 213113 432559 213396 757805 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (0.85%) |
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 25721 41050 114313 136203 181994 188450 193761 213017 213113 213396 213819 265933 270290 383590 385595 385880 387279 387477 387753 388568 391166 394420 398499 398684 400599 402941 416305 423774 426125 432387 432390 432480 432502 432508 432519 432528 432537 432559 432576 432595 433450 433455 433487 433620 433716 433855 436075 439571 445007 450682 453397 453435 464880 470898 475954 480563 482078 483663 484183 507341 508230 510856 514449 519742 519892 520924 530436 533459 536440 540746 547813 547828 555189 555705 563632 583182 584469 584483 588373 592552 595145 608288 608905 616199 636429 641531 644623 663716 672880 677357 680242 687382 689693 692767 700831 705152 728225 732408 754783 757805 758323 758510 758695 765892 767699 769017 770099 771392 782418 788425 788867 804567 804936 811114 811925 812505 812506 814435 825920 828567 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass - tights"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп колготк"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп колготк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.42%) |
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.