Query Metrics
7
Database Queries
7
Different statements
361.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.83 ms (59.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old жен секс"
]
|
||||||||||||||||||||||||||||||
|
126.11 ms (34.92%) |
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 3607 24224 382402 382724 386191 396817 397921 402093 420541 428080 429292 435289 456495 461392 494571 494682 504044 504764 505261 507263 511109 513410 538068 542934 550491 552027 554452 558779 563064 566009 569361 570131 574960 577561 577836 585583 593072 594063 594067 594767 596686 602623 611193 618187 623145 624132 625065 628219 631551 631828 644699 660845 663473 665877 668730 678711 682647 684812 684815 697462 701526 707774 712668 718498 721125 721223 721484 723744 726564 727915 727969 730370 732171 732607 733387 733588 734715 738314 738320 739739 742889 742949 744082 746710 747171 749940 752787 757996 762951 764193 768575 779199 786204 786491 789316 789976 790082 790834 790971 794154 796101 798860 800284 802016 803294 805653 808266 808833 809790 814034 816693 817688 817746 823910 824005 824152 824936 827084 827887 827889 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (3.31%) |
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 420541 494682 429292 684812 504044 817746 816693 827889 563064 668730 593072 628219 602623 594767 798860 739739 802016 808266 494571 396817 721484 566009 382402 827084 507263 577836 721125 678711 721223 631828 594067 596686 644699 631551 786204 786491 738320 747171 732171 762951 764193 611193 790834 585583 550491 3607 824936 574960 707774 742889 809790 757996 738314 625065 663473 734715 504764 817688 554452 718498 623145 594063 727915 803294 749940 618187 794154 428080 552027 660845 435289 511109 779199 789316 805653 723744 665877 382724 513410 624132 768575 456495 824152 808833 744082 727969 386191 505261 790971 402093 542934 732607 24224 397921 461392 712668 814034 824005 823910 827887 538068 577561 570131 558779 684815 682647 697462 701526 569361 790082 796101 800284 733387 746710 789976 742949 726564 730370 752787 733588 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old жен секс"
]
|
||||||||||||||||||||||||||||||
|
2.44 ms (0.68%) |
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 3607 24224 382402 382724 386191 396817 397921 402093 420541 428080 429292 435289 456495 461392 494571 494682 504044 504764 505261 507263 511109 513410 538068 542934 550491 552027 554452 558779 563064 566009 569361 570131 574960 577561 577836 585583 593072 594063 594067 594767 596686 602623 611193 618187 623145 624132 625065 628219 631551 631828 644699 660845 663473 665877 668730 678711 682647 684812 684815 697462 701526 707774 712668 718498 721125 721223 721484 723744 726564 727915 727969 730370 732171 732607 733387 733588 734715 738314 738320 739739 742889 742949 744082 746710 747171 749940 752787 757996 762951 764193 768575 779199 786204 786491 789316 789976 790082 790834 790971 794154 796101 798860 800284 802016 803294 805653 808266 808833 809790 814034 816693 817688 817746 823910 824005 824152 824936 827084 827887 827889 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old wife fuck"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.