Query Metrics
7
Database Queries
7
Different statements
145.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.91 ms (84.43%) |
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 39151 390225 391773 400727 402893 404178 415344 420833 426694 461997 463255 465393 470542 470687 477638 479422 485945 499993 509426 509500 513451 518561 530292 533761 534469 534499 535613 535633 535636 537085 539366 542402 543646 543668 544053 545994 558000 559467 567241 567938 574018 576133 578758 578825 592546 598728 599355 600208 600477 602707 602868 605958 610739 613398 618232 619042 619881 622815 625580 628206 641029 658496 663828 663832 667043 669504 670069 671197 672707 673163 674309 679671 684436 685106 688768 690662 693264 695087 695097 697251 701214 702237 702239 704996 709503 710220 711364 712953 721575 721597 726398 727523 730052 736128 749766 760394 764112 764121 764137 767884 768472 768486 769138 778121 781093 781270 787286 788032 792242 796537 799680 799726 803229 803236 804872 811209 824925 824946 825867 ] |
||||||||||||||||||||||||||||||
|
13.02 ms (8.94%) |
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 788032 479422 534469 672707 712953 685106 545994 499993 825867 825782 400727 824925 695087 702239 669504 702237 602707 605958 709503 535613 530292 543646 697251 721597 721575 598728 787286 804872 736128 764121 749766 768486 726398 727523 764112 764137 768472 711364 465393 39151 415344 485945 509500 404178 518561 426694 509426 781270 803236 803229 667043 542402 693264 704996 701214 578758 619881 610739 769138 778121 543668 558000 663832 671197 674309 690662 679671 684436 567241 567938 592546 622815 619042 781093 799726 767884 730052 613398 420833 391773 513451 402893 390225 824946 533761 534499 537085 574018 673163 688768 663828 710220 641029 600477 628206 599355 602868 792242 796537 799680 760394 618232 811209 535636 535633 658496 670069 576133 625580 470542 470687 539366 463255 559467 544053 695097 578825 600208 461997 477638 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.84%) |
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 39151 390225 391773 400727 402893 404178 415344 420833 426694 461997 463255 465393 470542 470687 477638 479422 485945 499993 509426 509500 513451 518561 530292 533761 534469 534499 535613 535633 535636 537085 539366 542402 543646 543668 544053 545994 558000 559467 567241 567938 574018 576133 578758 578825 592546 598728 599355 600208 600477 602707 602868 605958 610739 613398 618232 619042 619881 622815 625580 628206 641029 658496 663828 663832 667043 669504 670069 671197 672707 673163 674309 679671 684436 685106 688768 690662 693264 695087 695097 697251 701214 702237 702239 704996 709503 710220 711364 712953 721575 721597 726398 727523 730052 736128 749766 760394 764112 764121 764137 767884 768472 768486 769138 778121 781093 781270 787286 788032 792242 796537 799680 799726 803229 803236 804872 811209 824925 824946 825867 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian amateurs homemade"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск любительск домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.