SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002467s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040797s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486882 LIMIT 5 [ RunTime:0.016783s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486882 ORDER BY `minOrder` ASC [ RunTime:0.030189s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.015596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486882 ORDER BY `unit` DESC [ RunTime:0.014296s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486882 LIMIT 2 [ RunTime:0.015481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486882 ORDER BY `minOrder` ASC [ RunTime:0.011251s ]
select * from pdf where partno='TSW-110-08-S-S-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.032769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192012 LIMIT 5 [ RunTime:0.031056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192012 ORDER BY `minOrder` ASC [ RunTime:0.024599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192012 ORDER BY `unit` DESC [ RunTime:0.011381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192012 LIMIT 2 [ RunTime:0.037367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192012 ORDER BY `minOrder` ASC [ RunTime:0.010281s ]
select * from pdf where partno='TSW-110-08-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19819916 LIMIT 5 [ RunTime:0.012664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19819916 ORDER BY `minOrder` ASC [ RunTime:0.020658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19819916 ORDER BY `unit` DESC [ RunTime:0.062275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19819916 LIMIT 2 [ RunTime:0.042972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19819916 ORDER BY `minOrder` ASC [ RunTime:0.009995s ]
select * from pdf where partno='TSW-110-08-S-S-RA-005' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19818371 LIMIT 5 [ RunTime:0.012950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818371 ORDER BY `minOrder` ASC [ RunTime:0.007245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19818371 ORDER BY `unit` DESC [ RunTime:0.009610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19818371 LIMIT 2 [ RunTime:0.032558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818371 ORDER BY `minOrder` ASC [ RunTime:0.009279s ]
select * from pdf where partno='TSW-110-08-S-S-LL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748168 LIMIT 5 [ RunTime:0.017170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748168 ORDER BY `minOrder` ASC [ RunTime:0.033283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19748168 ORDER BY `unit` DESC [ RunTime:0.017602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19748168 LIMIT 2 [ RunTime:0.032174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748168 ORDER BY `minOrder` ASC [ RunTime:0.014597s ]
select * from pdf where partno='TSW-110-08-S-S-LA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220585 LIMIT 5 [ RunTime:0.021342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220585 ORDER BY `minOrder` ASC [ RunTime:0.028692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16220585 ORDER BY `unit` DESC [ RunTime:0.021625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16220585 LIMIT 2 [ RunTime:0.036092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220585 ORDER BY `minOrder` ASC [ RunTime:0.017879s ]
select * from pdf where partno='TSW-110-08-S-S-RA-006' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15487048 LIMIT 5 [ RunTime:0.001375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487048 ORDER BY `minOrder` ASC [ RunTime:0.012599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15487048 ORDER BY `unit` DESC [ RunTime:0.017753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15487048 LIMIT 2 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487048 ORDER BY `minOrder` ASC [ RunTime:0.002679s ]
select * from pdf where partno='TSW-110-08-S-S-RA-008' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12734532 LIMIT 5 [ RunTime:0.011052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12734532 ORDER BY `minOrder` ASC [ RunTime:0.003625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12734532 ORDER BY `unit` DESC [ RunTime:0.000832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12734532 LIMIT 2 [ RunTime:0.001418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12734532 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='TSW-110-08-S-S-RA-009' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12732466 LIMIT 5 [ RunTime:0.004210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12732466 ORDER BY `minOrder` ASC [ RunTime:0.003832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12732466 ORDER BY `unit` DESC [ RunTime:0.004242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12732466 LIMIT 2 [ RunTime:0.012022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12732466 ORDER BY `minOrder` ASC [ RunTime:0.009607s ]
select * from pdf where partno='TSW-110-08-S-S-005' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005764s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011913s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59483694 LIMIT 5 [ RunTime:0.001139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59483694 ORDER BY `minOrder` ASC [ RunTime:0.006227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59483694 ORDER BY `unit` DESC [ RunTime:0.002847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59483694 LIMIT 2 [ RunTime:0.005048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59483694 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='TSW-110-08-S-S-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003029s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007634s ]
SELECT `id` FROM `stock` WHERE `id` <> 59483694 AND `partno` = 'TSW-110-08-S-S-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486882 [ RunTime:0.005397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59576731 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59576731 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59576731 ORDER BY `unit` DESC [ RunTime:0.009078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59576731 LIMIT 2 [ RunTime:0.001891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59576731 ORDER BY `minOrder` ASC [ RunTime:0.007449s ]
select * from pdf where partno='TSW-110-08-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000593s ]
SELECT `id` FROM `stock` WHERE `id` <> 59576731 AND `partno` = 'TSW-110-08-S-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192012 [ RunTime:0.008907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59631715 LIMIT 5 [ RunTime:0.005356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59631715 ORDER BY `minOrder` ASC [ RunTime:0.008648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59631715 ORDER BY `unit` DESC [ RunTime:0.000497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59631715 LIMIT 2 [ RunTime:0.002168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59631715 ORDER BY `minOrder` ASC [ RunTime:0.003206s ]
select * from pdf where partno='TSW-110-08-S-S-005' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-005' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003021s ]
SELECT `id` FROM `stock` WHERE `id` <> 59631715 AND `partno` = 'TSW-110-08-S-S-005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12732466 [ RunTime:0.001577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59549521 LIMIT 5 [ RunTime:0.006457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549521 ORDER BY `minOrder` ASC [ RunTime:0.008493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59549521 ORDER BY `unit` DESC [ RunTime:0.004725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59549521 LIMIT 2 [ RunTime:0.013559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549521 ORDER BY `minOrder` ASC [ RunTime:0.002010s ]
select * from pdf where partno='TSW-110-08-S-S-RA-009' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-RA-009' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003617s ]
SELECT `id` FROM `stock` WHERE `id` <> 59549521 AND `partno` = 'TSW-110-08-S-S-RA-009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12734532 [ RunTime:0.007618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59549218 LIMIT 5 [ RunTime:0.007110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549218 ORDER BY `minOrder` ASC [ RunTime:0.010329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59549218 ORDER BY `unit` DESC [ RunTime:0.010807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59549218 LIMIT 2 [ RunTime:0.017328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549218 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
select * from pdf where partno='TSW-110-08-S-S-LA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-LA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000529s ]
SELECT `id` FROM `stock` WHERE `id` <> 59549218 AND `partno` = 'TSW-110-08-S-S-LA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748168 [ RunTime:0.002482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59478049 LIMIT 5 [ RunTime:0.034688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478049 ORDER BY `minOrder` ASC [ RunTime:0.048435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59478049 ORDER BY `unit` DESC [ RunTime:0.023614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59478049 LIMIT 2 [ RunTime:0.021068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478049 ORDER BY `minOrder` ASC [ RunTime:0.020481s ]
select * from pdf where partno='TSW-110-08-S-S-RA-006' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-RA-006' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003239s ]
SELECT `id` FROM `stock` WHERE `id` <> 59478049 AND `partno` = 'TSW-110-08-S-S-RA-006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220585 [ RunTime:0.009839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59478048 LIMIT 5 [ RunTime:0.009568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478048 ORDER BY `minOrder` ASC [ RunTime:0.027653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59478048 ORDER BY `unit` DESC [ RunTime:0.027528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59478048 LIMIT 2 [ RunTime:0.018639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478048 ORDER BY `minOrder` ASC [ RunTime:0.011844s ]
select * from pdf where partno='TSW-110-08-S-S-RA-005' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-RA-005' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012437s ]
SELECT `id` FROM `stock` WHERE `id` <> 59478048 AND `partno` = 'TSW-110-08-S-S-RA-005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19819916 [ RunTime:0.008055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59478047 LIMIT 5 [ RunTime:0.009840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478047 ORDER BY `minOrder` ASC [ RunTime:0.021819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59478047 ORDER BY `unit` DESC [ RunTime:0.032751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59478047 LIMIT 2 [ RunTime:0.017068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478047 ORDER BY `minOrder` ASC [ RunTime:0.004725s ]
select * from pdf where partno='TSW-110-08-S-S-RA-008' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-RA-008' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003681s ]
SELECT `id` FROM `stock` WHERE `id` <> 59478047 AND `partno` = 'TSW-110-08-S-S-RA-008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15487048 [ RunTime:0.007353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59474584 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59474584 ORDER BY `minOrder` ASC [ RunTime:0.005995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59474584 ORDER BY `unit` DESC [ RunTime:0.015392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59474584 LIMIT 2 [ RunTime:0.005066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59474584 ORDER BY `minOrder` ASC [ RunTime:0.007295s ]
select * from pdf where partno='TSW-110-08-S-S-LL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-110-08-S-S-LL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008612s ]
SELECT `id` FROM `stock` WHERE `id` <> 59474584 AND `partno` = 'TSW-110-08-S-S-LL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19818371 [ RunTime:0.010041s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017023s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028970s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021617s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015468s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029084s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010514s ]
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 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014727s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TSW-110-08-S-S%' OR `brand` LIKE 'TSW-110-08-S-S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020625s ]