Query Metrics
7
Database Queries
7
Different statements
152.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.18 ms (80.06%) |
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 197736 203645 233102 385632 388318 390830 391520 391669 395898 397908 397923 400807 400808 401003 411322 411329 411332 411908 419523 419524 429570 439591 439658 439717 439729 439786 440601 442545 443741 443743 443953 444100 451470 454211 454555 457417 459837 460736 460756 462279 462695 465338 465341 466251 466321 467626 469885 470201 470286 472148 476267 477723 478018 479026 479088 479110 479149 483405 484696 485444 490413 490934 506056 506247 509485 509488 509918 512425 520886 521129 526002 526747 529246 546928 546929 549758 552325 560430 562976 563180 563223 563413 566303 580640 589022 590449 591430 609157 609188 620241 620265 696321 709528 721413 731137 739927 741468 742389 742585 744890 747949 765889 781659 781666 781679 781692 781694 781757 782213 782284 794698 794699 796252 802195 816609 818924 820228 820280 823847 ] |
||||||||||||||||||||||||||||||
|
20.10 ms (13.17%) |
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 391669 411329 454211 454555 476267 439717 465338 465341 509485 509918 512425 526002 529246 521129 506247 490413 490934 479088 479110 552325 562976 566303 546928 549758 580640 546929 563180 203645 390830 395898 411908 451470 459837 233102 401003 391520 397908 439729 478018 479026 526747 485444 483405 563413 560430 439658 470201 820228 820280 816609 823847 818924 827870 721413 709528 590449 620241 591430 609157 609188 589022 794699 781694 781757 782213 782284 794698 796252 731137 741468 739927 742585 747949 742389 744890 765889 781659 781666 781679 781692 802195 197736 388318 385632 563223 462279 460756 469885 466321 466251 411332 506056 484696 696321 443743 443953 429570 411322 444100 509488 520886 620265 419523 419524 440601 442545 462695 397923 400807 439786 443741 457417 467626 470286 472148 477723 479149 400808 439591 460736 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.75%) |
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 197736 203645 233102 385632 388318 390830 391520 391669 395898 397908 397923 400807 400808 401003 411322 411329 411332 411908 419523 419524 429570 439591 439658 439717 439729 439786 440601 442545 443741 443743 443953 444100 451470 454211 454555 457417 459837 460736 460756 462279 462695 465338 465341 466251 466321 467626 469885 470201 470286 472148 476267 477723 478018 479026 479088 479110 479149 483405 484696 485444 490413 490934 506056 506247 509485 509488 509918 512425 520886 521129 526002 526747 529246 546928 546929 549758 552325 560430 562976 563180 563223 563413 566303 580640 589022 590449 591430 609157 609188 620241 620265 696321 709528 721413 731137 739927 741468 742389 742585 744890 747949 765889 781659 781666 781679 781692 781694 781757 782213 782284 794698 794699 796252 802195 816609 818924 820228 820280 823847 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature rus"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature русск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature русск"
]
|
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.