SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001690s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013120s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360544 LIMIT 5 [ RunTime:0.019941s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15360544 ORDER BY `minOrder` ASC [ RunTime:0.036400s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15360544 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15360544 LIMIT 2 [ RunTime:0.002120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15360544 ORDER BY `minOrder` ASC [ RunTime:0.017618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265499 LIMIT 5 [ RunTime:0.038886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265499 ORDER BY `minOrder` ASC [ RunTime:0.035950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265499 ORDER BY `unit` DESC [ RunTime:0.056301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265499 LIMIT 2 [ RunTime:0.018425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265499 ORDER BY `minOrder` ASC [ RunTime:0.021704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265739 LIMIT 5 [ RunTime:0.059108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265739 ORDER BY `minOrder` ASC [ RunTime:0.077675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265739 ORDER BY `unit` DESC [ RunTime:0.117204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265739 LIMIT 2 [ RunTime:0.054717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265739 ORDER BY `minOrder` ASC [ RunTime:0.025474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140636 LIMIT 5 [ RunTime:0.031094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140636 ORDER BY `minOrder` ASC [ RunTime:0.081237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17140636 ORDER BY `unit` DESC [ RunTime:0.121434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17140636 LIMIT 2 [ RunTime:0.060681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140636 ORDER BY `minOrder` ASC [ RunTime:0.043015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140635 LIMIT 5 [ RunTime:0.095796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140635 ORDER BY `minOrder` ASC [ RunTime:0.082150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17140635 ORDER BY `unit` DESC [ RunTime:0.063569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17140635 LIMIT 2 [ RunTime:0.097406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140635 ORDER BY `minOrder` ASC [ RunTime:0.008105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360550 LIMIT 5 [ RunTime:0.055839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15360550 ORDER BY `minOrder` ASC [ RunTime:0.064722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15360550 ORDER BY `unit` DESC [ RunTime:0.102903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15360550 LIMIT 2 [ RunTime:0.049665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15360550 ORDER BY `minOrder` ASC [ RunTime:0.046254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266048 LIMIT 5 [ RunTime:0.050292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266048 ORDER BY `minOrder` ASC [ RunTime:0.134255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266048 ORDER BY `unit` DESC [ RunTime:0.059121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266048 LIMIT 2 [ RunTime:0.032279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266048 ORDER BY `minOrder` ASC [ RunTime:0.004741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265896 LIMIT 5 [ RunTime:0.080509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265896 ORDER BY `minOrder` ASC [ RunTime:0.047282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265896 ORDER BY `unit` DESC [ RunTime:0.084406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265896 LIMIT 2 [ RunTime:0.174829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265896 ORDER BY `minOrder` ASC [ RunTime:0.058461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266021 LIMIT 5 [ RunTime:0.054191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266021 ORDER BY `minOrder` ASC [ RunTime:0.118716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266021 ORDER BY `unit` DESC [ RunTime:0.055227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266021 LIMIT 2 [ RunTime:0.149861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266021 ORDER BY `minOrder` ASC [ RunTime:0.013761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360630 LIMIT 5 [ RunTime:0.008471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15360630 ORDER BY `minOrder` ASC [ RunTime:0.014566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15360630 ORDER BY `unit` DESC [ RunTime:0.081520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15360630 LIMIT 2 [ RunTime:0.068983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15360630 ORDER BY `minOrder` ASC [ RunTime:0.014114s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070826 LIMIT 5 [ RunTime:0.058655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070826 ORDER BY `minOrder` ASC [ RunTime:0.041744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070826 ORDER BY `unit` DESC [ RunTime:0.054321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070826 LIMIT 2 [ RunTime:0.040445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070826 ORDER BY `minOrder` ASC [ RunTime:0.021659s ]
select * from pdf where partno='u442-dock13-s' and brandshort='tripp lite' limit 1 [ RunTime:0.048610s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u442-dock13-s' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.043062s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070826 AND `partno` = 'u442-dock13-s' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.072040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265499 [ RunTime:0.021481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071169 LIMIT 5 [ RunTime:0.030436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071169 ORDER BY `minOrder` ASC [ RunTime:0.076829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071169 ORDER BY `unit` DESC [ RunTime:0.061867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071169 LIMIT 2 [ RunTime:0.031174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071169 ORDER BY `minOrder` ASC [ RunTime:0.017171s ]
select * from pdf where partno='u442-dock10-s' and brandshort='tripp lite' limit 1 [ RunTime:0.075360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u442-dock10-s' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.022970s ]
SELECT `id` FROM `stock` WHERE `id` <> 51071169 AND `partno` = 'u442-dock10-s' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.029081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360544 [ RunTime:0.012468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071170 LIMIT 5 [ RunTime:0.010894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071170 ORDER BY `minOrder` ASC [ RunTime:0.040011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071170 ORDER BY `unit` DESC [ RunTime:0.058166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071170 LIMIT 2 [ RunTime:0.017400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071170 ORDER BY `minOrder` ASC [ RunTime:0.024240s ]
select * from pdf where partno='u442-dock12-s' and brandshort='tripp lite' limit 1 [ RunTime:0.087833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u442-dock12-s' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.032681s ]
SELECT `id` FROM `stock` WHERE `id` <> 51071170 AND `partno` = 'u442-dock12-s' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.059862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360630 [ RunTime:0.004765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071171 LIMIT 5 [ RunTime:0.048078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071171 ORDER BY `minOrder` ASC [ RunTime:0.091317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071171 ORDER BY `unit` DESC [ RunTime:0.140967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071171 LIMIT 2 [ RunTime:0.133612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071171 ORDER BY `minOrder` ASC [ RunTime:0.065319s ]
select * from pdf where partno='u442-dock16-b' and brandshort='tripp lite' limit 1 [ RunTime:0.058188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u442-dock16-b' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.155040s ]
SELECT `id` FROM `stock` WHERE `id` <> 51071171 AND `partno` = 'u442-dock16-b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.098538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140636 [ RunTime:0.020772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51071168 LIMIT 5 [ RunTime:0.019426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071168 ORDER BY `minOrder` ASC [ RunTime:0.063702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51071168 ORDER BY `unit` DESC [ RunTime:0.048892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51071168 LIMIT 2 [ RunTime:0.061963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51071168 ORDER BY `minOrder` ASC [ RunTime:0.038052s ]
select * from pdf where partno='u442-dock1' and brandshort='tripp lite' limit 1 [ RunTime:0.039255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u442-dock1' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.034575s ]
SELECT `id` FROM `stock` WHERE `id` <> 51071168 AND `partno` = 'u442-dock1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.033818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265739 [ RunTime:0.045662s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438214 LIMIT 5 [ RunTime:0.009430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438214 ORDER BY `minOrder` ASC [ RunTime:0.075964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438214 ORDER BY `unit` DESC [ RunTime:0.074477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438214 LIMIT 2 [ RunTime:0.017414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438214 ORDER BY `minOrder` ASC [ RunTime:0.014079s ]
select * from pdf where partno='U442-DOCK10-S' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.022987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK10-S' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.040960s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438214 AND `partno` = 'U442-DOCK10-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.081962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360544 [ RunTime:0.036481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438061 LIMIT 5 [ RunTime:0.022457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438061 ORDER BY `minOrder` ASC [ RunTime:0.031557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438061 ORDER BY `unit` DESC [ RunTime:0.122460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438061 LIMIT 2 [ RunTime:0.065629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438061 ORDER BY `minOrder` ASC [ RunTime:0.023812s ]
select * from pdf where partno='U442-DOCK13-S' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.029590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK13-S' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.014012s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438061 AND `partno` = 'U442-DOCK13-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.035597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265499 [ RunTime:0.023126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438287 LIMIT 5 [ RunTime:0.040512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438287 ORDER BY `minOrder` ASC [ RunTime:0.041097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438287 ORDER BY `unit` DESC [ RunTime:0.073844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438287 LIMIT 2 [ RunTime:0.050886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438287 ORDER BY `minOrder` ASC [ RunTime:0.018167s ]
select * from pdf where partno='U442-DOCK1' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.042095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK1' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.023665s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438287 AND `partno` = 'U442-DOCK1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.074131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265739 [ RunTime:0.021479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438560 LIMIT 5 [ RunTime:0.043229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438560 ORDER BY `minOrder` ASC [ RunTime:0.029570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438560 ORDER BY `unit` DESC [ RunTime:0.050242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438560 LIMIT 2 [ RunTime:0.029018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438560 ORDER BY `minOrder` ASC [ RunTime:0.020634s ]
select * from pdf where partno='U442-DOCK17-GY' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.041327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK17-GY' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.026258s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438560 AND `partno` = 'U442-DOCK17-GY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.059140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265896 [ RunTime:0.017943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438540 LIMIT 5 [ RunTime:0.018455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438540 ORDER BY `minOrder` ASC [ RunTime:0.013739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438540 ORDER BY `unit` DESC [ RunTime:0.022874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438540 LIMIT 2 [ RunTime:0.058321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438540 ORDER BY `minOrder` ASC [ RunTime:0.010033s ]
select * from pdf where partno='U442-DOCK16-B' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.021627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK16-B' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.091006s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438540 AND `partno` = 'U442-DOCK16-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.008666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140636 [ RunTime:0.032451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438781 LIMIT 5 [ RunTime:0.042964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438781 ORDER BY `minOrder` ASC [ RunTime:0.039818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438781 ORDER BY `unit` DESC [ RunTime:0.063201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438781 LIMIT 2 [ RunTime:0.031289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438781 ORDER BY `minOrder` ASC [ RunTime:0.019399s ]
select * from pdf where partno='U442-DOCK1-B' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.115999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK1-B' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.032266s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438781 AND `partno` = 'U442-DOCK1-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.020250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266048 [ RunTime:0.045512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438764 LIMIT 5 [ RunTime:0.074721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438764 ORDER BY `minOrder` ASC [ RunTime:0.038478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438764 ORDER BY `unit` DESC [ RunTime:0.030372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438764 LIMIT 2 [ RunTime:0.070007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438764 ORDER BY `minOrder` ASC [ RunTime:0.022307s ]
select * from pdf where partno='U442-DOCK15-S' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.043672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK15-S' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.013067s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438764 AND `partno` = 'U442-DOCK15-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.030901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266021 [ RunTime:0.018653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438736 LIMIT 5 [ RunTime:0.006000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438736 ORDER BY `minOrder` ASC [ RunTime:0.018812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438736 ORDER BY `unit` DESC [ RunTime:0.014487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438736 LIMIT 2 [ RunTime:0.017464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438736 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
select * from pdf where partno='U442-DOCK12-S' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.012086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U442-DOCK12-S' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.002770s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438736 AND `partno` = 'U442-DOCK12-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.028787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360630 [ RunTime:0.010775s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009475s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009286s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027590s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028154s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016746s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013717s ]
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 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020316s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'u442-dock1%' OR `brand` LIKE 'u442-dock1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005607s ]