SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002152s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034653s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474857 LIMIT 5 [ RunTime:0.023239s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474857 ORDER BY `minOrder` ASC [ RunTime:0.030304s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15474857 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15474857 LIMIT 2 [ RunTime:0.018394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474857 ORDER BY `minOrder` ASC [ RunTime:0.011272s ]
select * from pdf where partno='FTS-130-03-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.059607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754586 LIMIT 5 [ RunTime:0.033287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754586 ORDER BY `minOrder` ASC [ RunTime:0.017139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12754586 ORDER BY `unit` DESC [ RunTime:0.054114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12754586 LIMIT 2 [ RunTime:0.036954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754586 ORDER BY `minOrder` ASC [ RunTime:0.022503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746527 LIMIT 5 [ RunTime:0.021741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746527 ORDER BY `minOrder` ASC [ RunTime:0.027261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12746527 ORDER BY `unit` DESC [ RunTime:0.039879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12746527 LIMIT 2 [ RunTime:0.036852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746527 ORDER BY `minOrder` ASC [ RunTime:0.011619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11581633 LIMIT 5 [ RunTime:0.036810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11581633 ORDER BY `minOrder` ASC [ RunTime:0.046956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11581633 ORDER BY `unit` DESC [ RunTime:0.018681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11581633 LIMIT 2 [ RunTime:0.050427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11581633 ORDER BY `minOrder` ASC [ RunTime:0.013553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11581555 LIMIT 5 [ RunTime:0.027018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11581555 ORDER BY `minOrder` ASC [ RunTime:0.072516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11581555 ORDER BY `unit` DESC [ RunTime:0.035481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11581555 LIMIT 2 [ RunTime:0.014337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11581555 ORDER BY `minOrder` ASC [ RunTime:0.013328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11580586 LIMIT 5 [ RunTime:0.008534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11580586 ORDER BY `minOrder` ASC [ RunTime:0.022083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11580586 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11580586 LIMIT 2 [ RunTime:0.004915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11580586 ORDER BY `minOrder` ASC [ RunTime:0.006443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573562 LIMIT 5 [ RunTime:0.031455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573562 ORDER BY `minOrder` ASC [ RunTime:0.053609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11573562 ORDER BY `unit` DESC [ RunTime:0.137860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11573562 LIMIT 2 [ RunTime:0.037825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573562 ORDER BY `minOrder` ASC [ RunTime:0.044648s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037878s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59711923 LIMIT 5 [ RunTime:0.036811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711923 ORDER BY `minOrder` ASC [ RunTime:0.023477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59711923 ORDER BY `unit` DESC [ RunTime:0.032287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59711923 LIMIT 2 [ RunTime:0.027633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711923 ORDER BY `minOrder` ASC [ RunTime:0.010763s ]
select * from pdf where partno='FTS-130-03-L-DV-SA-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008599s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-SA-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018275s ]
SELECT `id` FROM `stock` WHERE `id` <> 59711923 AND `partno` = 'FTS-130-03-L-DV-SA-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754586 [ RunTime:0.030990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710561 LIMIT 5 [ RunTime:0.033405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710561 ORDER BY `minOrder` ASC [ RunTime:0.018614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710561 ORDER BY `unit` DESC [ RunTime:0.014108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710561 LIMIT 2 [ RunTime:0.064579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710561 ORDER BY `minOrder` ASC [ RunTime:0.012471s ]
select * from pdf where partno='FTS-130-03-L-DV-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.051539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040723s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710561 AND `partno` = 'FTS-130-03-L-DV-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11581555 [ RunTime:0.053893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710560 LIMIT 5 [ RunTime:0.014535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710560 ORDER BY `minOrder` ASC [ RunTime:0.057482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710560 ORDER BY `unit` DESC [ RunTime:0.005767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710560 LIMIT 2 [ RunTime:0.016848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710560 ORDER BY `minOrder` ASC [ RunTime:0.034594s ]
select * from pdf where partno='FTS-130-03-L-DV-SA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.069742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-SA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.054081s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710560 AND `partno` = 'FTS-130-03-L-DV-SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11581633 [ RunTime:0.045202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59708879 LIMIT 5 [ RunTime:0.035310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708879 ORDER BY `minOrder` ASC [ RunTime:0.038194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59708879 ORDER BY `unit` DESC [ RunTime:0.006070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59708879 LIMIT 2 [ RunTime:0.012147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708879 ORDER BY `minOrder` ASC [ RunTime:0.039625s ]
select * from pdf where partno='FTS-130-03-L-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025125s ]
SELECT `id` FROM `stock` WHERE `id` <> 59708879 AND `partno` = 'FTS-130-03-L-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.031764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59707900 LIMIT 5 [ RunTime:0.041887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707900 ORDER BY `minOrder` ASC [ RunTime:0.033276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59707900 ORDER BY `unit` DESC [ RunTime:0.049230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59707900 LIMIT 2 [ RunTime:0.018305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707900 ORDER BY `minOrder` ASC [ RunTime:0.004267s ]
select * from pdf where partno='FTS-130-03-L-DV-SA-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-SA-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024136s ]
SELECT `id` FROM `stock` WHERE `id` <> 59707900 AND `partno` = 'FTS-130-03-L-DV-SA-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746527 [ RunTime:0.029067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59707411 LIMIT 5 [ RunTime:0.017641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707411 ORDER BY `minOrder` ASC [ RunTime:0.016773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59707411 ORDER BY `unit` DESC [ RunTime:0.010303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59707411 LIMIT 2 [ RunTime:0.005064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707411 ORDER BY `minOrder` ASC [ RunTime:0.006434s ]
select * from pdf where partno='FTS-130-03-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006499s ]
SELECT `id` FROM `stock` WHERE `id` <> 59707411 AND `partno` = 'FTS-130-03-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11580586 [ RunTime:0.012772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59706991 LIMIT 5 [ RunTime:0.021930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706991 ORDER BY `minOrder` ASC [ RunTime:0.028198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59706991 ORDER BY `unit` DESC [ RunTime:0.035077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59706991 LIMIT 2 [ RunTime:0.015933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706991 ORDER BY `minOrder` ASC [ RunTime:0.008936s ]
select * from pdf where partno='FTS-130-03-L-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012270s ]
SELECT `id` FROM `stock` WHERE `id` <> 59706991 AND `partno` = 'FTS-130-03-L-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59701779 LIMIT 5 [ RunTime:0.025613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701779 ORDER BY `minOrder` ASC [ RunTime:0.017897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59701779 ORDER BY `unit` DESC [ RunTime:0.006980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59701779 LIMIT 2 [ RunTime:0.005668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701779 ORDER BY `minOrder` ASC [ RunTime:0.005284s ]
select * from pdf where partno='FTS-130-03-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018680s ]
SELECT `id` FROM `stock` WHERE `id` <> 59701779 AND `partno` = 'FTS-130-03-L-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573562 [ RunTime:0.009378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59563665 LIMIT 5 [ RunTime:0.002029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59563665 ORDER BY `minOrder` ASC [ RunTime:0.002153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59563665 ORDER BY `unit` DESC [ RunTime:0.015390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59563665 LIMIT 2 [ RunTime:0.014745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59563665 ORDER BY `minOrder` ASC [ RunTime:0.009121s ]
select * from pdf where partno='FTS-130-03-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-130-03-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002503s ]
SELECT `id` FROM `stock` WHERE `id` <> 59563665 AND `partno` = 'FTS-130-03-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474857 [ RunTime:0.001930s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ 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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018268s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021884s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016869s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012367s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004091s ]
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 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001735s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTS-130-03-L-DV%' OR `brand` LIKE 'FTS-130-03-L-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006411s ]