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 (96402,96403,96404,96405,96406,96407,96408,96409,96410,96411,96412,96413,96414,96415,96416,96417,96418,96419,96420,96421,96422,96423,96424,96425,96426,96427,96428,96429,96430,96431,96432,96433,96434,96435,96436,96437,96438,96439,96440,96441,96442,96443,96444,96445,96446,96447,96448,96449,96450,96451,96452,96453,96454,96455,96456,96457,96458,96459,96460,96461,96462,96463,96464,96465,96466,96467,96468,96469,96470,96471,96472,96473,96474,96475,96476,96477,96478,96479,96480,96481,96482,96483,96484,96485,96486,96487,96488,96489,97802,97803,97804,97805,97806,97807,97808,97809)) 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 |
|---|---|---|---|
| 96402 | B | 104583 | |
| 96403 | B | 104584 | |
| 96404 | B | 104585 | |
| 96405 | B | 104586 | |
| 96406 | B | 104587 | |
| 96407 | B | 104588 | |
| 96408 | B | 104589 | |
| 96409 | B | 104590 | |
| 96410 | B | 104591 | |
| 96411 | B | 104592 | |
| 96412 | B | 104593 | |
| 96413 | B | 104594 | |
| 96414 | B | 104595 | |
| 96415 | B | 104596 | |
| 96416 | B | 104597 | |
| 96417 | B | 104598 | |
| 96418 | B | 104599 | |
| 96419 | B | 104600 | |
| 96420 | B | 104601 | |
| 96421 | B | 104602 | |
| 96422 | B | 104603 | |
| 96423 | B | 104604 | |
| 96424 | B | 104605 | |
| 96425 | B | 104606 | |
| 96426 | B | 104607 | |
| 96427 | B | 104608 | |
| 96428 | B | 104609 | |
| 96429 | B | 104610 | |
| 96430 | B | 104611 | |
| 96431 | B | 104612 | |
| 96432 | B | 104613 | |
| 96433 | B | 104614 | |
| 96434 | B | 104615 | |
| 96435 | B | 104616 | |
| 96436 | B | 104617 | |
| 96437 | B | 104618 | |
| 96438 | B | 104619 | |
| 96439 | B | 104620 | |
| 96440 | B | 104621 | |
| 96441 | B | 104622 | |
| 96442 | B | 104623 | |
| 96443 | B | 104624 | |
| 96444 | B | 104625 | |
| 96445 | B | 104626 | |
| 96446 | B | 104627 | |
| 96447 | B | 104628 | |
| 96448 | B | 104629 | |
| 96449 | B | 104630 | |
| 96450 | B | 104631 | |
| 96451 | B | 104632 | |
| 96452 | B | 104633 | |
| 96453 | B | 104634 | |
| 96454 | B | 104635 | |
| 96455 | B | 104636 | |
| 96456 | B | 104637 | |
| 96457 | B | 104638 | |
| 96458 | B | 104639 | |
| 96459 | B | 104640 | |
| 96460 | B | 104641 | |
| 96461 | B | 104642 | |
| 96462 | B | 104643 | |
| 96463 | B | 104644 | |
| 96464 | B | 104645 | |
| 96465 | B | 104646 | |
| 96466 | B | 104647 | |
| 96467 | B | 104648 | |
| 96468 | B | 104649 | |
| 96469 | B | 104650 | |
| 96470 | B | 104651 | |
| 96471 | B | 104652 | |
| 96472 | B | 104653 | |
| 96473 | B | 104654 | |
| 96474 | B | 104655 | |
| 96475 | B | 104656 | |
| 96476 | B | 104657 | |
| 96477 | B | 104658 | |
| 96478 | B | 104659 | |
| 96479 | B | 104660 | |
| 96480 | B | 104661 | |
| 96481 | B | 104662 | |
| 96482 | B | 104663 | |
| 96483 | B | 104664 | |
| 96484 | B | 104665 | |
| 96485 | B | 104666 | |
| 96486 | B | 104667 | |
| 96487 | B | 104668 | |
| 96488 | B | 104669 | |
| 96489 | B | 104670 | |
| 97802 | B | 105983 | |
| 97803 | B | 105984 | |
| 97804 | B | 105985 | |
| 97805 | B | 105986 | |
| 97806 | B | 105987 | |
| 97807 | B | 105988 | |
| 97808 | B | 105989 | |
| 97809 | B | 105990 |