SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002434s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015998s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16995115 LIMIT 5 [ RunTime:0.024749s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16995115 ORDER BY `minOrder` ASC [ RunTime:0.006828s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16995115 ORDER BY `unit` DESC [ RunTime:0.003617s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16995115 LIMIT 2 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16995115 ORDER BY `minOrder` ASC [ RunTime:0.008169s ]
select * from pdf where partno='10822F' and brandshort='Aven Tools' limit 1 [ RunTime:0.003241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509996 LIMIT 5 [ RunTime:0.002940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509996 ORDER BY `minOrder` ASC [ RunTime:0.022477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509996 ORDER BY `unit` DESC [ RunTime:0.002824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509996 LIMIT 2 [ RunTime:0.009520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509996 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511231 LIMIT 5 [ RunTime:0.023264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511231 ORDER BY `minOrder` ASC [ RunTime:0.003558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19511231 ORDER BY `unit` DESC [ RunTime:0.002524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19511231 LIMIT 2 [ RunTime:0.006147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511231 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='108226' and brandshort='Basler Inc.' limit 1 [ RunTime:0.005689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268428 LIMIT 5 [ RunTime:0.005578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15268428 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15268428 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15268428 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15268428 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15207776 LIMIT 5 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207776 ORDER BY `minOrder` ASC [ RunTime:0.002253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15207776 ORDER BY `unit` DESC [ RunTime:0.012666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15207776 LIMIT 2 [ RunTime:0.007207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15207776 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='10822S' and brandshort='Aven Tools' limit 1 [ RunTime:0.002082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199623 LIMIT 5 [ RunTime:0.004724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199623 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12199623 ORDER BY `unit` DESC [ RunTime:0.001163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12199623 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199623 ORDER BY `minOrder` ASC [ RunTime:0.002761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666686 LIMIT 5 [ RunTime:0.009184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666686 ORDER BY `minOrder` ASC [ RunTime:0.001877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666686 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666686 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666686 ORDER BY `minOrder` ASC [ RunTime:0.002377s ]
select * from pdf where partno='108229' and brandshort='Basler Inc.' limit 1 [ RunTime:0.007361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666488 LIMIT 5 [ RunTime:0.003500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666488 ORDER BY `minOrder` ASC [ RunTime:0.014867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666488 ORDER BY `unit` DESC [ RunTime:0.020704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666488 LIMIT 2 [ RunTime:0.007997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666488 ORDER BY `minOrder` ASC [ RunTime:0.003445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982828 LIMIT 5 [ RunTime:0.008584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982828 ORDER BY `minOrder` ASC [ RunTime:0.003327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982828 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982828 LIMIT 2 [ RunTime:0.003798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982828 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981899 LIMIT 5 [ RunTime:0.006002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981899 ORDER BY `minOrder` ASC [ RunTime:0.009549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981899 ORDER BY `unit` DESC [ RunTime:0.004091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981899 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981899 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981686 LIMIT 5 [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981686 ORDER BY `minOrder` ASC [ RunTime:0.004080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981686 ORDER BY `unit` DESC [ RunTime:0.005996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981686 LIMIT 2 [ RunTime:0.002922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981686 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981682 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981682 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981682 ORDER BY `unit` DESC [ RunTime:0.002122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981682 LIMIT 2 [ RunTime:0.004721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981682 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979903 LIMIT 5 [ RunTime:0.002825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979903 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979903 ORDER BY `unit` DESC [ RunTime:0.000798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979903 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979903 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974241 LIMIT 5 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974241 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974241 ORDER BY `unit` DESC [ RunTime:0.003731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974241 LIMIT 2 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974241 ORDER BY `minOrder` ASC [ RunTime:0.001572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779931 LIMIT 5 [ RunTime:0.003113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779931 ORDER BY `minOrder` ASC [ RunTime:0.006626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779931 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779931 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779931 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779833 LIMIT 5 [ RunTime:0.001256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779833 ORDER BY `minOrder` ASC [ RunTime:0.001578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779833 ORDER BY `unit` DESC [ RunTime:0.006512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779833 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779833 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779700 LIMIT 5 [ RunTime:0.008748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779700 ORDER BY `minOrder` ASC [ RunTime:0.005526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779700 ORDER BY `unit` DESC [ RunTime:0.000743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779700 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779700 ORDER BY `minOrder` ASC [ RunTime:0.009248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779643 LIMIT 5 [ RunTime:0.028720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779643 ORDER BY `minOrder` ASC [ RunTime:0.006298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779643 ORDER BY `unit` DESC [ RunTime:0.000688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779643 LIMIT 2 [ RunTime:0.002316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779643 ORDER BY `minOrder` ASC [ RunTime:0.005988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779576 LIMIT 5 [ RunTime:0.014183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779576 ORDER BY `minOrder` ASC [ RunTime:0.019775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779576 ORDER BY `unit` DESC [ RunTime:0.011011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779576 LIMIT 2 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779576 ORDER BY `minOrder` ASC [ RunTime:0.005998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779507 LIMIT 5 [ RunTime:0.008921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779507 ORDER BY `minOrder` ASC [ RunTime:0.006711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779507 ORDER BY `unit` DESC [ RunTime:0.008396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779507 LIMIT 2 [ RunTime:0.023884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779507 ORDER BY `minOrder` ASC [ RunTime:0.002277s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235661 LIMIT 5 [ RunTime:0.002645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235661 ORDER BY `minOrder` ASC [ RunTime:0.004274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235661 ORDER BY `unit` DESC [ RunTime:0.025336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235661 LIMIT 2 [ RunTime:0.009556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235661 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
select * from pdf where partno='108229' and brandshort='basler' limit 1 [ RunTime:0.000949s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108229' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.001278s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58556913 LIMIT 5 [ RunTime:0.004076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58556913 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58556913 ORDER BY `unit` DESC [ RunTime:0.002982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58556913 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58556913 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='10822F' and brandshort='Aven Tools' limit 1 [ RunTime:0.000776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10822F' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.000669s ]
SELECT `id` FROM `stock` WHERE `id` <> 58556913 AND `partno` = '10822F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.001868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16995115 [ RunTime:0.004727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58557144 LIMIT 5 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557144 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58557144 ORDER BY `unit` DESC [ RunTime:0.000953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58557144 LIMIT 2 [ RunTime:0.002715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557144 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
select * from pdf where partno='10822S' and brandshort='Aven Tools' limit 1 [ RunTime:0.001745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10822S' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.003038s ]
SELECT `id` FROM `stock` WHERE `id` <> 58557144 AND `partno` = '10822S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15207776 [ RunTime:0.002393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64115488 LIMIT 5 [ RunTime:0.001853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115488 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64115488 ORDER BY `unit` DESC [ RunTime:0.002546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64115488 LIMIT 2 [ RunTime:0.001546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115488 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
select * from pdf where partno='1082298' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082298' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000429s ]
SELECT `id` FROM `stock` WHERE `id` <> 64115488 AND `partno` = '1082298' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199623 [ RunTime:0.005168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806245 LIMIT 5 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806245 ORDER BY `minOrder` ASC [ RunTime:0.001019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806245 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806245 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806245 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
select * from pdf where partno='1082289' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082289' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004633s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806245 AND `partno` = '1082289' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981686 [ RunTime:0.000720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806243 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806243 ORDER BY `minOrder` ASC [ RunTime:0.003721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806243 ORDER BY `unit` DESC [ RunTime:0.011842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806243 LIMIT 2 [ RunTime:0.005603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806243 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='1082288' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082288' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001863s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806243 AND `partno` = '1082288' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981682 [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805994 LIMIT 5 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805994 ORDER BY `minOrder` ASC [ RunTime:0.003491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805994 ORDER BY `unit` DESC [ RunTime:0.004070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805994 LIMIT 2 [ RunTime:0.002645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805994 ORDER BY `minOrder` ASC [ RunTime:0.001134s ]
select * from pdf where partno='1082251' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082251' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004512s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805994 AND `partno` = '1082251' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223754 [ RunTime:0.005013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805952 LIMIT 5 [ RunTime:0.003634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805952 ORDER BY `minOrder` ASC [ RunTime:0.003831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805952 ORDER BY `unit` DESC [ RunTime:0.011658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805952 LIMIT 2 [ RunTime:0.003127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805952 ORDER BY `minOrder` ASC [ RunTime:0.003257s ]
select * from pdf where partno='1082290' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082290' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002178s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805952 AND `partno` = '1082290' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774184 [ RunTime:0.011185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803845 LIMIT 5 [ RunTime:0.003508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803845 ORDER BY `minOrder` ASC [ RunTime:0.002504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803845 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803845 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803845 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='1082252' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082252' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000759s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803845 AND `partno` = '1082252' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223520 [ RunTime:0.007804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802646 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802646 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802646 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802646 LIMIT 2 [ RunTime:0.003207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802646 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='1082235' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082235' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000503s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802646 AND `partno` = '1082235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772239 [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802263 LIMIT 5 [ RunTime:0.003271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802263 ORDER BY `minOrder` ASC [ RunTime:0.003816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802263 ORDER BY `unit` DESC [ RunTime:0.007931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802263 LIMIT 2 [ RunTime:0.000971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802263 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='1082297' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082297' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002632s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802263 AND `partno` = '1082297' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772029 [ RunTime:0.001055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801785 LIMIT 5 [ RunTime:0.002134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801785 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801785 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801785 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801785 ORDER BY `minOrder` ASC [ RunTime:0.002412s ]
select * from pdf where partno='1082229' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082229' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000424s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801785 AND `partno` = '1082229' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771696 [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64639889 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64639889 ORDER BY `minOrder` ASC [ RunTime:0.006104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64639889 ORDER BY `unit` DESC [ RunTime:0.003287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64639889 LIMIT 2 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64639889 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='1082264' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082264' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002146s ]
SELECT `id` FROM `stock` WHERE `id` <> 64639889 AND `partno` = '1082264' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011142 [ RunTime:0.002510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64567549 LIMIT 5 [ RunTime:0.011761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64567549 ORDER BY `minOrder` ASC [ RunTime:0.015136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64567549 ORDER BY `unit` DESC [ RunTime:0.006803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64567549 LIMIT 2 [ RunTime:0.001922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64567549 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='108221' and brandshort='Basler Inc.' limit 1 [ RunTime:0.001709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108221' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.001797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64115952 LIMIT 5 [ RunTime:0.003302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115952 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64115952 ORDER BY `unit` DESC [ RunTime:0.013155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64115952 LIMIT 2 [ RunTime:0.007937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64115952 ORDER BY `minOrder` ASC [ RunTime:0.014629s ]
select * from pdf where partno='1082299' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082299' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037054s ]
SELECT `id` FROM `stock` WHERE `id` <> 64115952 AND `partno` = '1082299' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199140 [ RunTime:0.020428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63452192 LIMIT 5 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63452192 ORDER BY `minOrder` ASC [ RunTime:0.011362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63452192 ORDER BY `unit` DESC [ RunTime:0.004585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63452192 LIMIT 2 [ RunTime:0.012434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63452192 ORDER BY `minOrder` ASC [ RunTime:0.008775s ]
select * from pdf where partno='1082299' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082299' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381308 LIMIT 5 [ RunTime:0.003153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381308 ORDER BY `minOrder` ASC [ RunTime:0.005972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381308 ORDER BY `unit` DESC [ RunTime:0.006561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381308 LIMIT 2 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381308 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='10822F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10822F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.003721s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381308 AND `partno` = '10822F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.012335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380565 LIMIT 5 [ RunTime:0.004959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380565 ORDER BY `minOrder` ASC [ RunTime:0.002154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380565 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380565 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380565 ORDER BY `minOrder` ASC [ RunTime:0.005673s ]
select * from pdf where partno='10822' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.010858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10822' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004003s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380565 AND `partno` = '10822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347225 LIMIT 5 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347225 ORDER BY `minOrder` ASC [ RunTime:0.001232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347225 ORDER BY `unit` DESC [ RunTime:0.004560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347225 LIMIT 2 [ RunTime:0.005281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347225 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='1082239' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082239' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001230s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347225 AND `partno` = '1082239' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011735 [ RunTime:0.003292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63344936 LIMIT 5 [ RunTime:0.006841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344936 ORDER BY `minOrder` ASC [ RunTime:0.010337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63344936 ORDER BY `unit` DESC [ RunTime:0.000858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63344936 LIMIT 2 [ RunTime:0.001857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344936 ORDER BY `minOrder` ASC [ RunTime:0.008002s ]
select * from pdf where partno='1082241' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082241' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001690s ]
SELECT `id` FROM `stock` WHERE `id` <> 63344936 AND `partno` = '1082241' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779931 [ RunTime:0.002633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63344828 LIMIT 5 [ RunTime:0.003416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344828 ORDER BY `minOrder` ASC [ RunTime:0.006717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63344828 ORDER BY `unit` DESC [ RunTime:0.001329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63344828 LIMIT 2 [ RunTime:0.009777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344828 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='1082243' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1082243' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013311s ]
SELECT `id` FROM `stock` WHERE `id` <> 63344828 AND `partno` = '1082243' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779833 [ RunTime:0.000827s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001210s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009189s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003503s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001808s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008042s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001920s ]
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 '10822%' OR `brand` LIKE '10822%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000929s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10822%' OR `brand` LIKE '10822%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001442s ]