Query Metrics
7
Database Queries
7
Different statements
166.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.89 ms (84.51%) |
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 73947 397141 397341 457402 502232 510286 517769 521659 524508 550991 553701 574499 579295 586000 612407 615492 625285 635832 660000 663229 667371 668435 673318 673893 677702 689079 693350 704731 705024 707552 708943 710239 712160 712597 716160 718453 719554 719879 722057 722217 723194 729720 729869 731030 733990 737337 744540 749428 750028 752789 753351 755736 760263 760350 763642 764085 769246 770616 771351 772603 773445 776608 778216 780226 780483 780523 783513 783997 786226 787714 788316 789720 790690 792279 793389 793615 793686 794498 794579 795444 796937 797122 797337 801633 804840 806207 807270 812270 812613 813736 815327 815377 815401 815544 815612 815660 815724 816297 816482 816498 816532 816953 817677 819202 819382 819924 820067 820453 820573 821411 822217 822280 822458 823289 823525 825204 826748 827413 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (9.76%) |
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 825709 787714 807270 744540 793686 73947 823289 813736 825204 574499 719879 722057 673318 760350 719554 517769 524508 815327 822217 820573 826748 816953 820067 823525 815377 815544 815724 521659 663229 667371 693350 705024 660000 778216 789720 797122 752789 749428 723194 780483 729869 772603 397141 753351 793389 797337 780523 819382 821411 668435 707552 615492 763642 769246 764085 771351 773445 750028 795444 673893 635832 776608 812270 794498 731030 733990 764753 708943 712597 801633 816498 817677 819924 820453 822280 502232 550991 704731 718453 804840 783513 790690 806207 729720 755736 770616 760263 712160 722217 780226 510286 397341 815401 815612 815660 822458 827413 816297 816482 816532 819202 457402 553701 677702 689079 710239 716160 579295 625285 612407 586000 783997 786226 792279 793615 796937 788316 794579 812613 737337 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.54%) |
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 73947 397141 397341 457402 502232 510286 517769 521659 524508 550991 553701 574499 579295 586000 612407 615492 625285 635832 660000 663229 667371 668435 673318 673893 677702 689079 693350 704731 705024 707552 708943 710239 712160 712597 716160 718453 719554 719879 722057 722217 723194 729720 729869 731030 733990 737337 744540 749428 750028 752789 753351 755736 760263 760350 763642 764085 769246 770616 771351 772603 773445 776608 778216 780226 780483 780523 783513 783997 786226 787714 788316 789720 790690 792279 793389 793615 793686 794498 794579 795444 796937 797122 797337 801633 804840 806207 807270 812270 812613 813736 815327 815377 815401 815544 815612 815660 815724 816297 816482 816498 816532 816953 817677 819202 819382 819924 820067 820453 820573 821411 822217 822280 822458 823289 823525 825204 826748 827413 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"like to fuck"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"like секс"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"like секс"
]
|
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.