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 (98749,98758,99561,99570,99571,99572,99573,99580,99581,99582,99583,99584,99585,99586,99587,100067,100068,100069,100070,100071,100072,100150,100151,100152,100153,100154,100155,100156,100169,100170,100171,100172,100173,100174,100175,100176,100177,100178,100179,100180,100321,100322,100323,100324,100325,100326,100374,100375,100376,100377,100378,100379,100380,100381,100382,100383,100598,100599,100600,100601,100602,100603,100604,100605,100606,100607,100608,100609,100610,100611,100654,100655,100656,100657,100658,100659,100660,100661,100662,100663,100664,100696,100697,100698,100699,100884,100885,100886,100887,100900,100901,100902,100903,100904,100907,100908)) 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 |
|---|---|---|---|
| 98749 | B | 106930 | |
| 98758 | B | 106939 | |
| 99561 | B | 107742 | |
| 99570 | B | 107751 | |
| 99571 | B | 107752 | |
| 99572 | B | 107753 | |
| 99573 | B | 107754 | |
| 99580 | B | 107761 | |
| 99581 | B | 107762 | |
| 99582 | B | 107763 | |
| 99583 | B | 107764 | |
| 99584 | B | 107765 | |
| 99585 | B | 107766 | |
| 99586 | B | 107767 | |
| 99587 | B | 107768 | |
| 100067 | B | 108247 | |
| 100068 | B | 108248 | |
| 100069 | B | 108249 | |
| 100070 | B | 108250 | |
| 100071 | B | 108251 | |
| 100072 | B | 108252 | |
| 100150 | B | 108330 | |
| 100151 | B | 108331 | |
| 100152 | B | 108332 | |
| 100153 | B | 108333 | |
| 100154 | B | 108334 | |
| 100155 | B | 108335 | |
| 100156 | B | 108336 | |
| 100169 | B | 108349 | |
| 100170 | B | 108350 | |
| 100171 | B | 108351 | |
| 100172 | B | 108352 | |
| 100173 | B | 108353 | |
| 100174 | B | 108354 | |
| 100175 | B | 108355 | |
| 100176 | B | 108356 | |
| 100177 | B | 108357 | |
| 100178 | B | 108358 | |
| 100179 | B | 108359 | |
| 100180 | B | 108360 | |
| 100321 | B | 108501 | |
| 100322 | B | 108502 | |
| 100323 | B | 108503 | |
| 100324 | B | 108504 | |
| 100325 | B | 108505 | |
| 100326 | B | 108506 | |
| 100374 | B | 108554 | |
| 100375 | B | 108555 | |
| 100376 | B | 108556 | |
| 100377 | B | 108557 | |
| 100378 | B | 108558 | |
| 100379 | B | 108559 | |
| 100380 | B | 108560 | |
| 100381 | B | 108561 | |
| 100382 | B | 108562 | |
| 100383 | B | 108563 | |
| 100598 | B | 108778 | |
| 100599 | B | 108779 | |
| 100600 | B | 108780 | |
| 100601 | B | 108781 | |
| 100602 | B | 108782 | |
| 100603 | B | 108783 | |
| 100604 | B | 108784 | |
| 100605 | B | 108785 | |
| 100606 | B | 108786 | |
| 100607 | B | 108787 | |
| 100608 | B | 108788 | |
| 100609 | B | 108789 | |
| 100610 | B | 108790 | |
| 100611 | B | 108791 | |
| 100654 | B | 108834 | |
| 100655 | B | 108835 | |
| 100656 | B | 108836 | |
| 100657 | B | 108837 | |
| 100658 | B | 108838 | |
| 100659 | B | 108839 | |
| 100660 | B | 108840 | |
| 100661 | B | 108841 | |
| 100662 | B | 108842 | |
| 100663 | B | 108843 | |
| 100664 | B | 108844 | |
| 100696 | B | 108876 | |
| 100697 | B | 108877 | |
| 100698 | B | 108878 | |
| 100699 | B | 108879 | |
| 100884 | B | 109064 | |
| 100885 | B | 109065 | |
| 100886 | B | 109066 | |
| 100887 | B | 109067 | |
| 100900 | B | 109080 | |
| 100901 | B | 109081 | |
| 100902 | B | 109082 | |
| 100903 | B | 109083 | |
| 100904 | B | 109084 | |
| 100907 | B | 109087 | |
| 100908 | B | 109088 |