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 (87148,87149,87150,87151,87152,87153,87286,87154,87155,87156,87157,87158,87159,87287,87142,87143,87144,87145,87146,87147,87285,87172,87173,87174,87175,87176,87177,87160,87161,87162,87163,87164,87165,87166,87167,87168,87169,87170,87171,87136,87137,87138,87139,87140,87141,87284,89575,84701,88959,88960,88962,85801,85802,84700,88961,85800,88957,88958,88942,88969,88970,88973,88974,88967,88968,88971,88972,88955,88956,88953,88954,87879,84704,84707,91054,88509,88513,88950,88951,88952,88142,88145,89572,87878,89573,84696,88938,84699,88516,88519,88940,84703,84706,91053,88941,88512)) 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 |
|---|---|---|---|
| 84696 | D | 92734 | |
| 84699 | D | 92737 | |
| 84700 | D | 92738 | |
| 84701 | D | 92739 | |
| 84703 | D | 92741 | |
| 84704 | D | 92742 | |
| 84706 | D | 92744 | |
| 84707 | D | 92745 | |
| 85800 | D | 93838 | |
| 85801 | D | 93839 | |
| 85802 | D | 93840 | |
| 87136 | D | 95174 | |
| 87137 | D | 95175 | |
| 87138 | D | 95176 | |
| 87139 | D | 95177 | |
| 87140 | D | 95178 | |
| 87141 | D | 95179 | |
| 87142 | D | 95180 | |
| 87143 | D | 95181 | |
| 87144 | D | 95182 | |
| 87145 | D | 95183 | |
| 87146 | D | 95184 | |
| 87147 | D | 95185 | |
| 87148 | D | 95186 | |
| 87149 | D | 95187 | |
| 87150 | D | 95188 | |
| 87151 | D | 95189 | |
| 87152 | D | 95190 | |
| 87153 | D | 95191 | |
| 87154 | D | 95192 | |
| 87155 | D | 95193 | |
| 87156 | D | 95194 | |
| 87157 | D | 95195 | |
| 87158 | D | 95196 | |
| 87159 | D | 95197 | |
| 87160 | D | 95198 | |
| 87161 | D | 95199 | |
| 87162 | D | 95200 | |
| 87163 | D | 95201 | |
| 87164 | D | 95202 | |
| 87165 | D | 95203 | |
| 87166 | D | 95204 | |
| 87167 | D | 95205 | |
| 87168 | D | 95206 | |
| 87169 | D | 95207 | |
| 87170 | D | 95208 | |
| 87171 | D | 95209 | |
| 87172 | D | 95210 | |
| 87173 | D | 95211 | |
| 87174 | D | 95212 | |
| 87175 | D | 95213 | |
| 87176 | D | 95214 | |
| 87177 | D | 95215 | |
| 87284 | D | 95322 | |
| 87285 | D | 95323 | |
| 87286 | D | 95324 | |
| 87287 | D | 95325 | |
| 87878 | D | 95916 | |
| 87879 | D | 95917 | |
| 88142 | D | 96180 | |
| 88145 | D | 96183 | |
| 88509 | D | 96547 | |
| 88512 | D | 96550 | |
| 88513 | D | 96551 | |
| 88516 | D | 96554 | |
| 88519 | D | 96557 | |
| 88938 | D | 96976 | |
| 88940 | D | 96978 | |
| 88941 | D | 96979 | |
| 88942 | D | 96980 | |
| 88950 | D | 96988 | |
| 88951 | D | 96989 | |
| 88952 | D | 96990 | |
| 88953 | D | 96991 | |
| 88954 | D | 96992 | |
| 88955 | D | 96993 | |
| 88956 | D | 96994 | |
| 88957 | D | 96995 | |
| 88958 | D | 96996 | |
| 88959 | D | 96997 | |
| 88960 | D | 96998 | |
| 88961 | D | 96999 | |
| 88962 | D | 97000 | |
| 88967 | D | 97005 | |
| 88968 | D | 97006 | |
| 88969 | D | 97007 | |
| 88970 | D | 97008 | |
| 88971 | D | 97009 | |
| 88972 | D | 97010 | |
| 88973 | D | 97011 | |
| 88974 | D | 97012 | |
| 89572 | D | 97610 | |
| 89573 | D | 97611 | |
| 89575 | D | 97613 | |
| 91053 | D | 99126 | |
| 91054 | D | 99127 |