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 (85599,92212,92213,92214,92215,92217,92223,92465,92466,90827,92191,84238,87995,89167,89168,89170,89171,92430,91978,91981,82361,82432,82563,82567,82571,87882,92228,92229,92230,92231,92237,92469,92470,92471,92439,91865,85585,92366,92367,92368,92369,92370,92371,92372,90324,90326,91977,91979,91980,91982,91983,91892,92150,82556,84254,84259,85596,87577,87592,87607,88788,92197,92457,85646,85583,91866,91867,92325,92326,92327,92328,89595,89596,89597,82336,86251,90054,90056,90057,86861,87875,90323,91936,92240,92245,92247,92248,92249,92250,92252,92253,92485,92486,92487,84252,84253)) 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 |
|---|---|---|---|
| 82336 | D | 90373 | |
| 82361 | D | 90399 | |
| 82432 | D | 90470 | |
| 82556 | D | 90594 | |
| 82563 | D | 90601 | |
| 82567 | D | 90605 | |
| 82571 | D | 90609 | |
| 84238 | D | 92276 | |
| 84252 | D | 92290 | |
| 84253 | D | 92291 | |
| 84254 | D | 92292 | |
| 84259 | D | 92297 | |
| 85583 | D | 93621 | |
| 85585 | D | 93623 | |
| 85596 | D | 93634 | |
| 85599 | D | 93637 | |
| 85646 | D | 93684 | |
| 86251 | D | 94289 | |
| 86861 | D | 94899 | |
| 87577 | D | 95615 | |
| 87592 | D | 95630 | |
| 87607 | D | 95645 | |
| 87875 | D | 95913 | |
| 87882 | D | 95920 | |
| 87995 | D | 96033 | |
| 88788 | D | 96826 | |
| 89167 | D | 97205 | |
| 89168 | D | 97206 | |
| 89170 | D | 97208 | |
| 89171 | D | 97209 | |
| 89595 | D | 97633 | |
| 89596 | D | 97634 | |
| 89597 | D | 97635 | |
| 90054 | D | 98092 | |
| 90056 | D | 98094 | |
| 90057 | D | 98095 | |
| 90323 | D | 98361 | |
| 90324 | D | 98362 | |
| 90326 | D | 98364 | |
| 90827 | D | 98880 | |
| 91865 | D | 99943 | |
| 91866 | D | 99944 | |
| 91867 | D | 99945 | |
| 91892 | D | 99970 | |
| 91936 | D | 100014 | |
| 91977 | D | 100055 | |
| 91978 | D | 100056 | |
| 91979 | D | 100057 | |
| 91980 | D | 100058 | |
| 91981 | D | 100059 | |
| 91982 | D | 100060 | |
| 91983 | D | 100061 | |
| 92150 | D | 100228 | |
| 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 | |
| 92245 | D | 100323 | |
| 92247 | D | 100325 | |
| 92248 | D | 100326 | |
| 92249 | D | 100327 | |
| 92250 | D | 100328 | |
| 92252 | D | 100330 | |
| 92253 | D | 100331 | |
| 92325 | D | 100429 | |
| 92326 | D | 100430 | |
| 92327 | D | 100431 | |
| 92328 | D | 100432 | |
| 92366 | D | 100470 | |
| 92367 | D | 100471 | |
| 92368 | D | 100472 | |
| 92369 | D | 100473 | |
| 92370 | D | 100474 | |
| 92371 | D | 100475 | |
| 92372 | D | 100476 | |
| 92430 | D | 100534 | |
| 92439 | D | 100543 | |
| 92457 | D | 100561 | |
| 92465 | D | 100569 | |
| 92466 | D | 100570 | |
| 92469 | D | 100573 | |
| 92470 | D | 100574 | |
| 92471 | D | 100575 | |
| 92485 | D | 100589 | |
| 92486 | D | 100590 | |
| 92487 | D | 100591 |