Query Metrics
8
Database Queries
8
Different statements
161.87 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.56 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.69 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal fucking"
]
|
||||||||||||||||||||||||||||||
| 3 | 1.69 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01’øpy+s)—1¹ÅмWÊ"
]
|
||||||||||||||||||||||||||||||
| 4 | 15.84 ms |
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 728377 728387 738515 745107 753255 727874 735260 735806 773665 774697 775716 779706 182036 552584 628484 814226 445709 445714 447041 464878 474292 520790 531556 536440 537138 463304 565954 567947 570408 576134 580207 702159 719957 662209 676642 717845 642042 603432 619996 601830 633763 775825 805777 805684 769071 727560 724854 738528 767149 707408 807994 438830 397251 459496 148028 417986 499554 486221 509859 383722 188337 97107 417836 723573 818903 457608 510542 467940 656186 678775 686133 685819 686457 700930 707505 607464 600204 614880 793343 794037 724048 752589 642376 722848 397899 458156 194687 16946 401037 411695 502780 123029 713834 577087 696110 738147 749885 816405 815094 530498 540051 545473 695562 703574 695264 701267 709640 712720 713364 649310 662022 693089 694660 716703 720388 598451 617339 776234 776829 795838 ] |
||||||||||||||||||||||||||||||
| 5 | 3.06 ms |
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 16946 97107 123029 148028 182036 188337 194687 383722 397251 397899 401037 411695 417836 417986 438830 445709 445714 447041 457608 458156 459496 463304 464878 467940 474292 486221 499554 502780 509859 510542 520790 530498 531556 536440 537138 540051 545473 552584 565954 567947 570408 576134 577087 580207 598451 600204 601830 603432 607464 614880 617339 619996 628484 633763 642042 642376 649310 656186 662022 662209 676642 678775 685819 686133 686457 693089 694660 695264 695562 696110 700930 701267 702159 703574 707408 707505 709640 712720 713364 713834 716703 717845 719957 720388 722848 723573 724048 724854 727560 727874 728377 728387 735260 735806 738147 738515 738528 745107 749885 752589 753255 767149 769071 773665 774697 775716 775825 776234 776829 779706 793343 794037 795838 805684 805777 807994 814226 815094 816405 818903 ] |
||||||||||||||||||||||||||||||
| 6 | 135.20 ms |
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 16946 97107 123029 148028 182036 188337 194687 383722 397251 397899 401037 411695 417836 417986 438830 445709 445714 447041 457608 458156 459496 463304 464878 467940 474292 486221 499554 502780 509859 510542 520790 530498 531556 536440 537138 540051 545473 552584 565954 567947 570408 576134 577087 580207 598451 600204 601830 603432 607464 614880 617339 619996 628484 633763 642042 642376 649310 656186 662022 662209 676642 678775 685819 686133 686457 693089 694660 695264 695562 696110 700930 701267 702159 703574 707408 707505 709640 712720 713364 713834 716703 717845 719957 720388 722848 723573 724048 724854 727560 727874 728377 728387 735260 735806 738147 738515 738528 745107 749885 752589 753255 767149 769071 773665 774697 775716 775825 776234 776829 779706 793343 794037 795838 805684 805777 807994 814226 815094 816405 818903 ] |
||||||||||||||||||||||||||||||
| 7 | 1.52 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал fucking"
]
|
||||||||||||||||||||||||||||||
| 8 | 1.31 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал fucking"
]
|
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.