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 (85657,92212,92213,92214,92215,92217,92223,92465,92466,92191,86388,91350,84100,83093,85549,85550,85565,86221,92228,92229,92230,92231,92237,92469,92470,92471,91348,85585,89180,90074,91892,92150,85653,91361,91363,91391,91393,92197,92457,89727,91362,91364,83096,83098,84102,86385,92240,92245,92247,92248,92249,92250,92252,92253,92485,92486,92487,89738,85578,91392,91394,85655,91359,91389,84104,92010,92098,91360,91357,91387,92241,92242,92243,92244,92246,92251,92483,92484,92440,91358,92186,92187,92188,92189,92190,92441,85652,85656,91390,85582,92488,91388,92476,92477,92478,92479)) 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 |
|---|---|---|---|
| 83093 | D | 91131 | |
| 83096 | D | 91134 | |
| 83098 | D | 91136 | |
| 84100 | D | 92138 | |
| 84102 | D | 92140 | |
| 84104 | D | 92142 | |
| 85549 | D | 93587 | |
| 85550 | D | 93588 | |
| 85565 | D | 93603 | |
| 85578 | D | 93616 | |
| 85582 | D | 93620 | |
| 85585 | D | 93623 | |
| 85652 | D | 93690 | |
| 85653 | D | 93691 | |
| 85655 | D | 93693 | |
| 85656 | D | 93694 | |
| 85657 | D | 93695 | |
| 86221 | D | 94259 | |
| 86385 | D | 94423 | |
| 86388 | D | 94426 | |
| 89180 | D | 97218 | |
| 89727 | D | 97765 | |
| 89738 | D | 97776 | |
| 90074 | D | 98112 | |
| 91348 | D | 99421 | |
| 91350 | D | 99423 | |
| 91357 | D | 99430 | |
| 91358 | D | 99431 | |
| 91359 | D | 99432 | |
| 91360 | D | 99433 | |
| 91361 | D | 99434 | |
| 91362 | D | 99435 | |
| 91363 | D | 99436 | |
| 91364 | D | 99437 | |
| 91387 | D | 99460 | |
| 91388 | D | 99461 | |
| 91389 | D | 99462 | |
| 91390 | D | 99463 | |
| 91391 | D | 99464 | |
| 91392 | D | 99465 | |
| 91393 | D | 99466 | |
| 91394 | D | 99467 | |
| 91892 | D | 99970 | |
| 92010 | D | 100088 | |
| 92098 | D | 100176 | |
| 92150 | D | 100228 | |
| 92186 | D | 100264 | |
| 92187 | D | 100265 | |
| 92188 | D | 100266 | |
| 92189 | D | 100267 | |
| 92190 | D | 100268 | |
| 92191 | D | 100269 | |
| 92197 | D | 100275 | |
| 92212 | D | 100290 | |
| 92213 | D | 100291 | |
| 92214 | D | 100292 | |
| 92215 | D | 100293 | |
| 92217 | D | 100295 | |
| 92223 | D | 100301 | |
| 92228 | D | 100306 | |
| 92229 | D | 100307 | |
| 92230 | D | 100308 | |
| 92231 | D | 100309 | |
| 92237 | D | 100315 | |
| 92240 | D | 100318 | |
| 92241 | D | 100319 | |
| 92242 | D | 100320 | |
| 92243 | D | 100321 | |
| 92244 | D | 100322 | |
| 92245 | D | 100323 | |
| 92246 | D | 100324 | |
| 92247 | D | 100325 | |
| 92248 | D | 100326 | |
| 92249 | D | 100327 | |
| 92250 | D | 100328 | |
| 92251 | D | 100329 | |
| 92252 | D | 100330 | |
| 92253 | D | 100331 | |
| 92440 | D | 100544 | |
| 92441 | D | 100545 | |
| 92457 | D | 100561 | |
| 92465 | D | 100569 | |
| 92466 | D | 100570 | |
| 92469 | D | 100573 | |
| 92470 | D | 100574 | |
| 92471 | D | 100575 | |
| 92476 | D | 100580 | |
| 92477 | D | 100581 | |
| 92478 | D | 100582 | |
| 92479 | D | 100583 | |
| 92483 | D | 100587 | |
| 92484 | D | 100588 | |
| 92485 | D | 100589 | |
| 92486 | D | 100590 | |
| 92487 | D | 100591 | |
| 92488 | D | 100592 |