SHOW FULL COLUMNS FROM `stock` [ RunTime:0.012764s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.095309s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20075545 LIMIT 5 [ RunTime:0.093867s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20075545 ORDER BY `minOrder` ASC [ RunTime:0.058374s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20075545 ORDER BY `unit` DESC [ RunTime:0.095905s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.045257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20075545 LIMIT 2 [ RunTime:0.045673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20075545 ORDER BY `minOrder` ASC [ RunTime:0.013653s ]
select * from pdf where partno='RJHSE538R08' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.067375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072880 LIMIT 5 [ RunTime:0.056927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072880 ORDER BY `minOrder` ASC [ RunTime:0.081820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072880 ORDER BY `unit` DESC [ RunTime:0.115276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072880 LIMIT 2 [ RunTime:0.213788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072880 ORDER BY `minOrder` ASC [ RunTime:0.006581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072836 LIMIT 5 [ RunTime:0.062612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072836 ORDER BY `minOrder` ASC [ RunTime:0.101315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072836 ORDER BY `unit` DESC [ RunTime:0.050707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072836 LIMIT 2 [ RunTime:0.116142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072836 ORDER BY `minOrder` ASC [ RunTime:0.021597s ]
select * from pdf where partno='RJHSE538RA1' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.038851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370505 LIMIT 5 [ RunTime:0.106568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370505 ORDER BY `minOrder` ASC [ RunTime:0.094032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17370505 ORDER BY `unit` DESC [ RunTime:0.056931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17370505 LIMIT 2 [ RunTime:0.110394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370505 ORDER BY `minOrder` ASC [ RunTime:0.074569s ]
select * from pdf where partno='RJHSE538R04' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.072551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354808 LIMIT 5 [ RunTime:0.092777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354808 ORDER BY `minOrder` ASC [ RunTime:0.047114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354808 ORDER BY `unit` DESC [ RunTime:0.047394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354808 LIMIT 2 [ RunTime:0.091752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354808 ORDER BY `minOrder` ASC [ RunTime:0.048337s ]
select * from pdf where partno='RJHSE538R' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.043933s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076841s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60425105 LIMIT 5 [ RunTime:0.080798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60425105 ORDER BY `minOrder` ASC [ RunTime:0.121800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60425105 ORDER BY `unit` DESC [ RunTime:0.053586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60425105 LIMIT 2 [ RunTime:0.050796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60425105 ORDER BY `minOrder` ASC [ RunTime:0.035883s ]
select * from pdf where partno='RJHSE538R08' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.013992s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.006289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538R08' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.079834s ]
SELECT `id` FROM `stock` WHERE `id` <> 60425105 AND `partno` = 'RJHSE538R08' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.121792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20075545 [ RunTime:0.052927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60423885 LIMIT 5 [ RunTime:0.062325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423885 ORDER BY `minOrder` ASC [ RunTime:0.069880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60423885 ORDER BY `unit` DESC [ RunTime:0.080262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60423885 LIMIT 2 [ RunTime:0.121986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423885 ORDER BY `minOrder` ASC [ RunTime:0.107173s ]
select * from pdf where partno='RJHSE538R04' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.019479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538R04' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.046684s ]
SELECT `id` FROM `stock` WHERE `id` <> 60423885 AND `partno` = 'RJHSE538R04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.062553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370505 [ RunTime:0.092430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421539 LIMIT 5 [ RunTime:0.077802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421539 ORDER BY `minOrder` ASC [ RunTime:0.114231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421539 ORDER BY `unit` DESC [ RunTime:0.040071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421539 LIMIT 2 [ RunTime:0.087232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421539 ORDER BY `minOrder` ASC [ RunTime:0.042231s ]
select * from pdf where partno='RJHSE538RH1' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.057852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538RH1' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.078273s ]
SELECT `id` FROM `stock` WHERE `id` <> 60421539 AND `partno` = 'RJHSE538RH1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.113902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072880 [ RunTime:0.051538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421464 LIMIT 5 [ RunTime:0.097694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421464 ORDER BY `minOrder` ASC [ RunTime:0.079728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421464 ORDER BY `unit` DESC [ RunTime:0.075993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421464 LIMIT 2 [ RunTime:0.029104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421464 ORDER BY `minOrder` ASC [ RunTime:0.017371s ]
select * from pdf where partno='RJHSE538RA1' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.019263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538RA1' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.030287s ]
SELECT `id` FROM `stock` WHERE `id` <> 60421464 AND `partno` = 'RJHSE538RA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.049006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072836 [ RunTime:0.035272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421463 LIMIT 5 [ RunTime:0.025083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421463 ORDER BY `minOrder` ASC [ RunTime:0.027630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421463 ORDER BY `unit` DESC [ RunTime:0.016794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421463 LIMIT 2 [ RunTime:0.051397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421463 ORDER BY `minOrder` ASC [ RunTime:0.038424s ]
select * from pdf where partno='RJHSE538R' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.016034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538R' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.010466s ]
SELECT `id` FROM `stock` WHERE `id` <> 60421463 AND `partno` = 'RJHSE538R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.009926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354808 [ RunTime:0.014851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53605131 LIMIT 5 [ RunTime:0.070994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53605131 ORDER BY `minOrder` ASC [ RunTime:0.055262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53605131 ORDER BY `unit` DESC [ RunTime:0.051656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53605131 LIMIT 2 [ RunTime:0.114473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53605131 ORDER BY `minOrder` ASC [ RunTime:0.004240s ]
select * from pdf where partno='RJHSE538RA8' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.085113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538RA8' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.043140s ]
SELECT `id` FROM `stock` WHERE `id` <> 53605131 AND `partno` = 'RJHSE538RA8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.047359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53603730 LIMIT 5 [ RunTime:0.085644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603730 ORDER BY `minOrder` ASC [ RunTime:0.119605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53603730 ORDER BY `unit` DESC [ RunTime:0.173382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53603730 LIMIT 2 [ RunTime:0.110040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603730 ORDER BY `minOrder` ASC [ RunTime:0.115949s ]
select * from pdf where partno='RJHSE538RA4' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.149753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538RA4' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.050940s ]
SELECT `id` FROM `stock` WHERE `id` <> 53603730 AND `partno` = 'RJHSE538RA4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.050881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53603019 LIMIT 5 [ RunTime:0.035745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603019 ORDER BY `minOrder` ASC [ RunTime:0.092015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53603019 ORDER BY `unit` DESC [ RunTime:0.113684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53603019 LIMIT 2 [ RunTime:0.117300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603019 ORDER BY `minOrder` ASC [ RunTime:0.052685s ]
select * from pdf where partno='RJHSE538RA2' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.050777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538RA2' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.142072s ]
SELECT `id` FROM `stock` WHERE `id` <> 53603019 AND `partno` = 'RJHSE538RA2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.098609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53603018 LIMIT 5 [ RunTime:0.051175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603018 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53603018 ORDER BY `unit` DESC [ RunTime:0.011723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53603018 LIMIT 2 [ RunTime:0.033468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603018 ORDER BY `minOrder` ASC [ RunTime:0.016158s ]
select * from pdf where partno='RJHSE538R02' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.031816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538R02' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.018004s ]
SELECT `id` FROM `stock` WHERE `id` <> 53603018 AND `partno` = 'RJHSE538R02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.099163s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.113910s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.157659s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.246756s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051658s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052978s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090697s ]
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 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077778s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RJHSE538R%' OR `brand` LIKE 'RJHSE538R%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.074680s ]