Query Metrics
7
Database Queries
7
Different statements
222.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.46 ms (88.60%) |
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 361315 388078 388545 389630 390538 391926 400837 402207 402718 402736 406982 415196 418774 424155 424274 427308 428961 429384 432552 432580 435406 440534 440878 441495 444035 444197 446216 447147 447511 447530 447551 447734 448392 448431 450659 452769 452791 454343 454581 454633 456413 457089 457524 459872 462021 463304 463950 463968 464578 466752 467953 470181 470337 471958 472323 472337 472346 475499 476728 477133 478220 483369 483613 484193 485508 485646 486841 487712 488713 489876 491916 491961 493660 494443 496733 496869 496910 500849 502440 503682 503704 505287 505846 509645 510247 511955 513487 516157 516480 517973 518731 525028 528020 528781 558060 559021 565964 566405 572307 572692 573607 580712 591933 597057 597502 597552 598489 598674 605764 661933 692440 694660 713392 715410 718643 758241 762969 764821 799905 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (7.16%) |
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 475499 391926 427308 428961 440878 447511 459872 462021 463950 470337 472323 402207 406982 418774 424274 432580 452769 452791 466752 470181 390538 400837 402718 402736 440534 447530 454343 454581 456413 463968 471958 472337 435406 447147 447551 450659 472346 478220 500849 503704 518731 486841 487712 494443 502440 503682 517973 528020 483369 488713 489876 491916 491961 496733 496869 516480 525028 483613 505287 505846 509645 510247 513487 516157 528781 692440 715410 661933 694660 713392 597552 598489 791973 799905 762969 764821 758241 718643 361315 389630 444197 448392 448431 457089 415196 424155 432552 454633 511955 484193 496910 605764 388545 444035 441495 429384 446216 457524 447734 477133 485508 485646 476728 463304 464578 467953 493660 559021 565964 566405 572692 573607 558060 572307 580712 597057 598674 591933 597502 388078 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.14%) |
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 361315 388078 388545 389630 390538 391926 400837 402207 402718 402736 406982 415196 418774 424155 424274 427308 428961 429384 432552 432580 435406 440534 440878 441495 444035 444197 446216 447147 447511 447530 447551 447734 448392 448431 450659 452769 452791 454343 454581 454633 456413 457089 457524 459872 462021 463304 463950 463968 464578 466752 467953 470181 470337 471958 472323 472337 472346 475499 476728 477133 478220 483369 483613 484193 485508 485646 486841 487712 488713 489876 491916 491961 493660 494443 496733 496869 496910 500849 502440 503682 503704 505287 505846 509645 510247 511955 513487 516157 516480 517973 518731 525028 528020 528781 558060 559021 565964 566405 572307 572692 573607 580712 591933 597057 597502 597552 598489 598674 605764 661933 692440 694660 713392 715410 718643 758241 762969 764821 799905 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð░ð¢ð░ð╗Ðîð¢Ðïð╣ ð┐ð¥ÐÇð¢ð¥ ÐÇð¥ÐüÐüð©ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал порн русск"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.61%) |
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.