Query Metrics
7
Database Queries
7
Different statements
139.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.41 ms (84.04%) |
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 6976 129748 163536 358365 382554 387005 391869 392152 393499 396451 396929 397290 397320 397393 398011 398269 399905 406406 409916 413210 413779 414932 416163 417856 423863 427033 427850 432977 451723 455448 459239 463872 471550 490130 525734 530441 540627 567024 622246 636441 649989 675419 682302 738324 762746 764687 764993 765365 767354 768456 769749 771547 771757 772844 774595 775062 776377 777759 777827 778915 778987 779459 779563 779685 780047 780498 780520 780934 782868 783557 783744 784692 784911 784986 785191 785769 786145 786280 786694 786836 787158 787442 788954 789014 791528 791749 793370 793395 793446 793571 794930 796817 797103 797774 797916 797958 798849 799458 799784 801504 802167 802249 804824 804953 805189 808255 810414 811735 814284 817362 818133 818727 818768 818828 819371 823655 823658 825457 827491 827511 ] |
||||||||||||||||||||||||||||||
|
12.72 ms (9.10%) |
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 413779 738324 771757 382554 427850 783557 786694 767354 801504 778915 794930 417856 804824 827511 459239 779563 785191 811735 784692 392152 391869 393499 399905 432977 567024 129748 764687 784911 774595 397320 397393 414932 540627 791528 778987 818133 387005 765365 787442 793571 788954 636441 406406 769749 396929 416163 814284 776377 779459 786145 808255 764993 771547 398011 471550 423863 818727 530441 780520 797958 799458 787158 397290 398269 649989 682302 791749 805189 793446 163536 427033 396451 823658 827491 825457 817362 818768 818828 451723 525734 777827 793395 799784 780047 782868 783744 802167 797774 768456 796817 797103 798849 358365 6976 409916 780498 786280 455448 463872 490130 413210 819371 823655 675419 622246 775062 779685 780934 786836 793370 797916 777759 785769 789014 802249 762746 772844 784986 804953 810414 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.85%) |
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 6976 129748 163536 358365 382554 387005 391869 392152 393499 396451 396929 397290 397320 397393 398011 398269 399905 406406 409916 413210 413779 414932 416163 417856 423863 427033 427850 432977 451723 455448 459239 463872 471550 490130 525734 530441 540627 567024 622246 636441 649989 675419 682302 738324 762746 764687 764993 765365 767354 768456 769749 771547 771757 772844 774595 775062 776377 777759 777827 778915 778987 779459 779563 779685 780047 780498 780520 780934 782868 783557 783744 784692 784911 784986 785191 785769 786145 786280 786694 786836 787158 787442 788954 789014 791528 791749 793370 793395 793446 793571 794930 796817 797103 797774 797916 797958 798849 799458 799784 801504 802167 802249 804824 804953 805189 808255 810414 811735 814284 817362 818133 818727 818768 818828 819371 823655 823658 825457 827491 827511 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.13%) |
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.