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 (95977,95978,95979,95980,95981,95982,95983,95984,95985,95986,95987,95988,95989,95990,95991,95992,95993,95994,95995,95996,95997,95998,95999,96000,96001,96002,96003,96004,96005,96006,96007,96008,96009,96010,96011,96012,96013,96014,96015,96016,96017,96018,96019,96020,96021,96022,96023,96024,96025,96026,96027,96028,96029,96030,96031,96032,96033,96034,96035,96036,96037,96038,96039,96040,96041,96042,96043,96044,96045,96046,96047,96048,96049,96050,96051,96052,96053,96054,96055,96056,96057,96058,96059,96060,96061,96062,96063,96064,96065,96066,96067,96068,96069,96070,96071,96072)) 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 |
|---|---|---|---|
| 95977 | B | 104149 | |
| 95978 | B | 104150 | |
| 95979 | B | 104151 | |
| 95980 | B | 104152 | |
| 95981 | B | 104153 | |
| 95982 | B | 104154 | |
| 95983 | B | 104155 | |
| 95984 | B | 104156 | |
| 95985 | B | 104157 | |
| 95986 | B | 104158 | |
| 95987 | B | 104159 | |
| 95988 | B | 104160 | |
| 95989 | B | 104161 | |
| 95990 | B | 104162 | |
| 95991 | B | 104163 | |
| 95992 | B | 104164 | |
| 95993 | B | 104165 | |
| 95994 | B | 104166 | |
| 95995 | B | 104167 | |
| 95996 | B | 104168 | |
| 95997 | B | 104169 | |
| 95998 | B | 104170 | |
| 95999 | B | 104171 | |
| 96000 | B | 104172 | |
| 96001 | B | 104173 | |
| 96002 | B | 104174 | |
| 96003 | B | 104175 | |
| 96004 | B | 104176 | |
| 96005 | B | 104177 | |
| 96006 | B | 104178 | |
| 96007 | B | 104179 | |
| 96008 | B | 104180 | |
| 96009 | B | 104181 | |
| 96010 | B | 104182 | |
| 96011 | B | 104183 | |
| 96012 | B | 104184 | |
| 96013 | B | 104185 | |
| 96014 | B | 104186 | |
| 96015 | B | 104187 | |
| 96016 | B | 104188 | |
| 96017 | B | 104189 | |
| 96018 | B | 104190 | |
| 96019 | B | 104191 | |
| 96020 | B | 104192 | |
| 96021 | B | 104193 | |
| 96022 | B | 104194 | |
| 96023 | B | 104195 | |
| 96024 | B | 104196 | |
| 96025 | B | 104197 | |
| 96026 | B | 104198 | |
| 96027 | B | 104199 | |
| 96028 | B | 104200 | |
| 96029 | B | 104201 | |
| 96030 | B | 104202 | |
| 96031 | B | 104203 | |
| 96032 | B | 104204 | |
| 96033 | B | 104205 | |
| 96034 | B | 104206 | |
| 96035 | B | 104207 | |
| 96036 | B | 104208 | |
| 96037 | B | 104209 | |
| 96038 | B | 104210 | |
| 96039 | B | 104211 | |
| 96040 | B | 104212 | |
| 96041 | B | 104213 | |
| 96042 | B | 104214 | |
| 96043 | B | 104215 | |
| 96044 | B | 104216 | |
| 96045 | B | 104217 | |
| 96046 | B | 104218 | |
| 96047 | B | 104219 | |
| 96048 | B | 104220 | |
| 96049 | B | 104221 | |
| 96050 | B | 104222 | |
| 96051 | B | 104223 | |
| 96052 | B | 104224 | |
| 96053 | B | 104225 | |
| 96054 | B | 104226 | |
| 96055 | B | 104227 | |
| 96056 | B | 104228 | |
| 96057 | B | 104229 | |
| 96058 | B | 104230 | |
| 96059 | B | 104231 | |
| 96060 | B | 104232 | |
| 96061 | B | 104233 | |
| 96062 | B | 104234 | |
| 96063 | B | 104235 | |
| 96064 | B | 104236 | |
| 96065 | B | 104237 | |
| 96066 | B | 104238 | |
| 96067 | B | 104239 | |
| 96068 | B | 104240 | |
| 96069 | B | 104241 | |
| 96070 | B | 104242 | |
| 96071 | B | 104243 | |
| 96072 | B | 104244 |