SELECT 
  products.product_id 
FROM 
  cscart_products as products 
  LEFT JOIN cscart_products_categories as products_categories ON products.product_id = products_categories.product_id 
WHERE 
  products.product_id = 31827 
  AND 1 
  AND products_categories.category_id IN (
    2992, 
    3095, 
    2919, 
    1491, 
    2806, 
    2995, 
    2996, 
    2997, 
    2993, 
    2994, 
    2920, 
    3002, 
    3014, 
    3015, 
    3016, 
    3018, 
    3019, 
    3089, 
    3051, 
    3056, 
    2900, 
    3116, 
    3030, 
    2990, 
    2991, 
    2804, 
    2805, 
    3005, 
    2022, 
    2701, 
    2693, 
    2859, 
    2813, 
    2817, 
    2816, 
    2815, 
    2812, 
    2811, 
    2819, 
    2944, 
    2739, 
    3007, 
    2708, 
    2980, 
    2789, 
    3025, 
    3057, 
    2934, 
    2686, 
    2862, 
    2685, 
    3001, 
    3000, 
    2924, 
    2818, 
    2928, 
    2740, 
    2689, 
    2690, 
    2738, 
    2827, 
    2695, 
    2923, 
    2698, 
    2699, 
    2702, 
    2999, 
    2705, 
    2706, 
    2825, 
    2710, 
    2711, 
    2712, 
    2713, 
    2714, 
    2715, 
    2716, 
    2717, 
    2718, 
    2719, 
    2720, 
    2721, 
    2722, 
    2725, 
    2726, 
    2727, 
    2728, 
    2729, 
    2730, 
    2731, 
    2732, 
    2733, 
    2734, 
    2735, 
    2736, 
    2737, 
    2820, 
    2741, 
    2743, 
    2744, 
    2745, 
    2746, 
    2747, 
    2748, 
    2749, 
    2750, 
    2751, 
    2752, 
    2753, 
    2754, 
    2755, 
    2756, 
    2757, 
    2758, 
    2759, 
    2760, 
    2761, 
    2762, 
    2763, 
    2764, 
    2765, 
    2768, 
    2769, 
    2771, 
    2772, 
    2773, 
    2774, 
    2775, 
    2776, 
    2777, 
    2778, 
    2779, 
    2780, 
    2781, 
    2782, 
    2783, 
    2784, 
    2785, 
    2786, 
    2788, 
    3006, 
    2794, 
    2834, 
    2814, 
    2821, 
    2822, 
    2823, 
    2824, 
    2826, 
    2828, 
    2829, 
    2830, 
    2831, 
    2832, 
    2833, 
    2925, 
    2926, 
    2927, 
    2929, 
    2848, 
    2849, 
    2850, 
    2851, 
    2852
  )

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.69"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "products",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "5K"
          },
          "used_columns": [
            "product_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "products_categories",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "pt"
          ],
          "key": "pt",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 0,
          "filtered": "50.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "0.60",
            "eval_cost": "0.05",
            "prefix_cost": "0.70",
            "data_read_per_join": "8"
          },
          "used_columns": [
            "product_id",
            "category_id"
          ],
          "attached_condition": "(`cscart_db`.`products_categories`.`category_id` in (2992,3095,2919,1491,2806,2995,2996,2997,2993,2994,2920,3002,3014,3015,3016,3018,3019,3089,3051,3056,2900,3116,3030,2990,2991,2804,2805,3005,2022,2701,2693,2859,2813,2817,2816,2815,2812,2811,2819,2944,2739,3007,2708,2980,2789,3025,3057,2934,2686,2862,2685,3001,3000,2924,2818,2928,2740,2689,2690,2738,2827,2695,2923,2698,2699,2702,2999,2705,2706,2825,2710,2711,2712,2713,2714,2715,2716,2717,2718,2719,2720,2721,2722,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2820,2741,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2768,2769,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2788,3006,2794,2834,2814,2821,2822,2823,2824,2826,2828,2829,2830,2831,2832,2833,2925,2926,2927,2929,2848,2849,2850,2851,2852))"
        }
      }
    ]
  }
}