SELECT 
  * 
FROM 
  cscart_ble_content_images 
WHERE 
  page_id = 1491 
ORDER BY 
  position ASC, 
  image_id DESC

Query time 0.00064

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_ble_content_images.position, cscart_ble_content_images.image_id desc",
        "table": {
          "table_name": "cscart_ble_content_images",
          "access_type": "ALL",
          "rows": 1510,
          "filtered": 100,
          "attached_condition": "cscart_ble_content_images.page_id = 1491"
        }
      }
    }
  }
}

Result

image_id page_id position title src link_url product_id category_id
1635 1491 0 Wallaby Flush Mount Pendant Light finish-gallery-sunflower-1.jpg /lighting/ceiling-lights/flush-mount-lights/wallaby-flush-mount-pendant-light/ 62169 0
1636 1491 5 Canal Gooseneck Light finish-gallery-sunflower-2.jpg /lighting/wall-lights/gooseneck-lights/canal-gooseneck-light/ 61697 0
1637 1491 10 Wilcox Cord Pendant Light finish-gallery-sunflower-3.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/wilcox-deep-bowl-pendant-light/ 64726 0
1638 1491 15 Downtown Swing Arm Wall Sconce finish-gallery-sunflower-4.jpg /lighting/wall-lights/wall-sconces/downtown-swing-arm-sconce/ 64353 0
1639 1491 20 Seaside Cord Pendant Light finish-gallery-sunflower-5.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/seaside-pendant-light/ 64722 0
1640 1491 25 Bomber LED Gooseneck Light finish-gallery-sunflower-6.jpg /led-lighting/wall-lights/gooseneck-lights/bomber-led-gooseneck-light/ 64966 0
1641 1491 30 Bullet Gooseneck Light finish-gallery-sunflower-7.jpg /led-lighting/wall-lights/sign-lights/the-bullet-gooseneck-led-sign-light/ 64357 0
1642 1491 35 Kao Wall Sconce finish-gallery-sunflower-8.jpg /lighting/wall-lights/wall-sconces/kao-wall-sconce/ 62975 0
1643 1491 40 Gladstone Wall Sconce finish-gallery-sunflower-9.jpg /lighting/wall-lights/wall-sconces/gladstone-dome-shade-wall-sconce/ 63384 0
1644 1491 45 Sinclair LED Stem finish-gallery-sunflower-10.jpg /led-lighting/ceiling-lights/stem-mount-pendant-lighting/sinclair-led-stem-mount-pendant-light/ 64988 0
1645 1491 50 Tuscany Cord Pendant Light finish-gallery-sunflower-11.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/tuscany-cord-hung-pendant/ 61693 0
1646 1491 55 Wallaby Cord Pendant Light finish-gallery-sunflower-12.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/wallaby-pendant-light/ 62163 0
1647 1491 60 Laramie Nautical LED Gooseneck Light finish-gallery-sunflower-13.jpg /led-lighting/wall-lights/gooseneck-lights/the-laramie-nautical-led-gooseneck/ 63202 0
1648 1491 65 Bomber 2-Light Stem Pendant Light finish-gallery-sunflower-14.jpg /lighting/ceiling-lights/chandeliers/bomber-2-light-stem-mount-pendant/ 59894 0
1649 1491 70 Canal SoHo Wall Sconce finish-gallery-sunflower-15.jpg /lighting/wall-lights/wall-sconces/canal-soho-sconce/ 61081 0
1650 1491 75 Marathon Cord Pendant Light finish-gallery-sunflower-16.jpg /lighting/ceiling-lights/cord-hung-pendant-lighting/marathon-pendant-light/ 64764 0
1651 1491 80 Industrial Guard Double Vanity Light finish-gallery-sunflower-17.jpg /lighting/wall-lights/vanity-lights/industrial-guard-double-vanity-light/ 63231 0
1652 1491 85 Downtown Swing Arm Wall Sconce finish-gallery-sunflower-18.jpg 0 0