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 (97167,97168,97169,97170,97171,97172,97173,97174,97175,97176,97177,97178,97179,97180,97181,97182,97183,97184,97185,97186,97187,97188,97189,97190,97191,97192,97193,97194,97195,97196,97197,97198,97199,97200,97201,97202,97203,97204,97205,97206,97207,97208,97209,97210,97211,97212,97213,97214,97215,97216,97217,97218,97228,97229,97230,97231,97232,97233,97234,97235,97236,97237,97238,97239,97240,97241,97242,97243,97244,97245,97246,97247,97248,97249,97250,97251,97252,97253,97254,97255,97256,97257,97258,97259,97260,97261,97262,97263,97264,97265,97266,97267,97268,97269,97270,97271)) 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 |
|---|---|---|---|
| 97167 | B | 105348 | |
| 97168 | B | 105349 | |
| 97169 | B | 105350 | |
| 97170 | B | 105351 | |
| 97171 | B | 105352 | |
| 97172 | B | 105353 | |
| 97173 | B | 105354 | |
| 97174 | B | 105355 | |
| 97175 | B | 105356 | |
| 97176 | B | 105357 | |
| 97177 | B | 105358 | |
| 97178 | B | 105359 | |
| 97179 | B | 105360 | |
| 97180 | B | 105361 | |
| 97181 | B | 105362 | |
| 97182 | B | 105363 | |
| 97183 | B | 105364 | |
| 97184 | B | 105365 | |
| 97185 | B | 105366 | |
| 97186 | B | 105367 | |
| 97187 | B | 105368 | |
| 97188 | B | 105369 | |
| 97189 | B | 105370 | |
| 97190 | B | 105371 | |
| 97191 | B | 105372 | |
| 97192 | B | 105373 | |
| 97193 | B | 105374 | |
| 97194 | B | 105375 | |
| 97195 | B | 105376 | |
| 97196 | B | 105377 | |
| 97197 | B | 105378 | |
| 97198 | B | 105379 | |
| 97199 | B | 105380 | |
| 97200 | B | 105381 | |
| 97201 | B | 105382 | |
| 97202 | B | 105383 | |
| 97203 | B | 105384 | |
| 97204 | B | 105385 | |
| 97205 | B | 105386 | |
| 97206 | B | 105387 | |
| 97207 | B | 105388 | |
| 97208 | B | 105389 | |
| 97209 | B | 105390 | |
| 97210 | B | 105391 | |
| 97211 | B | 105392 | |
| 97212 | B | 105393 | |
| 97213 | B | 105394 | |
| 97214 | B | 105395 | |
| 97215 | B | 105396 | |
| 97216 | B | 105397 | |
| 97217 | B | 105398 | |
| 97218 | B | 105399 | |
| 97228 | B | 105409 | |
| 97229 | B | 105410 | |
| 97230 | B | 105411 | |
| 97231 | B | 105412 | |
| 97232 | B | 105413 | |
| 97233 | B | 105414 | |
| 97234 | B | 105415 | |
| 97235 | B | 105416 | |
| 97236 | B | 105417 | |
| 97237 | B | 105418 | |
| 97238 | B | 105419 | |
| 97239 | B | 105420 | |
| 97240 | B | 105421 | |
| 97241 | B | 105422 | |
| 97242 | B | 105423 | |
| 97243 | B | 105424 | |
| 97244 | B | 105425 | |
| 97245 | B | 105426 | |
| 97246 | B | 105427 | |
| 97247 | B | 105428 | |
| 97248 | B | 105429 | |
| 97249 | B | 105430 | |
| 97250 | B | 105431 | |
| 97251 | B | 105432 | |
| 97252 | B | 105433 | |
| 97253 | B | 105434 | |
| 97254 | B | 105435 | |
| 97255 | B | 105436 | |
| 97256 | B | 105437 | |
| 97257 | B | 105438 | |
| 97258 | B | 105439 | |
| 97259 | B | 105440 | |
| 97260 | B | 105441 | |
| 97261 | B | 105442 | |
| 97262 | B | 105443 | |
| 97263 | B | 105444 | |
| 97264 | B | 105445 | |
| 97265 | B | 105446 | |
| 97266 | B | 105447 | |
| 97267 | B | 105448 | |
| 97268 | B | 105449 | |
| 97269 | B | 105450 | |
| 97270 | B | 105451 | |
| 97271 | B | 105452 |