Query Metrics
7
Database Queries
7
Different statements
161.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.91 ms (86.18%) |
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 154573 191069 314894 390910 393075 394715 397915 402249 402771 421623 447028 448786 456944 458356 472877 480088 516101 518772 531370 542624 547405 547870 568479 571390 572921 573326 576498 577561 598182 615985 616569 617849 619112 630694 634995 650886 650937 655193 656556 656944 658180 660283 662512 674202 688211 691790 698797 713829 718151 719473 720419 720767 723003 726182 729002 736052 738835 739481 740522 744889 747100 750407 754027 757630 761092 761873 762485 763152 763827 767417 768018 768465 770368 770369 770925 771986 773687 773939 775434 776930 779747 780027 780485 780630 782885 783087 784920 784962 786084 787937 787965 788170 788221 788385 788405 792483 796332 796842 799209 800487 802284 802572 802946 804835 804929 806819 807264 808981 809987 810785 811504 812232 813356 813545 813925 814084 817022 827881 827883 827887 ] |
||||||||||||||||||||||||||||||
|
12.39 ms (7.69%) |
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 191069 154573 393075 394715 390910 402249 814084 813545 817022 813925 827883 827881 827887 456944 447028 448786 458356 480088 518772 531370 516101 472877 572921 577561 542624 568479 573326 576498 650886 656944 674202 719473 650937 688211 713829 720767 655193 656556 658180 660283 662512 691790 720419 547405 547870 571390 630694 616569 619112 634995 598182 615985 776930 780630 782885 788385 796842 799209 810785 811504 780027 783087 784962 792483 796332 809987 813356 736052 754027 768018 768465 770925 773687 773939 787937 787965 802572 807264 812232 750407 762485 763152 729002 738835 739481 747100 771986 726182 763827 767417 740522 744889 757630 761092 761873 770368 770369 617849 698797 718151 723003 775434 779747 780485 784920 786084 788170 788221 788405 800487 802284 802946 804835 804929 806819 808981 402771 421623 314894 397915 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.75%) |
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 154573 191069 314894 390910 393075 394715 397915 402249 402771 421623 447028 448786 456944 458356 472877 480088 516101 518772 531370 542624 547405 547870 568479 571390 572921 573326 576498 577561 598182 615985 616569 617849 619112 630694 634995 650886 650937 655193 656556 656944 658180 660283 662512 674202 688211 691790 698797 713829 718151 719473 720419 720767 723003 726182 729002 736052 738835 739481 740522 744889 747100 750407 754027 757630 761092 761873 762485 763152 763827 767417 768018 768465 770368 770369 770925 771986 773687 773939 775434 776930 779747 780027 780485 780630 782885 783087 784920 784962 786084 787937 787965 788170 788221 788385 788405 792483 796332 796842 799209 800487 802284 802572 802946 804835 804929 806819 807264 808981 809987 810785 811504 812232 813356 813545 813925 814084 817022 827881 827883 827887 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx with little"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx little"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx little"
]
|
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.