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 (90034,90035,90036,90037,87864,87866,90042,90043,90044,90045,90046,90047,90058,90059,84039,84230,84042,88098,84233,87831,87844,90014,90015,90016,90017,90026,90027,90028,90029,90030,90031,87850,88096,87860,87884,87886,87862,88315,91431,87829,87842,87848,87858,88314,87863,87865,87827,87840,87833,87846,87838,88308,88313,88320,88322,87856,87836,87854,87834,87852,92318,88254,92319,92321,92320,88259,88256,88257,85630,88258,87872,92317,88317,88318,88011,88255,88252,88061,92316,87871,88012,88309,88310,91432,88307,88253,88319,88321,85639,88010,88251,88306,88312,85640,88311,92892)) 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 |
|---|---|---|---|
| 84039 | D | 92077 | |
| 84042 | D | 92080 | |
| 84230 | D | 92268 | |
| 84233 | D | 92271 | |
| 85630 | D | 93668 | |
| 85639 | D | 93677 | |
| 85640 | D | 93678 | |
| 87827 | D | 95865 | |
| 87829 | D | 95867 | |
| 87831 | D | 95869 | |
| 87833 | D | 95871 | |
| 87834 | D | 95872 | |
| 87836 | D | 95874 | |
| 87838 | D | 95876 | |
| 87840 | D | 95878 | |
| 87842 | D | 95880 | |
| 87844 | D | 95882 | |
| 87846 | D | 95884 | |
| 87848 | D | 95886 | |
| 87850 | D | 95888 | |
| 87852 | D | 95890 | |
| 87854 | D | 95892 | |
| 87856 | D | 95894 | |
| 87858 | D | 95896 | |
| 87860 | D | 95898 | |
| 87862 | D | 95900 | |
| 87863 | D | 95901 | |
| 87864 | D | 95902 | |
| 87865 | D | 95903 | |
| 87866 | D | 95904 | |
| 87871 | D | 95909 | |
| 87872 | D | 95910 | |
| 87884 | D | 95922 | |
| 87886 | D | 95924 | |
| 88010 | D | 96048 | |
| 88011 | D | 96049 | |
| 88012 | D | 96050 | |
| 88061 | D | 96099 | |
| 88096 | D | 96134 | |
| 88098 | D | 96136 | |
| 88251 | D | 96289 | |
| 88252 | D | 96290 | |
| 88253 | D | 96291 | |
| 88254 | D | 96292 | |
| 88255 | D | 96293 | |
| 88256 | D | 96294 | |
| 88257 | D | 96295 | |
| 88258 | D | 96296 | |
| 88259 | D | 96297 | |
| 88306 | D | 96344 | |
| 88307 | D | 96345 | |
| 88308 | D | 96346 | |
| 88309 | D | 96347 | |
| 88310 | D | 96348 | |
| 88311 | D | 96349 | |
| 88312 | D | 96350 | |
| 88313 | D | 96351 | |
| 88314 | D | 96352 | |
| 88315 | D | 96353 | |
| 88317 | D | 96355 | |
| 88318 | D | 96356 | |
| 88319 | D | 96357 | |
| 88320 | D | 96358 | |
| 88321 | D | 96359 | |
| 88322 | D | 96360 | |
| 90014 | D | 98052 | |
| 90015 | D | 98053 | |
| 90016 | D | 98054 | |
| 90017 | D | 98055 | |
| 90026 | D | 98064 | |
| 90027 | D | 98065 | |
| 90028 | D | 98066 | |
| 90029 | D | 98067 | |
| 90030 | D | 98068 | |
| 90031 | D | 98069 | |
| 90034 | D | 98072 | |
| 90035 | D | 98073 | |
| 90036 | D | 98074 | |
| 90037 | D | 98075 | |
| 90042 | D | 98080 | |
| 90043 | D | 98081 | |
| 90044 | D | 98082 | |
| 90045 | D | 98083 | |
| 90046 | D | 98084 | |
| 90047 | D | 98085 | |
| 90058 | D | 98096 | |
| 90059 | D | 98097 | |
| 91431 | D | 99504 | |
| 91432 | D | 99505 | |
| 92316 | D | 100420 | |
| 92317 | D | 100421 | |
| 92318 | D | 100422 | |
| 92319 | D | 100423 | |
| 92320 | D | 100424 | |
| 92321 | D | 100425 | |
| 92892 | B | 101032 |