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 (90788,90790,90789,90791,90784,90786,90774,90772,90785,90787,90780,90782,90775,87367,90781,90783,90773,90776,90778,87366,87365,90777,90779,87354,90770,87364,82550,90768,87352,87353,90771,87358,87378,82548,90769,87380,87357,87376,87377,90766,90767,87374,90150,90165,87379,84073,84081,82509,87373,82508,90149,90164,90764,90765,90142,90157,90762,90763,90148,90163,82531,87369,84072,84080,82541,90759,90147,90162,82440,87368,87363,84071,84079,84095,90141,90156,90297,90304,82539,82530,84057,84065,82439,82549,87362,84070,84078,90758,90760,90761,85973,87361,87356,84069,84077,82540)) 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 |
|---|---|---|---|
| 82439 | D | 90477 | |
| 82440 | D | 90478 | |
| 82508 | D | 90546 | |
| 82509 | D | 90547 | |
| 82530 | D | 90568 | |
| 82531 | D | 90569 | |
| 82539 | D | 90577 | |
| 82540 | D | 90578 | |
| 82541 | D | 90579 | |
| 82548 | D | 90586 | |
| 82549 | D | 90587 | |
| 82550 | D | 90588 | |
| 84057 | D | 92095 | |
| 84065 | D | 92103 | |
| 84069 | D | 92107 | |
| 84070 | D | 92108 | |
| 84071 | D | 92109 | |
| 84072 | D | 92110 | |
| 84073 | D | 92111 | |
| 84077 | D | 92115 | |
| 84078 | D | 92116 | |
| 84079 | D | 92117 | |
| 84080 | D | 92118 | |
| 84081 | D | 92119 | |
| 84095 | D | 92133 | |
| 85973 | D | 94011 | |
| 87352 | D | 95390 | |
| 87353 | D | 95391 | |
| 87354 | D | 95392 | |
| 87356 | D | 95394 | |
| 87357 | D | 95395 | |
| 87358 | D | 95396 | |
| 87361 | D | 95399 | |
| 87362 | D | 95400 | |
| 87363 | D | 95401 | |
| 87364 | D | 95402 | |
| 87365 | D | 95403 | |
| 87366 | D | 95404 | |
| 87367 | D | 95405 | |
| 87368 | D | 95406 | |
| 87369 | D | 95407 | |
| 87373 | D | 95411 | |
| 87374 | D | 95412 | |
| 87376 | D | 95414 | |
| 87377 | D | 95415 | |
| 87378 | D | 95416 | |
| 87379 | D | 95417 | |
| 87380 | D | 95418 | |
| 90141 | D | 98179 | |
| 90142 | D | 98180 | |
| 90147 | D | 98185 | |
| 90148 | D | 98186 | |
| 90149 | D | 98187 | |
| 90150 | D | 98188 | |
| 90156 | D | 98194 | |
| 90157 | D | 98195 | |
| 90162 | D | 98200 | |
| 90163 | D | 98201 | |
| 90164 | D | 98202 | |
| 90165 | D | 98203 | |
| 90297 | D | 98335 | |
| 90304 | D | 98342 | |
| 90758 | D | 98811 | |
| 90759 | D | 98812 | |
| 90760 | D | 98813 | |
| 90761 | D | 98814 | |
| 90762 | D | 98815 | |
| 90763 | D | 98816 | |
| 90764 | D | 98817 | |
| 90765 | D | 98818 | |
| 90766 | D | 98819 | |
| 90767 | D | 98820 | |
| 90768 | D | 98821 | |
| 90769 | D | 98822 | |
| 90770 | D | 98823 | |
| 90771 | D | 98824 | |
| 90772 | D | 98825 | |
| 90773 | D | 98826 | |
| 90774 | D | 98827 | |
| 90775 | D | 98828 | |
| 90776 | D | 98829 | |
| 90777 | D | 98830 | |
| 90778 | D | 98831 | |
| 90779 | D | 98832 | |
| 90780 | D | 98833 | |
| 90781 | D | 98834 | |
| 90782 | D | 98835 | |
| 90783 | D | 98836 | |
| 90784 | D | 98837 | |
| 90785 | D | 98838 | |
| 90786 | D | 98839 | |
| 90787 | D | 98840 | |
| 90788 | D | 98841 | |
| 90789 | D | 98842 | |
| 90790 | D | 98843 | |
| 90791 | D | 98844 |