SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002502s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016601s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308311 LIMIT 5 [ RunTime:0.031913s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308311 ORDER BY `minOrder` ASC [ RunTime:0.011133s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.015987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13308311 ORDER BY `unit` DESC [ RunTime:0.027952s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13308311 LIMIT 2 [ RunTime:0.031985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308311 ORDER BY `minOrder` ASC [ RunTime:0.007092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591535 LIMIT 5 [ RunTime:0.029610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591535 ORDER BY `minOrder` ASC [ RunTime:0.008963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591535 ORDER BY `unit` DESC [ RunTime:0.015812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591535 LIMIT 2 [ RunTime:0.053906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591535 ORDER BY `minOrder` ASC [ RunTime:0.031585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374604 LIMIT 5 [ RunTime:0.009120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14374604 ORDER BY `minOrder` ASC [ RunTime:0.005604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14374604 ORDER BY `unit` DESC [ RunTime:0.028208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14374604 LIMIT 2 [ RunTime:0.036288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14374604 ORDER BY `minOrder` ASC [ RunTime:0.021132s ]
select * from pdf where partno='5063C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.025671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495345 LIMIT 5 [ RunTime:0.029948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495345 ORDER BY `minOrder` ASC [ RunTime:0.033814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13495345 ORDER BY `unit` DESC [ RunTime:0.011403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13495345 LIMIT 2 [ RunTime:0.013489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495345 ORDER BY `minOrder` ASC [ RunTime:0.020319s ]
select * from pdf where partno='5063C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.049985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376538 LIMIT 5 [ RunTime:0.017201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376538 ORDER BY `minOrder` ASC [ RunTime:0.016330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376538 ORDER BY `unit` DESC [ RunTime:0.023009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376538 LIMIT 2 [ RunTime:0.008555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376538 ORDER BY `minOrder` ASC [ RunTime:0.006038s ]
select * from pdf where partno='5063C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16397945 LIMIT 5 [ RunTime:0.019695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16397945 ORDER BY `minOrder` ASC [ RunTime:0.018261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16397945 ORDER BY `unit` DESC [ RunTime:0.004427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16397945 LIMIT 2 [ RunTime:0.008870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16397945 ORDER BY `minOrder` ASC [ RunTime:0.004260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344523 LIMIT 5 [ RunTime:0.014745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344523 ORDER BY `minOrder` ASC [ RunTime:0.021210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13344523 ORDER BY `unit` DESC [ RunTime:0.025821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13344523 LIMIT 2 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344523 ORDER BY `minOrder` ASC [ RunTime:0.002756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145392 LIMIT 5 [ RunTime:0.019923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145392 ORDER BY `minOrder` ASC [ RunTime:0.007370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16145392 ORDER BY `unit` DESC [ RunTime:0.009884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16145392 LIMIT 2 [ RunTime:0.008315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16145392 ORDER BY `minOrder` ASC [ RunTime:0.005401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514207 LIMIT 5 [ RunTime:0.014427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514207 ORDER BY `minOrder` ASC [ RunTime:0.009358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514207 ORDER BY `unit` DESC [ RunTime:0.007307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514207 LIMIT 2 [ RunTime:0.021300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514207 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='5063/1C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387798 LIMIT 5 [ RunTime:0.006372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387798 ORDER BY `minOrder` ASC [ RunTime:0.013233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387798 ORDER BY `unit` DESC [ RunTime:0.013113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387798 LIMIT 2 [ RunTime:0.022650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387798 ORDER BY `minOrder` ASC [ RunTime:0.009640s ]
select * from pdf where partno='5063/1C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389778 LIMIT 5 [ RunTime:0.001129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389778 ORDER BY `minOrder` ASC [ RunTime:0.004433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389778 ORDER BY `unit` DESC [ RunTime:0.013415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389778 LIMIT 2 [ RunTime:0.010674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389778 ORDER BY `minOrder` ASC [ RunTime:0.008411s ]
select * from pdf where partno='5063/1C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15425911 LIMIT 5 [ RunTime:0.003503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15425911 ORDER BY `minOrder` ASC [ RunTime:0.007907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15425911 ORDER BY `unit` DESC [ RunTime:0.001009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15425911 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15425911 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15220633 LIMIT 5 [ RunTime:0.001046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220633 ORDER BY `minOrder` ASC [ RunTime:0.005122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15220633 ORDER BY `unit` DESC [ RunTime:0.007413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15220633 LIMIT 2 [ RunTime:0.004688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15220633 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378259 LIMIT 5 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378259 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14378259 ORDER BY `unit` DESC [ RunTime:0.002996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14378259 LIMIT 2 [ RunTime:0.006300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378259 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
select * from pdf where partno='5063C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503765 LIMIT 5 [ RunTime:0.001881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503765 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503765 ORDER BY `unit` DESC [ RunTime:0.000649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503765 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503765 ORDER BY `minOrder` ASC [ RunTime:0.007839s ]
select * from pdf where partno='5063C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503764 LIMIT 5 [ RunTime:0.001422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503764 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503764 ORDER BY `unit` DESC [ RunTime:0.000682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503764 LIMIT 2 [ RunTime:0.008220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503764 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
select * from pdf where partno='5063/1C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13503760 LIMIT 5 [ RunTime:0.005908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503760 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13503760 ORDER BY `unit` DESC [ RunTime:0.003042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13503760 LIMIT 2 [ RunTime:0.001106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13503760 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='5063/1C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316604 LIMIT 5 [ RunTime:0.007814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316604 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316604 ORDER BY `unit` DESC [ RunTime:0.002382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316604 LIMIT 2 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316604 ORDER BY `minOrder` ASC [ RunTime:0.004261s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257011 LIMIT 5 [ RunTime:0.008195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257011 ORDER BY `minOrder` ASC [ RunTime:0.009432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257011 ORDER BY `unit` DESC [ RunTime:0.004464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257011 LIMIT 2 [ RunTime:0.005350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257011 ORDER BY `minOrder` ASC [ RunTime:0.008020s ]
select * from pdf where partno='5063-0-00-15-00-00-33-0' and brandshort='mill-max' limit 1 [ RunTime:0.000892s ]
select foldpath,foldpath2,filename from pdf_file where id=1674065 limit 1 [ RunTime:0.004996s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063-0-00-15-00-00-33-0' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.007049s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53492237 LIMIT 5 [ RunTime:0.003194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492237 ORDER BY `minOrder` ASC [ RunTime:0.008714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53492237 ORDER BY `unit` DESC [ RunTime:0.005895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53492237 LIMIT 2 [ RunTime:0.005280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492237 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
select * from pdf where partno='5063-0-00-15-00-00-33-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.007694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063-0-00-15-00-00-33-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.005218s ]
SELECT `id` FROM `stock` WHERE `id` <> 53492237 AND `partno` = '5063-0-00-15-00-00-33-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.003534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591535 [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36765800 LIMIT 5 [ RunTime:0.006907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36765800 ORDER BY `minOrder` ASC [ RunTime:0.005645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36765800 ORDER BY `unit` DESC [ RunTime:0.011439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36765800 LIMIT 2 [ RunTime:0.012508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36765800 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='5063-2' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063-2' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.029735s ]
SELECT `id` FROM `stock` WHERE `id` <> 36765800 AND `partno` = '5063-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308311 [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49572609 LIMIT 5 [ RunTime:0.009071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49572609 ORDER BY `minOrder` ASC [ RunTime:0.007225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49572609 ORDER BY `unit` DESC [ RunTime:0.001598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49572609 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49572609 ORDER BY `minOrder` ASC [ RunTime:0.002392s ]
select * from pdf where partno='5063-2' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063-2' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001677s ]
SELECT `id` FROM `stock` WHERE `id` <> 49572609 AND `partno` = '5063-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308311 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49174591 LIMIT 5 [ RunTime:0.001973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174591 ORDER BY `minOrder` ASC [ RunTime:0.002266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49174591 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49174591 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174591 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='5063C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000537s ]
SELECT `id` FROM `stock` WHERE `id` <> 49174591 AND `partno` = '5063C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374604 [ RunTime:0.005208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36378294 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378294 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36378294 ORDER BY `unit` DESC [ RunTime:0.004770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36378294 LIMIT 2 [ RunTime:0.029612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378294 ORDER BY `minOrder` ASC [ RunTime:0.007072s ]
select * from pdf where partno='5063C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001940s ]
SELECT `id` FROM `stock` WHERE `id` <> 36378294 AND `partno` = '5063C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374604 [ RunTime:0.001838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49573386 LIMIT 5 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49573386 ORDER BY `minOrder` ASC [ RunTime:0.007356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49573386 ORDER BY `unit` DESC [ RunTime:0.013005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49573386 LIMIT 2 [ RunTime:0.008285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49573386 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
select * from pdf where partno='5063-3' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.009757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063-3' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002742s ]
SELECT `id` FROM `stock` WHERE `id` <> 49573386 AND `partno` = '5063-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316604 [ RunTime:0.010350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36766594 LIMIT 5 [ RunTime:0.004881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766594 ORDER BY `minOrder` ASC [ RunTime:0.018757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36766594 ORDER BY `unit` DESC [ RunTime:0.006996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36766594 LIMIT 2 [ RunTime:0.012450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36766594 ORDER BY `minOrder` ASC [ RunTime:0.013807s ]
select * from pdf where partno='5063-3' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063-3' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000358s ]
SELECT `id` FROM `stock` WHERE `id` <> 36766594 AND `partno` = '5063-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.010491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316604 [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50752656 LIMIT 5 [ RunTime:0.009710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50752656 ORDER BY `minOrder` ASC [ RunTime:0.017554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50752656 ORDER BY `unit` DESC [ RunTime:0.011961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50752656 LIMIT 2 [ RunTime:0.014539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50752656 ORDER BY `minOrder` ASC [ RunTime:0.014817s ]
select * from pdf where partno='5063CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001041s ]
SELECT `id` FROM `stock` WHERE `id` <> 50752656 AND `partno` = '5063CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344523 [ RunTime:0.004296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38160537 LIMIT 5 [ RunTime:0.031063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38160537 ORDER BY `minOrder` ASC [ RunTime:0.006162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38160537 ORDER BY `unit` DESC [ RunTime:0.005448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38160537 LIMIT 2 [ RunTime:0.006981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38160537 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='5063CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000351s ]
SELECT `id` FROM `stock` WHERE `id` <> 38160537 AND `partno` = '5063CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344523 [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49174654 LIMIT 5 [ RunTime:0.004745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174654 ORDER BY `minOrder` ASC [ RunTime:0.008378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49174654 ORDER BY `unit` DESC [ RunTime:0.001563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49174654 LIMIT 2 [ RunTime:0.004965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174654 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='5063C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000839s ]
SELECT `id` FROM `stock` WHERE `id` <> 49174654 AND `partno` = '5063C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376538 [ RunTime:0.002902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36378360 LIMIT 5 [ RunTime:0.002939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378360 ORDER BY `minOrder` ASC [ RunTime:0.008567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36378360 ORDER BY `unit` DESC [ RunTime:0.001268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36378360 LIMIT 2 [ RunTime:0.002603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378360 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='5063C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000282s ]
SELECT `id` FROM `stock` WHERE `id` <> 36378360 AND `partno` = '5063C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376538 [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36377584 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36377584 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36377584 ORDER BY `unit` DESC [ RunTime:0.003237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36377584 LIMIT 2 [ RunTime:0.016530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36377584 ORDER BY `minOrder` ASC [ RunTime:0.009974s ]
select * from pdf where partno='5063C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001105s ]
SELECT `id` FROM `stock` WHERE `id` <> 36377584 AND `partno` = '5063C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495345 [ RunTime:0.007178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49173857 LIMIT 5 [ RunTime:0.002820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49173857 ORDER BY `minOrder` ASC [ RunTime:0.002682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49173857 ORDER BY `unit` DESC [ RunTime:0.000838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49173857 LIMIT 2 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49173857 ORDER BY `minOrder` ASC [ RunTime:0.003519s ]
select * from pdf where partno='5063C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006396s ]
SELECT `id` FROM `stock` WHERE `id` <> 49173857 AND `partno` = '5063C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.013372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495345 [ RunTime:0.002342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51422124 LIMIT 5 [ RunTime:0.001021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51422124 ORDER BY `minOrder` ASC [ RunTime:0.007336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51422124 ORDER BY `unit` DESC [ RunTime:0.002837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51422124 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51422124 ORDER BY `minOrder` ASC [ RunTime:0.002796s ]
select * from pdf where partno='5063' and brandshort='Pololu' limit 1 [ RunTime:0.000648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.002293s ]
SELECT `id` FROM `stock` WHERE `id` <> 51422124 AND `partno` = '5063' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.004897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16397945 [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49178726 LIMIT 5 [ RunTime:0.001096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49178726 ORDER BY `minOrder` ASC [ RunTime:0.004246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49178726 ORDER BY `unit` DESC [ RunTime:0.002770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49178726 LIMIT 2 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49178726 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='5063/1C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063/1C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001140s ]
SELECT `id` FROM `stock` WHERE `id` <> 49178726 AND `partno` = '5063/1C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387798 [ RunTime:0.003483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36382487 LIMIT 5 [ RunTime:0.005158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382487 ORDER BY `minOrder` ASC [ RunTime:0.013552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36382487 ORDER BY `unit` DESC [ RunTime:0.003844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36382487 LIMIT 2 [ RunTime:0.000511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382487 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='5063/1C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063/1C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000378s ]
SELECT `id` FROM `stock` WHERE `id` <> 36382487 AND `partno` = '5063/1C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387798 [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49177500 LIMIT 5 [ RunTime:0.014457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49177500 ORDER BY `minOrder` ASC [ RunTime:0.011507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49177500 ORDER BY `unit` DESC [ RunTime:0.001370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49177500 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49177500 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='5063/1C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063/1C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000644s ]
SELECT `id` FROM `stock` WHERE `id` <> 49177500 AND `partno` = '5063/1C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514207 [ RunTime:0.001967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36381237 LIMIT 5 [ RunTime:0.001209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36381237 ORDER BY `minOrder` ASC [ RunTime:0.000924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36381237 ORDER BY `unit` DESC [ RunTime:0.001246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36381237 LIMIT 2 [ RunTime:0.007552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36381237 ORDER BY `minOrder` ASC [ RunTime:0.007603s ]
select * from pdf where partno='5063/1C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063/1C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000380s ]
SELECT `id` FROM `stock` WHERE `id` <> 36381237 AND `partno` = '5063/1C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514207 [ RunTime:0.002939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50442639 LIMIT 5 [ RunTime:0.003129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50442639 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50442639 ORDER BY `unit` DESC [ RunTime:0.002250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50442639 LIMIT 2 [ RunTime:0.013338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50442639 ORDER BY `minOrder` ASC [ RunTime:0.014400s ]
select * from pdf where partno='5063' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000456s ]
SELECT `id` FROM `stock` WHERE `id` <> 50442639 AND `partno` = '5063' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.008539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145392 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37640002 LIMIT 5 [ RunTime:0.005686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37640002 ORDER BY `minOrder` ASC [ RunTime:0.016985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37640002 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37640002 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37640002 ORDER BY `minOrder` ASC [ RunTime:0.003858s ]
select * from pdf where partno='5063' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.010180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5063' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.001287s ]
SELECT `id` FROM `stock` WHERE `id` <> 37640002 AND `partno` = '5063' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.005281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145392 [ RunTime:0.008901s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008497s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009694s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012022s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020867s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012693s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007007s ]
SELECT `s`.`id`,`s`.`userid`,`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 ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039849s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5063%' OR `brand` LIKE '5063%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008954s ]