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 (97272,97273,97274,97275,97276,97277,97278,97279,97280,97281,97282,97283,97284,97285,97286,97287,97288,97289,97290,97291,97292,97293,97294,97295,97296,97297,97298,97299,97300,97301,97302,97303,97304,97305,97306,97307,97308,97309,97310,97311,97312,97313,97314,97315,97316,97317,97318,97319,97320,97321,97322,97323,97324,97325,97326,97327,97328,97329,97330,97331,97332,97333,97334,97335,97336,97337,97338,97339,97340,97341,97342,97343,97344,97345,97346,97347,97348,97349,97350,97351,97352,97353,97354,97355,97356,97357,97358,97359,97360,97361,97362,97363,97364,97365,97366,97367)) 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 |
|---|---|---|---|
| 97272 | B | 105453 | |
| 97273 | B | 105454 | |
| 97274 | B | 105455 | |
| 97275 | B | 105456 | |
| 97276 | B | 105457 | |
| 97277 | B | 105458 | |
| 97278 | B | 105459 | |
| 97279 | B | 105460 | |
| 97280 | B | 105461 | |
| 97281 | B | 105462 | |
| 97282 | B | 105463 | |
| 97283 | B | 105464 | |
| 97284 | B | 105465 | |
| 97285 | B | 105466 | |
| 97286 | B | 105467 | |
| 97287 | B | 105468 | |
| 97288 | B | 105469 | |
| 97289 | B | 105470 | |
| 97290 | B | 105471 | |
| 97291 | B | 105472 | |
| 97292 | B | 105473 | |
| 97293 | B | 105474 | |
| 97294 | B | 105475 | |
| 97295 | B | 105476 | |
| 97296 | B | 105477 | |
| 97297 | B | 105478 | |
| 97298 | B | 105479 | |
| 97299 | B | 105480 | |
| 97300 | B | 105481 | |
| 97301 | B | 105482 | |
| 97302 | B | 105483 | |
| 97303 | B | 105484 | |
| 97304 | B | 105485 | |
| 97305 | B | 105486 | |
| 97306 | B | 105487 | |
| 97307 | B | 105488 | |
| 97308 | B | 105489 | |
| 97309 | B | 105490 | |
| 97310 | B | 105491 | |
| 97311 | B | 105492 | |
| 97312 | B | 105493 | |
| 97313 | B | 105494 | |
| 97314 | B | 105495 | |
| 97315 | B | 105496 | |
| 97316 | B | 105497 | |
| 97317 | B | 105498 | |
| 97318 | B | 105499 | |
| 97319 | B | 105500 | |
| 97320 | B | 105501 | |
| 97321 | B | 105502 | |
| 97322 | B | 105503 | |
| 97323 | B | 105504 | |
| 97324 | B | 105505 | |
| 97325 | B | 105506 | |
| 97326 | B | 105507 | |
| 97327 | B | 105508 | |
| 97328 | B | 105509 | |
| 97329 | B | 105510 | |
| 97330 | B | 105511 | |
| 97331 | B | 105512 | |
| 97332 | B | 105513 | |
| 97333 | B | 105514 | |
| 97334 | B | 105515 | |
| 97335 | B | 105516 | |
| 97336 | B | 105517 | |
| 97337 | B | 105518 | |
| 97338 | B | 105519 | |
| 97339 | B | 105520 | |
| 97340 | B | 105521 | |
| 97341 | B | 105522 | |
| 97342 | B | 105523 | |
| 97343 | B | 105524 | |
| 97344 | B | 105525 | |
| 97345 | B | 105526 | |
| 97346 | B | 105527 | |
| 97347 | B | 105528 | |
| 97348 | B | 105529 | |
| 97349 | B | 105530 | |
| 97350 | B | 105531 | |
| 97351 | B | 105532 | |
| 97352 | B | 105533 | |
| 97353 | B | 105534 | |
| 97354 | B | 105535 | |
| 97355 | B | 105536 | |
| 97356 | B | 105537 | |
| 97357 | B | 105538 | |
| 97358 | B | 105539 | |
| 97359 | B | 105540 | |
| 97360 | B | 105541 | |
| 97361 | B | 105542 | |
| 97362 | B | 105543 | |
| 97363 | B | 105544 | |
| 97364 | B | 105545 | |
| 97365 | B | 105546 | |
| 97366 | B | 105547 | |
| 97367 | B | 105548 |