Query Metrics
7
Database Queries
7
Different statements
147.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.78 ms (82.00%) |
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 388722 394590 395284 407415 414090 415329 416561 416693 416703 416733 418121 422676 426511 428235 429859 430350 430353 435722 439135 439365 444829 447144 447158 447191 448464 449024 452791 453788 455914 462845 462922 465132 466633 466639 468946 469735 473366 475189 478437 488820 491183 497691 497697 500339 500787 501258 505798 508541 509820 511254 516320 517304 519712 520419 521829 522174 525281 526504 527409 529739 530425 530480 546129 550922 558261 560925 563939 573175 573197 574664 576932 579673 585963 590803 596649 597450 598406 601766 604404 605208 607296 609885 623193 633163 635224 642158 662856 665957 680816 686406 695875 700471 700975 705476 708465 711615 713506 713508 715797 722392 723618 738515 745101 748504 749084 750145 752712 755592 756828 762222 765684 765721 766945 770213 770405 782836 799938 800318 800538 808331 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (11.16%) |
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 770213 415329 505798 435722 447144 462922 448464 520419 573197 665957 596649 597450 430353 426511 527409 447191 407415 705476 738515 453788 546129 525281 635224 521829 416561 416703 558261 563939 604404 509820 662856 609885 723618 633163 428235 444829 452791 395284 449024 522174 808331 394590 530425 713506 642158 755592 756828 800318 766945 745101 750145 799938 447158 501258 439135 708465 598406 429859 560925 601766 623193 500339 462845 722392 388722 414090 416693 416733 455914 465132 468946 473366 478437 526504 497691 497697 466633 469735 574664 576932 700975 680816 590803 466639 519712 529739 488820 530480 695875 579673 605208 607296 782836 752712 749084 765684 715797 430350 418121 517304 770405 475189 516320 500787 550922 686406 700471 711615 713508 585963 800538 762222 765721 748504 439365 422676 491183 508541 573175 511254 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (2.04%) |
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 388722 394590 395284 407415 414090 415329 416561 416693 416703 416733 418121 422676 426511 428235 429859 430350 430353 435722 439135 439365 444829 447144 447158 447191 448464 449024 452791 453788 455914 462845 462922 465132 466633 466639 468946 469735 473366 475189 478437 488820 491183 497691 497697 500339 500787 501258 505798 508541 509820 511254 516320 517304 519712 520419 521829 522174 525281 526504 527409 529739 530425 530480 546129 550922 558261 560925 563939 573175 573197 574664 576932 579673 585963 590803 596649 597450 598406 601766 604404 605208 607296 609885 623193 633163 635224 642158 662856 665957 680816 686406 695875 700471 700975 705476 708465 711615 713506 713508 715797 722392 723618 738515 745101 748504 749084 750145 752712 755592 756828 762222 765684 765721 766945 770213 770405 782836 799938 800318 800538 808331 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal dildo fuck"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал дилд секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.06%) |
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.