SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002665s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052523s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.100567s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.091674s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627328 LIMIT 5 [ RunTime:0.032730s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627328 ORDER BY `minOrder` ASC [ RunTime:0.042436s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627328 ORDER BY `unit` DESC [ RunTime:0.010863s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.026012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627328 LIMIT 2 [ RunTime:0.088956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627328 ORDER BY `minOrder` ASC [ RunTime:0.020045s ]
select * from pdf where partno='MT5/V-291-300' and brandshort='Altech Corporation' limit 1 [ RunTime:0.063075s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-291-300' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.067768s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627328 AND `partno` = 'MT5/V-291-300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.062503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627327 LIMIT 5 [ RunTime:0.020782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627327 ORDER BY `minOrder` ASC [ RunTime:0.042927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627327 ORDER BY `unit` DESC [ RunTime:0.043990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627327 LIMIT 2 [ RunTime:0.021727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627327 ORDER BY `minOrder` ASC [ RunTime:0.022881s ]
select * from pdf where partno='MT5/V-281-290' and brandshort='Altech Corporation' limit 1 [ RunTime:0.018951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-281-290' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.004043s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627327 AND `partno` = 'MT5/V-281-290' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.012106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627326 LIMIT 5 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627326 ORDER BY `minOrder` ASC [ RunTime:0.002584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627326 ORDER BY `unit` DESC [ RunTime:0.004467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627326 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627326 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='MT5/V-271-280' and brandshort='Altech Corporation' limit 1 [ RunTime:0.004627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-271-280' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.002325s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627326 AND `partno` = 'MT5/V-271-280' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627325 LIMIT 5 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627325 ORDER BY `minOrder` ASC [ RunTime:0.001868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627325 ORDER BY `unit` DESC [ RunTime:0.013758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627325 LIMIT 2 [ RunTime:0.002482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627325 ORDER BY `minOrder` ASC [ RunTime:0.003959s ]
select * from pdf where partno='MT5/V-261-270' and brandshort='Altech Corporation' limit 1 [ RunTime:0.008804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-261-270' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.000963s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627325 AND `partno` = 'MT5/V-261-270' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.002422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627324 LIMIT 5 [ RunTime:0.005373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627324 ORDER BY `minOrder` ASC [ RunTime:0.003595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627324 ORDER BY `unit` DESC [ RunTime:0.000826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627324 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627324 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='MT5/V-251-260' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-251-260' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.003415s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627324 AND `partno` = 'MT5/V-251-260' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.008355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627323 LIMIT 5 [ RunTime:0.001492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627323 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627323 ORDER BY `unit` DESC [ RunTime:0.000682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627323 LIMIT 2 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627323 ORDER BY `minOrder` ASC [ RunTime:0.002874s ]
select * from pdf where partno='MT5/V-241-250' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-241-250' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.008658s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627323 AND `partno` = 'MT5/V-241-250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.004927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627322 LIMIT 5 [ RunTime:0.001050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627322 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627322 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627322 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627322 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
select * from pdf where partno='MT5/V-231-240' and brandshort='Altech Corporation' limit 1 [ RunTime:0.001220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-231-240' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.013827s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627322 AND `partno` = 'MT5/V-231-240' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.025040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627321 LIMIT 5 [ RunTime:0.013027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627321 ORDER BY `minOrder` ASC [ RunTime:0.003669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627321 ORDER BY `unit` DESC [ RunTime:0.000844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627321 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627321 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='MT5/V-221-230' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-221-230' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.007868s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627321 AND `partno` = 'MT5/V-221-230' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.009170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627320 LIMIT 5 [ RunTime:0.010841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627320 ORDER BY `minOrder` ASC [ RunTime:0.007702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627320 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627320 LIMIT 2 [ RunTime:0.002699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627320 ORDER BY `minOrder` ASC [ RunTime:0.003587s ]
select * from pdf where partno='MT5/V-21-30' and brandshort='Altech Corporation' limit 1 [ RunTime:0.008416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-21-30' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.015440s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627320 AND `partno` = 'MT5/V-21-30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.018318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627319 LIMIT 5 [ RunTime:0.015990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627319 ORDER BY `minOrder` ASC [ RunTime:0.003724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627319 ORDER BY `unit` DESC [ RunTime:0.010759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627319 LIMIT 2 [ RunTime:0.007729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627319 ORDER BY `minOrder` ASC [ RunTime:0.004708s ]
select * from pdf where partno='MT5/V-211-220' and brandshort='Altech Corporation' limit 1 [ RunTime:0.004851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-211-220' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.015878s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627319 AND `partno` = 'MT5/V-211-220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.007151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627318 LIMIT 5 [ RunTime:0.008167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627318 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627318 ORDER BY `unit` DESC [ RunTime:0.003064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627318 LIMIT 2 [ RunTime:0.002039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627318 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='MT5/V-201-210' and brandshort='Altech Corporation' limit 1 [ RunTime:0.000858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-201-210' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.005595s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627318 AND `partno` = 'MT5/V-201-210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.004713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627317 LIMIT 5 [ RunTime:0.014809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627317 ORDER BY `minOrder` ASC [ RunTime:0.008951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627317 ORDER BY `unit` DESC [ RunTime:0.005231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627317 LIMIT 2 [ RunTime:0.001075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627317 ORDER BY `minOrder` ASC [ RunTime:0.007246s ]
select * from pdf where partno='MT5/V-20' and brandshort='Altech Corporation' limit 1 [ RunTime:0.003823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-20' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.000805s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627317 AND `partno` = 'MT5/V-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.013297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60627316 LIMIT 5 [ RunTime:0.005156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627316 ORDER BY `minOrder` ASC [ RunTime:0.001829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60627316 ORDER BY `unit` DESC [ RunTime:0.004400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60627316 LIMIT 2 [ RunTime:0.001821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60627316 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='MT5/V-2' and brandshort='Altech Corporation' limit 1 [ RunTime:0.003237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MT5/V-2' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.021572s ]
SELECT `id` FROM `stock` WHERE `id` <> 60627316 AND `partno` = 'MT5/V-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.004919s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026832s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013180s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011264s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007641s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006380s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002196s ]
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 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002901s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MT5/V-2%' OR `brand` LIKE 'MT5/V-2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006733s ]