Query Metrics
7
Database Queries
7
Different statements
165.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.29 ms (84.18%) |
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 427486 428486 429455 434888 437861 440691 441882 444048 444930 445905 446612 450540 451791 452916 453515 461221 461688 462863 463468 463514 463823 464608 465142 465301 467675 470251 471620 473789 474764 479433 483495 485791 487294 488940 489214 489829 496236 496244 496285 497757 498855 499441 500057 500498 507517 507946 510902 512017 513558 514101 522998 524155 525400 526814 527359 529144 530446 538280 546882 550759 557030 560872 564122 567504 569793 574667 575406 578574 580326 580935 584490 584987 586344 587130 600982 606836 608775 609986 610652 614790 618101 624762 625279 627117 636399 642940 666709 681375 693967 710217 712264 715897 733708 744683 750792 754213 758224 761426 763777 767491 767813 772357 773725 775359 790757 793871 794717 796046 797604 801121 807734 808760 813246 815226 817307 819706 825310 827999 828704 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (9.18%) |
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 427486 434888 500057 496236 524155 525400 609986 450540 453515 428486 440691 819706 584987 461688 467675 451791 500498 530446 584490 560872 666709 693967 546882 550759 578574 618101 600982 801121 813246 750792 744683 758224 473789 437861 512017 499441 498855 489829 510902 625279 514101 444930 513558 488940 465301 445905 463823 507517 569793 580935 586344 444048 471620 470251 429455 446612 463468 527359 483495 496244 464608 487294 465142 507946 522998 574667 575406 606836 608775 463514 489214 485791 624762 529144 461221 567504 610652 580326 462863 497757 526814 452916 627117 587130 710217 681375 636399 808760 797604 538280 761426 826574 825310 557030 614790 794717 790757 772357 712264 807734 642940 793871 564122 763777 496285 441882 474764 775359 733708 817307 827999 828704 754213 796046 715897 773725 767491 767813 815226 479433 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.86%) |
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 427486 428486 429455 434888 437861 440691 441882 444048 444930 445905 446612 450540 451791 452916 453515 461221 461688 462863 463468 463514 463823 464608 465142 465301 467675 470251 471620 473789 474764 479433 483495 485791 487294 488940 489214 489829 496236 496244 496285 497757 498855 499441 500057 500498 507517 507946 510902 512017 513558 514101 522998 524155 525400 526814 527359 529144 530446 538280 546882 550759 557030 560872 564122 567504 569793 574667 575406 578574 580326 580935 584490 584987 586344 587130 600982 606836 608775 609986 610652 614790 618101 624762 625279 627117 636399 642940 666709 681375 693967 710217 712264 715897 733708 744683 750792 754213 758224 761426 763777 767491 767813 772357 773725 775359 790757 793871 794717 796046 797604 801121 807734 808760 813246 815226 817307 819706 825310 827999 828704 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"she is cum"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"she cum"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"she cum"
]
|
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.