Query Metrics
7
Database Queries
7
Different statements
412.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
390.10 ms (94.57%) |
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 31758 382541 386215 387667 389819 397206 397997 416038 417366 428262 432611 446772 446776 447250 449908 450108 452287 452950 454735 455928 456022 456030 463394 463782 467022 467024 467099 469433 469990 470195 471012 471020 471045 471461 474214 483522 485470 485955 487413 488191 489924 494589 499531 499714 504026 506092 507832 510899 510904 510938 513528 519753 519787 524444 525988 535345 540032 557720 558314 559412 562153 566794 579510 580121 581360 590089 597667 601145 601449 602466 605094 605285 621051 629815 632849 637245 659182 661424 664498 666672 671835 694098 695164 703715 703733 703758 703788 709128 714476 714927 726736 732178 734274 737131 739466 744024 745987 749455 754536 754863 759916 760231 761520 764212 768646 768649 770038 773754 783177 784648 795348 824505 824630 824735 824833 824868 824892 825396 827484 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (3.39%) |
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 759916 760231 768649 770038 726736 732178 734274 739466 744024 754863 768646 737131 745987 749455 754536 761520 764212 773754 632849 703715 703733 703758 703788 783177 795348 382541 389819 387667 397997 417366 824868 827484 824735 825396 489924 446772 446776 467024 447250 471045 525988 499714 467022 469990 664498 597667 590089 455928 463394 469433 504026 499531 510904 485955 659182 471461 487413 566794 605285 601145 784648 474214 471012 519753 510899 510938 535345 540032 557720 558314 562153 580121 666672 695164 714476 661424 694098 559412 602466 637245 629815 796642 709128 714927 456030 416038 428262 671835 452950 494589 432611 824892 824833 456022 463782 471020 450108 452287 483522 488191 581360 579510 601449 621051 470195 467099 449908 506092 507832 513528 524444 519787 485470 605094 454735 386215 31758 397206 824630 824505 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.54%) |
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 31758 382541 386215 387667 389819 397206 397997 416038 417366 428262 432611 446772 446776 447250 449908 450108 452287 452950 454735 455928 456022 456030 463394 463782 467022 467024 467099 469433 469990 470195 471012 471020 471045 471461 474214 483522 485470 485955 487413 488191 489924 494589 499531 499714 504026 506092 507832 510899 510904 510938 513528 519753 519787 524444 525988 535345 540032 557720 558314 559412 562153 566794 579510 580121 581360 590089 597667 601145 601449 602466 605094 605285 621051 629815 632849 637245 659182 661424 664498 666672 671835 694098 695164 703715 703733 703758 703788 709128 714476 714927 726736 732178 734274 737131 739466 744024 745987 749455 754536 754863 759916 760231 761520 764212 768646 768649 770038 773754 783177 784648 795348 824505 824630 824735 824833 824868 824892 825396 827484 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy webcam"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.32%) |
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.