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 (91604,91605,91606,91607,91608,91609,91625,91551,91552,91553,91554,91555,91556,91557,91558,91559,91560,91597,91623,91561,91562,91563,91564,91565,91566,91567,91568,91569,91570,91628,91629,91630,91631,91632,91633,91634,91635,91636,91637,91638,91639,91640,91641,91642,91643,91644,91645,91646,91647,91688,91689,91690,91691,91692,91693,91694,91695,91696,91697,91678,91679,91680,91681,91682,91683,91684,91685,91686,91687,91590,91591,91592,91593,91594,91595,91596,91598,91599,91600,91649,91650,91651,91652,91653,91654,91655,91656,91657,91659,91660,91661,91662,91663,91664,91665,91666)) 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 |
|---|---|---|---|
| 91551 | D | 99624 | |
| 91552 | D | 99625 | |
| 91553 | D | 99626 | |
| 91554 | D | 99627 | |
| 91555 | D | 99628 | |
| 91556 | D | 99629 | |
| 91557 | D | 99630 | |
| 91558 | D | 99631 | |
| 91559 | D | 99632 | |
| 91560 | D | 99633 | |
| 91561 | D | 99634 | |
| 91562 | D | 99635 | |
| 91563 | D | 99636 | |
| 91564 | D | 99637 | |
| 91565 | D | 99638 | |
| 91566 | D | 99639 | |
| 91567 | D | 99640 | |
| 91568 | D | 99641 | |
| 91569 | D | 99642 | |
| 91570 | D | 99643 | |
| 91590 | D | 99663 | |
| 91591 | D | 99664 | |
| 91592 | D | 99665 | |
| 91593 | D | 99666 | |
| 91594 | D | 99667 | |
| 91595 | D | 99668 | |
| 91596 | D | 99669 | |
| 91597 | D | 99670 | |
| 91598 | D | 99671 | |
| 91599 | D | 99672 | |
| 91600 | D | 99673 | |
| 91604 | D | 99677 | |
| 91605 | D | 99678 | |
| 91606 | D | 99679 | |
| 91607 | D | 99680 | |
| 91608 | D | 99681 | |
| 91609 | D | 99682 | |
| 91623 | D | 99696 | |
| 91625 | D | 99698 | |
| 91628 | D | 99701 | |
| 91629 | D | 99702 | |
| 91630 | D | 99703 | |
| 91631 | D | 99704 | |
| 91632 | D | 99705 | |
| 91633 | D | 99706 | |
| 91634 | D | 99707 | |
| 91635 | D | 99708 | |
| 91636 | D | 99709 | |
| 91637 | D | 99710 | |
| 91638 | D | 99711 | |
| 91639 | D | 99712 | |
| 91640 | D | 99713 | |
| 91641 | D | 99714 | |
| 91642 | D | 99715 | |
| 91643 | D | 99716 | |
| 91644 | D | 99717 | |
| 91645 | D | 99718 | |
| 91646 | D | 99719 | |
| 91647 | D | 99720 | |
| 91649 | D | 99722 | |
| 91650 | D | 99723 | |
| 91651 | D | 99724 | |
| 91652 | D | 99725 | |
| 91653 | D | 99726 | |
| 91654 | D | 99727 | |
| 91655 | D | 99728 | |
| 91656 | D | 99729 | |
| 91657 | D | 99730 | |
| 91659 | D | 99732 | |
| 91660 | D | 99733 | |
| 91661 | D | 99734 | |
| 91662 | D | 99735 | |
| 91663 | D | 99736 | |
| 91664 | D | 99737 | |
| 91665 | D | 99738 | |
| 91666 | D | 99739 | |
| 91678 | D | 99751 | |
| 91679 | D | 99752 | |
| 91680 | D | 99753 | |
| 91681 | D | 99754 | |
| 91682 | D | 99755 | |
| 91683 | D | 99756 | |
| 91684 | D | 99757 | |
| 91685 | D | 99758 | |
| 91686 | D | 99759 | |
| 91687 | D | 99760 | |
| 91688 | D | 99761 | |
| 91689 | D | 99762 | |
| 91690 | D | 99763 | |
| 91691 | D | 99764 | |
| 91692 | D | 99765 | |
| 91693 | D | 99766 | |
| 91694 | D | 99767 | |
| 91695 | D | 99768 | |
| 91696 | D | 99769 | |
| 91697 | D | 99770 |