Sandbox

SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    82444, 82443, 85611, 85610, 94983, 94984, 
    94985, 94986, 94987, 94988, 94989, 
    94990, 94991, 95545, 96787, 96866, 
    96867, 96868, 96869, 96870, 96871, 
    96872, 96873, 96874, 98511
  )

Query time 0.00074

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "11.29"
    },
    "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": 25,
      "rows_produced_per_join": 25,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.79",
        "eval_cost": "2.50",
        "prefix_cost": "11.29",
        "data_read_per_join": "119K"
      },
      "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 (82444,82443,85611,85610,94983,94984,94985,94986,94987,94988,94989,94990,94991,95545,96787,96866,96867,96868,96869,96870,96871,96872,96873,96874,98511))"
    }
  }
}

Result

product_id	product_code	product_type	status	company_id	list_price	weight	timestamp	updated_timestamp	is_edp	edp_shipping	unlimited_download	free_shipping	zero_price_action	is_pbp	is_op	is_oper	is_returnable	return_period	out_of_stock_actions	min_qty	max_qty	tax_ids	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
82443	AFCE8080	P	A	2	549.17	46.200	1679753840	1757016007	N	N	N	N	R	N	N	N	Y	10	B	1	50	6	N		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;}	0		1757016007	N	N	N
82444	AFCE8080H3	P	A	2	602.50	0.000	1679753843	1772139606	N	N	N	N	R	N	N	N	Y	10	B	1	50	6	N		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;}	0		1772139606	N	N	N
85610	ERCE8080	P	A	2	362.50	38.500	1679759686	1757016007	N	N	N	N	R	N	N	N	Y	10	B	1	50	6	N		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;}	0		1757016007	N	N	N
85611	ERCE8080H5	P	A	2	394.17	38.700	1679759688	1772139606	N	N	N	N	R	N	N	N	Y	10	B	1	50	6	N		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;}	0		1772139606	N	N	N
94983	AQVEN6161	P	A	2	0.00	0.000	1754596859	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	AQVEN6161	1757016007	N	N	N
94984	AQVEN6162	P	A	2	0.00	0.000	1754596859	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	AQVEN6162	1757016007	N	N	N
94985	AQVEN6163	P	A	2	0.00	0.000	1754596860	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	AQVEN6163	1757016007	N	N	N
94986	AQVEN6164	P	A	2	0.00	0.000	1754596860	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	AQVEN6164	1757016007	N	N	N
94987	AQVEN6165	P	A	2	0.00	0.000	1754596860	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	AQVEN6165	1757016007	N	N	N
94988	AQVEN6166	P	A	2	0.00	0.000	1754596861	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	AQVEN6166	1757016007	N	N	N
94989	AQVEN6167	P	A	2	0.00	0.000	1754596861	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	AQVEN6167	1757016007	N	N	N
94990	AQVEN6168	P	A	2	0.00	0.000	1754596862	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	AQVEN6168	1757016007	N	N	N
94991	AQVEN6169	P	A	2	0.00	0.000	1754596862	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	AQVEN6169	1757016007	N	N	N
95545	238900CORN-Q	P	A	2	0.00	0.000	1754769692	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	238900CORN-Q	1757016007	N	N	N
96787	AFCE8080-E6-P	P	A	2	0.00	0.000	1757102521	1772139606	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	AFCE8080-E6-P	1772139606	N	N	N
96866	AQVEN6161-P	P	A	2	0.00	0.000	1757102605	1772139606	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	AQVEN6161-P	1772139606	N	N	N
96867	AQVEN6162-P	P	A	2	0.00	0.000	1757102606	1772139606	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	AQVEN6162-P	1772139606	N	N	N
96868	AQVEN6163-P	P	A	2	0.00	0.000	1757102606	1772139606	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	AQVEN6163-P	1772139606	N	N	N
96869	AQVEN6164-P	P	A	2	0.00	0.000	1757102607	1772139606	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	AQVEN6164-P	1772139606	N	N	N
96870	AQVEN6165-P	P	A	2	0.00	0.000	1757102607	1772139606	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	AQVEN6165-P	1772139606	N	N	N
96871	AQVEN6166-P	P	A	2	0.00	0.000	1757102608	1772139606	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	AQVEN6166-P	1772139606	N	N	N
96872	AQVEN6167-P	P	A	2	0.00	0.000	1757102608	1772139606	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	AQVEN6167-P	1772139606	N	N	N
96873	AQVEN6168-P	P	A	2	0.00	0.000	1757102609	1772139606	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	AQVEN6168-P	1772139606	N	N	N
96874	AQVEN6169-P	P	A	2	0.00	0.000	1757102609	1772139606	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	AQVEN6169-P	1772139606	N	N	N
98511	ERCE8080-E5-P	P	A	2	0.00	0.000	1757103916	1772139606	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	ERCE8080-E5-P	1772139606	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.00074

JSON explain

Result