Query Metrics
7
Database Queries
7
Different statements
398.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.15 ms (52.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин дилд"
]
|
||||||||||||||||||||||||||||||
|
164.33 ms (41.29%) |
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 388081 392015 395883 401546 407398 421838 423651 435563 435567 446524 452886 457216 459718 464852 468233 471121 471983 480471 483658 493740 494495 510956 511005 513649 513667 513990 515259 517317 517813 521842 522175 526193 534826 535297 537220 540808 542167 542181 545455 545905 553684 553749 554980 555042 555777 556871 558098 559781 563015 571359 575973 576527 576772 576981 578786 584195 588320 588895 590713 591669 604698 608669 613679 622066 623277 628690 632123 641554 650598 667981 670340 671479 674522 687441 705630 708226 709654 715802 717839 720582 720911 723294 730723 734823 734844 734868 738484 742338 744227 749298 757099 757372 765638 765669 767111 767701 777094 778683 783044 784205 785540 787466 787516 788969 789613 792137 796327 797050 799199 800232 802225 803035 804932 806815 806861 807591 814636 818944 819534 824007 ] |
||||||||||||||||||||||||||||||
|
15.57 ms (3.91%) |
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 628690 623277 608669 468233 513649 517813 435563 392015 421838 457216 824007 446524 521842 515259 650598 622066 787466 388081 435567 483658 493740 555042 670340 717839 720911 395883 540808 818944 534826 535297 553684 553749 563015 542167 576772 542181 687441 723294 708226 578786 588320 591669 604698 783044 802225 804932 784205 730723 734844 738484 765669 744227 715802 778683 785540 797050 517317 471983 545905 554980 556871 471121 511005 494495 537220 510956 513990 558098 576981 667981 576527 584195 590713 632123 522175 777094 407398 819534 480471 575973 720582 674522 559781 588895 792137 803035 788969 800232 757372 767701 787516 742338 749298 767111 765638 757099 705630 789613 545455 513667 526193 401546 464852 571359 671479 641554 613679 806815 796327 459718 814636 555777 734823 807591 734868 799199 806861 423651 452886 709654 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (0.88%) |
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 388081 392015 395883 401546 407398 421838 423651 435563 435567 446524 452886 457216 459718 464852 468233 471121 471983 480471 483658 493740 494495 510956 511005 513649 513667 513990 515259 517317 517813 521842 522175 526193 534826 535297 537220 540808 542167 542181 545455 545905 553684 553749 554980 555042 555777 556871 558098 559781 563015 571359 575973 576527 576772 576981 578786 584195 588320 588895 590713 591669 604698 608669 613679 622066 623277 628690 632123 641554 650598 667981 670340 671479 674522 687441 705630 708226 709654 715802 717839 720582 720911 723294 730723 734823 734844 734868 738484 742338 744227 749298 757099 757372 765638 765669 767111 767701 777094 778683 783044 784205 785540 787466 787516 788969 789613 792137 796327 797050 799199 800232 802225 803035 804932 806815 806861 807591 814636 818944 819534 824007 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother dildo"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.