Query Metrics
7
Database Queries
7
Different statements
158.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.88 ms (80.79%) |
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 188335 203645 385359 385632 387285 388318 390898 391520 391655 391955 391964 392601 392674 397923 409346 411332 411366 411415 411757 411908 418080 419524 429570 439709 439717 439729 439786 440601 440744 442377 443428 443666 443741 443743 444104 446059 454156 454175 454179 454244 460736 460756 462279 465540 466012 466321 467233 467626 474481 474627 476258 476268 477735 478018 479026 479032 479083 479097 479149 480814 483405 484459 484607 484696 484703 484721 485444 506056 519739 526738 536433 546929 552325 562961 563180 563223 563434 563436 565724 580640 588998 590449 601951 609157 609274 619223 620241 621446 625036 678972 705358 714647 715458 721388 721392 721467 721570 731084 731088 740882 741653 744890 747949 757933 765889 781665 781666 781710 781733 781741 781757 781761 782160 782213 782284 794698 794718 802139 816609 823847 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (11.74%) |
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 478018 479026 740882 741653 731084 188335 462279 460756 506056 721392 721570 678972 714647 601951 621446 781710 731088 782160 794718 757933 721388 409346 479149 816609 590449 609157 781757 782213 388318 385632 465540 705358 802139 563434 392601 385359 391964 565724 562961 391655 418080 454156 454244 479097 454179 474481 467233 484607 526738 484696 419524 443741 460736 484703 484721 443743 563223 466321 444104 479032 391955 443428 476258 476268 439717 588998 411757 466012 392674 443666 552325 580640 546929 563180 203645 411908 391520 439729 485444 483405 479083 440601 477735 397923 439786 467626 440744 474627 411415 442377 446059 484459 715458 721467 609274 619223 781733 781761 781665 781741 625036 480814 439709 519739 536433 411366 387285 411332 454175 823847 620241 782284 794698 747949 744890 765889 781666 429570 563436 390898 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (2.63%) |
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 188335 203645 385359 385632 387285 388318 390898 391520 391655 391955 391964 392601 392674 397923 409346 411332 411366 411415 411757 411908 418080 419524 429570 439709 439717 439729 439786 440601 440744 442377 443428 443666 443741 443743 444104 446059 454156 454175 454179 454244 460736 460756 462279 465540 466012 466321 467233 467626 474481 474627 476258 476268 477735 478018 479026 479032 479083 479097 479149 480814 483405 484459 484607 484696 484703 484721 485444 506056 519739 526738 536433 546929 552325 562961 563180 563223 563434 563436 565724 580640 588998 590449 601951 609157 609274 619223 620241 621446 625036 678972 705358 714647 715458 721388 721392 721467 721570 731084 731088 740882 741653 744890 747949 757933 765889 781665 781666 781710 781733 781741 781757 781761 782160 782213 782284 794698 794718 802139 816609 823847 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature fuck russian"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
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.