SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001700s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011778s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260292 LIMIT 5 [ RunTime:0.013646s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260292 ORDER BY `minOrder` ASC [ RunTime:0.010386s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15260292 ORDER BY `unit` DESC [ RunTime:0.008815s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15260292 LIMIT 2 [ RunTime:0.004700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260292 ORDER BY `minOrder` ASC [ RunTime:0.010569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260288 LIMIT 5 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260288 ORDER BY `minOrder` ASC [ RunTime:0.010793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15260288 ORDER BY `unit` DESC [ RunTime:0.009575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15260288 LIMIT 2 [ RunTime:0.035244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260288 ORDER BY `minOrder` ASC [ RunTime:0.015272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17027142 LIMIT 5 [ RunTime:0.006528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027142 ORDER BY `minOrder` ASC [ RunTime:0.006825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17027142 ORDER BY `unit` DESC [ RunTime:0.036509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17027142 LIMIT 2 [ RunTime:0.015857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027142 ORDER BY `minOrder` ASC [ RunTime:0.014727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17043358 LIMIT 5 [ RunTime:0.040513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17043358 ORDER BY `minOrder` ASC [ RunTime:0.013582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17043358 ORDER BY `unit` DESC [ RunTime:0.012337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17043358 LIMIT 2 [ RunTime:0.005564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17043358 ORDER BY `minOrder` ASC [ RunTime:0.015828s ]
select * from pdf where partno='DT018ATFT' and brandshort='Displaytech' limit 1 [ RunTime:0.023495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14270183 LIMIT 5 [ RunTime:0.012093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14270183 ORDER BY `minOrder` ASC [ RunTime:0.010246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14270183 ORDER BY `unit` DESC [ RunTime:0.022273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14270183 LIMIT 2 [ RunTime:0.011105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14270183 ORDER BY `minOrder` ASC [ RunTime:0.002615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14270182 LIMIT 5 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14270182 ORDER BY `minOrder` ASC [ RunTime:0.004349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14270182 ORDER BY `unit` DESC [ RunTime:0.013754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14270182 LIMIT 2 [ RunTime:0.009679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14270182 ORDER BY `minOrder` ASC [ RunTime:0.000962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13383661 LIMIT 5 [ RunTime:0.002464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13383661 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13383661 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13383661 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13383661 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237228 LIMIT 5 [ RunTime:0.004081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237228 ORDER BY `minOrder` ASC [ RunTime:0.012100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237228 ORDER BY `unit` DESC [ RunTime:0.002328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237228 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237228 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='dt018atft' and brandshort='displaytech' limit 1 [ RunTime:0.000955s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'dt018atft' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.007330s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237228 AND `partno` = 'dt018atft' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.001908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17043358 [ RunTime:0.003173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237173 LIMIT 5 [ RunTime:0.003572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237173 ORDER BY `minOrder` ASC [ RunTime:0.002668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237173 ORDER BY `unit` DESC [ RunTime:0.012742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237173 LIMIT 2 [ RunTime:0.007064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237173 ORDER BY `minOrder` ASC [ RunTime:0.006969s ]
select * from pdf where partno='dt010atft' and brandshort='displaytech' limit 1 [ RunTime:0.005017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'dt010atft' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.010228s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237173 AND `partno` = 'dt010atft' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.006414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260292 [ RunTime:0.017194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237242 LIMIT 5 [ RunTime:0.008863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237242 ORDER BY `minOrder` ASC [ RunTime:0.012653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237242 ORDER BY `unit` DESC [ RunTime:0.009084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237242 LIMIT 2 [ RunTime:0.006684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237242 ORDER BY `minOrder` ASC [ RunTime:0.004725s ]
select * from pdf where partno='dt018btft-shb' and brandshort='displaytech' limit 1 [ RunTime:0.006989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'dt018btft-shb' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.009140s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237242 AND `partno` = 'dt018btft-shb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.017155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260288 [ RunTime:0.010428s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58132862 LIMIT 5 [ RunTime:0.003585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132862 ORDER BY `minOrder` ASC [ RunTime:0.015471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58132862 ORDER BY `unit` DESC [ RunTime:0.016472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58132862 LIMIT 2 [ RunTime:0.002421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132862 ORDER BY `minOrder` ASC [ RunTime:0.006620s ]
select * from pdf where partno='DT018ATFT' and brandshort='Displaytech' limit 1 [ RunTime:0.011517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT018ATFT' OR `brand` LIKE 'Displaytech%' ) ) LIMIT 1 [ RunTime:0.024669s ]
SELECT `id` FROM `stock` WHERE `id` <> 58132862 AND `partno` = 'DT018ATFT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.016699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17043358 [ RunTime:0.022779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58132990 LIMIT 5 [ RunTime:0.010796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132990 ORDER BY `minOrder` ASC [ RunTime:0.027277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58132990 ORDER BY `unit` DESC [ RunTime:0.015615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58132990 LIMIT 2 [ RunTime:0.034486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132990 ORDER BY `minOrder` ASC [ RunTime:0.017793s ]
select * from pdf where partno='DT010ATFT' and brandshort='Displaytech' limit 1 [ RunTime:0.008911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT010ATFT' OR `brand` LIKE 'Displaytech%' ) ) LIMIT 1 [ RunTime:0.023142s ]
SELECT `id` FROM `stock` WHERE `id` <> 58132990 AND `partno` = 'DT010ATFT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.015701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260292 [ RunTime:0.003760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58132980 LIMIT 5 [ RunTime:0.004423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132980 ORDER BY `minOrder` ASC [ RunTime:0.015547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58132980 ORDER BY `unit` DESC [ RunTime:0.014437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58132980 LIMIT 2 [ RunTime:0.007908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132980 ORDER BY `minOrder` ASC [ RunTime:0.009747s ]
select * from pdf where partno='DT018BTFT-SHB' and brandshort='Displaytech' limit 1 [ RunTime:0.020124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT018BTFT-SHB' OR `brand` LIKE 'Displaytech%' ) ) LIMIT 1 [ RunTime:0.004738s ]
SELECT `id` FROM `stock` WHERE `id` <> 58132980 AND `partno` = 'DT018BTFT-SHB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.030300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260288 [ RunTime:0.003590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64078344 LIMIT 5 [ RunTime:0.004179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64078344 ORDER BY `minOrder` ASC [ RunTime:0.001782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64078344 ORDER BY `unit` DESC [ RunTime:0.010536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64078344 LIMIT 2 [ RunTime:0.014756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64078344 ORDER BY `minOrder` ASC [ RunTime:0.001345s ]
select * from pdf where partno='DT01' and brandshort='Carlo Gavazzi Inc.' limit 1 [ RunTime:0.012522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT01' OR `brand` LIKE 'Carlo Gavazzi Inc.%' ) ) LIMIT 1 [ RunTime:0.005286s ]
SELECT `id` FROM `stock` WHERE `id` <> 64078344 AND `partno` = 'DT01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carlo gavazzi inc.%' ) [ RunTime:0.007778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17027142 [ RunTime:0.008421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63186600 LIMIT 5 [ RunTime:0.005817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63186600 ORDER BY `minOrder` ASC [ RunTime:0.034458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63186600 ORDER BY `unit` DESC [ RunTime:0.014529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63186600 LIMIT 2 [ RunTime:0.008039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63186600 ORDER BY `minOrder` ASC [ RunTime:0.010642s ]
select * from pdf where partno='DT01ACA200' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.012153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT01ACA200' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.016121s ]
SELECT `id` FROM `stock` WHERE `id` <> 63186600 AND `partno` = 'DT01ACA200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.027251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13383661 [ RunTime:0.026951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63186390 LIMIT 5 [ RunTime:0.030666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63186390 ORDER BY `minOrder` ASC [ RunTime:0.010730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63186390 ORDER BY `unit` DESC [ RunTime:0.045469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63186390 LIMIT 2 [ RunTime:0.028160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63186390 ORDER BY `minOrder` ASC [ RunTime:0.024942s ]
select * from pdf where partno='DT01ACA100' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.028816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT01ACA100' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.016903s ]
SELECT `id` FROM `stock` WHERE `id` <> 63186390 AND `partno` = 'DT01ACA100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.014684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14270183 [ RunTime:0.021147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63186389 LIMIT 5 [ RunTime:0.025708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63186389 ORDER BY `minOrder` ASC [ RunTime:0.009715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63186389 ORDER BY `unit` DESC [ RunTime:0.033519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63186389 LIMIT 2 [ RunTime:0.016342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63186389 ORDER BY `minOrder` ASC [ RunTime:0.011558s ]
select * from pdf where partno='DT01ABA100V' and brandshort='Toshiba Semiconductor and Storage' limit 1 [ RunTime:0.030164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT01ABA100V' OR `brand` LIKE 'Toshiba Semiconductor and Storage%' ) ) LIMIT 1 [ RunTime:0.007545s ]
SELECT `id` FROM `stock` WHERE `id` <> 63186389 AND `partno` = 'DT01ABA100V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%toshiba semiconductor and storage%' ) [ RunTime:0.037709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14270182 [ RunTime:0.045932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58134977 LIMIT 5 [ RunTime:0.019121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134977 ORDER BY `minOrder` ASC [ RunTime:0.032425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58134977 ORDER BY `unit` DESC [ RunTime:0.040121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58134977 LIMIT 2 [ RunTime:0.036462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134977 ORDER BY `minOrder` ASC [ RunTime:0.008962s ]
select * from pdf where partno='DT018BTFT' and brandshort='Displaytech' limit 1 [ RunTime:0.041284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT018BTFT' OR `brand` LIKE 'Displaytech%' ) ) LIMIT 1 [ RunTime:0.037549s ]
SELECT `id` FROM `stock` WHERE `id` <> 58134977 AND `partno` = 'DT018BTFT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.015510s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007440s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016554s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024184s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022904s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040031s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013533s ]
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 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041539s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DT01%' OR `brand` LIKE 'DT01%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.057518s ]