SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002805s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061766s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.082419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684640 LIMIT 5 [ RunTime:0.068404s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.049784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684640 ORDER BY `minOrder` ASC [ RunTime:0.023813s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684640 ORDER BY `unit` DESC [ RunTime:0.052893s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684640 LIMIT 2 [ RunTime:0.029535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684640 ORDER BY `minOrder` ASC [ RunTime:0.028280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12668898 LIMIT 5 [ RunTime:0.113498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12668898 ORDER BY `minOrder` ASC [ RunTime:0.087077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12668898 ORDER BY `unit` DESC [ RunTime:0.166281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12668898 LIMIT 2 [ RunTime:0.054066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12668898 ORDER BY `minOrder` ASC [ RunTime:0.046935s ]
select * from pdf where partno='SSM-106-L-DV-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.079158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534098 LIMIT 5 [ RunTime:0.019854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534098 ORDER BY `minOrder` ASC [ RunTime:0.069266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11534098 ORDER BY `unit` DESC [ RunTime:0.049413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11534098 LIMIT 2 [ RunTime:0.057586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534098 ORDER BY `minOrder` ASC [ RunTime:0.003182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533408 LIMIT 5 [ RunTime:0.060756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533408 ORDER BY `minOrder` ASC [ RunTime:0.087096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11533408 ORDER BY `unit` DESC [ RunTime:0.080622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11533408 LIMIT 2 [ RunTime:0.059247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533408 ORDER BY `minOrder` ASC [ RunTime:0.022937s ]
select * from pdf where partno='SSM-106-L-DV-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.097867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11532894 LIMIT 5 [ RunTime:0.041737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11532894 ORDER BY `minOrder` ASC [ RunTime:0.017711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11532894 ORDER BY `unit` DESC [ RunTime:0.036712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11532894 LIMIT 2 [ RunTime:0.047848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11532894 ORDER BY `minOrder` ASC [ RunTime:0.046049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11522465 LIMIT 5 [ RunTime:0.045187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11522465 ORDER BY `minOrder` ASC [ RunTime:0.066360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11522465 ORDER BY `unit` DESC [ RunTime:0.062012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11522465 LIMIT 2 [ RunTime:0.070183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11522465 ORDER BY `minOrder` ASC [ RunTime:0.044329s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029128s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52914099 LIMIT 5 [ RunTime:0.025265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52914099 ORDER BY `minOrder` ASC [ RunTime:0.016513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52914099 ORDER BY `unit` DESC [ RunTime:0.047829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52914099 LIMIT 2 [ RunTime:0.006962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52914099 ORDER BY `minOrder` ASC [ RunTime:0.005378s ]
select * from pdf where partno='SSM-106-L-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029147s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.056166s ]
SELECT `id` FROM `stock` WHERE `id` <> 52914099 AND `partno` = 'SSM-106-L-DV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.060410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52950642 LIMIT 5 [ RunTime:0.043443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52950642 ORDER BY `minOrder` ASC [ RunTime:0.032420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52950642 ORDER BY `unit` DESC [ RunTime:0.067745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52950642 LIMIT 2 [ RunTime:0.018588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52950642 ORDER BY `minOrder` ASC [ RunTime:0.029872s ]
select * from pdf where partno='SSM-106-L-DV-LC-012-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-012-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023029s ]
SELECT `id` FROM `stock` WHERE `id` <> 52950642 AND `partno` = 'SSM-106-L-DV-LC-012-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.095940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11532894 [ RunTime:0.019977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52949967 LIMIT 5 [ RunTime:0.046216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949967 ORDER BY `minOrder` ASC [ RunTime:0.042445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52949967 ORDER BY `unit` DESC [ RunTime:0.010642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52949967 LIMIT 2 [ RunTime:0.064563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949967 ORDER BY `minOrder` ASC [ RunTime:0.021329s ]
select * from pdf where partno='SSM-106-L-DV-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014251s ]
SELECT `id` FROM `stock` WHERE `id` <> 52949967 AND `partno` = 'SSM-106-L-DV-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.076012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684640 [ RunTime:0.042996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52949708 LIMIT 5 [ RunTime:0.053182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949708 ORDER BY `minOrder` ASC [ RunTime:0.090136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52949708 ORDER BY `unit` DESC [ RunTime:0.045220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52949708 LIMIT 2 [ RunTime:0.095555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949708 ORDER BY `minOrder` ASC [ RunTime:0.046984s ]
select * from pdf where partno='SSM-106-L-DV-LC-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.054558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.038181s ]
SELECT `id` FROM `stock` WHERE `id` <> 52949708 AND `partno` = 'SSM-106-L-DV-LC-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.081218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52949517 LIMIT 5 [ RunTime:0.046272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949517 ORDER BY `minOrder` ASC [ RunTime:0.053446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52949517 ORDER BY `unit` DESC [ RunTime:0.032500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52949517 LIMIT 2 [ RunTime:0.077968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949517 ORDER BY `minOrder` ASC [ RunTime:0.003520s ]
select * from pdf where partno='SSM-106-L-DV-LC-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019316s ]
SELECT `id` FROM `stock` WHERE `id` <> 52949517 AND `partno` = 'SSM-106-L-DV-LC-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52949208 LIMIT 5 [ RunTime:0.040981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949208 ORDER BY `minOrder` ASC [ RunTime:0.025306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52949208 ORDER BY `unit` DESC [ RunTime:0.015429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52949208 LIMIT 2 [ RunTime:0.013054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52949208 ORDER BY `minOrder` ASC [ RunTime:0.022408s ]
select * from pdf where partno='SSM-106-L-DV-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014907s ]
SELECT `id` FROM `stock` WHERE `id` <> 52949208 AND `partno` = 'SSM-106-L-DV-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534098 [ RunTime:0.028102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52947502 LIMIT 5 [ RunTime:0.018123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52947502 ORDER BY `minOrder` ASC [ RunTime:0.022455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52947502 ORDER BY `unit` DESC [ RunTime:0.026912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52947502 LIMIT 2 [ RunTime:0.006741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52947502 ORDER BY `minOrder` ASC [ RunTime:0.020655s ]
select * from pdf where partno='SSM-106-L-DV-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016960s ]
SELECT `id` FROM `stock` WHERE `id` <> 52947502 AND `partno` = 'SSM-106-L-DV-LC-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.115534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533408 [ RunTime:0.048151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52917917 LIMIT 5 [ RunTime:0.004699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52917917 ORDER BY `minOrder` ASC [ RunTime:0.015645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52917917 ORDER BY `unit` DESC [ RunTime:0.004147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52917917 LIMIT 2 [ RunTime:0.054974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52917917 ORDER BY `minOrder` ASC [ RunTime:0.018608s ]
select * from pdf where partno='SSM-106-L-DV-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014894s ]
SELECT `id` FROM `stock` WHERE `id` <> 52917917 AND `partno` = 'SSM-106-L-DV-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.057199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11522465 [ RunTime:0.018958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52917745 LIMIT 5 [ RunTime:0.024259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52917745 ORDER BY `minOrder` ASC [ RunTime:0.023680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52917745 ORDER BY `unit` DESC [ RunTime:0.023866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52917745 LIMIT 2 [ RunTime:0.028522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52917745 ORDER BY `minOrder` ASC [ RunTime:0.018701s ]
select * from pdf where partno='SSM-106-L-DV-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-106-L-DV-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035221s ]
SELECT `id` FROM `stock` WHERE `id` <> 52917745 AND `partno` = 'SSM-106-L-DV-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.038303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12668898 [ RunTime:0.018182s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047691s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038684s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011327s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029759s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049671s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040582s ]
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 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056184s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSM-106-L-DV-LC%' OR `brand` LIKE 'SSM-106-L-DV-LC%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034781s ]