unserialize(): Passing null to parameter #1 ($data) of type string is deprecated
app/addons/hybrid_auth/func.php, line: 200
| File: | app/addons/hybrid_auth/func.php |
| Line: | 200 |
| Function: | {closure} |
| File: | app/Tygh/Registry.php |
| Line: | 800 |
| Function: | {closure} |
| File: | app/addons/hybrid_auth/func.php |
| Line: | 222 |
| Function: | getOrSetCache |
| File: | app/addons/hybrid_auth/controllers/frontend/init.post.php |
| Line: | 17 |
| Function: | fn_hybrid_auth_get_providers_list |
| File: | app/functions/fn.control.php |
| Line: | 727 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 458 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "110.66"
},
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_discussion",
"access_type": "range",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"rows_examined_per_scan": 96,
"rows_produced_per_join": 96,
"filtered": "100.00",
"index_condition": "((`nuie_scalesta_net`.`cscart_discussion`.`object_id` in (98590,98591,98592,98593,98594,98595,98596,98597,98598,98599,98600,98601,98602,98603,98604,98605,98606,98607,98608,98609,98610,98611,98612,98613,98614,98615,98616,98617,98618,98619,98620,98621,98622,98623,98624,98625,98626,98627,98628,98629,98630,98631,98632,98633,98634,98635,98636,98637,98638,98639,98640,98641,98642,98643,98644,98645,98646,98647,98648,98649,98650,98651,98652,98653,98654,98655,98656,98657,98658,98659,98660,98661,98662,98663,98664,98665,98666,98667,98668,98669,98670,98671,98672,98673,98674,98675,98676,98677,98678,98679,98680,98681,98760,98761,99012,99013)) and (`nuie_scalesta_net`.`cscart_discussion`.`object_type` = 'P'))",
"cost_info": {
"read_cost": "57.61",
"eval_cost": "9.60",
"prefix_cost": "67.21",
"data_read_per_join": "2K"
},
"used_columns": [
"thread_id",
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"nuie_scalesta_net.cscart_discussion.thread_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 96,
"filtered": "100.00",
"cost_info": {
"read_cost": "24.00",
"eval_cost": "9.60",
"prefix_cost": "100.81",
"data_read_per_join": "42K"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), (`nuie_scalesta_net`.`cscart_discussion_posts`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 96,
"filtered": "100.00",
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "9.60",
"prefix_cost": "110.66",
"data_read_per_join": "1K"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), ((`nuie_scalesta_net`.`cscart_discussion_rating`.`post_id` = `nuie_scalesta_net`.`cscart_discussion_posts`.`post_id`) and (`nuie_scalesta_net`.`cscart_discussion_rating`.`thread_id` = `nuie_scalesta_net`.`cscart_discussion`.`thread_id`) and (`nuie_scalesta_net`.`cscart_discussion_rating`.`rating_value` <> 0)), true)"
}
}
]
}
}
}
| product_id | average_rating | discussion_type | discussion_thread_id |
|---|---|---|---|
| 98590 | B | 106771 | |
| 98591 | B | 106772 | |
| 98592 | B | 106773 | |
| 98593 | B | 106774 | |
| 98594 | B | 106775 | |
| 98595 | B | 106776 | |
| 98596 | B | 106777 | |
| 98597 | B | 106778 | |
| 98598 | B | 106779 | |
| 98599 | B | 106780 | |
| 98600 | B | 106781 | |
| 98601 | B | 106782 | |
| 98602 | B | 106783 | |
| 98603 | B | 106784 | |
| 98604 | B | 106785 | |
| 98605 | B | 106786 | |
| 98606 | B | 106787 | |
| 98607 | B | 106788 | |
| 98608 | B | 106789 | |
| 98609 | B | 106790 | |
| 98610 | B | 106791 | |
| 98611 | B | 106792 | |
| 98612 | B | 106793 | |
| 98613 | B | 106794 | |
| 98614 | B | 106795 | |
| 98615 | B | 106796 | |
| 98616 | B | 106797 | |
| 98617 | B | 106798 | |
| 98618 | B | 106799 | |
| 98619 | B | 106800 | |
| 98620 | B | 106801 | |
| 98621 | B | 106802 | |
| 98622 | B | 106803 | |
| 98623 | B | 106804 | |
| 98624 | B | 106805 | |
| 98625 | B | 106806 | |
| 98626 | B | 106807 | |
| 98627 | B | 106808 | |
| 98628 | B | 106809 | |
| 98629 | B | 106810 | |
| 98630 | B | 106811 | |
| 98631 | B | 106812 | |
| 98632 | B | 106813 | |
| 98633 | B | 106814 | |
| 98634 | B | 106815 | |
| 98635 | B | 106816 | |
| 98636 | B | 106817 | |
| 98637 | B | 106818 | |
| 98638 | B | 106819 | |
| 98639 | B | 106820 | |
| 98640 | B | 106821 | |
| 98641 | B | 106822 | |
| 98642 | B | 106823 | |
| 98643 | B | 106824 | |
| 98644 | B | 106825 | |
| 98645 | B | 106826 | |
| 98646 | B | 106827 | |
| 98647 | B | 106828 | |
| 98648 | B | 106829 | |
| 98649 | B | 106830 | |
| 98650 | B | 106831 | |
| 98651 | B | 106832 | |
| 98652 | B | 106833 | |
| 98653 | B | 106834 | |
| 98654 | B | 106835 | |
| 98655 | B | 106836 | |
| 98656 | B | 106837 | |
| 98657 | B | 106838 | |
| 98658 | B | 106839 | |
| 98659 | B | 106840 | |
| 98660 | B | 106841 | |
| 98661 | B | 106842 | |
| 98662 | B | 106843 | |
| 98663 | B | 106844 | |
| 98664 | B | 106845 | |
| 98665 | B | 106846 | |
| 98666 | B | 106847 | |
| 98667 | B | 106848 | |
| 98668 | B | 106849 | |
| 98669 | B | 106850 | |
| 98670 | B | 106851 | |
| 98671 | B | 106852 | |
| 98672 | B | 106853 | |
| 98673 | B | 106854 | |
| 98674 | B | 106855 | |
| 98675 | B | 106856 | |
| 98676 | B | 106857 | |
| 98677 | B | 106858 | |
| 98678 | B | 106859 | |
| 98679 | B | 106860 | |
| 98680 | B | 106861 | |
| 98681 | B | 106862 | |
| 98760 | B | 106941 | |
| 98761 | B | 106942 | |
| 99012 | B | 107193 | |
| 99013 | B | 107194 |