Query Metrics
7
Database Queries
7
Different statements
176.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.80 ms (87.09%) |
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 104551 107102 145335 378272 392319 398690 400348 400573 400589 440892 442963 485822 494972 502086 514362 533430 535102 552315 554940 560889 563691 591133 592400 593466 594220 594771 601422 601821 603741 610065 612162 621730 626520 637375 642164 668579 670460 672092 672664 672919 679908 683094 683784 689540 698739 702188 702378 707412 709560 709806 710007 712638 713186 716158 716967 719095 719228 720541 720558 721282 721814 722465 775564 775591 775627 775658 777113 781091 782525 782762 783563 787669 789556 791307 792235 792253 793245 793713 794860 795585 796466 799728 800120 801512 803079 803577 803918 805255 816778 817689 817707 818197 818831 818976 819002 819207 819297 819754 819823 819957 820022 820095 823457 823539 823551 823579 824306 824803 825056 825129 825228 825991 826054 826059 826288 826561 826843 826980 827084 828228 ] |
||||||||||||||||||||||||||||||
|
11.97 ms (6.78%) |
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 716158 716967 719095 721814 775591 781091 782525 789556 801512 803079 803577 803918 805255 104551 400573 145335 107102 392319 378272 400348 400589 398690 442963 440892 817707 818976 819002 819754 823539 824803 825056 826059 826054 826561 818831 819823 819957 820022 824306 825228 826843 826980 827084 816778 819207 819297 823457 825991 817689 818197 820095 823551 823579 825129 826288 828228 485822 535102 514362 533430 494972 502086 563691 552315 554940 670460 679908 683784 702188 702378 707412 712638 713186 721282 672092 672664 689540 698739 719228 668579 672919 683094 709560 709806 710007 720541 720558 722465 560889 594771 642164 621730 637375 594220 601422 601821 603741 610065 612162 591133 592400 593466 626520 775564 775627 775658 777113 782762 783563 787669 791307 792235 792253 793245 793713 794860 795585 796466 799728 800120 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.74%) |
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 104551 107102 145335 378272 392319 398690 400348 400573 400589 440892 442963 485822 494972 502086 514362 533430 535102 552315 554940 560889 563691 591133 592400 593466 594220 594771 601422 601821 603741 610065 612162 621730 626520 637375 642164 668579 670460 672092 672664 672919 679908 683094 683784 689540 698739 702188 702378 707412 709560 709806 710007 712638 713186 716158 716967 719095 719228 720541 720558 721282 721814 722465 775564 775591 775627 775658 777113 781091 782525 782762 783563 787669 789556 791307 792235 792253 793245 793713 794860 795585 796466 799728 800120 801512 803079 803577 803918 805255 816778 817689 817707 818197 818831 818976 819002 819207 819297 819754 819823 819957 820022 820095 823457 823539 823551 823579 824306 824803 825056 825129 825228 825991 826054 826059 826288 826561 826843 826980 827084 828228 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy on pussy"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy pussy"
]
|
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.