SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002585s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032180s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4604 LIMIT 5 [ RunTime:0.072678s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4604 ORDER BY `minOrder` ASC [ RunTime:0.025965s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4604 ORDER BY `unit` DESC [ RunTime:0.021684s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4604 LIMIT 2 [ RunTime:0.020902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4604 ORDER BY `minOrder` ASC [ RunTime:0.017797s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681465P' OR `brand` LIKE 'CLIFF ELECTRONIC COMPONENTS%' ) ) LIMIT 1 [ RunTime:0.016017s ]
SELECT `id` FROM `stock` WHERE `id` <> 4604 AND `partno` = 'FC681465P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components%' ) [ RunTime:0.024520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077221 [ RunTime:0.067683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077016 LIMIT 5 [ RunTime:0.026071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077016 ORDER BY `minOrder` ASC [ RunTime:0.020575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077016 ORDER BY `unit` DESC [ RunTime:0.043404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077016 LIMIT 2 [ RunTime:0.018371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077016 ORDER BY `minOrder` ASC [ RunTime:0.008210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15547919 LIMIT 5 [ RunTime:0.013026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15547919 ORDER BY `minOrder` ASC [ RunTime:0.019686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15547919 ORDER BY `unit` DESC [ RunTime:0.025673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15547919 LIMIT 2 [ RunTime:0.004105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15547919 ORDER BY `minOrder` ASC [ RunTime:0.023570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077060 LIMIT 5 [ RunTime:0.015157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077060 ORDER BY `minOrder` ASC [ RunTime:0.046633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077060 ORDER BY `unit` DESC [ RunTime:0.028779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077060 LIMIT 2 [ RunTime:0.012918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077060 ORDER BY `minOrder` ASC [ RunTime:0.007930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077075 LIMIT 5 [ RunTime:0.029792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077075 ORDER BY `minOrder` ASC [ RunTime:0.007315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077075 ORDER BY `unit` DESC [ RunTime:0.026293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077075 LIMIT 2 [ RunTime:0.006113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077075 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4840 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4840 ORDER BY `minOrder` ASC [ RunTime:0.001133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4840 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4840 LIMIT 2 [ RunTime:0.012866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4840 ORDER BY `minOrder` ASC [ RunTime:0.002845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC68149S' OR `brand` LIKE 'CLIFF ELECTRONIC COMPONENTS%' ) ) LIMIT 1 [ RunTime:0.005592s ]
SELECT `id` FROM `stock` WHERE `id` <> 4840 AND `partno` = 'FC68149S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components%' ) [ RunTime:0.005678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077191 LIMIT 5 [ RunTime:0.016452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077191 ORDER BY `minOrder` ASC [ RunTime:0.003691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077191 ORDER BY `unit` DESC [ RunTime:0.003617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077191 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077191 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356989 LIMIT 5 [ RunTime:0.019835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356989 ORDER BY `minOrder` ASC [ RunTime:0.019901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16356989 ORDER BY `unit` DESC [ RunTime:0.022536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16356989 LIMIT 2 [ RunTime:0.013387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356989 ORDER BY `minOrder` ASC [ RunTime:0.005657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658082 LIMIT 5 [ RunTime:0.009387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13658082 ORDER BY `minOrder` ASC [ RunTime:0.030110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13658082 ORDER BY `unit` DESC [ RunTime:0.015316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13658082 LIMIT 2 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13658082 ORDER BY `minOrder` ASC [ RunTime:0.005269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077238 LIMIT 5 [ RunTime:0.002667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077238 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077238 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077238 LIMIT 2 [ RunTime:0.031870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077238 ORDER BY `minOrder` ASC [ RunTime:0.012175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356918 LIMIT 5 [ RunTime:0.013089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356918 ORDER BY `minOrder` ASC [ RunTime:0.007145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16356918 ORDER BY `unit` DESC [ RunTime:0.009384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16356918 LIMIT 2 [ RunTime:0.008876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356918 ORDER BY `minOrder` ASC [ RunTime:0.010552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077190 LIMIT 5 [ RunTime:0.001319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077190 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077190 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077190 LIMIT 2 [ RunTime:0.007768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077190 ORDER BY `minOrder` ASC [ RunTime:0.017784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356992 LIMIT 5 [ RunTime:0.003684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356992 ORDER BY `minOrder` ASC [ RunTime:0.010233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16356992 ORDER BY `unit` DESC [ RunTime:0.020222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16356992 LIMIT 2 [ RunTime:0.002893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356992 ORDER BY `minOrder` ASC [ RunTime:0.012573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356987 LIMIT 5 [ RunTime:0.019049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356987 ORDER BY `minOrder` ASC [ RunTime:0.009235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16356987 ORDER BY `unit` DESC [ RunTime:0.010840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16356987 LIMIT 2 [ RunTime:0.004755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16356987 ORDER BY `minOrder` ASC [ RunTime:0.004282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371232 LIMIT 5 [ RunTime:0.025311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371232 ORDER BY `minOrder` ASC [ RunTime:0.011343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371232 ORDER BY `unit` DESC [ RunTime:0.008791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371232 LIMIT 2 [ RunTime:0.008098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371232 ORDER BY `minOrder` ASC [ RunTime:0.008008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4605 LIMIT 5 [ RunTime:0.007327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4605 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4605 ORDER BY `unit` DESC [ RunTime:0.001709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4605 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4605 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681465' OR `brand` LIKE 'CLIFF ELECTRONIC COMPONENTS%' ) ) LIMIT 1 [ RunTime:0.010853s ]
SELECT `id` FROM `stock` WHERE `id` <> 4605 AND `partno` = 'FC681465' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components%' ) [ RunTime:0.011333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077054 [ RunTime:0.012386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077054 LIMIT 5 [ RunTime:0.002554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077054 ORDER BY `minOrder` ASC [ RunTime:0.008001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077054 ORDER BY `unit` DESC [ RunTime:0.001627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077054 LIMIT 2 [ RunTime:0.002883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077054 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077188 LIMIT 5 [ RunTime:0.005463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077188 ORDER BY `minOrder` ASC [ RunTime:0.006107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077188 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077188 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077188 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11675543 LIMIT 5 [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11675543 ORDER BY `minOrder` ASC [ RunTime:0.006845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11675543 ORDER BY `unit` DESC [ RunTime:0.000252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11675543 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11675543 ORDER BY `minOrder` ASC [ RunTime:0.004362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077253 LIMIT 5 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077253 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077253 ORDER BY `unit` DESC [ RunTime:0.000317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077253 LIMIT 2 [ RunTime:0.001656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077253 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000888s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009326 LIMIT 5 [ RunTime:0.002065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009326 ORDER BY `minOrder` ASC [ RunTime:0.006379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009326 ORDER BY `unit` DESC [ RunTime:0.001130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009326 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009326 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='FC68148' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC68148' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.005577s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009326 AND `partno` = 'FC68148' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.002119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077016 [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009630 LIMIT 5 [ RunTime:0.004262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009630 ORDER BY `minOrder` ASC [ RunTime:0.000884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009630 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009630 LIMIT 2 [ RunTime:0.002680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009630 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='FC681445' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.003403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681445' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.014733s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009630 AND `partno` = 'FC681445' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.018228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077061 [ RunTime:0.000845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009590 LIMIT 5 [ RunTime:0.021723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009590 ORDER BY `minOrder` ASC [ RunTime:0.009006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009590 ORDER BY `unit` DESC [ RunTime:0.000819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009590 LIMIT 2 [ RunTime:0.001271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009590 ORDER BY `minOrder` ASC [ RunTime:0.002878s ]
select * from pdf where partno='FC681478' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.002361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681478' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.005759s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009590 AND `partno` = 'FC681478' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.003392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371231 [ RunTime:0.003530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009643 LIMIT 5 [ RunTime:0.002241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009643 ORDER BY `minOrder` ASC [ RunTime:0.004317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009643 ORDER BY `unit` DESC [ RunTime:0.002668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009643 LIMIT 2 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009643 ORDER BY `minOrder` ASC [ RunTime:0.013470s ]
select * from pdf where partno='FC6814775' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.000961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC6814775' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.001224s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009643 AND `partno` = 'FC6814775' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077075 [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009548 LIMIT 5 [ RunTime:0.010012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009548 ORDER BY `minOrder` ASC [ RunTime:0.008877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009548 ORDER BY `unit` DESC [ RunTime:0.009168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009548 LIMIT 2 [ RunTime:0.008963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009548 ORDER BY `minOrder` ASC [ RunTime:0.003138s ]
select * from pdf where partno='FC681467' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.002034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681467' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.006096s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009548 AND `partno` = 'FC681467' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.009640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077041 [ RunTime:0.013167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009627 LIMIT 5 [ RunTime:0.005252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009627 ORDER BY `minOrder` ASC [ RunTime:0.012292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009627 ORDER BY `unit` DESC [ RunTime:0.006110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009627 LIMIT 2 [ RunTime:0.010642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009627 ORDER BY `minOrder` ASC [ RunTime:0.004602s ]
select * from pdf where partno='FC681446' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681446' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.001950s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009627 AND `partno` = 'FC681446' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.010736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077060 [ RunTime:0.009087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009642 LIMIT 5 [ RunTime:0.006646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009642 ORDER BY `minOrder` ASC [ RunTime:0.002826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009642 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009642 LIMIT 2 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009642 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
select * from pdf where partno='FC6814785' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.007975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC6814785' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.003178s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009642 AND `partno` = 'FC6814785' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.007921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15547919 [ RunTime:0.011189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009543 LIMIT 5 [ RunTime:0.002747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009543 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009543 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009543 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009543 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='FC68148S' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC68148S' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.000683s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009543 AND `partno` = 'FC68148S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.006356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356918 [ RunTime:0.000575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009607 LIMIT 5 [ RunTime:0.001202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009607 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009607 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009607 LIMIT 2 [ RunTime:0.003579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009607 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='FC681473' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681473' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.002582s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009607 AND `partno` = 'FC681473' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.003704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16356989 [ RunTime:0.000811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009535 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009535 ORDER BY `minOrder` ASC [ RunTime:0.001520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009535 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009535 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009535 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='FC68149' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC68149' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.005626s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009535 AND `partno` = 'FC68149' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.002635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077023 [ RunTime:0.003391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009602 LIMIT 5 [ RunTime:0.004015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009602 ORDER BY `minOrder` ASC [ RunTime:0.004694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009602 ORDER BY `unit` DESC [ RunTime:0.002981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009602 LIMIT 2 [ RunTime:0.012985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009602 ORDER BY `minOrder` ASC [ RunTime:0.003770s ]
select * from pdf where partno='FC681465P' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.005180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681465P' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.004174s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009602 AND `partno` = 'FC681465P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.009457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077221 [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61007294 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61007294 ORDER BY `minOrder` ASC [ RunTime:0.007234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61007294 ORDER BY `unit` DESC [ RunTime:0.000214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61007294 LIMIT 2 [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61007294 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
select * from pdf where partno='FC6814' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.000404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC6814' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.000238s ]
SELECT `id` FROM `stock` WHERE `id` <> 61007294 AND `partno` = 'FC6814' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.000246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11675543 [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009547 LIMIT 5 [ RunTime:0.008166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009547 ORDER BY `minOrder` ASC [ RunTime:0.002798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009547 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009547 LIMIT 2 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009547 ORDER BY `minOrder` ASC [ RunTime:0.001042s ]
select * from pdf where partno='FC681492' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681492' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.009785s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009547 AND `partno` = 'FC681492' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.002134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009532 LIMIT 5 [ RunTime:0.001644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009532 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009532 ORDER BY `unit` DESC [ RunTime:0.002332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009532 LIMIT 2 [ RunTime:0.005281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009532 ORDER BY `minOrder` ASC [ RunTime:0.004343s ]
select * from pdf where partno='FC6814671' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.004561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC6814671' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.003743s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009532 AND `partno` = 'FC6814671' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077238 [ RunTime:0.000630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60374965 LIMIT 5 [ RunTime:0.004228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374965 ORDER BY `minOrder` ASC [ RunTime:0.007305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60374965 ORDER BY `unit` DESC [ RunTime:0.003675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60374965 LIMIT 2 [ RunTime:0.003797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374965 ORDER BY `minOrder` ASC [ RunTime:0.002811s ]
select * from pdf where partno='FC681473NUT' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.002193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681473NUT' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.002739s ]
SELECT `id` FROM `stock` WHERE `id` <> 60374965 AND `partno` = 'FC681473NUT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.001582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009815 LIMIT 5 [ RunTime:0.001107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009815 ORDER BY `minOrder` ASC [ RunTime:0.001256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009815 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009815 LIMIT 2 [ RunTime:0.002811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009815 ORDER BY `minOrder` ASC [ RunTime:0.002846s ]
select * from pdf where partno='FC68145' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.000996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC68145' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.003914s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009815 AND `partno` = 'FC68145' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077253 [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009566 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009566 ORDER BY `minOrder` ASC [ RunTime:0.003380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009566 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009566 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009566 ORDER BY `minOrder` ASC [ RunTime:0.002345s ]
select * from pdf where partno='FC68146' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC68146' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.007389s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009566 AND `partno` = 'FC68146' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.017668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077188 [ RunTime:0.006217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009613 LIMIT 5 [ RunTime:0.001362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009613 ORDER BY `minOrder` ASC [ RunTime:0.007852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009613 ORDER BY `unit` DESC [ RunTime:0.001990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009613 LIMIT 2 [ RunTime:0.001094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009613 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='FC681465S' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681465S' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.030873s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009613 AND `partno` = 'FC681465S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.022307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371232 [ RunTime:0.015496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61009593 LIMIT 5 [ RunTime:0.019229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009593 ORDER BY `minOrder` ASC [ RunTime:0.002381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61009593 ORDER BY `unit` DESC [ RunTime:0.003103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61009593 LIMIT 2 [ RunTime:0.015468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61009593 ORDER BY `minOrder` ASC [ RunTime:0.022968s ]
select * from pdf where partno='FC681465' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.015096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC681465' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.003232s ]
SELECT `id` FROM `stock` WHERE `id` <> 61009593 AND `partno` = 'FC681465' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.007055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077054 [ RunTime:0.001595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62985540 LIMIT 5 [ RunTime:0.002541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62985540 ORDER BY `minOrder` ASC [ RunTime:0.005185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62985540 ORDER BY `unit` DESC [ RunTime:0.004950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62985540 LIMIT 2 [ RunTime:0.005232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62985540 ORDER BY `minOrder` ASC [ RunTime:0.002467s ]
select * from pdf where partno='FC6814751' and brandshort='CLIFF Electronic Components Ltd' limit 1 [ RunTime:0.001633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC6814751' OR `brand` LIKE 'CLIFF Electronic Components Ltd%' ) ) LIMIT 1 [ RunTime:0.000862s ]
SELECT `id` FROM `stock` WHERE `id` <> 62985540 AND `partno` = 'FC6814751' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cliff electronic components ltd%' ) [ RunTime:0.004688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14526806 [ RunTime:0.002968s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005508s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003232s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001424s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002035s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002849s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011503s ]
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 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001579s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FC6814%' OR `brand` LIKE 'FC6814%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001412s ]