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 (92503,92504,92505,92506,92507,92192,92193,92194,92195,92196,92204,92205,92206,92207,92208,92209,92442,92443,92448,92147,92148,92149,92349,92350,92351,92352,89643,89646,89524,83998,84000,84002,84004,84034,90075,90062,84022,84023,84024,84025,84037,89617,89630,83955,83957,83959,83961,92067,92068,92069,92070,92071,92072,92073,92083,92084,92085,92086,92087,92088,92089,91297,92139,92140,92141,92142,92143,92144,92145,86380,92043,92044,92045,92046,92047,92048,92049,92059,92060,92061,92062,92063,92064,92065,92075,92076,92077,92078,92079,92080,92081,92131,92132,92133,92134,92135)) 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 |
|---|---|---|---|
| 83955 | D | 91993 | |
| 83957 | D | 91995 | |
| 83959 | D | 91997 | |
| 83961 | D | 91999 | |
| 83998 | D | 92036 | |
| 84000 | D | 92038 | |
| 84002 | D | 92040 | |
| 84004 | D | 92042 | |
| 84022 | D | 92060 | |
| 84023 | D | 92061 | |
| 84024 | D | 92062 | |
| 84025 | D | 92063 | |
| 84034 | D | 92072 | |
| 84037 | D | 92075 | |
| 86380 | D | 94418 | |
| 89524 | D | 97562 | |
| 89617 | D | 97655 | |
| 89630 | D | 97668 | |
| 89643 | D | 97681 | |
| 89646 | D | 97684 | |
| 90062 | D | 98100 | |
| 90075 | D | 98113 | |
| 91297 | D | 99370 | |
| 92043 | D | 100121 | |
| 92044 | D | 100122 | |
| 92045 | D | 100123 | |
| 92046 | D | 100124 | |
| 92047 | D | 100125 | |
| 92048 | D | 100126 | |
| 92049 | D | 100127 | |
| 92059 | D | 100137 | |
| 92060 | D | 100138 | |
| 92061 | D | 100139 | |
| 92062 | D | 100140 | |
| 92063 | D | 100141 | |
| 92064 | D | 100142 | |
| 92065 | D | 100143 | |
| 92067 | D | 100145 | |
| 92068 | D | 100146 | |
| 92069 | D | 100147 | |
| 92070 | D | 100148 | |
| 92071 | D | 100149 | |
| 92072 | D | 100150 | |
| 92073 | D | 100151 | |
| 92075 | D | 100153 | |
| 92076 | D | 100154 | |
| 92077 | D | 100155 | |
| 92078 | D | 100156 | |
| 92079 | D | 100157 | |
| 92080 | D | 100158 | |
| 92081 | D | 100159 | |
| 92083 | D | 100161 | |
| 92084 | D | 100162 | |
| 92085 | D | 100163 | |
| 92086 | D | 100164 | |
| 92087 | D | 100165 | |
| 92088 | D | 100166 | |
| 92089 | D | 100167 | |
| 92131 | D | 100209 | |
| 92132 | D | 100210 | |
| 92133 | D | 100211 | |
| 92134 | D | 100212 | |
| 92135 | D | 100213 | |
| 92139 | D | 100217 | |
| 92140 | D | 100218 | |
| 92141 | D | 100219 | |
| 92142 | D | 100220 | |
| 92143 | D | 100221 | |
| 92144 | D | 100222 | |
| 92145 | D | 100223 | |
| 92147 | D | 100225 | |
| 92148 | D | 100226 | |
| 92149 | D | 100227 | |
| 92192 | D | 100270 | |
| 92193 | D | 100271 | |
| 92194 | D | 100272 | |
| 92195 | D | 100273 | |
| 92196 | D | 100274 | |
| 92204 | D | 100282 | |
| 92205 | D | 100283 | |
| 92206 | D | 100284 | |
| 92207 | D | 100285 | |
| 92208 | D | 100286 | |
| 92209 | D | 100287 | |
| 92349 | D | 100453 | |
| 92350 | D | 100454 | |
| 92351 | D | 100455 | |
| 92352 | D | 100456 | |
| 92442 | D | 100546 | |
| 92443 | D | 100547 | |
| 92448 | D | 100552 | |
| 92503 | D | 100607 | |
| 92504 | D | 100608 | |
| 92505 | D | 100609 | |
| 92506 | D | 100610 | |
| 92507 | D | 100611 |