Query Metrics
7
Database Queries
7
Different statements
185.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.77 ms (86.63%) |
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 11718 21506 96944 97047 100616 163133 263296 341889 386883 388066 388647 390518 391508 393039 395937 396692 398689 401309 403067 405176 406091 417486 423609 438761 477319 522861 538563 540076 546840 548607 584014 606489 619445 631934 633070 637437 645964 649187 652245 652853 652877 652895 661247 670097 670761 671721 671724 672490 672579 673554 674430 678557 679050 679349 683291 683963 685621 685626 685686 687232 687249 689645 692815 694201 694221 694554 698537 699606 699608 699658 701051 703537 705537 705813 705828 708103 708826 717899 718655 719102 720273 720281 720774 720778 720819 721116 721405 721569 722692 722792 723481 723527 725312 728768 732004 741125 741537 742158 742459 751618 752566 754205 756210 758201 767287 770313 771560 772708 775892 778366 780637 788443 793441 793472 795525 805307 817444 817617 819597 820953 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (8.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 692815 584014 756210 728768 396692 263296 388647 386883 403067 417486 817617 652853 703537 720774 670097 721405 722692 652877 671724 619445 793472 795525 742459 751618 754205 701051 721569 793441 11718 406091 388066 393039 395937 96944 21506 817444 820953 540076 546840 683291 687249 699608 723481 649187 673554 674430 683963 685621 689645 694554 699658 705813 720281 720778 645964 652245 685626 694221 698537 705537 705828 708826 718655 722792 606489 631934 633070 637437 778366 788443 767287 772708 805307 732004 741125 742158 771560 725312 752566 758201 741537 770313 775892 780637 341889 398689 100616 390518 401309 163133 405176 97047 391508 423609 438761 723527 819597 477319 522861 538563 548607 661247 672490 678557 694201 708103 717899 719102 670761 671721 679050 679349 685686 699606 652895 672579 687232 720273 720819 721116 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.27%) |
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 11718 21506 96944 97047 100616 163133 263296 341889 386883 388066 388647 390518 391508 393039 395937 396692 398689 401309 403067 405176 406091 417486 423609 438761 477319 522861 538563 540076 546840 548607 584014 606489 619445 631934 633070 637437 645964 649187 652245 652853 652877 652895 661247 670097 670761 671721 671724 672490 672579 673554 674430 678557 679050 679349 683291 683963 685621 685626 685686 687232 687249 689645 692815 694201 694221 694554 698537 699606 699608 699658 701051 703537 705537 705813 705828 708103 708826 717899 718655 719102 720273 720281 720774 720778 720819 721116 721405 721569 722692 722792 723481 723527 725312 728768 732004 741125 741537 742158 742459 751618 752566 754205 756210 758201 767287 770313 771560 772708 775892 778366 780637 788443 793441 793472 795525 805307 817444 817617 819597 820953 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome teen"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро teen"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро teen"
]
|
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.