Query Metrics
7
Database Queries
7
Different statements
211.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.96 ms (89.88%) |
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 434488 438047 461663 467977 469827 473868 473943 488952 492439 505342 532281 533142 535266 536907 537666 540082 543465 545130 549217 550195 563563 565600 566121 576455 580559 587829 598632 604864 605049 611448 614770 614798 618955 622275 624180 625464 634836 644756 644793 652148 668790 669915 673825 693899 693940 696209 696721 699404 700598 700647 703792 706023 707388 709288 712677 715881 717432 718337 726768 727555 728109 728281 728629 729132 732792 733107 734197 734601 737900 738054 740858 741536 743079 743679 744522 747497 747822 749013 753546 768093 773246 776672 778414 778420 780763 784108 785018 786928 788303 790603 792713 793350 794428 794477 794927 796152 797540 797948 798373 799136 799335 799458 800971 801578 801740 803819 803904 804323 805182 808881 811956 811962 813850 814328 814663 819141 820061 823624 824321 824955 ] |
||||||||||||||||||||||||||||||
|
11.10 ms (5.25%) |
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 532281 537666 576455 545130 566121 700647 712677 696209 709288 715881 652148 673825 549217 598632 604864 625464 622275 644793 587829 605049 776672 800971 778414 780763 792713 794428 794477 797540 801578 734197 738054 740858 743679 749013 811956 753546 734601 768093 611448 718337 811962 438047 824321 814328 813850 823624 467977 492439 533142 535266 536907 540082 488952 543465 550195 580559 563563 565600 669915 693899 693940 696721 699404 703792 717432 668790 706023 707388 634836 624180 614770 644756 614798 618955 778420 788303 793350 794927 801740 803904 805182 785018 799335 799458 803819 729132 737900 773246 786928 790603 797948 808881 728281 728629 744522 747497 728109 732792 741536 726768 727555 743079 747822 733107 700598 784108 796152 798373 799136 804323 473943 505342 434488 820061 814663 819141 824955 461663 469827 473868 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.26%) |
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 434488 438047 461663 467977 469827 473868 473943 488952 492439 505342 532281 533142 535266 536907 537666 540082 543465 545130 549217 550195 563563 565600 566121 576455 580559 587829 598632 604864 605049 611448 614770 614798 618955 622275 624180 625464 634836 644756 644793 652148 668790 669915 673825 693899 693940 696209 696721 699404 700598 700647 703792 706023 707388 709288 712677 715881 717432 718337 726768 727555 728109 728281 728629 729132 732792 733107 734197 734601 737900 738054 740858 741536 743079 743679 744522 747497 747822 749013 753546 768093 773246 776672 778414 778420 780763 784108 785018 786928 788303 790603 792713 793350 794428 794477 794927 796152 797540 797948 798373 799136 799335 799458 800971 801578 801740 803819 803904 804323 805182 808881 811956 811962 813850 814328 814663 819141 820061 823624 824321 824955 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milk 2017"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milk"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milk"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.81%) |
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.