PHP Deprecated

Message

unserialize(): Passing null to parameter #1 ($data) of type string is deprecated

Error at

app/addons/hybrid_auth/func.php, line: 200

Backtrace

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
SELECT 
  cscart_products_categories.product_id, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = "M", 
      CONCAT(
        cscart_products_categories.category_id, 
        "M"
      ), 
      cscart_products_categories.category_id
    )
  ) AS category_ids, 
  product_position_source.position AS position 
FROM 
  cscart_products_categories 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  LEFT JOIN cscart_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id 
  AND product_position_source.category_id = 7228 
WHERE 
  cscart_products_categories.product_id IN (
    95977, 95978, 95979, 95980, 95981, 95982, 
    95983, 95984, 95985, 95986, 95987, 
    95988, 95989, 95990, 95991, 95992, 
    95993, 95994, 95995, 95996, 95997, 
    95998, 95999, 96000, 96001, 96002, 
    96003, 96004, 96005, 96006, 96007, 
    96008, 96009, 96010, 96011, 96012, 
    96013, 96014, 96015, 96016, 96017, 
    96018, 96019, 96020, 96021, 96022, 
    96023, 96024, 96025, 96026, 96027, 
    96028, 96029, 96030, 96031, 96032, 
    96033, 96034, 96035, 96036, 96037, 
    96038, 96039, 96040, 96041, 96042, 
    96043, 96044, 96045, 96046, 96047, 
    96048, 96049, 96050, 96051, 96052, 
    96053, 96054, 96055, 96056, 96057, 
    96058, 96059, 96060, 96061, 96062, 
    96063, 96064, 96065, 96066, 96067, 
    96068, 96069, 96070, 96071, 96072
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01581

JSON explain

{
  "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 (95977,95978,95979,95980,95981,95982,95983,95984,95985,95986,95987,95988,95989,95990,95991,95992,95993,95994,95995,95996,95997,95998,95999,96000,96001,96002,96003,96004,96005,96006,96007,96008,96009,96010,96011,96012,96013,96014,96015,96016,96017,96018,96019,96020,96021,96022,96023,96024,96025,96026,96027,96028,96029,96030,96031,96032,96033,96034,96035,96036,96037,96038,96039,96040,96041,96042,96043,96044,96045,96046,96047,96048,96049,96050,96051,96052,96053,96054,96055,96056,96057,96058,96059,96060,96061,96062,96063,96064,96065,96066,96067,96068,96069,96070,96071,96072))"
          }
        },
        {
          "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')))"
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
95977 7229M
95978 7229M
95979 7229M
95980 7229M
95981 7229M
95982 7229M
95983 7229M
95984 7229M
95985 7229M
95986 7229M
95987 7229M
95988 7229M
95989 7229M
95990 7229M
95991 7229M
95992 7229M
95993 7229M
95994 7229M
95995 7229M
95996 7229M
95997 7229M
95998 7229M
95999 7229M
96000 7229M
96001 7229M
96002 7229M
96003 7229M
96004 7229M
96005 7229M
96006 7229M
96007 7229M
96008 7229M
96009 7229M
96010 7229M
96011 7229M
96012 7229M
96013 7229M
96014 7229M
96015 7229M
96016 7229M
96017 7229M
96018 7229M
96019 7229M
96020 7229M
96021 7229M
96022 7229M
96023 7229M
96024 7229M
96025 7229M
96026 7229M
96027 7229M
96028 7229M
96029 7229M
96030 7229M
96031 7229M
96032 7229M
96033 7229M
96034 7229M
96035 7229M
96036 7229M
96037 7229M
96038 7229M
96039 7229M
96040 7229M
96041 7229M
96042 7229M
96043 7229M
96044 7229M
96045 7229M
96046 7229M
96047 7229M
96048 7229M
96049 7229M
96050 7234M
96051 7231M
96052 7234M
96053 7231M
96054 7234M
96055 7231M
96056 7234M
96057 7231M
96058 7234M
96059 7231M
96060 7234M
96061 7231M
96062 7231M
96063 7234M
96064 7231M
96065 7234M
96066 7231M
96067 7234M
96068 7231M
96069 7234M
96070 7231M
96071 7234M
96072 7231M