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 (86866,91330,86262,86280,86300,86326,91328,86867,86270,86291,86299,86325,91329,86261,86244,86269,86290,86292,86318,86271,87736,86281,86346,86350,91327,91426,86283,87745,86256,86309,86369,86272,86374,86298,86324,86282,86311,86327,86260,86308,91326,86243,87748,86378,86246,86268,86289,86277,87744,91425,86304,86317,91424,87751,91325,86373,86310,86347,86351,87753,86344,86348,86276,86376,86353,86303,86316,86254,86306,86371,86313,86329,86312,86328,86245,86345,86349,87743,86865,87747,86259,86307,91422,91423,87742,86297,86323,86273,86305,86377,86296,86322,86372,87750,86375,87746)) 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 |
|---|---|---|---|
| 86243 | D | 94281 | |
| 86244 | D | 94282 | |
| 86245 | D | 94283 | |
| 86246 | D | 94284 | |
| 86254 | D | 94292 | |
| 86256 | D | 94294 | |
| 86259 | D | 94297 | |
| 86260 | D | 94298 | |
| 86261 | D | 94299 | |
| 86262 | D | 94300 | |
| 86268 | D | 94306 | |
| 86269 | D | 94307 | |
| 86270 | D | 94308 | |
| 86271 | D | 94309 | |
| 86272 | D | 94310 | |
| 86273 | D | 94311 | |
| 86276 | D | 94314 | |
| 86277 | D | 94315 | |
| 86280 | D | 94318 | |
| 86281 | D | 94319 | |
| 86282 | D | 94320 | |
| 86283 | D | 94321 | |
| 86289 | D | 94327 | |
| 86290 | D | 94328 | |
| 86291 | D | 94329 | |
| 86292 | D | 94330 | |
| 86296 | D | 94334 | |
| 86297 | D | 94335 | |
| 86298 | D | 94336 | |
| 86299 | D | 94337 | |
| 86300 | D | 94338 | |
| 86303 | D | 94341 | |
| 86304 | D | 94342 | |
| 86305 | D | 94343 | |
| 86306 | D | 94344 | |
| 86307 | D | 94345 | |
| 86308 | D | 94346 | |
| 86309 | D | 94347 | |
| 86310 | D | 94348 | |
| 86311 | D | 94349 | |
| 86312 | D | 94350 | |
| 86313 | D | 94351 | |
| 86316 | D | 94354 | |
| 86317 | D | 94355 | |
| 86318 | D | 94356 | |
| 86322 | D | 94360 | |
| 86323 | D | 94361 | |
| 86324 | D | 94362 | |
| 86325 | D | 94363 | |
| 86326 | D | 94364 | |
| 86327 | D | 94365 | |
| 86328 | D | 94366 | |
| 86329 | D | 94367 | |
| 86344 | D | 94382 | |
| 86345 | D | 94383 | |
| 86346 | D | 94384 | |
| 86347 | D | 94385 | |
| 86348 | D | 94386 | |
| 86349 | D | 94387 | |
| 86350 | D | 94388 | |
| 86351 | D | 94389 | |
| 86353 | D | 94391 | |
| 86369 | D | 94407 | |
| 86371 | D | 94409 | |
| 86372 | D | 94410 | |
| 86373 | D | 94411 | |
| 86374 | D | 94412 | |
| 86375 | D | 94413 | |
| 86376 | D | 94414 | |
| 86377 | D | 94415 | |
| 86378 | D | 94416 | |
| 86865 | D | 94903 | |
| 86866 | D | 94904 | |
| 86867 | D | 94905 | |
| 87736 | D | 95774 | |
| 87742 | D | 95780 | |
| 87743 | D | 95781 | |
| 87744 | D | 95782 | |
| 87745 | D | 95783 | |
| 87746 | D | 95784 | |
| 87747 | D | 95785 | |
| 87748 | D | 95786 | |
| 87750 | D | 95788 | |
| 87751 | D | 95789 | |
| 87753 | D | 95791 | |
| 91325 | D | 99398 | |
| 91326 | D | 99399 | |
| 91327 | D | 99400 | |
| 91328 | D | 99401 | |
| 91329 | D | 99402 | |
| 91330 | D | 99403 | |
| 91422 | D | 99495 | |
| 91423 | D | 99496 | |
| 91424 | D | 99497 | |
| 91425 | D | 99498 | |
| 91426 | D | 99499 |