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 (90108,89006,89013,84007,84009,84011,84013,89010,91307,83963,83965,83967,83969,91303,83130,84006,84008,84010,84012,84035,90089,90099,92027,92028,92029,92030,92031,92032,92033,92035,92036,92037,92038,92039,92040,92041,92115,92116,92117,92118,92119,92120,92121,92123,92124,92125,92126,92127,92128,92129,83962,83964,83966,83968,89005,90079,83111,83121,92255,92256,92257,92496,92497,92498,92499,91296,83101,84107,83999,84001,84003,84005,92051,92052,92053,92054,92055,92056,92057,91550,91619,91788,91789,91790,91791,91792,91793,91794,91795,92254,92026,92034,92114,92122,92501,92502)) 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 |
|---|---|---|---|
| 83101 | D | 91139 | |
| 83111 | D | 91149 | |
| 83121 | D | 91159 | |
| 83130 | D | 91168 | |
| 83962 | D | 92000 | |
| 83963 | D | 92001 | |
| 83964 | D | 92002 | |
| 83965 | D | 92003 | |
| 83966 | D | 92004 | |
| 83967 | D | 92005 | |
| 83968 | D | 92006 | |
| 83969 | D | 92007 | |
| 83999 | D | 92037 | |
| 84001 | D | 92039 | |
| 84003 | D | 92041 | |
| 84005 | D | 92043 | |
| 84006 | D | 92044 | |
| 84007 | D | 92045 | |
| 84008 | D | 92046 | |
| 84009 | D | 92047 | |
| 84010 | D | 92048 | |
| 84011 | D | 92049 | |
| 84012 | D | 92050 | |
| 84013 | D | 92051 | |
| 84035 | D | 92073 | |
| 84107 | D | 92145 | |
| 89005 | D | 97043 | |
| 89006 | D | 97044 | |
| 89010 | D | 97048 | |
| 89013 | D | 97051 | |
| 90079 | D | 98117 | |
| 90089 | D | 98127 | |
| 90099 | D | 98137 | |
| 90108 | D | 98146 | |
| 91296 | D | 99369 | |
| 91303 | D | 99376 | |
| 91307 | D | 99380 | |
| 91550 | D | 99623 | |
| 91619 | D | 99692 | |
| 91788 | D | 99866 | |
| 91789 | D | 99867 | |
| 91790 | D | 99868 | |
| 91791 | D | 99869 | |
| 91792 | D | 99870 | |
| 91793 | D | 99871 | |
| 91794 | D | 99872 | |
| 91795 | D | 99873 | |
| 92026 | D | 100104 | |
| 92027 | D | 100105 | |
| 92028 | D | 100106 | |
| 92029 | D | 100107 | |
| 92030 | D | 100108 | |
| 92031 | D | 100109 | |
| 92032 | D | 100110 | |
| 92033 | D | 100111 | |
| 92034 | D | 100112 | |
| 92035 | D | 100113 | |
| 92036 | D | 100114 | |
| 92037 | D | 100115 | |
| 92038 | D | 100116 | |
| 92039 | D | 100117 | |
| 92040 | D | 100118 | |
| 92041 | D | 100119 | |
| 92051 | D | 100129 | |
| 92052 | D | 100130 | |
| 92053 | D | 100131 | |
| 92054 | D | 100132 | |
| 92055 | D | 100133 | |
| 92056 | D | 100134 | |
| 92057 | D | 100135 | |
| 92114 | D | 100192 | |
| 92115 | D | 100193 | |
| 92116 | D | 100194 | |
| 92117 | D | 100195 | |
| 92118 | D | 100196 | |
| 92119 | D | 100197 | |
| 92120 | D | 100198 | |
| 92121 | D | 100199 | |
| 92122 | D | 100200 | |
| 92123 | D | 100201 | |
| 92124 | D | 100202 | |
| 92125 | D | 100203 | |
| 92126 | D | 100204 | |
| 92127 | D | 100205 | |
| 92128 | D | 100206 | |
| 92129 | D | 100207 | |
| 92254 | D | 100332 | |
| 92255 | D | 100333 | |
| 92256 | D | 100334 | |
| 92257 | D | 100335 | |
| 92496 | D | 100600 | |
| 92497 | D | 100601 | |
| 92498 | D | 100602 | |
| 92499 | D | 100603 | |
| 92501 | D | 100605 | |
| 92502 | D | 100606 |