just let you know…i took slow query
i have 23000 product , 9 lanaguges , 3400 categeory.
---------wow
=======================================
[left]SET NAMES 'utf8'SELECT * FROM cscart_sessions WHERE 1 AND session_id = '4le1p5d2abo23n5oj7r54465h0' AND area = 'C'SELECT * FROM cscart_wg_geoip_currencies WHERE lic_id='1'SELECT a., b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'CART_LANGUAGE' WHERE status = 'A' ORDER BY a.positionSELECT count() FROM cscart_languages WHERE lang_code = 'EN' AND status IN ('A')SELECT localization_id, custom_weight_settings, weight_symbol, weight_unit FROM cscart_localizations WHERE status = 'A'SELECT cscart_languages.* FROM cscart_languages WHERE cscart_languages.status = 'A' SELECT a., b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'EN' WHERE status = 'A' ORDER BY a.positionSELECT object_holder, description FROM cscart_common_descriptions WHERE object_id = 0 AND lang_code = 'EN'SELECT object_holder, description FROM cscart_common_descriptions WHERE object_id = 0 AND lang_code = 'EN'SELECT a.localization_id, a.status, b.localization, a.is_default FROM cscart_localizations as a LEFT JOIN cscart_localization_descriptions as b ON a.localization_id = b.localization_id AND b.lang_code = 'EN' LEFT JOIN cscart_localization_elements AS c ON a.localization_id = c.localization_id AND c.element_type = 'L' RIGHT JOIN cscart_languages AS d ON c.element = d.lang_code AND d.status = 'A' WHERE a.status = 'A' ORDER BY localizationSELECT country FROM cscart_country_descriptions WHERE code = 'KR' AND lang_code = 'EN'SELECT cscart_state_descriptions.state FROM cscart_states LEFT JOIN cscart_state_descriptions ON cscart_state_descriptions.state_id = cscart_states.state_id AND cscart_state_descriptions.lang_code = 'EN' WHERE cscart_states.country_code = 'KR' AND cscart_states.code = 'KR'SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id WHERE lang_code = 'EN' AND l.dispatch LIKE 'index.index' ORDER BY l.object_ids DESC LIMIT 1SELECT data FROM cscart_storage_data WHERE data_key = 'mega_menu_pro_setup'SELECT event_id, title FROM cscart_giftreg_events WHERE (start_date <= 1372396552 AND end_date > 1372396552) AND type IN ('P','U') ORDER BY start_date LIMIT 3SELECT data FROM cscart_storage_data WHERE data_key = 'gift_registry_next_check'SELECT * FROM cscart_se_settingsSELECT company_id FROM cscart_companies WHERE status = 'A'SELECT * FROM cscart_languages WHERE status = 'A'SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT lang_code, value FROM cscart_se_settings WHERE name = 'parent_private_key' AND company_id = 0SELECT * FROM cscart_wg_country_shipping WHERE lic_id='1'SELECT status FROM cscart_countries WHERE code='KR'SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)[/left]
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id WHERE lang_code = 'EN' AND l.dispatch LIKE 'index.index' ORDER BY
l.object_ids DESC LIMIT 1SELECT * FROM cscart_bm_containers as c WHERE c.location_id = 9 SELECT , IF (cscart_bm_containers.location_id != 9, 0, 1) as default FROM cscart_bm_containers INNER JOIN cscart_bm_locations ON cscart_bm_containers.location_id = cscart_bm_locations.location_id WHERE cscart_bm_locations.is_default = 1 AND (cscart_bm_containers.position='TOP' OR cscart_bm_containers.position='BOTTOM') SELECT g. FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE c.container_id IN (1, 26, 3) ORDER BY g.parent_id, g.grid_id ASCSELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.,cscart_bm_blocks.,cscart_bm_blocks_descriptions. FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (31, 78, 79, 80, 101, 102, 103, 82, 42, 43, 44, 47, 52, 96, 97, 98, 99, 53, 55, 57, 62, 63, 65, 100) AND cscart_bm_blocks_descriptions.lang_code='EN' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id SELECT lang_code, name FROM cscart_languages WHERE status = 'A'SELECT status FROM cscart_menus WHERE menu_id = 3SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.status, sd.position, sd.parent_id, sd.id_path, sd.banner_id, sd.feature_id, sd.cat_view FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'EN' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.positionSELECT id_path FROM cscart_categories WHERE category_id = 166SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_seo_names.name as seo_name FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'EN' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id AND cscart_seo_names.type = 'c' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'EN' WHERE 1 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.id_path LIKE '166/%' ORDER BY cscart_categories.position asc, cscart_category_descriptions.category asc SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(8247, 8176, 8157, 1748, 2075, 8005, 7982, 3128, 2796, 3922, 8276, 8133, 6260, 7738, 8108, 2051, 4016, 1911, 3910, 3997, 8636, 7149, 8210, 8226, 3830, 8182, 8064, 6257, 5947, 6011, 8087, 3767, 8094, 5851, 8129, 8035, 8495, 983, 6033, 6065, 6017, 6053, 1009, 2002, 1567, 1620, 1637, 3964, 2482, 3818, 448, 5696, 5703, 5707, 1887, 3942, 1695, 886, 2516, 2541, 6321, 3911, 3928, 916, 888, 450, 2756, 8096, 5887, 7154, 8045, 996, 1540, 1546, 1553, 1559, 1472, 2046, 3598, 7137, 6037, 5955, 2499, 1619, 785, 1967, 1116, 756, 5892, 5864, 7944, 1521, 6204, 6187, 6170, 5962, 426, 6637, 3030, 1522, 1531, 2815, 8290, 7946, 7948, 8074, 8000, 7965, 7980, 6629, 6571, 5924, 5897, 3038, 3768, 8298, 7167, 1873, 5821, 2529, 3035, 2776, 2755, 6334, 6641, 8509, 6658, 428, 449, 466, 6668, 6672, 3776, 3065, 2375, 2389, 2349, 2363, 3587, 4238, 3592, 4244, 8640, 1717, 7130, 7116, 5873, 4064, 1918, 3101, 2056, 6646, 6650, 7740, 4034, 982, 1257, 1968, 3585, 7549, 2808, 7550, 930, 1494, 2244, 1288, 2302, 3156, 7175, 7105, 2480, 1373, 4237, 1004, 1079, 1071, 776, 778, 777, 6115, 766, 4065, 6651, 2365, 1259, 1278, 2542, 8134, 1678, 8278, 1658, 6261, 4013, 3921, 4018, 3923, 1523, 1532, 596, 1514, 984, 2351, 6659, 8065, 8009, 8212, 1496, 3588, 4239, 3593, 4245, 8641, 2045, 1716, 2517, 5948, 6012, 3929, 1749, 6066, 3778, 1168, 7741, 3068, 8496, 8036, 7983, 3966, 1970, 1638, 997, 6018, 8019, 6054, 6669, 8191, 3973, 2251, 8228, 5733, 7169, 6673, 975, 455, 3912, 6322, 887, 3036, 2348, 1977, 2080, 2498, 1868, 3831, 8291, 7155, 1621, 8248, 1011, 1428, 1375, 1396, 3753, 6039, 5956, 6638, 1474, 8075, 8001, 1920, 7147, 1310, 3586, 3620, 2809, 3200, 1276, 7552, 931, 2246, 1503, 4243, 1394, 1050, 6644, 1080, 1072, 5852, 7134, 3130, 2816, 3643, 5715, 8299, 8088, 8099, 3774, 2407, 917, 429, 889, 464, 467, 1912, 2356, 2777, 2052, 2273, 3941, 3040, 1988, 7117, 1541, 1547, 1554, 3202, 7590, 5925, 1560, 775, 8510, 2486, 3160, 1848, 1505, 3037, 2757, 2775, 2350, 5822, 1875, 963, 6630, 1718, 5752, 6572, 5898, 3769, 1124, 7967, 3103, 2060, 3819, 2423, 2452, 2304, 3622, 8637, 2534, 1569, 7950, 3775, 5697, 5704, 5708, 6653, 6335, 1177, 5874, 8177, 3600, 1228, 8158, 1979, 995, 6035, 6647, 2004, 2390, 7176, 7775, 7133, 1889, 8097, 8161, 8023, 5885, 4036, 1636, 786, 757, 2019, 5893, 1831, 5865, 7945, 2552, 1530, 6205, 6188, 6171, 5963, 427, 8085, 3749, 5783, 6333, 764, 6167, 3750, 6169, 5784, 3751, 7158, 4067, 8131, 7177, 7108, 8300, 7952, 3943, 1524, 1533, 3644, 1679, 1659, 5853, 2361, 8162, 4019, 3924, 2778, 1891, 1013, 8020, 3803, 1450, 1397, 1506, 5886, 8178, 8159, 1655, 2047, 5949, 1539, 3913, 1125, 7135, 890, 3930, 6055, 1750, 2391, 6639, 2810, 5894, 5964, 3754, 6660, 1877, 7745, 3770, 1070, 1850, 5753, 6573, 5899, 8010, 985, 7985, 1010, 1698, 7776, 1178, 1229, 3071, 8195, 8497, 8066, 1870, 6670, 758, 2536, 2404, 1914, 8121, 2798, 8279, 6013, 6323, 2817, 2554, 3062, 932, 2274, 5734, 3780, 8037, 1719, 3777, 6040, 5957, 8292, 1639, 1318, 1512, 2043, 3641, 2067, 5926, 3163, 8214, 2366, 8089, 8100, 1515, 8046, 8511, 7947, 8249, 1570, 1008, 1843, 8638, 6336, 1622, 1376, 1542, 2062, 1548, 1555, 1561, 3042, 8232, 1989, 2357, 2758, 2254, 3832, 2352, 965, 3105, 468, 469, 5698, 6067, 3623, 430, 763, 7968, 5705, 2425, 5709, 998, 3601, 2305, 3589, 4240, 2543, 3594, 4246, 3132, 1986, 2081, 1169, 2795, 8079, 8002, 2408, 1980, 7118, 1476, 6019, 3787, 6674, 7150, 7170, 2053, 8025, 5875, 918, 3203, 1971, 5823, 2488, 8110, 4037, 1172, 1727, 5761, 6645, 8136, 3820, 1304, 4069, 2257, 3100, 1077, 2083, 933, 1518, 3645, 1680, 5965, 6632, 7138, 3590, 4241, 3595, 4247, 4020, 3925, 2054, 3799, 2759, 8163, 3783, 8018, 1179, 1230, 8179, 3133, 7984, 1261, 1280, 2024, 2000, 8122, 1422, 2799, 5950, 3914, 3602, 1126, 1751, 3107, 966, 759, 1720, 8639, 6324, 7122, 5824, 3944, 2275, 7953, 5754, 3755, 7641, 5876, 8166, 6640, 1398, 8197, 5888, 1543, 1549, 1562, 1556, 2779, 6649, 2807, 6007, 1656, 2048, 8293, 8280, 6014, 1545, 2489, 3779, 2544, 1170, 2050, 7172, 891, 8498, 7746, 470, 919, 490, 431, 653, 498, 6041, 5958, 5790, 1640, 1853, 2064, 6574, 5900, 1525, 1534, 1972, 2070, 1057, 1012, 7153, 8013, 8217, 2306, 7969, 3805, 2420, 7551, 7178, 1739, 2373, 7777, 2501, 8093, 8101, 2811, 1173, 5699, 2453, 8067, 8233, 1981, 8038, 1623, 986, 6038, 6056, 1865, 8048, 8512, 7951, 3073, 3821, 1699, 6661, 6671, 2362, 8003, 1507, 1498, 3833, 3931, 2818, 1452, 1479, 1015, 7986, 2539, 2426, 3204, 5927, 3164, 3624, 6112, 6068, 7161, 7148, 1377, 1319, 2409, 8301, 2354, 1879, 5854, 999, 6020, 2521, 1993, 5735, 3044, 1990, 2368, 4032, 4038, 8633, 5762, 5866, 5837, 6116, 5883, 7163, 1171, 2524, 6652, 1544, 3591, 1550, 4242, 3596, 1557, 4249, 5959, 1563, 1998, 2800, 5825, 3926, 1681, 1661, 1871, 5855, 3166, 8061, 8055, 1480, 7174, 6008, 8281, 8634, 5755, 1747, 1262, 1281, 760, 7123, 1982, 1881, 6633, 2355, 967, 3075, 2503, 2025, 5928, 8017, 1836, 2428, 1991, 892, 7987, 3834, 2819, 2760, 3646, 2049, 1469, 5951, 8295, 2780, 2259, 1378, 595, 2001, 2411, 3625, 2814, 1552, 1000, 3756, 3945, 7156, 2085, 2448, 8138, 3121, 3915, 8513, 8302, 6332, 8028, 8080, 1641, 3205, 3603, 3822, 5878, 5736, 762, 8199, 7778, 4039, 3932, 5791, 8068, 1508, 5889, 1499, 8218, 8499, 7749, 6086, 2370, 6662, 8168, 8181, 3781, 920, 1526, 1535, 6044, 6026, 2525, 2055, 8268, 2558, 1721, 7113, 7970, 8260, 8039, 1973, 7989, 2364, 1399, 8234, 3046, 7957, 7601, 6575, 472, 1180, 492, 432, 2491, 674, 1231, 510, 5901, 2455, 1624, 3810, 6057, 1014, 1058, 1700, 3135, 3110, 2393, 7140, 1017, 987, 6069, 2066, 2277, 2812, 5763, 7979, 6230, 1061, 6079, 2781, 1885, 2561, 6009, 1682, 7124, 5826, 4022, 3112, 1992, 8297, 8282, 3647, 6326, 5756, 2260, 2068, 1263, 1282, 2506, 5879, 1753, 8264, 1181, 2026, 1232, 2813, 2540, 5952, 6076, 1500, 2761, 893, 2820, 2493, 3626, 1019, 988, 6070, 2429, 3604, 779, 7633, 2801, 5856, 968, 2527, 3137, 7992, 7127, 7996, 3946, 3168, 474, 1974, 6663, 493, 436, 5785, 681, 516, 8056, 8171, 8183, 8030, 8514, 8031, 7583, 1527, 1536, 5737, 3916, 3048, 1128, 2003, 7988, 8202, 3927, 5890, 2395, 1379, 1642, 6022, 1016, 6030, 6046, 5960, 8029, 7669, 8500, 7750, 3808, 5796, 5929, 6058, 8221, 7160, 8069, 2413, 1400, 1856, 2012, 2308, 3782, 1625, 921, 3757, 618, 5994, 1837, 8303, 2457, 6576, 5902, 3597, 6043, 1558, 8040, 3077, 7964, 1983, 2388, 1883, 2278, 1722, 8363, 8236, 5764, 6256, 2762, 2782, 1528, 1537, 6049, 6032, 1510, 1501, 7126, 6010, 1683, 1723, 969, 2017, 630, 1838, 6327, 6045, 3138, 6577, 3817, 6664, 2261, 1754, 2309, 3170, 1566, 3079, 1264, 1283, 7792, 3050, 2563, 5953, 3648, 3809, 2027, 2821, 3824, 5786, 476, 922, 495, 437, 767, 684, 518, 6071, 8086, 1663, 2802, 5797, 3947, 5827, 7994, 5738, 7146, 5867, 8135, 2459, 8304, 8266, 1458, 3627, 1485, 2431, 1401, 6262, 2494, 6231, 5930, 1233, 8635, 5903, 2548, 7990, 8204, 8057, 1902, 1021, 5995, 8515, 8032, 7595, 3605, 8033, 1182, 989, 8082, 6077, 5757, 8224, 1975, 3207, 1018, 2005, 894, 1643, 5880, 8173, 6023, 1984, 3114, 1129, 7752, 8501, 8041, 6059, 7955, 3917, 2504, 2279, 2069, 8071, 5765, 5787, 6636, 6250, 2763, 1502, 6034, 2565, 3053, 7754, 2568, 3649, 6328, 6024, 3081, 2281, 2071, 5931, 5868, 1755, 5758, 8137, 3606, 6665, 7793, 1529, 1538, 3140, 2021, 1910, 5954, 2028, 1130, 2461, 6060, 3629, 6047, 8140, 1664, 990, 5828, 8072, 3918, 633, 5904, 5996, 923, 768, 1234, 1839, 1183, 1724, 2783, 6078, 6578, 5881, 1460, 895, 3829, 6072, 8305, 2433, 781, 8267, 2823, 2310, 3759, 8007, 1644, 2495, 8050, 7956, 7995, 7991, 8205, 8058, 3117, 1985, 1511, 5739, 8516, 3208, 3825, 8083, 7142, 533, 478, 497, 438, 697, 1976, 1627, 2006, 1023, 5798, 970, 1402, 4063, 7128, 1858, 3940, 8502, 2262, 5766, 5859, 5840, 7143, 2824, 6073, 2804, 5895, 1725, 2282, 3141, 5872, 3083, 5759, 5905, 5997, 1235, 1756, 1915, 782, 7794, 1860, 3119, 2435, 1266, 7730, 6666, 7757, 5932, 3631, 1840, 635, 896, 6061, 1685, 1665, 1025, 1285, 2037, 5869, 3919, 3209, 5740, 8306, 554, 2464, 479, 1184, 439, 499, 6579, 2764, 3842, 2784, 8269, 1488, 1404, 1442, 1628, 6048, 5799, 712, 2311, 769, 440, 3607, 3055, 6074, 5830, 7993, 8207, 8059, 3175, 8034, 1380, 1131, 1645, 924, 2496, 7958, 8051, 7997, 8084, 2029, 991, 8139, 6259, 2007, 971, 2263, 5767, 8063, 5841, 5871, 2009, 260, 3143, 2283, 2785, 791, 1629, 6330, 2374, 8481, 2805, 1841, 770, 7737, 7796, 6050, 5800, 3827, 1406, 5998, 1381, 3608, 6580, 5906, 8141, 3085, 1686, 1267, 897, 2765, 7171, 8070, 1286, 1132, 5933, 8272, 3176, 2466, 3920, 6667, 1059, 2312, 2073, 5760, 3761, 6027, 6062, 992, 557, 481, 925, 500, 3210, 7966, 716, 1024, 7974, 2497, 2436, 1726, 3632, 1236, 3790, 663, 441, 8012, 1646, 2030, 5741, 1827, 7611, 7998, 5870, 3057, 2264, 5768, 5831, 3806, 261, 6063, 6051, 5801, 1066, 5742, 6657, 1630, 1237, 5793, 3609, 3059, 7173, 2265, 6331, 3177, 1186, 8472, 8483, 1863, 717, 1758, 6028, 993, 1466, 2313, 1687, 1667, 1268, 6080, 5832, 5999, 3792, 3762, 926, 2394, 680, 3087, 3828, 792, 1031, 1647, 6581, 2467, 1026, 1382, 8142, 502, 5907, 7797, 1287, 1408, 898, 563, 3211, 5934, 3634, 2031, 7761, 8014, 7999, 771, 2284, 5769, 8492, 1064, 6029, 726, 483, 994, 443, 1707, 1032, 2032, 1648, 8621, 2314, 959, 8485, 8473, 3962, 927, 503, 1383, 5743, 5706, 2266, 1491, 3763, 1409, 1759, 1027, 1688, 6081, 8493, 793, 1238, 3061, 3088, 804, 2285, 682, 1065, 7799, 3179, 8143, 2468, 5935, 3795, 6000, 6075, 2767, 2787, 6582, 3610, 1269, 1187, 1134, 5908, 3212, 7763, 1631, 1289, 6064, 6052, 3635, 5770, 6229, 802, 3764, 1033, 3637, 8016, 506, 2286, 5732, 1649, 3969, 1189, 3796, 8144, 8475, 8487, 1492, 1632, 575, 2315, 1669, 794, 1760, 5744, 6082, 1028, 1135, 900, 6001, 1437, 3181, 7800, 691, 5701, 5710, 3090, 6583, 2788, 3611, 6168, 1270, 7764, 6031, 2469, 522, 3213, 1290, 2267, 2768, 1030, 1067, 6584, 535, 729, 901, 8476, 8488, 5745, 692, 2287, 1633, 6002, 1438, 1034, 3094, 1670, 1690, 3612, 5771, 1761, 1192, 2316, 1136, 5937, 2268, 1385, 3639, 3214, 5910, 7803, 5702, 8145, 3765, 2769, 3183, 3797, 5836, 2789, 1650, 582, 485, 1271, 1709, 6258, 2269, 2472, 3800, 702, 8146, 3215, 6003, 730, 588, 1294, 1137, 536, 486, 1710, 8478, 902, 1651, 508, 1691, 1671, 5772, 2770, 1215, 2317, 7807, 3613, 5911, 3766, 1762, 1068, 6585, 2790, 7769, 3715, 5746, 5938, 2270, 5912, 5747, 593, 1138, 8479, 1711, 734, 1217, 1692, 5773, 903, 5678, 5684, 5687, 5939, 6586, 5695, 3186, 6004, 3614, 1445, 8147, 2557, 1763, 3804, 3217, 1652, 2791, 2771, 1273, 3615, 1712, 1219, 707, 5679, 5685, 5688, 904, 2271, 2559, 5940, 6005, 6587, 6232, 1673, 1693, 5774, 1764, 5690, 5692, 2600, 1139, 3220, 3717, 1392, 5913, 5748, 1274, 6006, 5941, 1275, 5691, 5693, 905, 5781, 708, 1713, 1694, 1674, 5775, 6233, 805, 2793, 2773, 2601, 1765, 5689, 5680, 5686, 3616, 3189, 5914, 3224, 2560, 6588, 1654, 1140, 7943, 8021, 3190, 264, 3617, 5833, 5782, 2562, 6623, 6566, 5776, 6234, 1766, 5681, 5915, 1141, 5694, 5942, 2602, 2774, 906, 1142, 5682, 6635, 907, 2603, 3618, 5943, 1676, 5777, 2564, 6567, 5751, 6235, 1767, 5916, 2041, 3193, 6337, 5731, 6613, 5917, 6568, 6236, 3619, 5778, 5683, 2566, 2604, 1768, 5918, 944, 2605, 6085, 6655, 6569, 2569, 3194, 5945, 1769, 6656, 2606, 2570, 6570, 3195, 1770, 2571, 2607, 5921, 6240, 2572, 2608, 2573, 2609, 5922, 2610, 2574, 2575, 2612, 2576, 2577, 2613, 2578, 2615, 2580, 268, 2617, 2618, 269, 7547, 8118, 272, 7548, 8128, 5891, 5961, 867, 868, 869, 275, 871, 276) SELECT cscart_images_links., cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'EN' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 260 ORDER BY cscart_images_links.position, cscart_images_links.pair_idSELECT cscart_images_links., cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'EN' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 260 ORDER BY cscart_images_links.position, cscart_images_links.pair_idSELECT cscart_images_links., cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'EN' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 261 ORDER BY cscart_images_links.position, cscart_images_links.pair_idSELECT cscart_images_links., cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, cscart_images.image_id as images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'EN' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 261 ORDER BY cscart_images_links.position,
The size of the SQL has very little to do with the it runs our whether it is considered a 'long query'or not.