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 (99033,99034,99035,99036,99037,99038,99039,99040,99041,99042,99043,99044,99045,99046,99047,99048,99049,99050,99051,99052,99053,99054,99055,99189,99190,99191,99239,99282,99283,99284,99285,99286,99287,99288,99289,99290,99291,99292,99293,99294,99295,99296,99297,99298,99299,99300,99301,99302,99303,99304,99305,99306,99307,99308,99309,99310,99311,99312,99319,99320,99321,99356,99357,99358,99359,99360,99361,99362,99363,99364,99365,99366,99367,99368,99374,99375,99376,99377,99378,99379,99380,99381,99382,99383,99384,99385,99386,99387,99388,99389,99390,99391,99392,99393,99394,99395)) 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 |
|---|---|---|---|
| 99033 | B | 107214 | |
| 99034 | B | 107215 | |
| 99035 | B | 107216 | |
| 99036 | B | 107217 | |
| 99037 | B | 107218 | |
| 99038 | B | 107219 | |
| 99039 | B | 107220 | |
| 99040 | B | 107221 | |
| 99041 | B | 107222 | |
| 99042 | B | 107223 | |
| 99043 | B | 107224 | |
| 99044 | B | 107225 | |
| 99045 | B | 107226 | |
| 99046 | B | 107227 | |
| 99047 | B | 107228 | |
| 99048 | B | 107229 | |
| 99049 | B | 107230 | |
| 99050 | B | 107231 | |
| 99051 | B | 107232 | |
| 99052 | B | 107233 | |
| 99053 | B | 107234 | |
| 99054 | B | 107235 | |
| 99055 | B | 107236 | |
| 99189 | B | 107370 | |
| 99190 | B | 107371 | |
| 99191 | B | 107372 | |
| 99239 | B | 107420 | |
| 99282 | B | 107463 | |
| 99283 | B | 107464 | |
| 99284 | B | 107465 | |
| 99285 | B | 107466 | |
| 99286 | B | 107467 | |
| 99287 | B | 107468 | |
| 99288 | B | 107469 | |
| 99289 | B | 107470 | |
| 99290 | B | 107471 | |
| 99291 | B | 107472 | |
| 99292 | B | 107473 | |
| 99293 | B | 107474 | |
| 99294 | B | 107475 | |
| 99295 | B | 107476 | |
| 99296 | B | 107477 | |
| 99297 | B | 107478 | |
| 99298 | B | 107479 | |
| 99299 | B | 107480 | |
| 99300 | B | 107481 | |
| 99301 | B | 107482 | |
| 99302 | B | 107483 | |
| 99303 | B | 107484 | |
| 99304 | B | 107485 | |
| 99305 | B | 107486 | |
| 99306 | B | 107487 | |
| 99307 | B | 107488 | |
| 99308 | B | 107489 | |
| 99309 | B | 107490 | |
| 99310 | B | 107491 | |
| 99311 | B | 107492 | |
| 99312 | B | 107493 | |
| 99319 | B | 107500 | |
| 99320 | B | 107501 | |
| 99321 | B | 107502 | |
| 99356 | B | 107537 | |
| 99357 | B | 107538 | |
| 99358 | B | 107539 | |
| 99359 | B | 107540 | |
| 99360 | B | 107541 | |
| 99361 | B | 107542 | |
| 99362 | B | 107543 | |
| 99363 | B | 107544 | |
| 99364 | B | 107545 | |
| 99365 | B | 107546 | |
| 99366 | B | 107547 | |
| 99367 | B | 107548 | |
| 99368 | B | 107549 | |
| 99374 | B | 107555 | |
| 99375 | B | 107556 | |
| 99376 | B | 107557 | |
| 99377 | B | 107558 | |
| 99378 | B | 107559 | |
| 99379 | B | 107560 | |
| 99380 | B | 107561 | |
| 99381 | B | 107562 | |
| 99382 | B | 107563 | |
| 99383 | B | 107564 | |
| 99384 | B | 107565 | |
| 99385 | B | 107566 | |
| 99386 | B | 107567 | |
| 99387 | B | 107568 | |
| 99388 | B | 107569 | |
| 99389 | B | 107570 | |
| 99390 | B | 107571 | |
| 99391 | B | 107572 | |
| 99392 | B | 107573 | |
| 99393 | B | 107574 | |
| 99394 | B | 107575 | |
| 99395 | B | 107576 |