Query Metrics
7
Database Queries
7
Different statements
196.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.37 ms (88.59%) |
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 384460 393872 398504 398514 399061 409050 410993 477620 494739 498745 520230 552218 556720 558933 560987 564941 565648 572575 584177 591279 593818 595695 613670 615642 617356 618088 618348 621532 622930 632496 638711 644613 665999 667418 675052 675729 692423 698811 702171 705321 705461 712265 714279 716593 716694 716727 716831 719592 720967 728354 730118 732741 735595 739587 740235 742246 742836 744464 744822 746972 747925 748340 749722 749757 752936 757174 760112 760787 762136 762371 763292 764058 764322 764351 764515 764632 767320 768048 768241 768723 769568 769646 772078 772889 775626 778338 780605 780609 780645 783225 784181 786156 786619 790982 792338 792564 793729 793738 793756 794810 795899 799557 802824 807532 809188 809813 810280 810394 810576 816595 818069 818183 818804 818872 819381 820721 825038 827899 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (6.23%) |
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 747925 772889 698811 780645 792564 615642 595695 794810 740235 827899 793756 775626 793729 810576 818872 818183 820721 477620 716831 799557 784181 809188 772078 792338 769568 763292 768241 716727 398504 398514 409050 825038 667418 632496 793738 768723 760112 762136 764632 749722 764351 764515 786156 393872 399061 826522 498745 494739 584177 552218 665999 716694 719592 720967 644613 810394 732741 767320 384460 818804 816595 675052 675729 705321 591279 618088 618348 795899 802824 739587 744822 810280 728354 762371 730118 748340 778338 790982 818069 819381 520230 564941 565648 712265 692423 702171 705461 556720 572575 617356 621532 597860 613670 638711 780605 757174 760787 749757 764058 742246 752936 735595 744464 764322 746972 768048 780609 809813 714279 716593 783225 769646 410993 560987 786619 742836 807532 558933 593818 622930 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.55%) |
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 384460 393872 398504 398514 399061 409050 410993 477620 494739 498745 520230 552218 556720 558933 560987 564941 565648 572575 584177 591279 593818 595695 613670 615642 617356 618088 618348 621532 622930 632496 638711 644613 665999 667418 675052 675729 692423 698811 702171 705321 705461 712265 714279 716593 716694 716727 716831 719592 720967 728354 730118 732741 735595 739587 740235 742246 742836 744464 744822 746972 747925 748340 749722 749757 752936 757174 760112 760787 762136 762371 763292 764058 764322 764351 764515 764632 767320 768048 768241 768723 769568 769646 772078 772889 775626 778338 780605 780609 780645 783225 784181 786156 786619 790982 792338 792564 793729 793738 793756 794810 795899 799557 802824 807532 809188 809813 810280 810394 810576 816595 818069 818183 818804 818872 819381 820721 825038 827899 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex rough"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс rough"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс rough"
]
|
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.