Query Metrics
7
Database Queries
7
Different statements
376.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.81 ms (55.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal ffm onlyfans"
]
|
||||||||||||||||||||||||||||||
|
147.32 ms (39.14%) |
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 455156 462926 552783 554294 569232 572683 579541 585756 587110 587537 591411 592855 599433 602888 603618 604702 614565 622506 630082 631058 632175 632724 648740 653101 653956 656274 660081 670902 679261 679263 679647 680353 684482 697456 700922 701541 704677 717718 717955 720080 720278 724999 727191 727199 728321 731480 733579 738558 738589 738602 742345 742631 745497 747649 755601 759299 761195 761996 762979 764836 765458 765562 765589 765692 765713 766711 766762 766907 766963 767044 767138 767859 770708 773661 774021 776544 777585 782639 783778 784782 785594 785956 786203 786752 786761 787883 788033 789847 791092 791712 791849 793184 793363 793449 797625 798730 798773 798806 798814 799480 800785 800852 805045 805518 809300 809318 809321 813450 814434 816653 818255 821840 821850 823971 824865 825273 826804 827214 827249 ] |
||||||||||||||||||||||||||||||
|
12.54 ms (3.33%) |
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 785594 809318 455156 591411 604702 805045 767859 821850 821840 554294 653956 585756 809321 733579 747649 731480 824865 782639 770708 656274 680353 684482 787883 766907 774021 786752 766711 773661 765589 765458 738589 759299 765692 783778 791849 800785 784782 745497 798806 765562 777585 761195 809300 814434 552783 587537 603618 697456 776544 785956 799480 816653 798730 762979 798773 827249 813450 761996 759773 767044 631058 791712 755601 679647 717955 679263 700922 622506 630082 793184 764836 793449 728321 569232 579541 653101 614565 587110 818255 823971 827214 679261 720278 788033 797625 766963 738602 789847 798814 462926 826804 670902 701541 717718 660081 704677 632175 602888 592855 786203 786761 800852 767138 742345 742631 765713 724999 727199 738558 791092 805518 599433 727191 766762 793363 648740 572683 720080 632724 825273 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.52%) |
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 455156 462926 552783 554294 569232 572683 579541 585756 587110 587537 591411 592855 599433 602888 603618 604702 614565 622506 630082 631058 632175 632724 648740 653101 653956 656274 660081 670902 679261 679263 679647 680353 684482 697456 700922 701541 704677 717718 717955 720080 720278 724999 727191 727199 728321 731480 733579 738558 738589 738602 742345 742631 745497 747649 755601 759299 761195 761996 762979 764836 765458 765562 765589 765692 765713 766711 766762 766907 766963 767044 767138 767859 770708 773661 774021 776544 777585 782639 783778 784782 785594 785956 786203 786752 786761 787883 788033 789847 791092 791712 791849 793184 793363 793449 797625 798730 798773 798806 798814 799480 800785 800852 805045 805518 809300 809318 809321 813450 814434 816653 818255 821840 821850 823971 824865 825273 826804 827214 827249 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал жмж секс втро онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.38%) |
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.