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 (92424,92425,92426,92427,92428,92429,92431,92432,92433,92434,92435,92436,92437,92438,87252,87253,87254,87255,87256,87257,87258,87259,88102,88103,92430,92439,84775,84779,84788,84797,88070,88394,87962,88079,88084,87994,88390,91428,91430,88395,86887,88389,88391,88388,88392,87993,91427,91429,88393,93790,93791,93842,93843,93844,93845,94619,94620,94621,94622,94623,94624,94625,94626,94627,94628,94629,94630,94631,94632,94633,94634,94635,94636,94637,94638,94639,94640,94671,94672,94673,94674,94822,94844,94845,94846,94847,94848,94952,94953,94954,94955,95310,95311,95317,95320,95361)) 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 |
|---|---|---|---|
| 84775 | D | 92813 | |
| 84779 | D | 92817 | |
| 84788 | D | 92826 | |
| 84797 | D | 92835 | |
| 86887 | D | 94925 | |
| 87252 | D | 95290 | |
| 87253 | D | 95291 | |
| 87254 | D | 95292 | |
| 87255 | D | 95293 | |
| 87256 | D | 95294 | |
| 87257 | D | 95295 | |
| 87258 | D | 95296 | |
| 87259 | D | 95297 | |
| 87962 | D | 96000 | |
| 87993 | D | 96031 | |
| 87994 | D | 96032 | |
| 88070 | D | 96108 | |
| 88079 | D | 96117 | |
| 88084 | D | 96122 | |
| 88102 | D | 96140 | |
| 88103 | D | 96141 | |
| 88388 | D | 96426 | |
| 88389 | D | 96427 | |
| 88390 | D | 96428 | |
| 88391 | D | 96429 | |
| 88392 | D | 96430 | |
| 88393 | D | 96431 | |
| 88394 | D | 96432 | |
| 88395 | D | 96433 | |
| 91427 | D | 99500 | |
| 91428 | D | 99501 | |
| 91429 | D | 99502 | |
| 91430 | D | 99503 | |
| 92424 | D | 100528 | |
| 92425 | D | 100529 | |
| 92426 | D | 100530 | |
| 92427 | D | 100531 | |
| 92428 | D | 100532 | |
| 92429 | D | 100533 | |
| 92430 | D | 100534 | |
| 92431 | D | 100535 | |
| 92432 | D | 100536 | |
| 92433 | D | 100537 | |
| 92434 | D | 100538 | |
| 92435 | D | 100539 | |
| 92436 | D | 100540 | |
| 92437 | D | 100541 | |
| 92438 | D | 100542 | |
| 92439 | D | 100543 | |
| 93790 | B | 101930 | |
| 93791 | B | 101931 | |
| 93842 | B | 101982 | |
| 93843 | B | 101983 | |
| 93844 | B | 101984 | |
| 93845 | B | 101985 | |
| 94619 | B | 102791 | |
| 94620 | B | 102792 | |
| 94621 | B | 102793 | |
| 94622 | B | 102794 | |
| 94623 | B | 102795 | |
| 94624 | B | 102796 | |
| 94625 | B | 102797 | |
| 94626 | B | 102798 | |
| 94627 | B | 102799 | |
| 94628 | B | 102800 | |
| 94629 | B | 102801 | |
| 94630 | B | 102802 | |
| 94631 | B | 102803 | |
| 94632 | B | 102804 | |
| 94633 | B | 102805 | |
| 94634 | B | 102806 | |
| 94635 | B | 102807 | |
| 94636 | B | 102808 | |
| 94637 | B | 102809 | |
| 94638 | B | 102810 | |
| 94639 | B | 102811 | |
| 94640 | B | 102812 | |
| 94671 | B | 102843 | |
| 94672 | B | 102844 | |
| 94673 | B | 102845 | |
| 94674 | B | 102846 | |
| 94822 | B | 102994 | |
| 94844 | B | 103016 | |
| 94845 | B | 103017 | |
| 94846 | B | 103018 | |
| 94847 | B | 103019 | |
| 94848 | B | 103020 | |
| 94952 | B | 103124 | |
| 94953 | B | 103125 | |
| 94954 | B | 103126 | |
| 94955 | B | 103127 | |
| 95310 | B | 103482 | |
| 95311 | B | 103483 | |
| 95317 | B | 103489 | |
| 95320 | B | 103492 | |
| 95361 | B | 103533 |