Query Metrics
7
Database Queries
7
Different statements
397.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.72 ms (53.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation anal"
]
|
||||||||||||||||||||||||||||||
|
163.71 ms (41.14%) |
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 96259 152882 159511 391563 403355 420533 422162 530698 531787 534564 544125 568569 588929 590806 591759 600444 604432 605155 606597 623267 623572 630099 634021 634067 639363 642048 642165 644036 648469 699385 703277 710018 714672 716036 718746 722393 725177 726134 726164 726986 727564 728365 735756 737117 738820 741301 741959 742297 744185 745448 746915 748653 749202 749268 750449 750565 750582 750917 751438 751995 752595 752647 752709 753720 758720 758807 761302 761555 761646 765355 765569 765593 766087 766679 768419 768756 769100 769325 770219 770258 770274 770400 770419 774650 778480 782443 782511 782791 783702 784227 785250 785579 785582 786993 787505 787887 789151 790399 791625 792871 793280 793281 793283 793292 793838 794155 795407 796284 799837 799898 800537 800551 800638 800807 800824 805037 806543 807341 808328 812054 ] |
||||||||||||||||||||||||||||||
|
13.76 ms (3.46%) |
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 600444 604432 606597 634067 639363 588929 590806 605155 634021 642165 623267 778480 783702 785579 790399 793281 793283 793838 807341 808328 774650 785582 796284 800537 800551 800807 800824 806543 725177 735756 745448 748653 749202 751438 752595 752647 761646 766087 770274 786993 787505 791625 799837 800638 726134 726164 728365 738820 741301 741959 746915 758807 768756 769100 770258 742297 758720 761302 765355 750917 751995 752709 753720 761555 765569 765593 768419 770219 727564 737117 749268 750565 750582 766679 770400 770419 623572 630099 642048 644036 699385 703277 710018 714672 722393 782511 782791 784227 787887 793280 793292 794155 799898 152882 420533 568569 726986 403355 531787 544125 648469 718746 716036 591759 782443 805037 785250 789151 792871 795407 812054 750449 769325 744185 96259 391563 159511 422162 530698 534564 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (0.77%) |
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 96259 152882 159511 391563 403355 420533 422162 530698 531787 534564 544125 568569 588929 590806 591759 600444 604432 605155 606597 623267 623572 630099 634021 634067 639363 642048 642165 644036 648469 699385 703277 710018 714672 716036 718746 722393 725177 726134 726164 726986 727564 728365 735756 737117 738820 741301 741959 742297 744185 745448 746915 748653 749202 749268 750449 750565 750582 750917 751438 751995 752595 752647 752709 753720 758720 758807 761302 761555 761646 765355 765569 765593 766087 766679 768419 768756 769100 769325 770219 770258 770274 770400 770419 774650 778480 782443 782511 782791 783702 784227 785250 785579 785582 786993 787505 787887 789151 790399 791625 792871 793280 793281 793283 793292 793838 794155 795407 796284 799837 799898 800537 800551 800638 800807 800824 805037 806543 807341 808328 812054 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац анал"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац анал"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.