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 (97437,97438,97439,97440,97441,97442,97443,97444,97445,97446,97447,97448,97449,97450,97451,97452,97453,97454,97455,97456,97457,97458,97459,97460,97461,97462,97463,97464,97465,97466,97467,97468,97469,97470,97471,97472,97473,97474,97475,97476,97477,97478,97479,97480,97481,97482,97483,97484,97485,97486,97487,97488,97489,97490,97491,97492,97493,97494,97495,97496,97497,97498,97499,97500,97501,97502,97503,97504,97505,97525,97526,97527,97528,97529,97530,97531,97532,97533,99068,99069,99070,99071,99072,99073,99074,99075,99076,99077,99078,99079,99080,99081,99082,99083,99084,99085)) 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 |
|---|---|---|---|
| 97437 | B | 105618 | |
| 97438 | B | 105619 | |
| 97439 | B | 105620 | |
| 97440 | B | 105621 | |
| 97441 | B | 105622 | |
| 97442 | B | 105623 | |
| 97443 | B | 105624 | |
| 97444 | B | 105625 | |
| 97445 | B | 105626 | |
| 97446 | B | 105627 | |
| 97447 | B | 105628 | |
| 97448 | B | 105629 | |
| 97449 | B | 105630 | |
| 97450 | B | 105631 | |
| 97451 | B | 105632 | |
| 97452 | B | 105633 | |
| 97453 | B | 105634 | |
| 97454 | B | 105635 | |
| 97455 | B | 105636 | |
| 97456 | B | 105637 | |
| 97457 | B | 105638 | |
| 97458 | B | 105639 | |
| 97459 | B | 105640 | |
| 97460 | B | 105641 | |
| 97461 | B | 105642 | |
| 97462 | B | 105643 | |
| 97463 | B | 105644 | |
| 97464 | B | 105645 | |
| 97465 | B | 105646 | |
| 97466 | B | 105647 | |
| 97467 | B | 105648 | |
| 97468 | B | 105649 | |
| 97469 | B | 105650 | |
| 97470 | B | 105651 | |
| 97471 | B | 105652 | |
| 97472 | B | 105653 | |
| 97473 | B | 105654 | |
| 97474 | B | 105655 | |
| 97475 | B | 105656 | |
| 97476 | B | 105657 | |
| 97477 | B | 105658 | |
| 97478 | B | 105659 | |
| 97479 | B | 105660 | |
| 97480 | B | 105661 | |
| 97481 | B | 105662 | |
| 97482 | B | 105663 | |
| 97483 | B | 105664 | |
| 97484 | B | 105665 | |
| 97485 | B | 105666 | |
| 97486 | B | 105667 | |
| 97487 | B | 105668 | |
| 97488 | B | 105669 | |
| 97489 | B | 105670 | |
| 97490 | B | 105671 | |
| 97491 | B | 105672 | |
| 97492 | B | 105673 | |
| 97493 | B | 105674 | |
| 97494 | B | 105675 | |
| 97495 | B | 105676 | |
| 97496 | B | 105677 | |
| 97497 | B | 105678 | |
| 97498 | B | 105679 | |
| 97499 | B | 105680 | |
| 97500 | B | 105681 | |
| 97501 | B | 105682 | |
| 97502 | B | 105683 | |
| 97503 | B | 105684 | |
| 97504 | B | 105685 | |
| 97505 | B | 105686 | |
| 97525 | B | 105706 | |
| 97526 | B | 105707 | |
| 97527 | B | 105708 | |
| 97528 | B | 105709 | |
| 97529 | B | 105710 | |
| 97530 | B | 105711 | |
| 97531 | B | 105712 | |
| 97532 | B | 105713 | |
| 97533 | B | 105714 | |
| 99068 | B | 107249 | |
| 99069 | B | 107250 | |
| 99070 | B | 107251 | |
| 99071 | B | 107252 | |
| 99072 | B | 107253 | |
| 99073 | B | 107254 | |
| 99074 | B | 107255 | |
| 99075 | B | 107256 | |
| 99076 | B | 107257 | |
| 99077 | B | 107258 | |
| 99078 | B | 107259 | |
| 99079 | B | 107260 | |
| 99080 | B | 107261 | |
| 99081 | B | 107262 | |
| 99082 | B | 107263 | |
| 99083 | B | 107264 | |
| 99084 | B | 107265 | |
| 99085 | B | 107266 |