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 (91301,83112,83122,83132,89624,90066,86384,89618,89631,87370,89609,89610,89625,89638,90069,89634,89726,90091,90101,90078,85533,89015,90072,90077,84108,89621,89183,83102,92198,92199,92200,92201,92202,92444,92445,92446,92447,89622,89635,91372,91374,83091,91310,86387,84098,90086,90088,90098,83129,90085,91309,92146,83994,83995,83996,83997,92018,92106,89012,91302,91371,91373,86382,89192,85541,91370,92003,92004,92005,92006,92007,92008,92009,92091,92092,92093,92094,92095,92096,92097,92203,92449,91381,91383,83113,83123,83990,83991,83992,83993,89614,89627,83100,85532,91294,84106)) 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 |
|---|---|---|---|
| 83091 | D | 91129 | |
| 83100 | D | 91138 | |
| 83102 | D | 91140 | |
| 83112 | D | 91150 | |
| 83113 | D | 91151 | |
| 83122 | D | 91160 | |
| 83123 | D | 91161 | |
| 83129 | D | 91167 | |
| 83132 | D | 91170 | |
| 83990 | D | 92028 | |
| 83991 | D | 92029 | |
| 83992 | D | 92030 | |
| 83993 | D | 92031 | |
| 83994 | D | 92032 | |
| 83995 | D | 92033 | |
| 83996 | D | 92034 | |
| 83997 | D | 92035 | |
| 84098 | D | 92136 | |
| 84106 | D | 92144 | |
| 84108 | D | 92146 | |
| 85532 | D | 93570 | |
| 85533 | D | 93571 | |
| 85541 | D | 93579 | |
| 86382 | D | 94420 | |
| 86384 | D | 94422 | |
| 86387 | D | 94425 | |
| 87370 | D | 95408 | |
| 89012 | D | 97050 | |
| 89015 | D | 97053 | |
| 89183 | D | 97221 | |
| 89192 | D | 97230 | |
| 89609 | D | 97647 | |
| 89610 | D | 97648 | |
| 89614 | D | 97652 | |
| 89618 | D | 97656 | |
| 89621 | D | 97659 | |
| 89622 | D | 97660 | |
| 89624 | D | 97662 | |
| 89625 | D | 97663 | |
| 89627 | D | 97665 | |
| 89631 | D | 97669 | |
| 89634 | D | 97672 | |
| 89635 | D | 97673 | |
| 89638 | D | 97676 | |
| 89726 | D | 97764 | |
| 90066 | D | 98104 | |
| 90069 | D | 98107 | |
| 90072 | D | 98110 | |
| 90077 | D | 98115 | |
| 90078 | D | 98116 | |
| 90085 | D | 98123 | |
| 90086 | D | 98124 | |
| 90088 | D | 98126 | |
| 90091 | D | 98129 | |
| 90098 | D | 98136 | |
| 90101 | D | 98139 | |
| 91294 | D | 99367 | |
| 91301 | D | 99374 | |
| 91302 | D | 99375 | |
| 91309 | D | 99382 | |
| 91310 | D | 99383 | |
| 91370 | D | 99443 | |
| 91371 | D | 99444 | |
| 91372 | D | 99445 | |
| 91373 | D | 99446 | |
| 91374 | D | 99447 | |
| 91381 | D | 99454 | |
| 91383 | D | 99456 | |
| 92003 | D | 100081 | |
| 92004 | D | 100082 | |
| 92005 | D | 100083 | |
| 92006 | D | 100084 | |
| 92007 | D | 100085 | |
| 92008 | D | 100086 | |
| 92009 | D | 100087 | |
| 92018 | D | 100096 | |
| 92091 | D | 100169 | |
| 92092 | D | 100170 | |
| 92093 | D | 100171 | |
| 92094 | D | 100172 | |
| 92095 | D | 100173 | |
| 92096 | D | 100174 | |
| 92097 | D | 100175 | |
| 92106 | D | 100184 | |
| 92146 | D | 100224 | |
| 92198 | D | 100276 | |
| 92199 | D | 100277 | |
| 92200 | D | 100278 | |
| 92201 | D | 100279 | |
| 92202 | D | 100280 | |
| 92203 | D | 100281 | |
| 92444 | D | 100548 | |
| 92445 | D | 100549 | |
| 92446 | D | 100550 | |
| 92447 | D | 100551 | |
| 92449 | D | 100553 |