SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001431s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024790s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512739 LIMIT 5 [ RunTime:0.012171s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512739 ORDER BY `minOrder` ASC [ RunTime:0.002329s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512739 ORDER BY `unit` DESC [ RunTime:0.006297s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512739 LIMIT 2 [ RunTime:0.017989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512739 ORDER BY `minOrder` ASC [ RunTime:0.002395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376995 LIMIT 5 [ RunTime:0.013272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376995 ORDER BY `minOrder` ASC [ RunTime:0.007272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376995 ORDER BY `unit` DESC [ RunTime:0.011970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376995 LIMIT 2 [ RunTime:0.021506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376995 ORDER BY `minOrder` ASC [ RunTime:0.001515s ]
select * from pdf where partno='5599/5C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.018275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392733 LIMIT 5 [ RunTime:0.012885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392733 ORDER BY `minOrder` ASC [ RunTime:0.006975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392733 ORDER BY `unit` DESC [ RunTime:0.002312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392733 LIMIT 2 [ RunTime:0.013321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392733 ORDER BY `minOrder` ASC [ RunTime:0.025009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513870 LIMIT 5 [ RunTime:0.019176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513870 ORDER BY `minOrder` ASC [ RunTime:0.027985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513870 ORDER BY `unit` DESC [ RunTime:0.036535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513870 LIMIT 2 [ RunTime:0.035132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513870 ORDER BY `minOrder` ASC [ RunTime:0.024612s ]
select * from pdf where partno='5599/5C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.028008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494649 LIMIT 5 [ RunTime:0.034832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494649 ORDER BY `minOrder` ASC [ RunTime:0.023753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13494649 ORDER BY `unit` DESC [ RunTime:0.008553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13494649 LIMIT 2 [ RunTime:0.009501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494649 ORDER BY `minOrder` ASC [ RunTime:0.001540s ]
select * from pdf where partno='5599/12C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.030485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299027 LIMIT 5 [ RunTime:0.047321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299027 ORDER BY `minOrder` ASC [ RunTime:0.090671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17299027 ORDER BY `unit` DESC [ RunTime:0.040787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17299027 LIMIT 2 [ RunTime:0.011037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299027 ORDER BY `minOrder` ASC [ RunTime:0.014246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17027017 LIMIT 5 [ RunTime:0.029464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027017 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17027017 ORDER BY `unit` DESC [ RunTime:0.013146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17027017 LIMIT 2 [ RunTime:0.019961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027017 ORDER BY `minOrder` ASC [ RunTime:0.032126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389904 LIMIT 5 [ RunTime:0.008024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389904 ORDER BY `minOrder` ASC [ RunTime:0.026553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389904 ORDER BY `unit` DESC [ RunTime:0.011404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389904 LIMIT 2 [ RunTime:0.019503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389904 ORDER BY `minOrder` ASC [ RunTime:0.001911s ]
select * from pdf where partno='5599/12C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385241 LIMIT 5 [ RunTime:0.006799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385241 ORDER BY `minOrder` ASC [ RunTime:0.017686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385241 ORDER BY `unit` DESC [ RunTime:0.018133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385241 LIMIT 2 [ RunTime:0.020858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385241 ORDER BY `minOrder` ASC [ RunTime:0.003442s ]
select * from pdf where partno='5599/19C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382075 LIMIT 5 [ RunTime:0.007575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382075 ORDER BY `minOrder` ASC [ RunTime:0.007394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382075 ORDER BY `unit` DESC [ RunTime:0.014323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382075 LIMIT 2 [ RunTime:0.009588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382075 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='5599/27C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381990 LIMIT 5 [ RunTime:0.006307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381990 ORDER BY `minOrder` ASC [ RunTime:0.005769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381990 ORDER BY `unit` DESC [ RunTime:0.006616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381990 LIMIT 2 [ RunTime:0.024087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381990 ORDER BY `minOrder` ASC [ RunTime:0.012367s ]
select * from pdf where partno='5599/27C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381807 LIMIT 5 [ RunTime:0.005852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381807 ORDER BY `minOrder` ASC [ RunTime:0.004122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381807 ORDER BY `unit` DESC [ RunTime:0.014457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381807 LIMIT 2 [ RunTime:0.011714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381807 ORDER BY `minOrder` ASC [ RunTime:0.001085s ]
select * from pdf where partno='5599/19C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.008310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381614 LIMIT 5 [ RunTime:0.008128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381614 ORDER BY `minOrder` ASC [ RunTime:0.016652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381614 ORDER BY `unit` DESC [ RunTime:0.004655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381614 LIMIT 2 [ RunTime:0.004540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381614 ORDER BY `minOrder` ASC [ RunTime:0.007302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381611 LIMIT 5 [ RunTime:0.005009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381611 ORDER BY `minOrder` ASC [ RunTime:0.004269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381611 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381611 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381611 ORDER BY `minOrder` ASC [ RunTime:0.001320s ]
select * from pdf where partno='5599/15C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380942 LIMIT 5 [ RunTime:0.005603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380942 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380942 ORDER BY `unit` DESC [ RunTime:0.003291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380942 LIMIT 2 [ RunTime:0.004016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380942 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='5599/19C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380557 LIMIT 5 [ RunTime:0.001337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380557 ORDER BY `minOrder` ASC [ RunTime:0.006159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380557 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380557 LIMIT 2 [ RunTime:0.002202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380557 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
select * from pdf where partno='5599/7C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380380 LIMIT 5 [ RunTime:0.001343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380380 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380380 ORDER BY `unit` DESC [ RunTime:0.001674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380380 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380380 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
select * from pdf where partno='5599/5C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14380379 LIMIT 5 [ RunTime:0.002807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380379 ORDER BY `minOrder` ASC [ RunTime:0.004704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14380379 ORDER BY `unit` DESC [ RunTime:0.001911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14380379 LIMIT 2 [ RunTime:0.003886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14380379 ORDER BY `minOrder` ASC [ RunTime:0.004439s ]
select * from pdf where partno='5599/5C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379925 LIMIT 5 [ RunTime:0.009890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379925 ORDER BY `minOrder` ASC [ RunTime:0.019422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14379925 ORDER BY `unit` DESC [ RunTime:0.004091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14379925 LIMIT 2 [ RunTime:0.019145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379925 ORDER BY `minOrder` ASC [ RunTime:0.025206s ]
select * from pdf where partno='5599/15C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378919 LIMIT 5 [ RunTime:0.007441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378919 ORDER BY `minOrder` ASC [ RunTime:0.003431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14378919 ORDER BY `unit` DESC [ RunTime:0.000997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14378919 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378919 ORDER BY `minOrder` ASC [ RunTime:0.003369s ]
select * from pdf where partno='5599/7C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001220s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281893 LIMIT 5 [ RunTime:0.003280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281893 ORDER BY `minOrder` ASC [ RunTime:0.004277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281893 ORDER BY `unit` DESC [ RunTime:0.002784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281893 LIMIT 2 [ RunTime:0.003429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281893 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='55991-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001029s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55991-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.025206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281749 LIMIT 5 [ RunTime:0.003330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281749 ORDER BY `minOrder` ASC [ RunTime:0.004497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281749 ORDER BY `unit` DESC [ RunTime:0.007295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281749 LIMIT 2 [ RunTime:0.002577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281749 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='55991-1' and brandshort='te connectivity' limit 1 [ RunTime:0.000521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55991-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237238 LIMIT 5 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237238 ORDER BY `minOrder` ASC [ RunTime:0.002860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237238 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237238 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237238 ORDER BY `minOrder` ASC [ RunTime:0.006745s ]
select * from pdf where partno='5599' and brandshort='adafruit' limit 1 [ RunTime:0.000514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.000421s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53824534 LIMIT 5 [ RunTime:0.009510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53824534 ORDER BY `minOrder` ASC [ RunTime:0.017632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53824534 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53824534 LIMIT 2 [ RunTime:0.006629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53824534 ORDER BY `minOrder` ASC [ RunTime:0.005442s ]
select * from pdf where partno='55991-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55991-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002393s ]
SELECT `id` FROM `stock` WHERE `id` <> 53824534 AND `partno` = '55991-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53823979 LIMIT 5 [ RunTime:0.003332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53823979 ORDER BY `minOrder` ASC [ RunTime:0.006677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53823979 ORDER BY `unit` DESC [ RunTime:0.006973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53823979 LIMIT 2 [ RunTime:0.012522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53823979 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='55991-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55991-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007291s ]
SELECT `id` FROM `stock` WHERE `id` <> 53823979 AND `partno` = '55991-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512739 [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49175221 LIMIT 5 [ RunTime:0.013409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49175221 ORDER BY `minOrder` ASC [ RunTime:0.013794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49175221 ORDER BY `unit` DESC [ RunTime:0.009513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49175221 LIMIT 2 [ RunTime:0.011624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49175221 ORDER BY `minOrder` ASC [ RunTime:0.006119s ]
select * from pdf where partno='5599/5C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/5C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.020216s ]
SELECT `id` FROM `stock` WHERE `id` <> 49175221 AND `partno` = '5599/5C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.014907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376995 [ RunTime:0.009558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36378910 LIMIT 5 [ RunTime:0.009197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378910 ORDER BY `minOrder` ASC [ RunTime:0.001351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36378910 ORDER BY `unit` DESC [ RunTime:0.001506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36378910 LIMIT 2 [ RunTime:0.008360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378910 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='5599/5C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/5C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001088s ]
SELECT `id` FROM `stock` WHERE `id` <> 36378910 AND `partno` = '5599/5C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376995 [ RunTime:0.006614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37435298 LIMIT 5 [ RunTime:0.006252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37435298 ORDER BY `minOrder` ASC [ RunTime:0.015720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37435298 ORDER BY `unit` DESC [ RunTime:0.006816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37435298 LIMIT 2 [ RunTime:0.001295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37435298 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='5599' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000601s ]
SELECT `id` FROM `stock` WHERE `id` <> 37435298 AND `partno` = '5599' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392733 [ RunTime:0.007683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50238282 LIMIT 5 [ RunTime:0.000847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50238282 ORDER BY `minOrder` ASC [ RunTime:0.000736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50238282 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50238282 LIMIT 2 [ RunTime:0.005237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50238282 ORDER BY `minOrder` ASC [ RunTime:0.007333s ]
select * from pdf where partno='5599' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000500s ]
SELECT `id` FROM `stock` WHERE `id` <> 50238282 AND `partno` = '5599' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.009469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392733 [ RunTime:0.002596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36382353 LIMIT 5 [ RunTime:0.006762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382353 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36382353 ORDER BY `unit` DESC [ RunTime:0.003331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36382353 LIMIT 2 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36382353 ORDER BY `minOrder` ASC [ RunTime:0.007362s ]
select * from pdf where partno='5599/5C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/5C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001905s ]
SELECT `id` FROM `stock` WHERE `id` <> 36382353 AND `partno` = '5599/5C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513870 [ RunTime:0.007767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49178594 LIMIT 5 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49178594 ORDER BY `minOrder` ASC [ RunTime:0.006726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49178594 ORDER BY `unit` DESC [ RunTime:0.001263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49178594 LIMIT 2 [ RunTime:0.001032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49178594 ORDER BY `minOrder` ASC [ RunTime:0.002898s ]
select * from pdf where partno='5599/5C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/5C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000206s ]
SELECT `id` FROM `stock` WHERE `id` <> 49178594 AND `partno` = '5599/5C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513870 [ RunTime:0.000209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49182889 LIMIT 5 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49182889 ORDER BY `minOrder` ASC [ RunTime:0.003427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49182889 ORDER BY `unit` DESC [ RunTime:0.004340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49182889 LIMIT 2 [ RunTime:0.004994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49182889 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
select * from pdf where partno='5599/12C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/12C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000934s ]
SELECT `id` FROM `stock` WHERE `id` <> 49182889 AND `partno` = '5599/12C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494649 [ RunTime:0.002518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49182879 LIMIT 5 [ RunTime:0.005009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49182879 ORDER BY `minOrder` ASC [ RunTime:0.004621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49182879 ORDER BY `unit` DESC [ RunTime:0.001652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49182879 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49182879 ORDER BY `minOrder` ASC [ RunTime:0.001506s ]
select * from pdf where partno='5599/5C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/5C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005402s ]
SELECT `id` FROM `stock` WHERE `id` <> 49182879 AND `partno` = '5599/5C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517091 [ RunTime:0.004047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36386588 LIMIT 5 [ RunTime:0.009193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36386588 ORDER BY `minOrder` ASC [ RunTime:0.001592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36386588 ORDER BY `unit` DESC [ RunTime:0.002654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36386588 LIMIT 2 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36386588 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='5599/12C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/12C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000539s ]
SELECT `id` FROM `stock` WHERE `id` <> 36386588 AND `partno` = '5599/12C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494649 [ RunTime:0.001839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36386578 LIMIT 5 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36386578 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36386578 ORDER BY `unit` DESC [ RunTime:0.003555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36386578 LIMIT 2 [ RunTime:0.005120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36386578 ORDER BY `minOrder` ASC [ RunTime:0.001529s ]
select * from pdf where partno='5599/5C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/5C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000516s ]
SELECT `id` FROM `stock` WHERE `id` <> 36386578 AND `partno` = '5599/5C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517091 [ RunTime:0.004932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53830730 LIMIT 5 [ RunTime:0.003328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53830730 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53830730 ORDER BY `unit` DESC [ RunTime:0.008910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53830730 LIMIT 2 [ RunTime:0.002138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53830730 ORDER BY `minOrder` ASC [ RunTime:0.006705s ]
select * from pdf where partno='55992-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55992-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002741s ]
SELECT `id` FROM `stock` WHERE `id` <> 53830730 AND `partno` = '55992-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299027 [ RunTime:0.008300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53828919 LIMIT 5 [ RunTime:0.003877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53828919 ORDER BY `minOrder` ASC [ RunTime:0.004072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53828919 ORDER BY `unit` DESC [ RunTime:0.000922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53828919 LIMIT 2 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53828919 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='55995-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55995-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.005596s ]
SELECT `id` FROM `stock` WHERE `id` <> 53828919 AND `partno` = '55995-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.001388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416268 [ RunTime:0.003253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53828916 LIMIT 5 [ RunTime:0.005227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53828916 ORDER BY `minOrder` ASC [ RunTime:0.002351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53828916 ORDER BY `unit` DESC [ RunTime:0.001311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53828916 LIMIT 2 [ RunTime:0.000812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53828916 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='55995-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55995-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.004514s ]
SELECT `id` FROM `stock` WHERE `id` <> 53828916 AND `partno` = '55995-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.008871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12515279 [ RunTime:0.003251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50676313 LIMIT 5 [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50676313 ORDER BY `minOrder` ASC [ RunTime:0.001318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50676313 ORDER BY `unit` DESC [ RunTime:0.004742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50676313 LIMIT 2 [ RunTime:0.004863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50676313 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='5599401' and brandshort='3M' limit 1 [ RunTime:0.001007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599401' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.020286s ]
SELECT `id` FROM `stock` WHERE `id` <> 50676313 AND `partno` = '5599401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.013257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17027017 [ RunTime:0.004207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49218510 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218510 ORDER BY `minOrder` ASC [ RunTime:0.005645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49218510 ORDER BY `unit` DESC [ RunTime:0.002155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49218510 LIMIT 2 [ RunTime:0.006462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218510 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
select * from pdf where partno='5599/19C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/19C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003691s ]
SELECT `id` FROM `stock` WHERE `id` <> 49218510 AND `partno` = '5599/19C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385241 [ RunTime:0.001849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49207465 LIMIT 5 [ RunTime:0.001614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49207465 ORDER BY `minOrder` ASC [ RunTime:0.003901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49207465 ORDER BY `unit` DESC [ RunTime:0.006068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49207465 LIMIT 2 [ RunTime:0.002784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49207465 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='5599/27C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/27C SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.007738s ]
SELECT `id` FROM `stock` WHERE `id` <> 49207465 AND `partno` = '5599/27C SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13509883 [ RunTime:0.000994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49207464 LIMIT 5 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49207464 ORDER BY `minOrder` ASC [ RunTime:0.005898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49207464 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49207464 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49207464 ORDER BY `minOrder` ASC [ RunTime:0.003002s ]
select * from pdf where partno='5599/27C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/27C BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000858s ]
SELECT `id` FROM `stock` WHERE `id` <> 49207464 AND `partno` = '5599/27C BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.007921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382075 [ RunTime:0.001816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49207257 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49207257 ORDER BY `minOrder` ASC [ RunTime:0.002961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49207257 ORDER BY `unit` DESC [ RunTime:0.000943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49207257 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49207257 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='5599/27C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5599/27C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000616s ]
SELECT `id` FROM `stock` WHERE `id` <> 49207257 AND `partno` = '5599/27C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381990 [ RunTime:0.000496s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001159s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006754s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012350s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011844s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011186s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001808s ]
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 '5599%' OR `brand` LIKE '5599%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001971s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5599%' OR `brand` LIKE '5599%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008333s ]