Query Metrics
7
Database Queries
7
Different statements
205.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.93 ms (88.59%) |
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 467118 497336 529940 537240 546633 546720 546896 552407 555032 555604 556459 565376 595133 598284 599433 601189 615256 615272 621789 627213 630082 631058 634423 636125 641571 642596 661966 664276 674278 677434 698814 701634 703422 708213 710936 711535 714523 715246 721691 724433 725657 725765 726182 736972 738541 739487 748002 751191 758531 759299 760979 761704 761996 764383 764448 765458 765589 765692 766657 767415 767514 768014 770596 771014 771326 771746 772352 772429 772430 772537 773322 773689 773730 774218 774238 775509 775554 776128 776275 776544 777726 777939 780018 780112 781623 783593 783653 783778 783887 785443 786203 787609 788675 790883 791849 792683 795623 796039 796295 796603 797893 798105 798814 799354 799467 799597 800785 803311 805119 808448 811089 811517 811875 812625 814717 819651 824122 825086 ] |
||||||||||||||||||||||||||||||
|
13.70 ms (6.67%) |
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 764383 765589 771014 774218 725657 725765 761704 761996 763756 765458 767514 768014 771746 772430 772537 738541 748002 751191 759299 760979 765692 770596 773689 615256 634423 708213 710936 714523 775509 776128 777726 780112 783778 788675 790883 791849 792683 796603 798105 798814 799597 800785 805119 814717 674278 677434 701634 715246 555032 621789 783653 783887 797893 783593 787609 796295 739487 773730 758531 773322 726182 772352 736972 766657 615272 711535 780018 785443 537240 776544 819651 661966 721691 698814 636125 598284 595133 627213 630082 775389 811517 812625 775554 776275 796039 795623 724433 764448 767415 774238 497336 529940 546720 556459 565376 546633 555604 546896 552407 599433 631058 799354 467118 781623 772429 825086 642596 601189 641571 786203 803311 808448 811089 811875 664276 703422 799467 771326 777939 824122 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.29%) |
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 467118 497336 529940 537240 546633 546720 546896 552407 555032 555604 556459 565376 595133 598284 599433 601189 615256 615272 621789 627213 630082 631058 634423 636125 641571 642596 661966 664276 674278 677434 698814 701634 703422 708213 710936 711535 714523 715246 721691 724433 725657 725765 726182 736972 738541 739487 748002 751191 758531 759299 760979 761704 761996 764383 764448 765458 765589 765692 766657 767415 767514 768014 770596 771014 771326 771746 772352 772429 772430 772537 773322 773689 773730 774218 774238 775509 775554 776128 776275 776544 777726 777939 780018 780112 781623 783593 783653 783778 783887 785443 786203 787609 788675 790883 791849 792683 795623 796039 796295 796603 797893 798105 798814 799354 799467 799597 800785 803311 805119 808448 811089 811517 811875 812625 814717 819651 824122 825086 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass onlyfans"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.75%) |
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.