Query Metrics
8
Database Queries
8
Different statements
394.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.21 ms (53.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian onlyfans"
]
|
||||||||||||||||||||||||||||||
|
160.71 ms (40.73%) |
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 447205 521432 541499 542100 542747 542907 546725 546886 546896 548150 549532 551450 552333 552407 552874 555604 556459 556563 558461 558704 559051 559797 560034 560361 560836 562214 563559 563759 564204 565912 567623 569571 569596 571504 572337 574741 581084 581510 583110 594604 597210 599433 605735 611983 621588 622071 650297 655538 659472 674179 678651 683034 684468 687817 687852 692966 693283 699246 705017 705018 705654 708337 709480 711716 711857 716197 716999 718116 720457 722337 723181 723210 741421 743973 745268 755017 764322 765797 767514 768049 768528 774911 776283 777214 777489 777629 777726 777755 778276 778338 778342 778348 783229 783887 784768 785900 788638 789445 789847 794077 809340 813643 814170 816154 817985 818005 818031 818073 819895 821819 821828 823715 823937 824297 825025 825286 825503 825528 825530 825696 ] |
||||||||||||||||||||||||||||||
|
12.58 ms (3.19%) |
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 743973 745268 755017 764322 767514 768049 768528 741421 765797 716999 777214 777489 777629 777726 777755 778338 778342 783229 784768 785900 788638 789445 789847 794077 546886 556563 563759 569596 581510 542100 549532 551450 552874 556459 558704 559051 564204 571504 552333 555604 558461 563559 569571 572337 546896 552407 559797 560034 565912 567623 599433 605735 521432 541499 542747 546725 548150 560836 723210 711716 783887 809340 447205 819895 542907 813643 818005 818031 821828 814170 821819 816154 823937 824297 825530 825696 817985 818073 823715 825025 825286 825503 825528 562214 574741 560361 674179 684468 687817 693283 722337 723181 655538 678651 687852 705017 705018 705654 711857 718116 650297 659472 683034 692966 699246 708337 709480 716197 720457 581084 583110 594604 621588 622071 597210 611983 774911 776283 778276 778348 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (0.67%) |
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 447205 521432 541499 542100 542747 542907 546725 546886 546896 548150 549532 551450 552333 552407 552874 555604 556459 556563 558461 558704 559051 559797 560034 560361 560836 562214 563559 563759 564204 565912 567623 569571 569596 571504 572337 574741 581084 581510 583110 594604 597210 599433 605735 611983 621588 622071 650297 655538 659472 674179 678651 683034 684468 687817 687852 692966 693283 699246 705017 705018 705654 708337 709480 711716 711857 716197 716999 718116 720457 722337 723181 723210 741421 743973 745268 755017 764322 765797 767514 768049 768528 774911 776283 777214 777489 777629 777726 777755 778276 778338 778342 778348 783229 783887 784768 785900 788638 789445 789847 794077 809340 813643 814170 816154 817985 818005 818031 818073 819895 821819 821828 823715 823937 824297 825025 825286 825503 825528 825530 825696 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.64%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01’Æ"ØÐqب|WyÓ|(h"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.37%) |
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.