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 (93787,93788,93798,93799,93800,93801,93802,93803,93804,93805,93806,93807,93808,93809,93810,93811,93812,93813,93814,93815,93816,93817,93818,93832,93833,93834,93835,93836,93837,93838,93839,93840,93841,93882,93883,93884,93885,94367,94368,94369,94370,94371,94372,94373,94374,94375,94376,94377,94378,94379,94380,94438,94463,94464,94465,94466,94467,94468,94469,94470,94471,94472,94473,94474,94475,94476,94477,94478,94479,94480,94481,94482,94483,94589,94590,94591,94811,94812,94820,94821,94959,94960,94961,94962,94963,94964,95360,95394,95395,95396,95397,95398,95399,95400,95401,95424)) 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 |
|---|---|---|---|
| 93787 | B | 101927 | |
| 93788 | B | 101928 | |
| 93798 | B | 101938 | |
| 93799 | B | 101939 | |
| 93800 | B | 101940 | |
| 93801 | B | 101941 | |
| 93802 | B | 101942 | |
| 93803 | B | 101943 | |
| 93804 | B | 101944 | |
| 93805 | B | 101945 | |
| 93806 | B | 101946 | |
| 93807 | B | 101947 | |
| 93808 | B | 101948 | |
| 93809 | B | 101949 | |
| 93810 | B | 101950 | |
| 93811 | B | 101951 | |
| 93812 | B | 101952 | |
| 93813 | B | 101953 | |
| 93814 | B | 101954 | |
| 93815 | B | 101955 | |
| 93816 | B | 101956 | |
| 93817 | B | 101957 | |
| 93818 | B | 101958 | |
| 93832 | B | 101972 | |
| 93833 | B | 101973 | |
| 93834 | B | 101974 | |
| 93835 | B | 101975 | |
| 93836 | B | 101976 | |
| 93837 | B | 101977 | |
| 93838 | B | 101978 | |
| 93839 | B | 101979 | |
| 93840 | B | 101980 | |
| 93841 | B | 101981 | |
| 93882 | B | 102022 | |
| 93883 | B | 102023 | |
| 93884 | B | 102024 | |
| 93885 | B | 102025 | |
| 94367 | B | 102509 | |
| 94368 | B | 102510 | |
| 94369 | B | 102511 | |
| 94370 | B | 102512 | |
| 94371 | B | 102513 | |
| 94372 | B | 102514 | |
| 94373 | B | 102515 | |
| 94374 | B | 102516 | |
| 94375 | B | 102517 | |
| 94376 | B | 102518 | |
| 94377 | B | 102519 | |
| 94378 | B | 102520 | |
| 94379 | B | 102521 | |
| 94380 | B | 102522 | |
| 94438 | B | 102584 | |
| 94463 | B | 102635 | |
| 94464 | B | 102636 | |
| 94465 | B | 102637 | |
| 94466 | B | 102638 | |
| 94467 | B | 102639 | |
| 94468 | B | 102640 | |
| 94469 | B | 102641 | |
| 94470 | B | 102642 | |
| 94471 | B | 102643 | |
| 94472 | B | 102644 | |
| 94473 | B | 102645 | |
| 94474 | B | 102646 | |
| 94475 | B | 102647 | |
| 94476 | B | 102648 | |
| 94477 | B | 102649 | |
| 94478 | B | 102650 | |
| 94479 | B | 102651 | |
| 94480 | B | 102652 | |
| 94481 | B | 102653 | |
| 94482 | B | 102654 | |
| 94483 | B | 102655 | |
| 94589 | B | 102761 | |
| 94590 | B | 102762 | |
| 94591 | B | 102763 | |
| 94811 | B | 102983 | |
| 94812 | B | 102984 | |
| 94820 | B | 102992 | |
| 94821 | B | 102993 | |
| 94959 | B | 103131 | |
| 94960 | B | 103132 | |
| 94961 | B | 103133 | |
| 94962 | B | 103134 | |
| 94963 | B | 103135 | |
| 94964 | B | 103136 | |
| 95360 | B | 103532 | |
| 95394 | B | 103566 | |
| 95395 | B | 103567 | |
| 95396 | B | 103568 | |
| 95397 | B | 103569 | |
| 95398 | B | 103570 | |
| 95399 | B | 103571 | |
| 95400 | B | 103572 | |
| 95401 | B | 103573 | |
| 95424 | B | 103596 |