Query Metrics
7
Database Queries
7
Different statements
228.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.77 ms (88.81%) |
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 6813 54088 84837 132984 190732 382503 399061 404054 435225 451498 466078 466484 496709 524476 529594 531679 533495 560912 563926 570349 572388 598770 603612 604163 624462 633748 640116 646041 647817 647991 650317 653540 659520 660534 663362 665184 667223 670204 680640 683278 696329 710453 718079 721734 722113 725582 728643 729121 730763 732247 733443 738828 743511 744769 746347 749982 752289 752418 752455 752484 753682 754605 756007 760527 768882 769197 771606 775512 776635 777430 780968 782127 783494 791054 794186 794298 794623 797309 798525 801047 801393 811094 811917 813738 814308 814354 814458 815569 817525 817633 818143 818313 818507 819148 819201 819209 819347 819437 819634 820734 823737 823858 823982 823999 824351 824653 825312 826017 826125 826258 826418 827105 828088 828345 828440 828490 828520 828588 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (6.01%) |
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 728643 823858 825995 828440 825312 826125 744769 746347 190732 819347 826258 828490 811917 603612 826017 754605 768882 797309 826523 814308 823982 813738 823999 466078 811094 733443 794186 743511 777430 404054 6813 382503 826418 819209 827105 819148 820734 828088 828520 533495 531679 653540 646041 710453 624462 749982 640116 722113 818507 828345 696329 633748 783494 598770 132984 814458 823737 819437 828588 466484 496709 683278 647991 665184 650317 663362 721734 798525 725582 780968 451498 435225 604163 680640 756007 791054 818313 824351 818143 819201 570349 647817 659520 660534 667223 730763 752418 801393 729121 769197 752289 752455 752484 753682 782127 84837 824653 801047 524476 776635 760527 738828 54088 399061 814354 815569 817633 819634 817525 529594 563926 572388 670204 718079 560912 775512 794623 794298 771606 732247 ] |
||||||||||||||||||||||||||||||
|
4.12 ms (1.80%) |
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 6813 54088 84837 132984 190732 382503 399061 404054 435225 451498 466078 466484 496709 524476 529594 531679 533495 560912 563926 570349 572388 598770 603612 604163 624462 633748 640116 646041 647817 647991 650317 653540 659520 660534 663362 665184 667223 670204 680640 683278 696329 710453 718079 721734 722113 725582 728643 729121 730763 732247 733443 738828 743511 744769 746347 749982 752289 752418 752455 752484 753682 754605 756007 760527 768882 769197 771606 775512 776635 777430 780968 782127 783494 791054 794186 794298 794623 797309 798525 801047 801393 811094 811917 813738 814308 814354 814458 815569 817525 817633 818143 818313 818507 819148 819201 819209 819347 819437 819634 820734 823737 823858 823982 823999 824351 824653 825312 826017 826125 826258 826418 827105 828088 828345 828440 828490 828520 828588 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot tits"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot сиськ"
]
|
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.