Query Metrics
7
Database Queries
7
Different statements
355.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
323.72 ms (91.01%) |
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 156525 187223 213573 218768 311163 358757 382588 386172 388325 389011 391121 394514 397999 398967 399923 400494 400993 403381 407274 407649 408659 411376 415977 416018 416029 418697 424473 424740 425640 431321 432679 439679 439682 439732 443095 444709 445107 445936 448619 453107 453234 453305 453549 454008 454202 454533 454564 455640 458383 459157 460156 464364 465001 465352 466080 466180 466748 467109 468730 471082 474495 477991 482338 484640 484659 485311 489985 490190 491222 491700 492272 493735 494003 494649 509337 510750 512199 513503 513525 513990 517451 518486 524553 524864 526744 528671 530826 532020 533594 534253 537107 546316 555281 555395 555758 562847 566684 570934 570940 571266 571708 571785 576662 578693 614339 627338 669218 709723 715869 725206 785423 787020 807533 814428 815270 815297 815318 815853 816376 817269 ] |
||||||||||||||||||||||||||||||
|
21.51 ms (6.05%) |
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 627338 787020 725206 785423 466180 400494 398967 400993 411376 424473 439682 466748 474495 477991 439679 439732 454564 465352 466080 454202 510750 513525 518486 484640 490190 494649 492272 484659 513503 807533 388325 407649 418697 408659 416029 431321 815297 453305 465001 482338 489985 445936 532020 571266 571785 715869 669218 709723 614339 218768 425640 468730 445107 517451 386172 213573 187223 156525 394514 358757 311163 382588 389011 391121 397999 399923 403381 424740 407274 432679 444709 416018 415977 443095 814428 815318 815853 815270 817269 816376 454008 454533 455640 458383 493735 448619 453234 453549 459157 460156 467109 471082 453107 464364 485311 491222 512199 526744 524864 533594 537107 509337 530826 513990 524553 528671 534253 491700 494003 546316 555281 555395 562847 570934 570940 571708 578693 555758 566684 576662 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.00%) |
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 156525 187223 213573 218768 311163 358757 382588 386172 388325 389011 391121 394514 397999 398967 399923 400494 400993 403381 407274 407649 408659 411376 415977 416018 416029 418697 424473 424740 425640 431321 432679 439679 439682 439732 443095 444709 445107 445936 448619 453107 453234 453305 453549 454008 454202 454533 454564 455640 458383 459157 460156 464364 465001 465352 466080 466180 466748 467109 468730 471082 474495 477991 482338 484640 484659 485311 489985 490190 491222 491700 492272 493735 494003 494649 509337 510750 512199 513503 513525 513990 517451 518486 524553 524864 526744 528671 530826 532020 533594 534253 537107 546316 555281 555395 555758 562847 566684 570934 570940 571266 571708 571785 576662 578693 614339 627338 669218 709723 715869 725206 785423 787020 807533 814428 815270 815297 815318 815853 816376 817269 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature milf shower"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature milf shower"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature milf shower"
]
|
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.