Sandbox

SELECT 
  * 
FROM 
  cscart_ble_product_details 
WHERE 
  detail_id IN ('690', '691', '692', '693', '3313') 
  OR type = 'G' 
ORDER BY 
  position, 
  title ASC

Query time 0.00143

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_ble_product_details.position, cscart_ble_product_details.title",
        "table": {
          "table_name": "cscart_ble_product_details",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 3239,
          "filtered": 100,
          "attached_condition": "cscart_ble_product_details.detail_id in ('690','691','692','693','3313') or cscart_ble_product_details.`type` = 'G'"
        }
      }
    }
  }
}

Result

detail_id	position	title	type	status	extra_details	disabled_on
3313	0	Dimensions	L	A
691	2	Max Wattage Per Socket	L	A	Light Bulb Not Included Fixtures Configured with GU24 Socket Are Non-Returnable
692	4	Schoolhouse Globes	L	A	Schoolhouse globes with painted bands should be gently cleaned with a damp, soft cloth. Globes with painted bands should not be immersed in water or rinsed under running water. To protect the glass and painted bands, avoid alcohol-based and abrasive cleaners. Schoolhouse globes featuring painted bands should only be used indoors, excluding full bathrooms.
693	6	Copper & Brass	L	A	For oil-rubbed copper, weathered copper and brass finishes, slight variations may occur from shade to shade. Copper and brass fixtures have a longer lead time and may take up to 4 weeks to manufacture. That are no returns accepted on these metals. Copper is a "living" metal that, without regular cleaning, will undergo a natural weathering process. Much like the formation of rust on iron, a patina develops on copper which actually protects the metal. If you prefer the new-penny look of copper, you can keep it shiny with regular care with a gentle cleaning agent such as Bar Keeper's Friend.
1	8	Lead Times & Returns	G	A	Lead Time: Standard lead time is 8-10 weeks. Products utilizing natural metals, including brass and copper, may take an additional 3-4 weeks to manufacture beyond the standard lead time. PLEASE NOTE: Due to current supply chain challenges and additional factors beyond Barn Light Electric's control, lead times may be longer than customary. Please contact our Customer Care Team if you have any questions or concerns regarding your order(s) at 321-269-2299. We apologize for this inconvenience and appreciate your extended patience.	[61329]
2	10	Finish Care & Maintenance	G	A	No metal fixture, no matter the finish, is guaranteed against corrosion especially in salt air environments. If your fixture is installed in a location near salt water, we recommend cleaning it frequently. If your fixture is not installed in a location near salt water, we recommend periodic cleaning with a mild soap-and-water wash and gentle buffing to extend the life of our painted finishes.	[]