Query Metrics
7
Database Queries
7
Different statements
252.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.84 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.13 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur riding creampie"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.74 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 3523 398449 417556 417788 817990 824190 518230 555481 781753 788029 795213 795247 812159 758817 785745 803648 728360 774251 726059 726820 746569 761359 725286 735022 763762 722928 783559 785783 510907 540248 571785 582944 670821 702343 823844 823955 826153 460611 677569 775345 794439 808969 813002 801039 804012 762380 763922 759694 728276 715888 791782 792677 797096 798799 536416 574169 565028 577287 582056 656579 563709 583790 604822 616505 616519 591186 620533 622065 611495 628618 595394 616526 629167 803532 804335 635351 488299 630135 532041 699168 586973 614583 509971 826676 530066 534735 471715 571425 666403 679882 803873 761764 742828 748620 761936 735939 756629 721872 487973 531244 495070 510882 527072 710094 640411 791195 796154 796468 725094 725309 726081 734293 758754 756898 768197 797709 370928 477067 441159 422414 ] |
||||||||||||||||||||||||||||||
| 4 | 3.16 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 3523 370928 398449 417556 417788 422414 441159 460611 471715 477067 487973 488299 495070 509971 510882 510907 518230 527072 530066 531244 532041 534735 536416 540248 555481 563709 565028 571425 571785 574169 577287 582056 582944 583790 586973 591186 595394 604822 611495 614583 616505 616519 616526 620533 622065 628618 629167 630135 635351 640411 656579 666403 670821 677569 679882 699168 702343 710094 715888 721872 722928 725094 725286 725309 726059 726081 726820 728276 728360 734293 735022 735939 742828 746569 748620 756629 756898 758754 758817 759694 761359 761764 761936 762380 763762 763922 768197 774251 775345 781753 785745 785783 788029 791195 791782 792677 794439 795213 795247 796154 796468 797096 797709 798799 801039 803532 803648 803873 804012 804335 808969 812159 813002 817990 823844 823955 824190 826153 826676 ] |
||||||||||||||||||||||||||||||
| 5 | 227.64 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 3523 370928 398449 417556 417788 422414 441159 460611 471715 477067 487973 488299 495070 509971 510882 510907 518230 527072 530066 531244 532041 534735 536416 540248 555481 563709 565028 571425 571785 574169 577287 582056 582944 583790 586973 591186 595394 604822 611495 614583 616505 616519 616526 620533 622065 628618 629167 630135 635351 640411 656579 666403 670821 677569 679882 699168 702343 710094 715888 721872 722928 725094 725286 725309 726059 726081 726820 728276 728360 734293 735022 735939 742828 746569 748620 756629 756898 758754 758817 759694 761359 761764 761936 762380 763762 763922 768197 774251 775345 781753 785745 785783 788029 791195 791782 792677 794439 795213 795247 796154 796468 797096 797709 798799 801039 803532 803648 803873 804012 804335 808969 812159 813002 817990 823844 823955 824190 826153 826676 ] |
||||||||||||||||||||||||||||||
| 6 | 1.87 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск riding creampie"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск riding creampie"
]
|
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.