SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002563s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040062s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235528 LIMIT 5 [ RunTime:0.002011s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235528 ORDER BY `minOrder` ASC [ RunTime:0.012186s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12235528 ORDER BY `unit` DESC [ RunTime:0.017263s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12235528 LIMIT 2 [ RunTime:0.007478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235528 ORDER BY `minOrder` ASC [ RunTime:0.008299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235562 LIMIT 5 [ RunTime:0.015964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235562 ORDER BY `minOrder` ASC [ RunTime:0.013646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12235562 ORDER BY `unit` DESC [ RunTime:0.009525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12235562 LIMIT 2 [ RunTime:0.001096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235562 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18579010 LIMIT 5 [ RunTime:0.005952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18579010 ORDER BY `minOrder` ASC [ RunTime:0.013546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18579010 ORDER BY `unit` DESC [ RunTime:0.020100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18579010 LIMIT 2 [ RunTime:0.005449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18579010 ORDER BY `minOrder` ASC [ RunTime:0.005482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176387 LIMIT 5 [ RunTime:0.004324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176387 ORDER BY `minOrder` ASC [ RunTime:0.003206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15176387 ORDER BY `unit` DESC [ RunTime:0.002156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15176387 LIMIT 2 [ RunTime:0.007312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15176387 ORDER BY `minOrder` ASC [ RunTime:0.022303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780828 LIMIT 5 [ RunTime:0.020721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780828 ORDER BY `minOrder` ASC [ RunTime:0.000994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14780828 ORDER BY `unit` DESC [ RunTime:0.002290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14780828 LIMIT 2 [ RunTime:0.011768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780828 ORDER BY `minOrder` ASC [ RunTime:0.012257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780742 LIMIT 5 [ RunTime:0.012605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780742 ORDER BY `minOrder` ASC [ RunTime:0.015580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14780742 ORDER BY `unit` DESC [ RunTime:0.025253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14780742 LIMIT 2 [ RunTime:0.002830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780742 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887165 LIMIT 5 [ RunTime:0.000798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887165 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13887165 ORDER BY `unit` DESC [ RunTime:0.002873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13887165 LIMIT 2 [ RunTime:0.007114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887165 ORDER BY `minOrder` ASC [ RunTime:0.005723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887091 LIMIT 5 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887091 ORDER BY `minOrder` ASC [ RunTime:0.002293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13887091 ORDER BY `unit` DESC [ RunTime:0.008976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13887091 LIMIT 2 [ RunTime:0.006467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13887091 ORDER BY `minOrder` ASC [ RunTime:0.003179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235670 LIMIT 5 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235670 ORDER BY `minOrder` ASC [ RunTime:0.007315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12235670 ORDER BY `unit` DESC [ RunTime:0.007514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12235670 LIMIT 2 [ RunTime:0.021713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235670 ORDER BY `minOrder` ASC [ RunTime:0.008565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235669 LIMIT 5 [ RunTime:0.042920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235669 ORDER BY `minOrder` ASC [ RunTime:0.018667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12235669 ORDER BY `unit` DESC [ RunTime:0.006477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12235669 LIMIT 2 [ RunTime:0.001784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235669 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235663 LIMIT 5 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235663 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12235663 ORDER BY `unit` DESC [ RunTime:0.000220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12235663 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12235663 ORDER BY `minOrder` ASC [ RunTime:0.007338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11232880 LIMIT 5 [ RunTime:0.011532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11232880 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11232880 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11232880 LIMIT 2 [ RunTime:0.006216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11232880 ORDER BY `minOrder` ASC [ RunTime:0.001103s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000833s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63286282 LIMIT 5 [ RunTime:0.011507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286282 ORDER BY `minOrder` ASC [ RunTime:0.003601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63286282 ORDER BY `unit` DESC [ RunTime:0.002925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63286282 LIMIT 2 [ RunTime:0.002265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286282 ORDER BY `minOrder` ASC [ RunTime:0.002566s ]
select * from pdf where partno='MB1040-000' and brandshort='MaxBotix Inc.' limit 1 [ RunTime:0.003909s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1040-000' OR `brand` LIKE 'MaxBotix Inc.%' ) ) LIMIT 1 [ RunTime:0.006488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63286303 LIMIT 5 [ RunTime:0.011729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286303 ORDER BY `minOrder` ASC [ RunTime:0.002535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63286303 ORDER BY `unit` DESC [ RunTime:0.003199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63286303 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286303 ORDER BY `minOrder` ASC [ RunTime:0.004608s ]
select * from pdf where partno='MB1043-000' and brandshort='MaxBotix Inc.' limit 1 [ RunTime:0.016151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1043-000' OR `brand` LIKE 'MaxBotix Inc.%' ) ) LIMIT 1 [ RunTime:0.005225s ]
SELECT `id` FROM `stock` WHERE `id` <> 63286303 AND `partno` = 'MB1043-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%maxbotix inc.%' ) [ RunTime:0.002878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235528 [ RunTime:0.004868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64359479 LIMIT 5 [ RunTime:0.001242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359479 ORDER BY `minOrder` ASC [ RunTime:0.003630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64359479 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64359479 LIMIT 2 [ RunTime:0.003647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359479 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='MB1048DMRW-12RI4' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.002048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1048DMRW-12RI4' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.001089s ]
SELECT `id` FROM `stock` WHERE `id` <> 64359479 AND `partno` = 'MB1048DMRW-12RI4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887165 [ RunTime:0.000712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64359475 LIMIT 5 [ RunTime:0.002736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359475 ORDER BY `minOrder` ASC [ RunTime:0.001487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64359475 ORDER BY `unit` DESC [ RunTime:0.000593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64359475 LIMIT 2 [ RunTime:0.002745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359475 ORDER BY `minOrder` ASC [ RunTime:0.002562s ]
select * from pdf where partno='MB1048DMRW-15RI4' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.000854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1048DMRW-15RI4' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.008858s ]
SELECT `id` FROM `stock` WHERE `id` <> 64359475 AND `partno` = 'MB1048DMRW-15RI4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.002184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780828 [ RunTime:0.000748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64359310 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359310 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64359310 ORDER BY `unit` DESC [ RunTime:0.004973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64359310 LIMIT 2 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359310 ORDER BY `minOrder` ASC [ RunTime:0.003452s ]
select * from pdf where partno='MB1048SMRW-05RI4' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.004676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1048SMRW-05RI4' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.000640s ]
SELECT `id` FROM `stock` WHERE `id` <> 64359310 AND `partno` = 'MB1048SMRW-05RI4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.002714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13887091 [ RunTime:0.011286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64359305 LIMIT 5 [ RunTime:0.012387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359305 ORDER BY `minOrder` ASC [ RunTime:0.006557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64359305 ORDER BY `unit` DESC [ RunTime:0.002350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64359305 LIMIT 2 [ RunTime:0.003278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64359305 ORDER BY `minOrder` ASC [ RunTime:0.003813s ]
select * from pdf where partno='MB1048SMRW-12RI4' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.003306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1048SMRW-12RI4' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.002927s ]
SELECT `id` FROM `stock` WHERE `id` <> 64359305 AND `partno` = 'MB1048SMRW-12RI4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.012051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780742 [ RunTime:0.012707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63286523 LIMIT 5 [ RunTime:0.004155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286523 ORDER BY `minOrder` ASC [ RunTime:0.019347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63286523 ORDER BY `unit` DESC [ RunTime:0.004616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63286523 LIMIT 2 [ RunTime:0.002893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286523 ORDER BY `minOrder` ASC [ RunTime:0.005090s ]
select * from pdf where partno='MB1043-050' and brandshort='MaxBotix Inc.' limit 1 [ RunTime:0.007065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1043-050' OR `brand` LIKE 'MaxBotix Inc.%' ) ) LIMIT 1 [ RunTime:0.005583s ]
SELECT `id` FROM `stock` WHERE `id` <> 63286523 AND `partno` = 'MB1043-050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%maxbotix inc.%' ) [ RunTime:0.001028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235670 [ RunTime:0.003299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63286499 LIMIT 5 [ RunTime:0.006256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286499 ORDER BY `minOrder` ASC [ RunTime:0.011161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63286499 ORDER BY `unit` DESC [ RunTime:0.010901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63286499 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286499 ORDER BY `minOrder` ASC [ RunTime:0.001530s ]
select * from pdf where partno='MB1044-000' and brandshort='MaxBotix Inc.' limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1044-000' OR `brand` LIKE 'MaxBotix Inc.%' ) ) LIMIT 1 [ RunTime:0.004294s ]
SELECT `id` FROM `stock` WHERE `id` <> 63286499 AND `partno` = 'MB1044-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%maxbotix inc.%' ) [ RunTime:0.002203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235562 [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63286482 LIMIT 5 [ RunTime:0.006236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286482 ORDER BY `minOrder` ASC [ RunTime:0.011350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63286482 ORDER BY `unit` DESC [ RunTime:0.013339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63286482 LIMIT 2 [ RunTime:0.006750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286482 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='MB1043-040' and brandshort='MaxBotix Inc.' limit 1 [ RunTime:0.001971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1043-040' OR `brand` LIKE 'MaxBotix Inc.%' ) ) LIMIT 1 [ RunTime:0.000829s ]
SELECT `id` FROM `stock` WHERE `id` <> 63286482 AND `partno` = 'MB1043-040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%maxbotix inc.%' ) [ RunTime:0.001629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235669 [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63286478 LIMIT 5 [ RunTime:0.007633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286478 ORDER BY `minOrder` ASC [ RunTime:0.006753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63286478 ORDER BY `unit` DESC [ RunTime:0.013678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63286478 LIMIT 2 [ RunTime:0.004684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286478 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='MB1044-040' and brandshort='MaxBotix Inc.' limit 1 [ RunTime:0.000671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1044-040' OR `brand` LIKE 'MaxBotix Inc.%' ) ) LIMIT 1 [ RunTime:0.004424s ]
SELECT `id` FROM `stock` WHERE `id` <> 63286478 AND `partno` = 'MB1044-040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%maxbotix inc.%' ) [ RunTime:0.002341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12235663 [ RunTime:0.002177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63286477 LIMIT 5 [ RunTime:0.004678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286477 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63286477 ORDER BY `unit` DESC [ RunTime:0.003140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63286477 LIMIT 2 [ RunTime:0.003092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63286477 ORDER BY `minOrder` ASC [ RunTime:0.002145s ]
select * from pdf where partno='MB1040-040' and brandshort='MaxBotix Inc.' limit 1 [ RunTime:0.004468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB1040-040' OR `brand` LIKE 'MaxBotix Inc.%' ) ) LIMIT 1 [ RunTime:0.000981s ]
SELECT `id` FROM `stock` WHERE `id` <> 63286477 AND `partno` = 'MB1040-040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%maxbotix inc.%' ) [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11232880 [ RunTime:0.009825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58721980 LIMIT 5 [ RunTime:0.018911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58721980 ORDER BY `minOrder` ASC [ RunTime:0.002468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58721980 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58721980 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58721980 ORDER BY `minOrder` ASC [ RunTime:0.000903s ]
select * from pdf where partno='MB104' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB104' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000554s ]
SELECT `id` FROM `stock` WHERE `id` <> 58721980 AND `partno` = 'MB104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15176387 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58721679 LIMIT 5 [ RunTime:0.000834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58721679 ORDER BY `minOrder` ASC [ RunTime:0.018459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58721679 ORDER BY `unit` DESC [ RunTime:0.002970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58721679 LIMIT 2 [ RunTime:0.018791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58721679 ORDER BY `minOrder` ASC [ RunTime:0.005859s ]
select * from pdf where partno='MB104-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MB104-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.005463s ]
SELECT `id` FROM `stock` WHERE `id` <> 58721679 AND `partno` = 'MB104-BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.022123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18579010 [ RunTime:0.030374s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013876s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039831s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020450s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014478s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026404s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016318s ]
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 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001218s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MB104%' OR `brand` LIKE 'MB104%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015204s ]