Query Metrics
7
Database Queries
7
Different statements
849.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
418.60 ms (49.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жестко глубокая глотк…"
]
|
||||||||||||||||||||||||||||||
|
269.15 ms (31.70%) |
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 24931 389364 827975 414385 791086 407523 531131 388374 748975 777044 813556 386929 396360 416093 812337 584903 400967 685416 741582 742831 640451 324555 386787 517564 716648 814324 522407 716715 810139 419931 118226 533569 793438 743799 790719 763457 397197 401532 414069 425499 424652 385618 426689 395405 431432 471163 673217 395498 396584 814312 792126 793742 783201 783294 810582 779883 382472 811937 318343 819552 819858 827954 486059 789883 791703 811968 809664 810234 810611 79862 420371 817126 817754 794977 406064 417958 601150 383296 814317 475920 740692 506279 400938 827924 827958 546805 712553 820032 665378 196306 827949 720705 476073 659452 751161 633514 386448 385705 397411 824921 817157 819606 86309 765260 425884 814251 789881 510024 639782 336987 783446 809605 416933 814258 814276 817756 816650 817300 641761 749693 ] |
||||||||||||||||||||||||||||||
|
152.68 ms (17.98%) |
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 24931 79862 86309 118226 196306 318343 324555 336987 382472 383296 385618 385705 386448 386787 386929 388374 389364 395405 395498 396360 396584 397197 397411 400938 400967 401532 406064 407523 414069 414385 416093 416933 417958 419931 420371 424652 425499 425884 426689 431432 471163 475920 476073 486059 506279 510024 517564 522407 531131 533569 546805 584903 601150 633514 639782 640451 641761 659452 665378 673217 685416 712553 716648 716715 720705 740692 741582 742831 743799 748975 749693 751161 763457 765260 777044 779883 783201 783294 783446 789881 789883 790719 791086 791703 792126 793438 793742 794977 809605 809664 810139 810234 810582 810611 811937 811968 812337 813556 814251 814258 814276 814312 814317 814324 816650 817126 817157 817300 817754 817756 819552 819606 819858 820032 824921 827924 827949 827954 827958 827975 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (0.33%) |
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 24931 79862 86309 118226 196306 318343 324555 336987 382472 383296 385618 385705 386448 386787 386929 388374 389364 395405 395498 396360 396584 397197 397411 400938 400967 401532 406064 407523 414069 414385 416093 416933 417958 419931 420371 424652 425499 425884 426689 431432 471163 475920 476073 486059 506279 510024 517564 522407 531131 533569 546805 584903 601150 633514 639782 640451 641761 659452 665378 673217 685416 712553 716648 716715 720705 740692 741582 742831 743799 748975 749693 751161 763457 765260 777044 779883 783201 783294 783446 789881 789883 790719 791086 791703 792126 793438 793742 794977 809605 809664 810139 810234 810582 810611 811937 811968 812337 813556 814251 814258 814276 814312 814317 814324 816650 817126 817157 817300 817754 817756 819552 819606 819858 820032 824921 827924 827949 827954 827958 827975 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.19%) |
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.