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 (86313,86329,86259,86307,86297,86323,86267,86288,86302,86315,86295,86301,86314,86321,86265,86286,86293,86319,86263,86284,95165,95168,95171,95173,95177,95179,95181,95187,95189,95195,95197,95201,95203,95205,95213,95215,95219,95222,95224,95227,95230,95232,95234,95236,95238,95240,95242,95244,96050,96052,96054,96056,96058,96060,96063,96065,96067,96069,96071,96073,96075,96077,96079,96080,96081,96084,96085,96088,96089,96092,96093,96096,96097,96100,96101,96104,96394,96395,96396,96397,96409,96410,96429,96432,96433,96442,96443,96444,96445,96446,96447,96448,96449,96450,96451,96452)) 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 |
|---|---|---|---|
| 86259 | D | 94297 | |
| 86263 | D | 94301 | |
| 86265 | D | 94303 | |
| 86267 | D | 94305 | |
| 86284 | D | 94322 | |
| 86286 | D | 94324 | |
| 86288 | D | 94326 | |
| 86293 | D | 94331 | |
| 86295 | D | 94333 | |
| 86297 | D | 94335 | |
| 86301 | D | 94339 | |
| 86302 | D | 94340 | |
| 86307 | D | 94345 | |
| 86313 | D | 94351 | |
| 86314 | D | 94352 | |
| 86315 | D | 94353 | |
| 86319 | D | 94357 | |
| 86321 | D | 94359 | |
| 86323 | D | 94361 | |
| 86329 | D | 94367 | |
| 95165 | B | 103337 | |
| 95168 | B | 103340 | |
| 95171 | B | 103343 | |
| 95173 | B | 103345 | |
| 95177 | B | 103349 | |
| 95179 | B | 103351 | |
| 95181 | B | 103353 | |
| 95187 | B | 103359 | |
| 95189 | B | 103361 | |
| 95195 | B | 103367 | |
| 95197 | B | 103369 | |
| 95201 | B | 103373 | |
| 95203 | B | 103375 | |
| 95205 | B | 103377 | |
| 95213 | B | 103385 | |
| 95215 | B | 103387 | |
| 95219 | B | 103391 | |
| 95222 | B | 103394 | |
| 95224 | B | 103396 | |
| 95227 | B | 103399 | |
| 95230 | B | 103402 | |
| 95232 | B | 103404 | |
| 95234 | B | 103406 | |
| 95236 | B | 103408 | |
| 95238 | B | 103410 | |
| 95240 | B | 103412 | |
| 95242 | B | 103414 | |
| 95244 | B | 103416 | |
| 96050 | B | 104222 | |
| 96052 | B | 104224 | |
| 96054 | B | 104226 | |
| 96056 | B | 104228 | |
| 96058 | B | 104230 | |
| 96060 | B | 104232 | |
| 96063 | B | 104235 | |
| 96065 | B | 104237 | |
| 96067 | B | 104239 | |
| 96069 | B | 104241 | |
| 96071 | B | 104243 | |
| 96073 | B | 104245 | |
| 96075 | B | 104247 | |
| 96077 | B | 104249 | |
| 96079 | B | 104251 | |
| 96080 | B | 104252 | |
| 96081 | B | 104253 | |
| 96084 | B | 104256 | |
| 96085 | B | 104257 | |
| 96088 | B | 104260 | |
| 96089 | B | 104261 | |
| 96092 | B | 104264 | |
| 96093 | B | 104265 | |
| 96096 | B | 104268 | |
| 96097 | B | 104269 | |
| 96100 | B | 104272 | |
| 96101 | B | 104273 | |
| 96104 | B | 104276 | |
| 96394 | B | 104575 | |
| 96395 | B | 104576 | |
| 96396 | B | 104577 | |
| 96397 | B | 104578 | |
| 96409 | B | 104590 | |
| 96410 | B | 104591 | |
| 96429 | B | 104610 | |
| 96432 | B | 104613 | |
| 96433 | B | 104614 | |
| 96442 | B | 104623 | |
| 96443 | B | 104624 | |
| 96444 | B | 104625 | |
| 96445 | B | 104626 | |
| 96446 | B | 104627 | |
| 96447 | B | 104628 | |
| 96448 | B | 104629 | |
| 96449 | B | 104630 | |
| 96450 | B | 104631 | |
| 96451 | B | 104632 | |
| 96452 | B | 104633 |