SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001577s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012925s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880669 LIMIT 5 [ RunTime:0.010399s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880669 ORDER BY `minOrder` ASC [ RunTime:0.018334s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880669 ORDER BY `unit` DESC [ RunTime:0.012141s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880669 LIMIT 2 [ RunTime:0.014900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880669 ORDER BY `minOrder` ASC [ RunTime:0.015428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12877099 LIMIT 5 [ RunTime:0.023493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12877099 ORDER BY `minOrder` ASC [ RunTime:0.026482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12877099 ORDER BY `unit` DESC [ RunTime:0.013121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12877099 LIMIT 2 [ RunTime:0.018544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12877099 ORDER BY `minOrder` ASC [ RunTime:0.015338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16358931 LIMIT 5 [ RunTime:0.014545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16358931 ORDER BY `minOrder` ASC [ RunTime:0.012269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16358931 ORDER BY `unit` DESC [ RunTime:0.019762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16358931 LIMIT 2 [ RunTime:0.030051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16358931 ORDER BY `minOrder` ASC [ RunTime:0.015001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681513 LIMIT 5 [ RunTime:0.018632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681513 ORDER BY `minOrder` ASC [ RunTime:0.049187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681513 ORDER BY `unit` DESC [ RunTime:0.026980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681513 LIMIT 2 [ RunTime:0.008620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681513 ORDER BY `minOrder` ASC [ RunTime:0.006387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078223 LIMIT 5 [ RunTime:0.032007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078223 ORDER BY `minOrder` ASC [ RunTime:0.006527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20078223 ORDER BY `unit` DESC [ RunTime:0.027647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20078223 LIMIT 2 [ RunTime:0.028645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20078223 ORDER BY `minOrder` ASC [ RunTime:0.010283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682393 LIMIT 5 [ RunTime:0.051032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682393 ORDER BY `minOrder` ASC [ RunTime:0.047956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682393 ORDER BY `unit` DESC [ RunTime:0.037150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682393 LIMIT 2 [ RunTime:0.036221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682393 ORDER BY `minOrder` ASC [ RunTime:0.035223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879546 LIMIT 5 [ RunTime:0.022577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879546 ORDER BY `minOrder` ASC [ RunTime:0.014906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879546 ORDER BY `unit` DESC [ RunTime:0.032415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879546 LIMIT 2 [ RunTime:0.032108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879546 ORDER BY `minOrder` ASC [ RunTime:0.010602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11680823 LIMIT 5 [ RunTime:0.019240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11680823 ORDER BY `minOrder` ASC [ RunTime:0.014397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11680823 ORDER BY `unit` DESC [ RunTime:0.012353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11680823 LIMIT 2 [ RunTime:0.040700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11680823 ORDER BY `minOrder` ASC [ RunTime:0.029311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11679488 LIMIT 5 [ RunTime:0.030697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11679488 ORDER BY `minOrder` ASC [ RunTime:0.024170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11679488 ORDER BY `unit` DESC [ RunTime:0.021731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11679488 LIMIT 2 [ RunTime:0.033840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11679488 ORDER BY `minOrder` ASC [ RunTime:0.005358s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016344s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908238 LIMIT 5 [ RunTime:0.006136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908238 ORDER BY `minOrder` ASC [ RunTime:0.009246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908238 ORDER BY `unit` DESC [ RunTime:0.000500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908238 LIMIT 2 [ RunTime:0.003680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908238 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
select * from pdf where partno='901-10309' and brandshort='Amphenol RF' limit 1 [ RunTime:0.009768s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10309' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.026285s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908238 AND `partno` = '901-10309' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.024863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880669 [ RunTime:0.014622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61910578 LIMIT 5 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910578 ORDER BY `minOrder` ASC [ RunTime:0.017901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61910578 ORDER BY `unit` DESC [ RunTime:0.009306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61910578 LIMIT 2 [ RunTime:0.026604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910578 ORDER BY `minOrder` ASC [ RunTime:0.006049s ]
select * from pdf where partno='901-10387' and brandshort='Amphenol RF' limit 1 [ RunTime:0.006011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10387' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000953s ]
SELECT `id` FROM `stock` WHERE `id` <> 61910578 AND `partno` = '901-10387' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.009699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12877099 [ RunTime:0.011955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60606839 LIMIT 5 [ RunTime:0.006272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606839 ORDER BY `minOrder` ASC [ RunTime:0.009452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60606839 ORDER BY `unit` DESC [ RunTime:0.019987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60606839 LIMIT 2 [ RunTime:0.001612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60606839 ORDER BY `minOrder` ASC [ RunTime:0.002265s ]
select * from pdf where partno='901-10384' and brandshort='Amphenol RF' limit 1 [ RunTime:0.002226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10384' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000994s ]
SELECT `id` FROM `stock` WHERE `id` <> 60606839 AND `partno` = '901-10384' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.039641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20078223 [ RunTime:0.015252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60607161 LIMIT 5 [ RunTime:0.014076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60607161 ORDER BY `minOrder` ASC [ RunTime:0.001784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60607161 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60607161 LIMIT 2 [ RunTime:0.010681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60607161 ORDER BY `minOrder` ASC [ RunTime:0.010948s ]
select * from pdf where partno='901-10395' and brandshort='Amphenol RF' limit 1 [ RunTime:0.020992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10395' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.018060s ]
SELECT `id` FROM `stock` WHERE `id` <> 60607161 AND `partno` = '901-10395' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.020511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16358931 [ RunTime:0.012720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909830 LIMIT 5 [ RunTime:0.018468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909830 ORDER BY `minOrder` ASC [ RunTime:0.014836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909830 ORDER BY `unit` DESC [ RunTime:0.008950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909830 LIMIT 2 [ RunTime:0.006359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909830 ORDER BY `minOrder` ASC [ RunTime:0.002392s ]
select * from pdf where partno='901-10385-EE' and brandshort='Amphenol RF' limit 1 [ RunTime:0.006299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10385-EE' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.001167s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909830 AND `partno` = '901-10385-EE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.010844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682393 [ RunTime:0.010028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915306 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915306 ORDER BY `minOrder` ASC [ RunTime:0.003028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915306 ORDER BY `unit` DESC [ RunTime:0.001331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915306 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915306 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
select * from pdf where partno='901-10352' and brandshort='Amphenol RF' limit 1 [ RunTime:0.003015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10352' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.008687s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915306 AND `partno` = '901-10352' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.001824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681513 [ RunTime:0.000954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913667 LIMIT 5 [ RunTime:0.006162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913667 ORDER BY `minOrder` ASC [ RunTime:0.022708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913667 ORDER BY `unit` DESC [ RunTime:0.002307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913667 LIMIT 2 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913667 ORDER BY `minOrder` ASC [ RunTime:0.012529s ]
select * from pdf where partno='901-103' and brandshort='Amphenol RF' limit 1 [ RunTime:0.001488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-103' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.001385s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913667 AND `partno` = '901-103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.001459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879546 [ RunTime:0.010971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61929394 LIMIT 5 [ RunTime:0.015794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61929394 ORDER BY `minOrder` ASC [ RunTime:0.024075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61929394 ORDER BY `unit` DESC [ RunTime:0.000766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61929394 LIMIT 2 [ RunTime:0.003551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61929394 ORDER BY `minOrder` ASC [ RunTime:0.007139s ]
select * from pdf where partno='901-103-11' and brandshort='Amphenol RF' limit 1 [ RunTime:0.012006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-103-11' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.020770s ]
SELECT `id` FROM `stock` WHERE `id` <> 61929394 AND `partno` = '901-103-11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.011888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11679488 [ RunTime:0.004179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61921598 LIMIT 5 [ RunTime:0.007717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61921598 ORDER BY `minOrder` ASC [ RunTime:0.007675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61921598 ORDER BY `unit` DESC [ RunTime:0.016658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61921598 LIMIT 2 [ RunTime:0.021582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61921598 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='901-10398' and brandshort='Amphenol RF' limit 1 [ RunTime:0.003409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10398' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.013399s ]
SELECT `id` FROM `stock` WHERE `id` <> 61921598 AND `partno` = '901-10398' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.004007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11680823 [ RunTime:0.007185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915904 LIMIT 5 [ RunTime:0.001372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915904 ORDER BY `minOrder` ASC [ RunTime:0.018496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915904 ORDER BY `unit` DESC [ RunTime:0.011249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915904 LIMIT 2 [ RunTime:0.006710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915904 ORDER BY `minOrder` ASC [ RunTime:0.014206s ]
select * from pdf where partno='901-10385' and brandshort='Amphenol RF' limit 1 [ RunTime:0.015013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '901-10385' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.013798s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915904 AND `partno` = '901-10385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.023011s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018993s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014813s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013678s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023615s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005993s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018135s ]
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 '901-103%' OR `brand` LIKE '901-103%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011417s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '901-103%' OR `brand` LIKE '901-103%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.032637s ]