Query Metrics
7
Database Queries
7
Different statements
187.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.71 ms (88.85%) |
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 393560 523464 531355 531358 537806 546434 551519 557908 558930 564674 565297 566434 567241 574038 578909 579298 595533 598368 600198 601455 601656 603746 603938 606562 611494 614223 615171 618087 620587 621502 621995 622508 622815 622891 624027 624647 625760 625978 626100 630467 631310 632792 634287 634460 639165 639204 639653 642538 643267 644398 645749 647192 648699 651002 652533 653620 653914 654272 656244 661444 668342 680522 680825 691148 691622 692171 693515 694573 695467 697945 706399 707450 712659 716366 717038 719457 723261 728700 730792 732632 733796 735175 737770 740703 745197 747618 757940 759347 765585 765957 767824 768171 769608 772841 775562 777335 777481 777521 778168 778786 780478 782038 785047 785463 785897 787739 790141 791277 793054 793894 795455 796896 799873 802973 811534 818016 821818 825730 826795 ] |
||||||||||||||||||||||||||||||
|
8.97 ms (4.78%) |
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 680522 688854 697945 707450 651002 652533 654272 656244 691622 706399 716366 558930 578909 579298 606562 626100 639653 598368 614223 618087 632792 595533 600198 603746 603938 611494 639204 642538 601656 615171 621502 622508 624027 631310 634287 639165 643267 785897 795455 802973 811534 777481 793054 799873 728700 730792 733796 757940 767824 772841 787739 790141 765957 735175 768171 732632 745197 759347 624647 630467 717038 775562 778168 778786 523464 565297 546434 645749 691148 719457 648699 653914 661444 680825 693515 668342 692171 564674 601455 737770 621995 777335 777521 393560 818016 821818 825730 723261 740703 765585 782038 694573 622891 826795 647192 695467 567241 622815 625978 747618 712659 793894 785463 769608 780478 625760 557908 653620 634460 620587 644398 785047 791277 796896 531358 531355 537806 551519 566434 574038 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.61%) |
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 393560 523464 531355 531358 537806 546434 551519 557908 558930 564674 565297 566434 567241 574038 578909 579298 595533 598368 600198 601455 601656 603746 603938 606562 611494 614223 615171 618087 620587 621502 621995 622508 622815 622891 624027 624647 625760 625978 626100 630467 631310 632792 634287 634460 639165 639204 639653 642538 643267 644398 645749 647192 648699 651002 652533 653620 653914 654272 656244 661444 668342 680522 680825 691148 691622 692171 693515 694573 695467 697945 706399 707450 712659 716366 717038 719457 723261 728700 730792 732632 733796 735175 737770 740703 745197 747618 757940 759347 765585 765957 767824 768171 769608 772841 775562 777335 777481 777521 778168 778786 780478 782038 785047 785463 785897 787739 790141 791277 793054 793894 795455 796896 799873 802973 811534 818016 821818 825730 826795 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teens секс"
]
|
||||||||||||||||||||||||||||||
|
2.32 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teens секс"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teens sex"
]
|
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.