Query Metrics
7
Database Queries
7
Different statements
157.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.78 ms (83.81%) |
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 398968 415746 416020 417389 418697 419130 423653 429609 443903 446274 454143 455080 478542 478597 480470 492658 493679 493743 497509 497708 500787 507542 508292 511828 513629 513641 513646 513654 513697 513964 513971 515538 516140 518766 529988 531787 532369 532708 536124 542203 546121 547427 547479 547492 547499 547506 547523 547536 547807 548836 549720 549771 550367 554803 554917 554992 555020 555048 555142 555258 555360 555752 556451 556680 558173 560905 561510 563075 564176 565110 565275 566157 571015 571809 575601 583059 583712 585088 586688 587987 588202 591288 593495 593586 604562 610006 610067 612060 615693 632107 641126 647856 669062 671043 681298 687325 699625 714562 729277 735910 736249 741158 748463 749234 770149 773877 782789 784358 793534 797785 799027 800542 804208 804215 810297 816167 817262 818607 824621 827207 ] |
||||||||||||||||||||||||||||||
|
14.47 ms (9.20%) |
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 546121 565110 547492 554992 555360 555752 558173 564176 566157 671043 647856 550367 555258 556451 565275 593495 610067 591288 610006 588202 784358 748463 797785 804208 749234 735910 770149 604562 615693 799027 804215 492658 516140 493743 518766 554803 800542 736249 714562 497708 478542 549771 587987 415746 513697 515538 417389 429609 446274 493679 497509 500787 583712 548836 669062 782789 793534 507542 443903 549720 827207 729277 773877 641126 612060 571809 416020 423653 585088 455080 480470 513964 513971 478597 547427 555020 560905 561510 583059 547807 554917 547523 547536 563075 699625 681298 555048 555142 556680 586688 593586 632107 741158 810297 454143 398968 511828 513646 513629 513641 513654 529988 418697 575601 419130 816167 817262 818607 824621 536124 532369 532708 508292 531787 542203 547506 571015 547479 547499 687325 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.90%) |
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 398968 415746 416020 417389 418697 419130 423653 429609 443903 446274 454143 455080 478542 478597 480470 492658 493679 493743 497509 497708 500787 507542 508292 511828 513629 513641 513646 513654 513697 513964 513971 515538 516140 518766 529988 531787 532369 532708 536124 542203 546121 547427 547479 547492 547499 547506 547523 547536 547807 548836 549720 549771 550367 554803 554917 554992 555020 555048 555142 555258 555360 555752 556451 556680 558173 560905 561510 563075 564176 565110 565275 566157 571015 571809 575601 583059 583712 585088 586688 587987 588202 591288 593495 593586 604562 610006 610067 612060 615693 632107 641126 647856 669062 671043 681298 687325 699625 714562 729277 735910 736249 741158 748463 749234 770149 773877 782789 784358 793534 797785 799027 800542 804208 804215 810297 816167 817262 818607 824621 827207 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature ass gape"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature жоп большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
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.