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": "86.69"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"link_type",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 96,
"rows_produced_per_join": 96,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "9.89",
"eval_cost": "9.60",
"prefix_cost": "19.49",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
],
"attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (98590,98591,98592,98593,98594,98595,98596,98597,98598,98599,98600,98601,98602,98603,98604,98605,98606,98607,98608,98609,98610,98611,98612,98613,98614,98615,98616,98617,98618,98619,98620,98621,98622,98623,98624,98625,98626,98627,98628,98629,98630,98631,98632,98633,98634,98635,98636,98637,98638,98639,98640,98641,98642,98643,98644,98645,98646,98647,98648,98649,98650,98651,98652,98653,98654,98655,98656,98657,98658,98659,98660,98661,98662,98663,98664,98665,98666,98667,98668,98669,98670,98671,98672,98673,98674,98675,98676,98677,98678,98679,98680,98681,98760,98761,99012,99013))"
}
},
{
"table": {
"table_name": "product_position_source",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"nuie_scalesta_net.cscart_products_categories.product_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": "53.09",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id",
"position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"nuie_scalesta_net.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 4,
"filtered": "5.00",
"cost_info": {
"read_cost": "24.00",
"eval_cost": "0.48",
"prefix_cost": "86.69",
"data_read_per_join": "12K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`nuie_scalesta_net`.`cscart_categories`.`storefront_id` in (0,1)) and ((`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`))) and (`nuie_scalesta_net`.`cscart_categories`.`status` in ('A','H')))"
}
}
]
}
}
}
| product_id | category_ids | position |
|---|---|---|
| 98590 | 7229M | |
| 98591 | 7229M | |
| 98592 | 7229M | |
| 98593 | 7229M | |
| 98594 | 7229M | |
| 98595 | 7229M | |
| 98596 | 7229M | |
| 98597 | 7229M | |
| 98598 | 7229M | |
| 98599 | 7229M | |
| 98600 | 7231M | |
| 98601 | 7231M | |
| 98602 | 7234M | |
| 98603 | 7231M | |
| 98604 | 7229M | |
| 98605 | 7229M | |
| 98606 | 7234M | |
| 98607 | 7231M | |
| 98608 | 7234M | |
| 98609 | 7231M | |
| 98610 | 7234M | |
| 98611 | 7231M | |
| 98612 | 7231M | |
| 98613 | 7231M | |
| 98614 | 7229M | |
| 98615 | 7229M | |
| 98616 | 7231M | |
| 98617 | 7229M | |
| 98618 | 7229M | |
| 98619 | 7229M | |
| 98620 | 7229M | |
| 98621 | 7229M | |
| 98622 | 7229M | |
| 98623 | 7229M | |
| 98624 | 7229M | |
| 98625 | 7234M | |
| 98626 | 7231M | |
| 98627 | 7234M | |
| 98628 | 7231M | |
| 98629 | 7234M | |
| 98630 | 7231M | |
| 98631 | 7231M | |
| 98632 | 7231M | |
| 98633 | 7231M | |
| 98634 | 7234M | |
| 98635 | 7231M | |
| 98636 | 7234M | |
| 98637 | 7231M | |
| 98638 | 7234M | |
| 98639 | 7231M | |
| 98640 | 7231M | |
| 98641 | 7231M | |
| 98642 | 7234M | |
| 98643 | 7234M | |
| 98644 | 7231M | |
| 98645 | 7231M | |
| 98646 | 7231M | |
| 98647 | 7231M | |
| 98648 | 7234M | |
| 98649 | 7231M | |
| 98650 | 7231M | |
| 98651 | 7229M | |
| 98652 | 7231M | |
| 98653 | 7231M | |
| 98654 | 7234M | |
| 98655 | 7234M | |
| 98656 | 7234M | |
| 98657 | 7231M | |
| 98658 | 7231M | |
| 98659 | 7231M | |
| 98660 | 7234M | |
| 98661 | 7231M | |
| 98662 | 7234M | |
| 98663 | 7231M | |
| 98664 | 7234M | |
| 98665 | 7231M | |
| 98666 | 7231M | |
| 98667 | 7231M | |
| 98668 | 7231M | |
| 98669 | 7231M | |
| 98670 | 7234M | |
| 98671 | 7231M | |
| 98672 | 7231M | |
| 98673 | 7231M | |
| 98674 | 7231M | |
| 98675 | 7231M | |
| 98676 | 7231M | |
| 98677 | 7231M | |
| 98678 | 7231M | |
| 98679 | 7231M | |
| 98680 | 7231M | |
| 98681 | 7229M | |
| 98760 | 7229M | |
| 98761 | 7229M | |
| 99012 | 7229M | |
| 99013 | 7229M |