SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001851s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053461s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852951 LIMIT 5 [ RunTime:0.035502s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852951 ORDER BY `minOrder` ASC [ RunTime:0.031652s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852951 ORDER BY `unit` DESC [ RunTime:0.032913s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852951 LIMIT 2 [ RunTime:0.074239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852951 ORDER BY `minOrder` ASC [ RunTime:0.011260s ]
select * from pdf where partno='TFC-115-32-L-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19756491 LIMIT 5 [ RunTime:0.051517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19756491 ORDER BY `minOrder` ASC [ RunTime:0.104439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19756491 ORDER BY `unit` DESC [ RunTime:0.007088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19756491 LIMIT 2 [ RunTime:0.032566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19756491 ORDER BY `minOrder` ASC [ RunTime:0.016271s ]
select * from pdf where partno='TFC-115-32-L-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15475252 LIMIT 5 [ RunTime:0.045854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15475252 ORDER BY `minOrder` ASC [ RunTime:0.040606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15475252 ORDER BY `unit` DESC [ RunTime:0.029358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15475252 LIMIT 2 [ RunTime:0.030561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15475252 ORDER BY `minOrder` ASC [ RunTime:0.009131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746651 LIMIT 5 [ RunTime:0.016781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746651 ORDER BY `minOrder` ASC [ RunTime:0.025591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12746651 ORDER BY `unit` DESC [ RunTime:0.033712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12746651 LIMIT 2 [ RunTime:0.012160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746651 ORDER BY `minOrder` ASC [ RunTime:0.008282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746038 LIMIT 5 [ RunTime:0.016089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746038 ORDER BY `minOrder` ASC [ RunTime:0.037112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12746038 ORDER BY `unit` DESC [ RunTime:0.013823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12746038 LIMIT 2 [ RunTime:0.021599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746038 ORDER BY `minOrder` ASC [ RunTime:0.018301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575595 LIMIT 5 [ RunTime:0.014057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575595 ORDER BY `minOrder` ASC [ RunTime:0.033089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11575595 ORDER BY `unit` DESC [ RunTime:0.020202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11575595 LIMIT 2 [ RunTime:0.010469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575595 ORDER BY `minOrder` ASC [ RunTime:0.015482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573225 LIMIT 5 [ RunTime:0.011263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573225 ORDER BY `minOrder` ASC [ RunTime:0.014766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11573225 ORDER BY `unit` DESC [ RunTime:0.021108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11573225 LIMIT 2 [ RunTime:0.024410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573225 ORDER BY `minOrder` ASC [ RunTime:0.019075s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029492s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59542764 LIMIT 5 [ RunTime:0.075528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542764 ORDER BY `minOrder` ASC [ RunTime:0.014513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59542764 ORDER BY `unit` DESC [ RunTime:0.018712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59542764 LIMIT 2 [ RunTime:0.031101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542764 ORDER BY `minOrder` ASC [ RunTime:0.006472s ]
select * from pdf where partno='TFC-115-32-L-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008942s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.038499s ]
SELECT `id` FROM `stock` WHERE `id` <> 59542764 AND `partno` = 'TFC-115-32-L-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852951 [ RunTime:0.017025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59566213 LIMIT 5 [ RunTime:0.019181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59566213 ORDER BY `minOrder` ASC [ RunTime:0.005013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59566213 ORDER BY `unit` DESC [ RunTime:0.024186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59566213 LIMIT 2 [ RunTime:0.012694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59566213 ORDER BY `minOrder` ASC [ RunTime:0.015643s ]
select * from pdf where partno='TFC-115-32-L-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009766s ]
SELECT `id` FROM `stock` WHERE `id` <> 59566213 AND `partno` = 'TFC-115-32-L-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19756491 [ RunTime:0.005429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59566138 LIMIT 5 [ RunTime:0.025185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59566138 ORDER BY `minOrder` ASC [ RunTime:0.012462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59566138 ORDER BY `unit` DESC [ RunTime:0.034118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59566138 LIMIT 2 [ RunTime:0.003698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59566138 ORDER BY `minOrder` ASC [ RunTime:0.003355s ]
select * from pdf where partno='TFC-115-32-L-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004334s ]
SELECT `id` FROM `stock` WHERE `id` <> 59566138 AND `partno` = 'TFC-115-32-L-D-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15475252 [ RunTime:0.011174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52843080 LIMIT 5 [ RunTime:0.022585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52843080 ORDER BY `minOrder` ASC [ RunTime:0.028932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52843080 ORDER BY `unit` DESC [ RunTime:0.013391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52843080 LIMIT 2 [ RunTime:0.020788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52843080 ORDER BY `minOrder` ASC [ RunTime:0.004991s ]
select * from pdf where partno='TFC-115-32-L-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020916s ]
SELECT `id` FROM `stock` WHERE `id` <> 52843080 AND `partno` = 'TFC-115-32-L-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746038 [ RunTime:0.025061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52842573 LIMIT 5 [ RunTime:0.034335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52842573 ORDER BY `minOrder` ASC [ RunTime:0.040408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52842573 ORDER BY `unit` DESC [ RunTime:0.010891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52842573 LIMIT 2 [ RunTime:0.009044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52842573 ORDER BY `minOrder` ASC [ RunTime:0.017501s ]
select * from pdf where partno='TFC-115-32-L-D-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001028s ]
SELECT `id` FROM `stock` WHERE `id` <> 52842573 AND `partno` = 'TFC-115-32-L-D-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52820496 LIMIT 5 [ RunTime:0.011528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52820496 ORDER BY `minOrder` ASC [ RunTime:0.006322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52820496 ORDER BY `unit` DESC [ RunTime:0.001908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52820496 LIMIT 2 [ RunTime:0.011532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52820496 ORDER BY `minOrder` ASC [ RunTime:0.002648s ]
select * from pdf where partno='TFC-115-32-L-D-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000533s ]
SELECT `id` FROM `stock` WHERE `id` <> 52820496 AND `partno` = 'TFC-115-32-L-D-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746651 [ RunTime:0.014043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52818331 LIMIT 5 [ RunTime:0.005340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818331 ORDER BY `minOrder` ASC [ RunTime:0.013786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52818331 ORDER BY `unit` DESC [ RunTime:0.009227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52818331 LIMIT 2 [ RunTime:0.011775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818331 ORDER BY `minOrder` ASC [ RunTime:0.008248s ]
select * from pdf where partno='TFC-115-32-L-D-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009527s ]
SELECT `id` FROM `stock` WHERE `id` <> 52818331 AND `partno` = 'TFC-115-32-L-D-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573225 [ RunTime:0.005050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52817547 LIMIT 5 [ RunTime:0.007753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52817547 ORDER BY `minOrder` ASC [ RunTime:0.015281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52817547 ORDER BY `unit` DESC [ RunTime:0.003243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52817547 LIMIT 2 [ RunTime:0.002744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52817547 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='TFC-115-32-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC-115-32-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006270s ]
SELECT `id` FROM `stock` WHERE `id` <> 52817547 AND `partno` = 'TFC-115-32-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575595 [ RunTime:0.006700s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020643s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014159s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018087s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005913s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009308s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007541s ]
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 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010582s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TFC-115-32-L-D%' OR `brand` LIKE 'TFC-115-32-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004404s ]