SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001995s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046475s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.029318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12113282 LIMIT 5 [ RunTime:0.111725s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12113282 ORDER BY `minOrder` ASC [ RunTime:0.052701s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12113282 ORDER BY `unit` DESC [ RunTime:0.051535s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12113282 LIMIT 2 [ RunTime:0.027055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12113282 ORDER BY `minOrder` ASC [ RunTime:0.060228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085555 LIMIT 5 [ RunTime:0.095993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085555 ORDER BY `minOrder` ASC [ RunTime:0.071902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085555 ORDER BY `unit` DESC [ RunTime:0.051190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085555 LIMIT 2 [ RunTime:0.051140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085555 ORDER BY `minOrder` ASC [ RunTime:0.069328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085544 LIMIT 5 [ RunTime:0.051343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085544 ORDER BY `minOrder` ASC [ RunTime:0.051168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085544 ORDER BY `unit` DESC [ RunTime:0.050910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085544 LIMIT 2 [ RunTime:0.050789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085544 ORDER BY `minOrder` ASC [ RunTime:0.050720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085374 LIMIT 5 [ RunTime:0.051021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085374 ORDER BY `minOrder` ASC [ RunTime:0.022424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085374 ORDER BY `unit` DESC [ RunTime:0.010225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085374 LIMIT 2 [ RunTime:0.030864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085374 ORDER BY `minOrder` ASC [ RunTime:0.029331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085286 LIMIT 5 [ RunTime:0.025196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085286 ORDER BY `minOrder` ASC [ RunTime:0.030048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085286 ORDER BY `unit` DESC [ RunTime:0.067146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085286 LIMIT 2 [ RunTime:0.076939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085286 ORDER BY `minOrder` ASC [ RunTime:0.061049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085285 LIMIT 5 [ RunTime:0.046239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085285 ORDER BY `minOrder` ASC [ RunTime:0.059965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085285 ORDER BY `unit` DESC [ RunTime:0.051091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085285 LIMIT 2 [ RunTime:0.193024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085285 ORDER BY `minOrder` ASC [ RunTime:0.125232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085245 LIMIT 5 [ RunTime:0.071965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085245 ORDER BY `minOrder` ASC [ RunTime:0.014385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085245 ORDER BY `unit` DESC [ RunTime:0.034086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085245 LIMIT 2 [ RunTime:0.063717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085245 ORDER BY `minOrder` ASC [ RunTime:0.047459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085244 LIMIT 5 [ RunTime:0.085220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085244 ORDER BY `minOrder` ASC [ RunTime:0.050500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085244 ORDER BY `unit` DESC [ RunTime:0.056502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085244 LIMIT 2 [ RunTime:0.073273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085244 ORDER BY `minOrder` ASC [ RunTime:0.034004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085193 LIMIT 5 [ RunTime:0.061023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085193 ORDER BY `minOrder` ASC [ RunTime:0.003337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085193 ORDER BY `unit` DESC [ RunTime:0.033961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085193 LIMIT 2 [ RunTime:0.040805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085193 ORDER BY `minOrder` ASC [ RunTime:0.032865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085192 LIMIT 5 [ RunTime:0.024760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085192 ORDER BY `minOrder` ASC [ RunTime:0.033403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085192 ORDER BY `unit` DESC [ RunTime:0.032249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085192 LIMIT 2 [ RunTime:0.025867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085192 ORDER BY `minOrder` ASC [ RunTime:0.045745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085191 LIMIT 5 [ RunTime:0.047328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085191 ORDER BY `minOrder` ASC [ RunTime:0.003980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085191 ORDER BY `unit` DESC [ RunTime:0.079955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085191 LIMIT 2 [ RunTime:0.074075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085191 ORDER BY `minOrder` ASC [ RunTime:0.133386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085190 LIMIT 5 [ RunTime:0.061313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085190 ORDER BY `minOrder` ASC [ RunTime:0.151393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085190 ORDER BY `unit` DESC [ RunTime:0.105897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085190 LIMIT 2 [ RunTime:0.083909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085190 ORDER BY `minOrder` ASC [ RunTime:0.019120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085189 LIMIT 5 [ RunTime:0.041114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085189 ORDER BY `minOrder` ASC [ RunTime:0.051664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085189 ORDER BY `unit` DESC [ RunTime:0.008783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085189 LIMIT 2 [ RunTime:0.006715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085189 ORDER BY `minOrder` ASC [ RunTime:0.021204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085130 LIMIT 5 [ RunTime:0.009682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085130 ORDER BY `minOrder` ASC [ RunTime:0.006215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085130 ORDER BY `unit` DESC [ RunTime:0.001241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085130 LIMIT 2 [ RunTime:0.008086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085130 ORDER BY `minOrder` ASC [ RunTime:0.001440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085129 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085129 ORDER BY `minOrder` ASC [ RunTime:0.001083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085129 ORDER BY `unit` DESC [ RunTime:0.002309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085129 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085129 ORDER BY `minOrder` ASC [ RunTime:0.001735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085128 LIMIT 5 [ RunTime:0.003050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085128 ORDER BY `minOrder` ASC [ RunTime:0.001787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085128 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085128 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085128 ORDER BY `minOrder` ASC [ RunTime:0.002193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085034 LIMIT 5 [ RunTime:0.000867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085034 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12085034 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12085034 LIMIT 2 [ RunTime:0.004563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12085034 ORDER BY `minOrder` ASC [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130137 LIMIT 5 [ RunTime:0.002491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130137 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11130137 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11130137 LIMIT 2 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130137 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130105 LIMIT 5 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130105 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11130105 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11130105 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130105 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130055 LIMIT 5 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130055 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11130055 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11130055 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11130055 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32169425 LIMIT 5 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32169425 ORDER BY `minOrder` ASC [ RunTime:0.001271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32169425 ORDER BY `unit` DESC [ RunTime:0.001062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32169425 LIMIT 2 [ RunTime:0.010064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32169425 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
select * from pdf where partno='lfa150f-48-sng' and brandshort='cosel' limit 1 [ RunTime:0.002348s ]
select foldpath,foldpath2,filename from pdf_file where id=1918603 limit 1 [ RunTime:0.011474s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'lfa150f-48-sng' OR `brand` LIKE 'cosel%' ) ) LIMIT 1 [ RunTime:0.001668s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630816 LIMIT 5 [ RunTime:0.002234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630816 ORDER BY `minOrder` ASC [ RunTime:0.001645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630816 ORDER BY `unit` DESC [ RunTime:0.001272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630816 LIMIT 2 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630816 ORDER BY `minOrder` ASC [ RunTime:0.001460s ]
select * from pdf where partno='LFA150F-48-SNCR2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.010815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNCR2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.002481s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630816 AND `partno` = 'LFA150F-48-SNCR2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.002919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630815 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630815 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630815 ORDER BY `unit` DESC [ RunTime:0.001368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630815 LIMIT 2 [ RunTime:0.003191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630815 ORDER BY `minOrder` ASC [ RunTime:0.001763s ]
select * from pdf where partno='LFA150F-48-SNCR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.002533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNCR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000665s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630815 AND `partno` = 'LFA150F-48-SNCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130137 [ RunTime:0.001956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630485 LIMIT 5 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630485 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630485 ORDER BY `unit` DESC [ RunTime:0.000287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630485 LIMIT 2 [ RunTime:0.000842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630485 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='LFA150F-48-SCR2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SCR2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001169s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630485 AND `partno` = 'LFA150F-48-SCR2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.002793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085555 [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630484 LIMIT 5 [ RunTime:0.002890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630484 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630484 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630484 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630484 ORDER BY `minOrder` ASC [ RunTime:0.001313s ]
select * from pdf where partno='LFA150F-48-SCR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SCR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.003435s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630484 AND `partno` = 'LFA150F-48-SCR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130105 [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630461 LIMIT 5 [ RunTime:0.002893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630461 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630461 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630461 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630461 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='LFA150F-48-SNCG' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNCG' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001525s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630461 AND `partno` = 'LFA150F-48-SNCG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085544 [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630402 LIMIT 5 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630402 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630402 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630402 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630402 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='LFA150F-48-SNCY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNCY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001572s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630402 AND `partno` = 'LFA150F-48-SNCY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130055 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630401 LIMIT 5 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630401 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630401 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630401 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630401 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='LFA150F-48-SNCJ1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNCJ1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.006934s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630401 AND `partno` = 'LFA150F-48-SNCJ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.001201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130054 [ RunTime:0.002152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41630400 LIMIT 5 [ RunTime:0.001423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630400 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41630400 ORDER BY `unit` DESC [ RunTime:0.003794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41630400 LIMIT 2 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41630400 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='LFA150F-48-SNC' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNC' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.002730s ]
SELECT `id` FROM `stock` WHERE `id` <> 41630400 AND `partno` = 'LFA150F-48-SNC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130053 [ RunTime:0.002845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629980 LIMIT 5 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629980 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629980 ORDER BY `unit` DESC [ RunTime:0.000269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629980 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629980 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
select * from pdf where partno='LFA150F-48-SCG' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SCG' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000319s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629980 AND `partno` = 'LFA150F-48-SCG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130015 [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629928 LIMIT 5 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629928 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629928 ORDER BY `unit` DESC [ RunTime:0.001397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629928 LIMIT 2 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629928 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
select * from pdf where partno='LFA150F-48-SCY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SCY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000681s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629928 AND `partno` = 'LFA150F-48-SCY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.001157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11130000 [ RunTime:0.000265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629927 LIMIT 5 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629927 ORDER BY `minOrder` ASC [ RunTime:0.000873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629927 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629927 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629927 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='LFA150F-48-SCJ1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.004529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SCJ1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001037s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629927 AND `partno` = 'LFA150F-48-SCJ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085374 [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629926 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629926 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629926 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629926 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629926 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='LFA150F-48-SC' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.001016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SC' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001416s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629926 AND `partno` = 'LFA150F-48-SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11129999 [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629823 LIMIT 5 [ RunTime:0.000826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629823 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629823 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629823 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629823 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='LFA150F-48-SNGR2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.001205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNGR2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.006101s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629823 AND `partno` = 'LFA150F-48-SNGR2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629822 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629822 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629822 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629822 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629822 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='LFA150F-48-SNGR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNGR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.002353s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629822 AND `partno` = 'LFA150F-48-SNGR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629545 LIMIT 5 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629545 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629545 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629545 LIMIT 2 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629545 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
select * from pdf where partno='LFA150F-48-SNRY' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.002580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNRY' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000847s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629545 AND `partno` = 'LFA150F-48-SNRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085286 [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629544 LIMIT 5 [ RunTime:0.001185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629544 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629544 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629544 LIMIT 2 [ RunTime:0.004498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629544 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='LFA150F-48-SNR2Y' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.003097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNR2Y' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.001062s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629544 AND `partno` = 'LFA150F-48-SNR2Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629543 LIMIT 5 [ RunTime:0.003037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629543 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629543 ORDER BY `unit` DESC [ RunTime:0.000258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629543 LIMIT 2 [ RunTime:0.005233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629543 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
select * from pdf where partno='LFA150F-48-SNR2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNR2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000276s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629543 AND `partno` = 'LFA150F-48-SNR2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11129944 [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629542 LIMIT 5 [ RunTime:0.001150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629542 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629542 ORDER BY `unit` DESC [ RunTime:0.000784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629542 LIMIT 2 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629542 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
select * from pdf where partno='LFA150F-48-SNR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.003775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.004826s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629542 AND `partno` = 'LFA150F-48-SNR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629541 LIMIT 5 [ RunTime:0.000913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629541 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629541 ORDER BY `unit` DESC [ RunTime:0.001272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629541 LIMIT 2 [ RunTime:0.001896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629541 ORDER BY `minOrder` ASC [ RunTime:0.008880s ]
select * from pdf where partno='LFA150F-48-SNJ1R2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.008843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNJ1R2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000948s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629541 AND `partno` = 'LFA150F-48-SNJ1R2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.009565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12085285 [ RunTime:0.015299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41629540 LIMIT 5 [ RunTime:0.006383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629540 ORDER BY `minOrder` ASC [ RunTime:0.025985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41629540 ORDER BY `unit` DESC [ RunTime:0.019389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41629540 LIMIT 2 [ RunTime:0.025486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41629540 ORDER BY `minOrder` ASC [ RunTime:0.032149s ]
select * from pdf where partno='LFA150F-48-SNJ1R' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.008760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LFA150F-48-SNJ1R' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000940s ]
SELECT `id` FROM `stock` WHERE `id` <> 41629540 AND `partno` = 'LFA150F-48-SNJ1R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.010522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11129943 [ RunTime:0.001357s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001405s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001150s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001253s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009642s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001231s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007008s ]
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 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008362s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LFA150F-48-S%' OR `brand` LIKE 'LFA150F-48-S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009303s ]