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 (89394,89396,89390,89392,89388,89395,89397,89410,89411,89412,82420,89360,89363,89365,82354,89359,89297,89362,89364,89296,89391,89393,89406,89408,89407,90843,82421,89302,89389,89300,82381,89301,89299,89349,89334,89350,89263,89336,82355,89353,82380,89333,89354,86823,89355,89356,89335,89293,89291,89370,89262,89372,89273,89276,89369,89371,89374,89292,89287,86819,86821,89272,89275,89357,89271,89274,89358,86822,89327,89373,89266,89328,89329,89269,89402,89404,89403,89331,89265,89330,89264,86817,89368,89268,89367,89308,89267,86818,86820,89295,89332,89294,89405,89309,89321,89257)) 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 |
|---|---|---|---|
| 82354 | D | 90392 | |
| 82355 | D | 90393 | |
| 82380 | D | 90418 | |
| 82381 | D | 90419 | |
| 82420 | D | 90458 | |
| 82421 | D | 90459 | |
| 86817 | D | 94855 | |
| 86818 | D | 94856 | |
| 86819 | D | 94857 | |
| 86820 | D | 94858 | |
| 86821 | D | 94859 | |
| 86822 | D | 94860 | |
| 86823 | D | 94861 | |
| 89257 | D | 97295 | |
| 89262 | D | 97300 | |
| 89263 | D | 97301 | |
| 89264 | D | 97302 | |
| 89265 | D | 97303 | |
| 89266 | D | 97304 | |
| 89267 | D | 97305 | |
| 89268 | D | 97306 | |
| 89269 | D | 97307 | |
| 89271 | D | 97309 | |
| 89272 | D | 97310 | |
| 89273 | D | 97311 | |
| 89274 | D | 97312 | |
| 89275 | D | 97313 | |
| 89276 | D | 97314 | |
| 89287 | D | 97325 | |
| 89291 | D | 97329 | |
| 89292 | D | 97330 | |
| 89293 | D | 97331 | |
| 89294 | D | 97332 | |
| 89295 | D | 97333 | |
| 89296 | D | 97334 | |
| 89297 | D | 97335 | |
| 89299 | D | 97337 | |
| 89300 | D | 97338 | |
| 89301 | D | 97339 | |
| 89302 | D | 97340 | |
| 89308 | D | 97346 | |
| 89309 | D | 97347 | |
| 89321 | D | 97359 | |
| 89327 | D | 97365 | |
| 89328 | D | 97366 | |
| 89329 | D | 97367 | |
| 89330 | D | 97368 | |
| 89331 | D | 97369 | |
| 89332 | D | 97370 | |
| 89333 | D | 97371 | |
| 89334 | D | 97372 | |
| 89335 | D | 97373 | |
| 89336 | D | 97374 | |
| 89349 | D | 97387 | |
| 89350 | D | 97388 | |
| 89353 | D | 97391 | |
| 89354 | D | 97392 | |
| 89355 | D | 97393 | |
| 89356 | D | 97394 | |
| 89357 | D | 97395 | |
| 89358 | D | 97396 | |
| 89359 | D | 97397 | |
| 89360 | D | 97398 | |
| 89362 | D | 97400 | |
| 89363 | D | 97401 | |
| 89364 | D | 97402 | |
| 89365 | D | 97403 | |
| 89367 | D | 97405 | |
| 89368 | D | 97406 | |
| 89369 | D | 97407 | |
| 89370 | D | 97408 | |
| 89371 | D | 97409 | |
| 89372 | D | 97410 | |
| 89373 | D | 97411 | |
| 89374 | D | 97412 | |
| 89388 | D | 97426 | |
| 89389 | D | 97427 | |
| 89390 | D | 97428 | |
| 89391 | D | 97429 | |
| 89392 | D | 97430 | |
| 89393 | D | 97431 | |
| 89394 | D | 97432 | |
| 89395 | D | 97433 | |
| 89396 | D | 97434 | |
| 89397 | D | 97435 | |
| 89402 | D | 97440 | |
| 89403 | D | 97441 | |
| 89404 | D | 97442 | |
| 89405 | D | 97443 | |
| 89406 | D | 97444 | |
| 89407 | D | 97445 | |
| 89408 | D | 97446 | |
| 89410 | D | 97448 | |
| 89411 | D | 97449 | |
| 89412 | D | 97450 | |
| 90843 | D | 98905 |