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 (97553,97554,97555,97556,97557,97558,97559,97560,97561,97562,97563,97564,97565,97566,97568,97569,97571,97572,97587,97588,97589,97590,97591,97592,97593,97594,97595,97596,97597,97598,97599,97600,97601,97602,97603,97604,97605,97606,97607,97713,97714,97715,97953,97954,97955,97956,97957,97958,97994,97995,97996,97997,97998,97999,98000,98024,98025,98026,98027,98028,98029,98457,98458,98459,98460,98461,98462,98463,98464,98465,98466,98467,98468,98469,98470,98471,98472,98473,98474,98475,98496,98497,98498,98499,98500,98501,98515,98521,98522,99026,99027,99028,99029,99030,99031,99032)) 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 |
|---|---|---|---|
| 97553 | B | 105734 | |
| 97554 | B | 105735 | |
| 97555 | B | 105736 | |
| 97556 | B | 105737 | |
| 97557 | B | 105738 | |
| 97558 | B | 105739 | |
| 97559 | B | 105740 | |
| 97560 | B | 105741 | |
| 97561 | B | 105742 | |
| 97562 | B | 105743 | |
| 97563 | B | 105744 | |
| 97564 | B | 105745 | |
| 97565 | B | 105746 | |
| 97566 | B | 105747 | |
| 97568 | B | 105749 | |
| 97569 | B | 105750 | |
| 97571 | B | 105752 | |
| 97572 | B | 105753 | |
| 97587 | B | 105768 | |
| 97588 | B | 105769 | |
| 97589 | B | 105770 | |
| 97590 | B | 105771 | |
| 97591 | B | 105772 | |
| 97592 | B | 105773 | |
| 97593 | B | 105774 | |
| 97594 | B | 105775 | |
| 97595 | B | 105776 | |
| 97596 | B | 105777 | |
| 97597 | B | 105778 | |
| 97598 | B | 105779 | |
| 97599 | B | 105780 | |
| 97600 | B | 105781 | |
| 97601 | B | 105782 | |
| 97602 | B | 105783 | |
| 97603 | B | 105784 | |
| 97604 | B | 105785 | |
| 97605 | B | 105786 | |
| 97606 | B | 105787 | |
| 97607 | B | 105788 | |
| 97713 | B | 105894 | |
| 97714 | B | 105895 | |
| 97715 | B | 105896 | |
| 97953 | B | 106134 | |
| 97954 | B | 106135 | |
| 97955 | B | 106136 | |
| 97956 | B | 106137 | |
| 97957 | B | 106138 | |
| 97958 | B | 106139 | |
| 97994 | B | 106175 | |
| 97995 | B | 106176 | |
| 97996 | B | 106177 | |
| 97997 | B | 106178 | |
| 97998 | B | 106179 | |
| 97999 | B | 106180 | |
| 98000 | B | 106181 | |
| 98024 | B | 106205 | |
| 98025 | B | 106206 | |
| 98026 | B | 106207 | |
| 98027 | B | 106208 | |
| 98028 | B | 106209 | |
| 98029 | B | 106210 | |
| 98457 | B | 106638 | |
| 98458 | B | 106639 | |
| 98459 | B | 106640 | |
| 98460 | B | 106641 | |
| 98461 | B | 106642 | |
| 98462 | B | 106643 | |
| 98463 | B | 106644 | |
| 98464 | B | 106645 | |
| 98465 | B | 106646 | |
| 98466 | B | 106647 | |
| 98467 | B | 106648 | |
| 98468 | B | 106649 | |
| 98469 | B | 106650 | |
| 98470 | B | 106651 | |
| 98471 | B | 106652 | |
| 98472 | B | 106653 | |
| 98473 | B | 106654 | |
| 98474 | B | 106655 | |
| 98475 | B | 106656 | |
| 98496 | B | 106677 | |
| 98497 | B | 106678 | |
| 98498 | B | 106679 | |
| 98499 | B | 106680 | |
| 98500 | B | 106681 | |
| 98501 | B | 106682 | |
| 98515 | B | 106696 | |
| 98521 | B | 106702 | |
| 98522 | B | 106703 | |
| 99026 | B | 107207 | |
| 99027 | B | 107208 | |
| 99028 | B | 107209 | |
| 99029 | B | 107210 | |
| 99030 | B | 107211 | |
| 99031 | B | 107212 | |
| 99032 | B | 107213 |