Query Metrics
7
Database Queries
7
Different statements
161.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.11 ms (78.70%) |
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 36977 247538 389976 390157 395246 395662 398038 412525 416240 418458 420385 423950 427135 432884 434083 434133 441041 444187 446936 450077 450277 454008 455640 463509 465495 466909 468157 468159 472967 478988 480788 482641 490397 492420 495376 499302 504463 509019 509430 513990 515531 515665 517539 517540 522231 523176 528223 533572 534443 535003 543678 547962 554735 558261 563374 563971 566627 566902 577105 577282 577521 580817 581428 584037 588458 589522 593042 593195 597545 598136 600936 613161 613162 616136 627009 634363 636172 650143 650524 651775 652986 661039 663293 664574 670939 672354 674231 678924 680815 697878 706705 708989 711695 727163 727322 738564 740694 743778 743996 744231 749025 751386 752477 753630 754938 757504 764731 776844 777668 784001 787275 788513 791479 803239 806468 808591 811902 816837 817871 827025 ] |
||||||||||||||||||||||||||||||
|
25.74 ms (15.94%) |
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 432884 454008 455640 465495 468157 450277 472967 478988 504463 513990 463509 580817 577105 577521 588458 613162 600936 593195 740694 627009 427135 395662 495376 509019 490397 566902 652986 581428 598136 418458 444187 420385 517539 577282 650524 664574 672354 661039 613161 593042 811902 743778 752477 636172 743996 753630 764731 395246 563374 441041 466909 528223 515665 480788 412525 389976 434083 523176 515531 534443 651775 663293 708989 650143 678924 616136 589522 806468 787275 791479 757504 706705 777668 784001 808591 423950 566627 803239 738564 247538 446936 468159 492420 517540 674231 827025 558261 509430 543678 711695 563971 634363 727322 751386 776844 788513 36977 398038 482641 522231 547962 584037 680815 597545 390157 434133 450077 499302 817871 816837 533572 535003 554735 697878 670939 744231 754938 727163 749025 416240 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.50%) |
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 36977 247538 389976 390157 395246 395662 398038 412525 416240 418458 420385 423950 427135 432884 434083 434133 441041 444187 446936 450077 450277 454008 455640 463509 465495 466909 468157 468159 472967 478988 480788 482641 490397 492420 495376 499302 504463 509019 509430 513990 515531 515665 517539 517540 522231 523176 528223 533572 534443 535003 543678 547962 554735 558261 563374 563971 566627 566902 577105 577282 577521 580817 581428 584037 588458 589522 593042 593195 597545 598136 600936 613161 613162 616136 627009 634363 636172 650143 650524 651775 652986 661039 663293 664574 670939 672354 674231 678924 680815 697878 706705 708989 711695 727163 727322 738564 740694 743778 743996 744231 749025 751386 752477 753630 754938 757504 764731 776844 777668 784001 787275 788513 791479 803239 806468 808591 811902 816837 817871 827025 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom solo girl"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван соло девушк"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.