SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001536s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000430s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001744s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000878s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000182s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000207s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000182s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001127s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `partno` LIKE 'SM6T12CA%' AND `status` <> 2 ) [ RunTime:0.003672s ]
SELECT `s`.`id`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `partno` LIKE 'SM6T12CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004253s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4770064 LIMIT 4 [ RunTime:0.002772s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4770064 ORDER BY `minOrder` ASC [ RunTime:0.002676s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4770064 ORDER BY `unit` DESC [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4770064 LIMIT 2 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4770064 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4334104 LIMIT 4 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4334104 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4334104 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4334104 LIMIT 2 [ RunTime:0.002320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4334104 ORDER BY `minOrder` ASC [ RunTime:0.000189s ]
select * from pdf where partno='SM6T12CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814 LIMIT 4 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814 ORDER BY `minOrder` ASC [ RunTime:0.002103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814 ORDER BY `unit` DESC [ RunTime:0.003863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814 LIMIT 2 [ RunTime:0.001818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814 ORDER BY `minOrder` ASC [ RunTime:0.000164s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T12CA' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.004578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6659601 LIMIT 4 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6659601 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6659601 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6659601 LIMIT 2 [ RunTime:0.000225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6659601 ORDER BY `minOrder` ASC [ RunTime:0.000155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6657015 LIMIT 4 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6657015 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6657015 ORDER BY `unit` DESC [ RunTime:0.002232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6657015 LIMIT 2 [ RunTime:0.001956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6657015 ORDER BY `minOrder` ASC [ RunTime:0.000154s ]
select * from pdf where partno='SM6T12CAHE3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4800002 LIMIT 4 [ RunTime:0.001482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4800002 ORDER BY `minOrder` ASC [ RunTime:0.006203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4800002 ORDER BY `unit` DESC [ RunTime:0.003178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4800002 LIMIT 2 [ RunTime:0.002214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4800002 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4799718 LIMIT 4 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4799718 ORDER BY `minOrder` ASC [ RunTime:0.004650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4799718 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4799718 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4799718 ORDER BY `minOrder` ASC [ RunTime:0.000181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4777712 LIMIT 4 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777712 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4777712 ORDER BY `unit` DESC [ RunTime:0.000259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4777712 LIMIT 2 [ RunTime:0.003632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777712 ORDER BY `minOrder` ASC [ RunTime:0.000165s ]
select * from pdf where partno='SM6T12CA-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4777612 LIMIT 4 [ RunTime:0.001180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777612 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4777612 ORDER BY `unit` DESC [ RunTime:0.000234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4777612 LIMIT 2 [ RunTime:0.000223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777612 ORDER BY `minOrder` ASC [ RunTime:0.000153s ]
select * from pdf where partno='SM6T12CA-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4771622 LIMIT 4 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4771622 ORDER BY `minOrder` ASC [ RunTime:0.001451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4771622 ORDER BY `unit` DESC [ RunTime:0.008080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4771622 LIMIT 2 [ RunTime:0.003420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4771622 ORDER BY `minOrder` ASC [ RunTime:0.005328s ]
select * from pdf where partno='SM6T12CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4337553 LIMIT 4 [ RunTime:0.001233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337553 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4337553 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4337553 LIMIT 2 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337553 ORDER BY `minOrder` ASC [ RunTime:0.002726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4337288 LIMIT 4 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337288 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4337288 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4337288 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337288 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4337287 LIMIT 4 [ RunTime:0.002346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337287 ORDER BY `minOrder` ASC [ RunTime:0.003611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4337287 ORDER BY `unit` DESC [ RunTime:0.000948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4337287 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337287 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4334420 LIMIT 4 [ RunTime:0.000978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4334420 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4334420 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4334420 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4334420 ORDER BY `minOrder` ASC [ RunTime:0.002696s ]
select * from pdf where partno='SM6T12CAHE3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4326573 LIMIT 4 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4326573 ORDER BY `minOrder` ASC [ RunTime:0.005801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4326573 ORDER BY `unit` DESC [ RunTime:0.002298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4326573 LIMIT 2 [ RunTime:0.007384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4326573 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SM6T12CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002758s ]