SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001160s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021500s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591566 LIMIT 5 [ RunTime:0.015558s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591566 ORDER BY `minOrder` ASC [ RunTime:0.010061s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591566 ORDER BY `unit` DESC [ RunTime:0.009955s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591566 LIMIT 2 [ RunTime:0.007487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591566 ORDER BY `minOrder` ASC [ RunTime:0.012311s ]
select * from pdf where partno='9103-0-00-80-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.020680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208734 LIMIT 5 [ RunTime:0.017700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208734 ORDER BY `minOrder` ASC [ RunTime:0.006295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16208734 ORDER BY `unit` DESC [ RunTime:0.009008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16208734 LIMIT 2 [ RunTime:0.003264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208734 ORDER BY `minOrder` ASC [ RunTime:0.003168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852237 LIMIT 5 [ RunTime:0.017064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852237 ORDER BY `minOrder` ASC [ RunTime:0.004154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852237 ORDER BY `unit` DESC [ RunTime:0.009569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852237 LIMIT 2 [ RunTime:0.013688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852237 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909481 LIMIT 5 [ RunTime:0.006146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909481 ORDER BY `minOrder` ASC [ RunTime:0.010303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14909481 ORDER BY `unit` DESC [ RunTime:0.009634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14909481 LIMIT 2 [ RunTime:0.009499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14909481 ORDER BY `minOrder` ASC [ RunTime:0.010907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19806183 LIMIT 5 [ RunTime:0.013864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806183 ORDER BY `minOrder` ASC [ RunTime:0.029493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19806183 ORDER BY `unit` DESC [ RunTime:0.014905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19806183 LIMIT 2 [ RunTime:0.014209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806183 ORDER BY `minOrder` ASC [ RunTime:0.012306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19804429 LIMIT 5 [ RunTime:0.009583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19804429 ORDER BY `minOrder` ASC [ RunTime:0.009927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19804429 ORDER BY `unit` DESC [ RunTime:0.009002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19804429 LIMIT 2 [ RunTime:0.013553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19804429 ORDER BY `minOrder` ASC [ RunTime:0.004597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19797645 LIMIT 5 [ RunTime:0.015441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797645 ORDER BY `minOrder` ASC [ RunTime:0.035918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19797645 ORDER BY `unit` DESC [ RunTime:0.011693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19797645 LIMIT 2 [ RunTime:0.017341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797645 ORDER BY `minOrder` ASC [ RunTime:0.004503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19790804 LIMIT 5 [ RunTime:0.015690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19790804 ORDER BY `minOrder` ASC [ RunTime:0.009062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19790804 ORDER BY `unit` DESC [ RunTime:0.010717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19790804 LIMIT 2 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19790804 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19785676 LIMIT 5 [ RunTime:0.003936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19785676 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19785676 ORDER BY `unit` DESC [ RunTime:0.002924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19785676 LIMIT 2 [ RunTime:0.005919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19785676 ORDER BY `minOrder` ASC [ RunTime:0.007834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19781031 LIMIT 5 [ RunTime:0.005005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19781031 ORDER BY `minOrder` ASC [ RunTime:0.053498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19781031 ORDER BY `unit` DESC [ RunTime:0.034963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19781031 LIMIT 2 [ RunTime:0.023365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19781031 ORDER BY `minOrder` ASC [ RunTime:0.019212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300038 LIMIT 5 [ RunTime:0.020312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300038 ORDER BY `minOrder` ASC [ RunTime:0.033946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300038 ORDER BY `unit` DESC [ RunTime:0.048780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300038 LIMIT 2 [ RunTime:0.036417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300038 ORDER BY `minOrder` ASC [ RunTime:0.003422s ]
select * from pdf where partno='9103-0-00-15-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.016039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17056861 LIMIT 5 [ RunTime:0.017704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17056861 ORDER BY `minOrder` ASC [ RunTime:0.007737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17056861 ORDER BY `unit` DESC [ RunTime:0.005156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17056861 LIMIT 2 [ RunTime:0.019098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17056861 ORDER BY `minOrder` ASC [ RunTime:0.008726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16211105 LIMIT 5 [ RunTime:0.008686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211105 ORDER BY `minOrder` ASC [ RunTime:0.035751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16211105 ORDER BY `unit` DESC [ RunTime:0.024099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16211105 LIMIT 2 [ RunTime:0.028110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211105 ORDER BY `minOrder` ASC [ RunTime:0.015817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15488389 LIMIT 5 [ RunTime:0.013866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15488389 ORDER BY `minOrder` ASC [ RunTime:0.009394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15488389 ORDER BY `unit` DESC [ RunTime:0.002558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15488389 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15488389 ORDER BY `minOrder` ASC [ RunTime:0.010945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12751107 LIMIT 5 [ RunTime:0.002896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751107 ORDER BY `minOrder` ASC [ RunTime:0.007028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12751107 ORDER BY `unit` DESC [ RunTime:0.021809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12751107 LIMIT 2 [ RunTime:0.017973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751107 ORDER BY `minOrder` ASC [ RunTime:0.012503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748726 LIMIT 5 [ RunTime:0.016897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748726 ORDER BY `minOrder` ASC [ RunTime:0.006770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12748726 ORDER BY `unit` DESC [ RunTime:0.027327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12748726 LIMIT 2 [ RunTime:0.040611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748726 ORDER BY `minOrder` ASC [ RunTime:0.007016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740993 LIMIT 5 [ RunTime:0.020692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740993 ORDER BY `minOrder` ASC [ RunTime:0.023888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740993 ORDER BY `unit` DESC [ RunTime:0.007181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740993 LIMIT 2 [ RunTime:0.005565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740993 ORDER BY `minOrder` ASC [ RunTime:0.016253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739833 LIMIT 5 [ RunTime:0.013234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739833 ORDER BY `minOrder` ASC [ RunTime:0.016536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12739833 ORDER BY `unit` DESC [ RunTime:0.014895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12739833 LIMIT 2 [ RunTime:0.031061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739833 ORDER BY `minOrder` ASC [ RunTime:0.024193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12717773 LIMIT 5 [ RunTime:0.013681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12717773 ORDER BY `minOrder` ASC [ RunTime:0.002844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12717773 ORDER BY `unit` DESC [ RunTime:0.004709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12717773 LIMIT 2 [ RunTime:0.001231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12717773 ORDER BY `minOrder` ASC [ RunTime:0.015291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12241474 LIMIT 5 [ RunTime:0.014968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12241474 ORDER BY `minOrder` ASC [ RunTime:0.003750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12241474 ORDER BY `unit` DESC [ RunTime:0.006941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12241474 LIMIT 2 [ RunTime:0.050650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12241474 ORDER BY `minOrder` ASC [ RunTime:0.006652s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283052 LIMIT 5 [ RunTime:0.014012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283052 ORDER BY `minOrder` ASC [ RunTime:0.066042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283052 ORDER BY `unit` DESC [ RunTime:0.007421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283052 LIMIT 2 [ RunTime:0.049238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283052 ORDER BY `minOrder` ASC [ RunTime:0.044806s ]
select * from pdf where partno='9103' and brandshort='b&k precision' limit 1 [ RunTime:0.024981s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103' OR `brand` LIKE 'b&k precision%' ) ) LIMIT 1 [ RunTime:0.041170s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60310554 LIMIT 5 [ RunTime:0.013810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310554 ORDER BY `minOrder` ASC [ RunTime:0.071792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60310554 ORDER BY `unit` DESC [ RunTime:0.027826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60310554 LIMIT 2 [ RunTime:0.032007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310554 ORDER BY `minOrder` ASC [ RunTime:0.001254s ]
select * from pdf where partno='9103-0-00-80-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.004221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103-0-00-80-00-00-08-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.019093s ]
SELECT `id` FROM `stock` WHERE `id` <> 60310554 AND `partno` = '9103-0-00-80-00-00-08-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.008382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591566 [ RunTime:0.038431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59499817 LIMIT 5 [ RunTime:0.032452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59499817 ORDER BY `minOrder` ASC [ RunTime:0.028025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59499817 ORDER BY `unit` DESC [ RunTime:0.023504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59499817 LIMIT 2 [ RunTime:0.004995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59499817 ORDER BY `minOrder` ASC [ RunTime:0.002820s ]
select * from pdf where partno='91036-120LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.034486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-120LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.057946s ]
SELECT `id` FROM `stock` WHERE `id` <> 59499817 AND `partno` = '91036-120LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.110101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208734 [ RunTime:0.078146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523666 LIMIT 5 [ RunTime:0.046100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523666 ORDER BY `minOrder` ASC [ RunTime:0.033615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523666 ORDER BY `unit` DESC [ RunTime:0.006284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523666 LIMIT 2 [ RunTime:0.017434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523666 ORDER BY `minOrder` ASC [ RunTime:0.041067s ]
select * from pdf where partno='9103' and brandshort='B&K Precision' limit 1 [ RunTime:0.012070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103' OR `brand` LIKE 'B&K Precision%' ) ) LIMIT 1 [ RunTime:0.031419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59447564 LIMIT 5 [ RunTime:0.026470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447564 ORDER BY `minOrder` ASC [ RunTime:0.053526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59447564 ORDER BY `unit` DESC [ RunTime:0.058431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59447564 LIMIT 2 [ RunTime:0.007189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447564 ORDER BY `minOrder` ASC [ RunTime:0.011325s ]
select * from pdf where partno='91036-150CTLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.027037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-150CTLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.076898s ]
SELECT `id` FROM `stock` WHERE `id` <> 59447564 AND `partno` = '91036-150CTLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.075414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852237 [ RunTime:0.052734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63417197 LIMIT 5 [ RunTime:0.021771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63417197 ORDER BY `minOrder` ASC [ RunTime:0.019306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63417197 ORDER BY `unit` DESC [ RunTime:0.008269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63417197 LIMIT 2 [ RunTime:0.050710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63417197 ORDER BY `minOrder` ASC [ RunTime:0.015495s ]
select * from pdf where partno='9103' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.039622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.030270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63376162 LIMIT 5 [ RunTime:0.043101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376162 ORDER BY `minOrder` ASC [ RunTime:0.198192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63376162 ORDER BY `unit` DESC [ RunTime:0.051020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63376162 LIMIT 2 [ RunTime:0.083181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376162 ORDER BY `minOrder` ASC [ RunTime:0.113483s ]
select * from pdf where partno='9103' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.105281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.052986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63220672 LIMIT 5 [ RunTime:0.050968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63220672 ORDER BY `minOrder` ASC [ RunTime:0.093293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63220672 ORDER BY `unit` DESC [ RunTime:0.025884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63220672 LIMIT 2 [ RunTime:0.112875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63220672 ORDER BY `minOrder` ASC [ RunTime:0.001969s ]
select * from pdf where partno='9103. 12' and brandshort='Pepperl+Fuchs, Inc.' limit 1 [ RunTime:0.050049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103. 12' OR `brand` LIKE 'Pepperl+Fuchs, Inc.%' ) ) LIMIT 1 [ RunTime:0.051331s ]
SELECT `id` FROM `stock` WHERE `id` <> 63220672 AND `partno` = '9103. 12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pepperl+fuchs, inc.%' ) [ RunTime:0.100022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12241474 [ RunTime:0.095637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623796 LIMIT 5 [ RunTime:0.058362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623796 ORDER BY `minOrder` ASC [ RunTime:0.069977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623796 ORDER BY `unit` DESC [ RunTime:0.066817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623796 LIMIT 2 [ RunTime:0.016179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623796 ORDER BY `minOrder` ASC [ RunTime:0.024713s ]
select * from pdf where partno='9103.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.038473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.042078s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623796 AND `partno` = '9103.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.129450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60312505 LIMIT 5 [ RunTime:0.074898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60312505 ORDER BY `minOrder` ASC [ RunTime:0.052043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60312505 ORDER BY `unit` DESC [ RunTime:0.073141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60312505 LIMIT 2 [ RunTime:0.053864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60312505 ORDER BY `minOrder` ASC [ RunTime:0.031102s ]
select * from pdf where partno='9103-0-00-15-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.008818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9103-0-00-15-00-00-08-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.045887s ]
SELECT `id` FROM `stock` WHERE `id` <> 60312505 AND `partno` = '9103-0-00-15-00-00-08-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.021983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300038 [ RunTime:0.037736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59683897 LIMIT 5 [ RunTime:0.063200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59683897 ORDER BY `minOrder` ASC [ RunTime:0.047218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59683897 ORDER BY `unit` DESC [ RunTime:0.048984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59683897 LIMIT 2 [ RunTime:0.040770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59683897 ORDER BY `minOrder` ASC [ RunTime:0.031808s ]
select * from pdf where partno='91036-140' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.024166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-140' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.053869s ]
SELECT `id` FROM `stock` WHERE `id` <> 59683897 AND `partno` = '91036-140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.045784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11569191 [ RunTime:0.055176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59678174 LIMIT 5 [ RunTime:0.024596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59678174 ORDER BY `minOrder` ASC [ RunTime:0.014559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59678174 ORDER BY `unit` DESC [ RunTime:0.028579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59678174 LIMIT 2 [ RunTime:0.033513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59678174 ORDER BY `minOrder` ASC [ RunTime:0.022072s ]
select * from pdf where partno='91036-130LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.032903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-130LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.038581s ]
SELECT `id` FROM `stock` WHERE `id` <> 59678174 AND `partno` = '91036-130LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.063238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19797645 [ RunTime:0.062558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59655852 LIMIT 5 [ RunTime:0.074336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59655852 ORDER BY `minOrder` ASC [ RunTime:0.005326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59655852 ORDER BY `unit` DESC [ RunTime:0.014439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59655852 LIMIT 2 [ RunTime:0.029799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59655852 ORDER BY `minOrder` ASC [ RunTime:0.031038s ]
select * from pdf where partno='91036-120' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.018325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-120' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.028862s ]
SELECT `id` FROM `stock` WHERE `id` <> 59655852 AND `partno` = '91036-120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.021895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19790804 [ RunTime:0.043239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59649538 LIMIT 5 [ RunTime:0.039997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59649538 ORDER BY `minOrder` ASC [ RunTime:0.041089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59649538 ORDER BY `unit` DESC [ RunTime:0.005818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59649538 LIMIT 2 [ RunTime:0.017730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59649538 ORDER BY `minOrder` ASC [ RunTime:0.042233s ]
select * from pdf where partno='91036-115LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.036455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-115LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006005s ]
SELECT `id` FROM `stock` WHERE `id` <> 59649538 AND `partno` = '91036-115LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.010559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19785676 [ RunTime:0.042699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59644003 LIMIT 5 [ RunTime:0.035790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59644003 ORDER BY `minOrder` ASC [ RunTime:0.013742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59644003 ORDER BY `unit` DESC [ RunTime:0.012686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59644003 LIMIT 2 [ RunTime:0.020041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59644003 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
select * from pdf where partno='91036-115' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.022531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-115' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004735s ]
SELECT `id` FROM `stock` WHERE `id` <> 59644003 AND `partno` = '91036-115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19781031 [ RunTime:0.008271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59606677 LIMIT 5 [ RunTime:0.021259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606677 ORDER BY `minOrder` ASC [ RunTime:0.040129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59606677 ORDER BY `unit` DESC [ RunTime:0.030055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59606677 LIMIT 2 [ RunTime:0.006005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606677 ORDER BY `minOrder` ASC [ RunTime:0.010379s ]
select * from pdf where partno='91036-105LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.012376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-105LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.024176s ]
SELECT `id` FROM `stock` WHERE `id` <> 59606677 AND `partno` = '91036-105LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12717773 [ RunTime:0.005481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59486800 LIMIT 5 [ RunTime:0.018164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59486800 ORDER BY `minOrder` ASC [ RunTime:0.018854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59486800 ORDER BY `unit` DESC [ RunTime:0.012172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59486800 LIMIT 2 [ RunTime:0.021160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59486800 ORDER BY `minOrder` ASC [ RunTime:0.020006s ]
select * from pdf where partno='91036-110LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.023366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91036-110LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.012045s ]
SELECT `id` FROM `stock` WHERE `id` <> 59486800 AND `partno` = '91036-110LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15488389 [ RunTime:0.005481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540258 LIMIT 5 [ RunTime:0.017268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540258 ORDER BY `minOrder` ASC [ RunTime:0.008988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540258 ORDER BY `unit` DESC [ RunTime:0.037604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540258 LIMIT 2 [ RunTime:0.012665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540258 ORDER BY `minOrder` ASC [ RunTime:0.016490s ]
select * from pdf where partno='91039-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.004338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91039-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.004714s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540258 AND `partno` = '91039-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.003670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540204 LIMIT 5 [ RunTime:0.028826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540204 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540204 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540204 LIMIT 2 [ RunTime:0.009062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540204 ORDER BY `minOrder` ASC [ RunTime:0.002597s ]
select * from pdf where partno='91038-3' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.006478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91038-3' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.017776s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540204 AND `partno` = '91038-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.029799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540148 LIMIT 5 [ RunTime:0.008520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540148 ORDER BY `minOrder` ASC [ RunTime:0.021264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540148 ORDER BY `unit` DESC [ RunTime:0.003816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540148 LIMIT 2 [ RunTime:0.017907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540148 ORDER BY `minOrder` ASC [ RunTime:0.003143s ]
select * from pdf where partno='91039-3' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.007006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91039-3' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.009082s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540148 AND `partno` = '91039-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.016498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58539783 LIMIT 5 [ RunTime:0.015461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58539783 ORDER BY `minOrder` ASC [ RunTime:0.018271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58539783 ORDER BY `unit` DESC [ RunTime:0.008116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58539783 LIMIT 2 [ RunTime:0.009566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58539783 ORDER BY `minOrder` ASC [ RunTime:0.002946s ]
select * from pdf where partno='91035-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.014791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91035-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.013482s ]
SELECT `id` FROM `stock` WHERE `id` <> 58539783 AND `partno` = '91035-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.027581s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006690s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006379s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008007s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021239s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009442s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014872s ]
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 '9103%' OR `brand` LIKE '9103%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005674s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9103%' OR `brand` LIKE '9103%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013632s ]