SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002748s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031958s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18716275 LIMIT 5 [ RunTime:0.034037s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716275 ORDER BY `minOrder` ASC [ RunTime:0.006802s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18716275 ORDER BY `unit` DESC [ RunTime:0.005741s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18716275 LIMIT 2 [ RunTime:0.024569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716275 ORDER BY `minOrder` ASC [ RunTime:0.001892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291315 LIMIT 5 [ RunTime:0.011337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291315 ORDER BY `minOrder` ASC [ RunTime:0.008219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13291315 ORDER BY `unit` DESC [ RunTime:0.007288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13291315 LIMIT 2 [ RunTime:0.021896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291315 ORDER BY `minOrder` ASC [ RunTime:0.003087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291248 LIMIT 5 [ RunTime:0.006549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291248 ORDER BY `minOrder` ASC [ RunTime:0.016016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13291248 ORDER BY `unit` DESC [ RunTime:0.003220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13291248 LIMIT 2 [ RunTime:0.033101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291248 ORDER BY `minOrder` ASC [ RunTime:0.005099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288188 LIMIT 5 [ RunTime:0.015037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288188 ORDER BY `minOrder` ASC [ RunTime:0.005078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288188 ORDER BY `unit` DESC [ RunTime:0.013595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288188 LIMIT 2 [ RunTime:0.009577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288188 ORDER BY `minOrder` ASC [ RunTime:0.003662s ]
select * from pdf where partno='8900868030' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.004388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027332 LIMIT 5 [ RunTime:0.028134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027332 ORDER BY `minOrder` ASC [ RunTime:0.001027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027332 ORDER BY `unit` DESC [ RunTime:0.010489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027332 LIMIT 2 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027332 ORDER BY `minOrder` ASC [ RunTime:0.003808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12024223 LIMIT 5 [ RunTime:0.001046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12024223 ORDER BY `minOrder` ASC [ RunTime:0.008191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12024223 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12024223 LIMIT 2 [ RunTime:0.012036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12024223 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12023428 LIMIT 5 [ RunTime:0.005302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12023428 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12023428 ORDER BY `unit` DESC [ RunTime:0.005743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12023428 LIMIT 2 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12023428 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001847s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57622094 LIMIT 5 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57622094 ORDER BY `minOrder` ASC [ RunTime:0.001102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57622094 ORDER BY `unit` DESC [ RunTime:0.000382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57622094 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57622094 ORDER BY `minOrder` ASC [ RunTime:0.003700s ]
select * from pdf where partno='890086' and brandshort='3M' limit 1 [ RunTime:0.010737s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '890086' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004712s ]
SELECT `id` FROM `stock` WHERE `id` <> 57622094 AND `partno` = '890086' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.010832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18716275 [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32672048 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32672048 ORDER BY `minOrder` ASC [ RunTime:0.003601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32672048 ORDER BY `unit` DESC [ RunTime:0.003097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32672048 LIMIT 2 [ RunTime:0.007477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32672048 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='8900868013' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868013' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002074s ]
SELECT `id` FROM `stock` WHERE `id` <> 32672048 AND `partno` = '8900868013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027332 [ RunTime:0.003595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32608773 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608773 ORDER BY `minOrder` ASC [ RunTime:0.002177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32608773 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32608773 LIMIT 2 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608773 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='8900868015' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868015' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000649s ]
SELECT `id` FROM `stock` WHERE `id` <> 32608773 AND `partno` = '8900868015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12024223 [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32608772 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608772 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32608772 ORDER BY `unit` DESC [ RunTime:0.006591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32608772 LIMIT 2 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608772 ORDER BY `minOrder` ASC [ RunTime:0.000186s ]
select * from pdf where partno='8900868016' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868016' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000776s ]
SELECT `id` FROM `stock` WHERE `id` <> 32608772 AND `partno` = '8900868016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291315 [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32608771 LIMIT 5 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608771 ORDER BY `minOrder` ASC [ RunTime:0.002439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32608771 ORDER BY `unit` DESC [ RunTime:0.000895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32608771 LIMIT 2 [ RunTime:0.001042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608771 ORDER BY `minOrder` ASC [ RunTime:0.000187s ]
select * from pdf where partno='8900868014' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868014' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002473s ]
SELECT `id` FROM `stock` WHERE `id` <> 32608771 AND `partno` = '8900868014' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291248 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32597905 LIMIT 5 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32597905 ORDER BY `minOrder` ASC [ RunTime:0.005348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32597905 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32597905 LIMIT 2 [ RunTime:0.003541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32597905 ORDER BY `minOrder` ASC [ RunTime:0.000182s ]
select * from pdf where partno='8900868012' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868012' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002836s ]
SELECT `id` FROM `stock` WHERE `id` <> 32597905 AND `partno` = '8900868012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12023428 [ RunTime:0.000222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32504130 LIMIT 5 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32504130 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32504130 ORDER BY `unit` DESC [ RunTime:0.001935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32504130 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32504130 ORDER BY `minOrder` ASC [ RunTime:0.000189s ]
select * from pdf where partno='8900868030' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868030' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000460s ]
SELECT `id` FROM `stock` WHERE `id` <> 32504130 AND `partno` = '8900868030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288188 [ RunTime:0.001843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32504129 LIMIT 5 [ RunTime:0.004730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32504129 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32504129 ORDER BY `unit` DESC [ RunTime:0.000282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32504129 LIMIT 2 [ RunTime:0.001975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32504129 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='8900868031' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868031' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001654s ]
SELECT `id` FROM `stock` WHERE `id` <> 32504129 AND `partno` = '8900868031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32504128 LIMIT 5 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32504128 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32504128 ORDER BY `unit` DESC [ RunTime:0.002581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32504128 LIMIT 2 [ RunTime:0.001273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32504128 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
select * from pdf where partno='8900868032' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8900868032' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001691s ]
SELECT `id` FROM `stock` WHERE `id` <> 32504128 AND `partno` = '8900868032' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000440s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001900s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007836s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003862s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002549s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000768s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000460s ]
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 '890086%' OR `brand` LIKE '890086%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002324s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '890086%' OR `brand` LIKE '890086%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000542s ]