SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001955s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020731s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15444251 LIMIT 5 [ RunTime:0.017766s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15444251 ORDER BY `minOrder` ASC [ RunTime:0.006256s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15444251 ORDER BY `unit` DESC [ RunTime:0.002680s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15444251 LIMIT 2 [ RunTime:0.005048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15444251 ORDER BY `minOrder` ASC [ RunTime:0.003623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981896 LIMIT 5 [ RunTime:0.013037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981896 ORDER BY `minOrder` ASC [ RunTime:0.018387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981896 ORDER BY `unit` DESC [ RunTime:0.025042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981896 LIMIT 2 [ RunTime:0.002261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981896 ORDER BY `minOrder` ASC [ RunTime:0.006635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788270 LIMIT 5 [ RunTime:0.014517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788270 ORDER BY `minOrder` ASC [ RunTime:0.014276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18788270 ORDER BY `unit` DESC [ RunTime:0.054546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18788270 LIMIT 2 [ RunTime:0.036997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788270 ORDER BY `minOrder` ASC [ RunTime:0.020485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786708 LIMIT 5 [ RunTime:0.017335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786708 ORDER BY `minOrder` ASC [ RunTime:0.071041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786708 ORDER BY `unit` DESC [ RunTime:0.064518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786708 LIMIT 2 [ RunTime:0.043933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786708 ORDER BY `minOrder` ASC [ RunTime:0.007890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779069 LIMIT 5 [ RunTime:0.059714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779069 ORDER BY `minOrder` ASC [ RunTime:0.077985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779069 ORDER BY `unit` DESC [ RunTime:0.037124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779069 LIMIT 2 [ RunTime:0.015869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779069 ORDER BY `minOrder` ASC [ RunTime:0.026169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18731546 LIMIT 5 [ RunTime:0.042455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731546 ORDER BY `minOrder` ASC [ RunTime:0.009607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18731546 ORDER BY `unit` DESC [ RunTime:0.013693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18731546 LIMIT 2 [ RunTime:0.021282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18731546 ORDER BY `minOrder` ASC [ RunTime:0.008465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049061 LIMIT 5 [ RunTime:0.021922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049061 ORDER BY `minOrder` ASC [ RunTime:0.014666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17049061 ORDER BY `unit` DESC [ RunTime:0.009346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17049061 LIMIT 2 [ RunTime:0.001966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049061 ORDER BY `minOrder` ASC [ RunTime:0.003936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011314 LIMIT 5 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011314 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16011314 ORDER BY `unit` DESC [ RunTime:0.009727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16011314 LIMIT 2 [ RunTime:0.018186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011314 ORDER BY `minOrder` ASC [ RunTime:0.007228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15215969 LIMIT 5 [ RunTime:0.003277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215969 ORDER BY `minOrder` ASC [ RunTime:0.002639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15215969 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15215969 LIMIT 2 [ RunTime:0.003140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215969 ORDER BY `minOrder` ASC [ RunTime:0.003330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14180202 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14180202 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14180202 ORDER BY `unit` DESC [ RunTime:0.001501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14180202 LIMIT 2 [ RunTime:0.004196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14180202 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080636 LIMIT 5 [ RunTime:0.001042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080636 ORDER BY `minOrder` ASC [ RunTime:0.001032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080636 ORDER BY `unit` DESC [ RunTime:0.000575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080636 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080636 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
select * from pdf where partno='108178' and brandshort='basler' limit 1 [ RunTime:0.004674s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108178' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.006494s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60487066 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487066 ORDER BY `minOrder` ASC [ RunTime:0.020941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60487066 ORDER BY `unit` DESC [ RunTime:0.003570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60487066 LIMIT 2 [ RunTime:0.014388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487066 ORDER BY `minOrder` ASC [ RunTime:0.006644s ]
select * from pdf where partno='1081780000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081780000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010996s ]
SELECT `id` FROM `stock` WHERE `id` <> 60487066 AND `partno` = '1081780000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15444251 [ RunTime:0.011606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64639511 LIMIT 5 [ RunTime:0.004097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64639511 ORDER BY `minOrder` ASC [ RunTime:0.008168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64639511 ORDER BY `unit` DESC [ RunTime:0.011360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64639511 LIMIT 2 [ RunTime:0.021833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64639511 ORDER BY `minOrder` ASC [ RunTime:0.002566s ]
select * from pdf where partno='1081780' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081780' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000641s ]
SELECT `id` FROM `stock` WHERE `id` <> 64639511 AND `partno` = '1081780' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011314 [ RunTime:0.003647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63344270 LIMIT 5 [ RunTime:0.003101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344270 ORDER BY `minOrder` ASC [ RunTime:0.007190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63344270 ORDER BY `unit` DESC [ RunTime:0.006267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63344270 LIMIT 2 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344270 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='1081785' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081785' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008234s ]
SELECT `id` FROM `stock` WHERE `id` <> 63344270 AND `partno` = '1081785' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14180202 [ RunTime:0.002283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63343754 LIMIT 5 [ RunTime:0.034641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343754 ORDER BY `minOrder` ASC [ RunTime:0.009586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63343754 ORDER BY `unit` DESC [ RunTime:0.006091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63343754 LIMIT 2 [ RunTime:0.004897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343754 ORDER BY `minOrder` ASC [ RunTime:0.005805s ]
select * from pdf where partno='1081783' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081783' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000700s ]
SELECT `id` FROM `stock` WHERE `id` <> 63343754 AND `partno` = '1081783' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779069 [ RunTime:0.021442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63342667 LIMIT 5 [ RunTime:0.006498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342667 ORDER BY `minOrder` ASC [ RunTime:0.038281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63342667 ORDER BY `unit` DESC [ RunTime:0.007930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63342667 LIMIT 2 [ RunTime:0.010452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342667 ORDER BY `minOrder` ASC [ RunTime:0.004141s ]
select * from pdf where partno='1081782' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081782' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005973s ]
SELECT `id` FROM `stock` WHERE `id` <> 63342667 AND `partno` = '1081782' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788270 [ RunTime:0.012811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63340479 LIMIT 5 [ RunTime:0.004546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340479 ORDER BY `minOrder` ASC [ RunTime:0.008464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63340479 ORDER BY `unit` DESC [ RunTime:0.017838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63340479 LIMIT 2 [ RunTime:0.005491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340479 ORDER BY `minOrder` ASC [ RunTime:0.001759s ]
select * from pdf where partno='1081784' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081784' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014632s ]
SELECT `id` FROM `stock` WHERE `id` <> 63340479 AND `partno` = '1081784' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786708 [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199004 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199004 ORDER BY `minOrder` ASC [ RunTime:0.009147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199004 ORDER BY `unit` DESC [ RunTime:0.004201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199004 LIMIT 2 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199004 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='1081788' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081788' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001379s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199004 AND `partno` = '1081788' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981896 [ RunTime:0.006501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198191 LIMIT 5 [ RunTime:0.003094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198191 ORDER BY `minOrder` ASC [ RunTime:0.005690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198191 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198191 LIMIT 2 [ RunTime:0.001158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198191 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='1081787' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1081787' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001372s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198191 AND `partno` = '1081787' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049061 [ RunTime:0.000650s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000979s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004253s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006980s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002142s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005410s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001045s ]
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 '108178%' OR `brand` LIKE '108178%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001023s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '108178%' OR `brand` LIKE '108178%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000984s ]