Sandbox

SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    94652, 94653, 94659, 94660, 94661, 94663, 
    94664, 94665, 94675, 94676, 94677, 
    94813, 94817, 94818, 94819, 95449, 
    95803, 95805, 95807, 95809, 95811, 
    97719, 97720, 97721, 97722, 97723, 
    97724, 97725, 97726, 97727, 97765, 
    97766, 97767, 97768, 97769, 97770, 
    97771, 97772, 97773, 97775, 97776, 
    97777, 97783, 97784, 97785, 97787, 
    97788, 97789
  )

Query time 0.00093

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.67"
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.87",
        "eval_cost": "4.80",
        "prefix_cost": "21.67",
        "data_read_per_join": "230K"
      },
      "used_columns": [
        "product_id",
        "product_code",
        "product_type",
        "status",
        "company_id",
        "list_price",
        "amount",
        "weight",
        "length",
        "width",
        "height",
        "shipping_freight",
        "low_avail_limit",
        "timestamp",
        "updated_timestamp",
        "usergroup_ids",
        "is_edp",
        "edp_shipping",
        "unlimited_download",
        "tracking",
        "free_shipping",
        "zero_price_action",
        "is_pbp",
        "is_op",
        "is_oper",
        "is_returnable",
        "return_period",
        "avail_since",
        "out_of_stock_actions",
        "localization",
        "min_qty",
        "max_qty",
        "qty_step",
        "list_qty_count",
        "tax_ids",
        "age_verification",
        "age_limit",
        "options_type",
        "exceptions_type",
        "details_layout",
        "shipping_params",
        "facebook_obj_type",
        "parent_product_id",
        "buy_now_url",
        "my_supplier_id",
        "supplier_amount",
        "manufacturer_code",
        "supplier_access_time",
        "rf_stop_update_price",
        "rf_stop_update_amount",
        "rf_stop_update_status",
        "rf_cost"
      ],
      "attached_condition": "(`nuie_scalesta_net`.`cscart_products`.`product_id` in (94652,94653,94659,94660,94661,94663,94664,94665,94675,94676,94677,94813,94817,94818,94819,95449,95803,95805,95807,95809,95811,97719,97720,97721,97722,97723,97724,97725,97726,97727,97765,97766,97767,97768,97769,97770,97771,97772,97773,97775,97776,97777,97783,97784,97785,97787,97788,97789))"
    }
  }
}

Result

product_id	product_code	product_type	status	company_id	timestamp	updated_timestamp	is_edp	edp_shipping	unlimited_download	free_shipping	is_pbp	is_op	is_oper	is_returnable	return_period	out_of_stock_actions	age_verification	details_layout	shipping_params	my_supplier_id	manufacturer_code	supplier_access_time	rf_stop_update_price	rf_stop_update_amount	rf_stop_update_status
94652	BAYF428	P	A	2	1753473690	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF428	1757016007	N	N	N
94653	BAYF431	P	A	2	1753473690	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF431	1757016007	N	N	N
94659	BAYF481	P	A	2	1753473693	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF481	1757016007	N	N	N
94660	BAYF484	P	A	2	1753473694	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF484	1757016007	N	N	N
94661	BAYF487	P	A	2	1753473694	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF487	1757016007	N	N	N
94663	BAYF822	P	A	2	1753473695	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF822	1757016007	N	N	N
94664	BAYF828	P	A	2	1753473695	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF828	1757016007	N	N	N
94665	BAYF831	P	A	2	1753473695	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF831	1757016007	N	N	N
94675	BAYF881	P	A	2	1753473700	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF881	1757016007	N	N	N
94676	BAYF884	P	A	2	1753473700	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF884	1757016007	N	N	N
94677	BAYF887	P	A	2	1753473700	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF887	1757016007	N	N	N
94813	OFF3217	P	A	2	1753473769	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	OFF3217	1757016007	N	N	N
94817	PP1127	P	A	2	1753473772	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	PP1127	1757016007	N	N	N
94818	PP1128	P	A	2	1753473772	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	PP1128	1787688005	N	N	N
94819	PP1129	P	A	2	1753473773	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	PP1129	1787688005	N	N	N
95449	237TITMC350	P	A	2	1754769642	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	237TITMC350	1757016007	N	N	N
95803	LSL117	P	A	2	1754773237	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	LSL117	1757016007	N	N	N
95805	LSL1417	P	A	2	1754773239	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	LSL1417	1757016007	N	N	N
95807	LSL1817	P	A	2	1754773242	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	LSL1817	1757016007	N	N	N
95809	LSL3117	P	A	2	1754773245	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	LSL3117	1757016007	N	N	N
95811	LSL3217	P	A	2	1754773247	1757016007	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	LSL3217	1757016007	N	N	N
97719	BAYF122-P	P	A	2	1757103439	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF122-P	1787688005	N	N	N
97720	BAYF123-P	P	A	2	1757103439	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF123-P	1787688005	N	N	N
97721	BAYF124-P	P	A	2	1757103439	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF124-P	1787688005	N	N	N
97722	BAYF128-P	P	A	2	1757103439	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF128-P	1787688005	N	N	N
97723	BAYF129-P	P	A	2	1757103440	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF129-P	1787688005	N	N	N
97724	BAYF130-P	P	A	2	1757103440	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF130-P	1787688005	N	N	N
97725	BAYF131-P	P	A	2	1757103440	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF131-P	1787688005	N	N	N
97726	BAYF132-P	P	A	2	1757103441	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF132-P	1787688005	N	N	N
97727	BAYF133-P	P	A	2	1757103441	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF133-P	1787688005	N	N	N
97765	BAYF181-P	P	A	2	1757103456	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF181-P	1787688005	N	N	N
97766	BAYF182-P	P	A	2	1757103456	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF182-P	1787688005	N	N	N
97767	BAYF183-P	P	A	2	1757103456	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF183-P	1787688005	N	N	N
97768	BAYF184-P	P	A	2	1757103457	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF184-P	1787688005	N	N	N
97769	BAYF185-P	P	A	2	1757103457	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF185-P	1787688005	N	N	N
97770	BAYF186-P	P	A	2	1757103458	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF186-P	1787688005	N	N	N
97771	BAYF187-P	P	A	2	1757103458	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF187-P	1787688005	N	N	N
97772	BAYF188-P	P	A	2	1757103458	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF188-P	1787688005	N	N	N
97773	BAYF189-P	P	A	2	1757103458	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF189-P	1787688005	N	N	N
97775	BAYF422-P	P	A	2	1757103459	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF422-P	1787688005	N	N	N
97776	BAYF428-P	P	A	2	1757103459	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF428-P	1787688005	N	N	N
97777	BAYF431-P	P	A	2	1757103460	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF431-P	1787688005	N	N	N
97783	BAYF481-P	P	A	2	1757103463	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF481-P	1787688005	N	N	N
97784	BAYF484-P	P	A	2	1757103464	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF484-P	1787688005	N	N	N
97785	BAYF487-P	P	A	2	1757103464	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF487-P	1787688005	N	N	N
97787	BAYF822-P	P	A	2	1757103465	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF822-P	1787688005	N	N	N
97788	BAYF828-P	P	A	2	1757103465	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF828-P	1787688005	N	N	N
97789	BAYF831-P	P	A	2	1757103465	1787688005	N	N	N	N	N	N	N	Y	10	N	N	default	a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	1	BAYF831-P	1787688005	N	N	N

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

PHP Deprecated

Message

Error at

Backtrace

Query time 0.00093

JSON explain

Result