Query Metrics
7
Database Queries
7
Different statements
146.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.35 ms (84.96%) |
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 32030 88031 238771 310581 324827 382236 387549 411161 416943 420321 422718 451057 463687 466308 471155 477436 494863 530970 533596 541018 545282 546384 554305 558407 561054 572255 572776 575616 583653 585741 591425 596552 603231 610158 611471 614254 635067 636372 639109 643553 643969 659191 659341 662453 662492 689762 697833 698233 699878 701976 703235 703946 706763 707264 708858 709089 710918 712224 713779 715261 716412 716456 731691 732410 736629 740520 743227 743235 751037 754804 757204 758277 758508 758728 767496 775568 777872 778730 780079 781404 782542 782718 782950 783175 783847 784853 785473 787172 791439 791920 792458 795401 796386 796390 796519 802073 802221 803140 804806 806638 809139 810398 810491 811096 812480 813712 816161 817183 819133 819703 822817 824432 824755 824854 826353 826459 827920 828357 828722 ] |
||||||||||||||||||||||||||||||
|
12.92 ms (8.83%) |
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 767496 731691 754804 758277 771930 697833 699878 703235 703946 708858 782542 784853 785473 787172 802073 810398 411161 416943 466308 477436 775568 572776 585741 471155 238771 824432 824755 826459 817183 824854 828357 827920 828722 712224 777872 732410 751037 781404 324827 662453 451057 463687 310581 382236 32030 88031 387549 420321 422718 826353 816161 819703 822817 813712 819133 530970 533596 494863 541018 558407 572255 583653 545282 659341 701976 707264 689762 709089 710918 713779 716412 659191 662492 698233 706763 715261 716456 546384 554305 561054 575616 591425 596552 614254 635067 636372 643969 603231 611471 643553 610158 639109 782718 783847 792458 796390 796519 804806 811096 812480 778730 780079 782950 783175 791439 791920 795401 796386 802221 803140 806638 809139 810491 736629 740520 743227 743235 757204 758508 758728 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.76%) |
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 32030 88031 238771 310581 324827 382236 387549 411161 416943 420321 422718 451057 463687 466308 471155 477436 494863 530970 533596 541018 545282 546384 554305 558407 561054 572255 572776 575616 583653 585741 591425 596552 603231 610158 611471 614254 635067 636372 639109 643553 643969 659191 659341 662453 662492 689762 697833 698233 699878 701976 703235 703946 706763 707264 708858 709089 710918 712224 713779 715261 716412 716456 731691 732410 736629 740520 743227 743235 751037 754804 757204 758277 758508 758728 767496 775568 777872 778730 780079 781404 782542 782718 782950 783175 783847 784853 785473 787172 791439 791920 792458 795401 796386 796390 796519 802073 802221 803140 804806 806638 809139 810398 810491 811096 812480 813712 816161 817183 819133 819703 822817 824432 824755 824854 826353 826459 827920 828357 828722 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen boy masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодой мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.94%) |
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.