캐쉬를 먹으면 빠른데 그렇지 않으면 약 10초정도 걸립니다.
인덱스 확인좀 해주세여, 조언좀 해주세여..
SELECT SQL_CACHE
pc.cd_order_no ,
pc.name_eg ,
pc.name_kr ,
pc.cd_sell_status ,
pc.vcd_sell_status ,
pmc.manufacture_name ,
count(pi.image_no) as thumb ,
count(pci.cd_image_no ) as download ,
pc.reg_date
FROM product_cd as pc
LEFT JOIN pi_table as pi
ON pi.cd_order_no = pc.cd_order_no
LEFT JOIN pci_table as pci
ON pci.image_no = pi.image_no
LEFT JOIN pmc_table as pmc
ON pc.manufacture_code = pmc.manufacture_code
WHERE 1
GROUP BY pc.cd_order_no
ORDER BY reg_date DESC LIMIT 0, 25
위에 쿼리를 explain 으로 가져오면
table type possible_keys key key_len ref rows Extra
pc index NULL cd_order_no 20 NULL 12959 Using t...
pi ref cd_order_no cd_order_no 20 pc.cd_order_no 115
pci ref image_no image_no 4 pi.image_no 1
pmc eq_ref PRIMARY PRIMARY 3 pc.manufacture_code 1
|