Query Metrics
7
Database Queries
7
Different statements
389.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.96 ms (54.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член огромный"
]
|
||||||||||||||||||||||||||||||
|
151.82 ms (39.01%) |
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 154675 382934 388144 388973 399224 424672 429793 435922 435934 442410 449125 453298 454293 455573 455870 464755 471859 477809 479954 481570 482140 482676 483139 483190 485666 489258 489353 494270 500221 504085 508759 508882 509174 509578 509669 510834 510869 511749 515705 523398 525497 528525 528877 530039 530383 530476 530623 530681 531173 531183 531206 531208 532351 532737 532962 533051 533982 534150 535094 535255 536872 540944 542524 545117 548525 551886 554185 554519 561931 563559 568541 568677 568909 572019 572022 574763 577468 577535 580160 582802 586219 591600 593279 598667 598833 601435 602698 603652 606574 607454 613180 613908 615839 629333 629630 631478 632687 639735 642033 651051 676111 677917 678125 679317 707706 707740 726315 773963 775802 779037 787944 791679 797445 801906 803596 807170 807542 813029 813265 813579 ] |
||||||||||||||||||||||||||||||
|
17.29 ms (4.44%) |
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 775802 779037 791679 813029 773963 787944 523398 482140 582802 563559 577468 607454 631478 598833 797445 602698 813265 471859 424672 536872 388144 510869 545117 593279 455870 509578 510834 485666 568541 606574 726315 479954 511749 435934 613908 388973 494270 483139 489353 154675 442410 574763 629333 429793 453298 528525 540944 707740 677917 613180 435922 449125 483190 509174 509669 515705 382934 548525 807170 508759 580160 803596 525497 532962 531183 577535 551886 679317 598667 477809 554519 508882 572019 399224 455573 601435 531206 534150 532351 533051 530623 568909 568677 676111 707706 651051 678125 639735 591600 801906 632687 533982 572022 542524 586219 813579 561931 642033 615839 603652 554185 464755 629630 500221 535255 454293 489258 528877 482676 504085 807542 481570 535094 530039 530383 531208 530681 532737 530476 531173 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.76%) |
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 154675 382934 388144 388973 399224 424672 429793 435922 435934 442410 449125 453298 454293 455573 455870 464755 471859 477809 479954 481570 482140 482676 483139 483190 485666 489258 489353 494270 500221 504085 508759 508882 509174 509578 509669 510834 510869 511749 515705 523398 525497 528525 528877 530039 530383 530476 530623 530681 531173 531183 531206 531208 532351 532737 532962 533051 533982 534150 535094 535255 536872 540944 542524 545117 548525 551886 554185 554519 561931 563559 568541 568677 568909 572019 572022 574763 577468 577535 580160 582802 586219 591600 593279 598667 598833 601435 602698 603652 606574 607454 613180 613908 615839 629333 629630 631478 632687 639735 642033 651051 676111 677917 678125 679317 707706 707740 726315 773963 775802 779037 787944 791679 797445 801906 803596 807170 807542 813029 813265 813579 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочка члена огромным"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член огромный"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.40%) |
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.