SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001468s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012253s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12064230 LIMIT 5 [ RunTime:0.022957s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064230 ORDER BY `minOrder` ASC [ RunTime:0.008127s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12064230 ORDER BY `unit` DESC [ RunTime:0.022477s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12064230 LIMIT 2 [ RunTime:0.011578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064230 ORDER BY `minOrder` ASC [ RunTime:0.005457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13435302 LIMIT 5 [ RunTime:0.010997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13435302 ORDER BY `minOrder` ASC [ RunTime:0.017590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13435302 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13435302 LIMIT 2 [ RunTime:0.015803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13435302 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511298 LIMIT 5 [ RunTime:0.005622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511298 ORDER BY `minOrder` ASC [ RunTime:0.031827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19511298 ORDER BY `unit` DESC [ RunTime:0.003975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19511298 LIMIT 2 [ RunTime:0.008680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511298 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727587 LIMIT 5 [ RunTime:0.004961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727587 ORDER BY `minOrder` ASC [ RunTime:0.005790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18727587 ORDER BY `unit` DESC [ RunTime:0.027760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18727587 LIMIT 2 [ RunTime:0.011777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18727587 ORDER BY `minOrder` ASC [ RunTime:0.003630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720663 LIMIT 5 [ RunTime:0.004797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720663 ORDER BY `minOrder` ASC [ RunTime:0.015365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720663 ORDER BY `unit` DESC [ RunTime:0.010987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720663 LIMIT 2 [ RunTime:0.004421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720663 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584498 LIMIT 5 [ RunTime:0.001881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584498 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584498 ORDER BY `unit` DESC [ RunTime:0.002401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584498 LIMIT 2 [ RunTime:0.001933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584498 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18726916 LIMIT 5 [ RunTime:0.002758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18726916 ORDER BY `minOrder` ASC [ RunTime:0.005349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18726916 ORDER BY `unit` DESC [ RunTime:0.001728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18726916 LIMIT 2 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18726916 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18723831 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18723831 ORDER BY `minOrder` ASC [ RunTime:0.008065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18723831 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18723831 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18723831 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18721478 LIMIT 5 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18721478 ORDER BY `minOrder` ASC [ RunTime:0.003039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18721478 ORDER BY `unit` DESC [ RunTime:0.002783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18721478 LIMIT 2 [ RunTime:0.002451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18721478 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16998955 LIMIT 5 [ RunTime:0.001059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16998955 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16998955 ORDER BY `unit` DESC [ RunTime:0.003879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16998955 LIMIT 2 [ RunTime:0.009883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16998955 ORDER BY `minOrder` ASC [ RunTime:0.005198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750543 LIMIT 5 [ RunTime:0.006514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750543 ORDER BY `minOrder` ASC [ RunTime:0.003719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750543 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750543 LIMIT 2 [ RunTime:0.008654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750543 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857441 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857441 ORDER BY `minOrder` ASC [ RunTime:0.004222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857441 ORDER BY `unit` DESC [ RunTime:0.001891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857441 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857441 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857324 LIMIT 5 [ RunTime:0.002803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857324 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857324 ORDER BY `unit` DESC [ RunTime:0.002356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857324 LIMIT 2 [ RunTime:0.002104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857324 ORDER BY `minOrder` ASC [ RunTime:0.004247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13856758 LIMIT 5 [ RunTime:0.003599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856758 ORDER BY `minOrder` ASC [ RunTime:0.003121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13856758 ORDER BY `unit` DESC [ RunTime:0.004346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13856758 LIMIT 2 [ RunTime:0.001530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856758 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13453573 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13453573 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13453573 ORDER BY `unit` DESC [ RunTime:0.001216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13453573 LIMIT 2 [ RunTime:0.001740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13453573 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13300155 LIMIT 5 [ RunTime:0.001643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13300155 ORDER BY `minOrder` ASC [ RunTime:0.004014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13300155 ORDER BY `unit` DESC [ RunTime:0.002901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13300155 LIMIT 2 [ RunTime:0.002684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13300155 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448548 LIMIT 5 [ RunTime:0.001762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448548 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12448548 ORDER BY `unit` DESC [ RunTime:0.001095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12448548 LIMIT 2 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448548 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448520 LIMIT 5 [ RunTime:0.001629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448520 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12448520 ORDER BY `unit` DESC [ RunTime:0.001061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12448520 LIMIT 2 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448520 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448458 LIMIT 5 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448458 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12448458 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12448458 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448458 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447878 LIMIT 5 [ RunTime:0.002026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447878 ORDER BY `minOrder` ASC [ RunTime:0.002302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447878 ORDER BY `unit` DESC [ RunTime:0.000361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447878 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447878 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
select * from pdf where partno='5256CDB' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001656s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32293223 LIMIT 5 [ RunTime:0.002650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32293223 ORDER BY `minOrder` ASC [ RunTime:0.005120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32293223 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32293223 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32293223 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='5256-rc' and brandshort='bourns' limit 1 [ RunTime:0.000516s ]
select foldpath,foldpath2,filename from pdf_file where id=1131776 limit 1 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256-rc' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.000420s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461293 LIMIT 5 [ RunTime:0.005265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461293 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461293 ORDER BY `unit` DESC [ RunTime:0.000294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461293 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461293 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
select * from pdf where partno='5256-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000269s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461293 AND `partno` = '5256-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13435302 [ RunTime:0.000736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57754142 LIMIT 5 [ RunTime:0.001589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57754142 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57754142 ORDER BY `unit` DESC [ RunTime:0.002556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57754142 LIMIT 2 [ RunTime:0.002616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57754142 ORDER BY `minOrder` ASC [ RunTime:0.001504s ]
select * from pdf where partno='5256CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000769s ]
SELECT `id` FROM `stock` WHERE `id` <> 57754142 AND `partno` = '5256CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12064230 [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57237484 LIMIT 5 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57237484 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57237484 ORDER BY `unit` DESC [ RunTime:0.001156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57237484 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57237484 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
select * from pdf where partno='5256' and brandshort='Pololu' limit 1 [ RunTime:0.001244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.008303s ]
SELECT `id` FROM `stock` WHERE `id` <> 57237484 AND `partno` = '5256' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.005652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511298 [ RunTime:0.002085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44626327 LIMIT 5 [ RunTime:0.001644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626327 ORDER BY `minOrder` ASC [ RunTime:0.001093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44626327 ORDER BY `unit` DESC [ RunTime:0.000636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44626327 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626327 ORDER BY `minOrder` ASC [ RunTime:0.003062s ]
select * from pdf where partno='525651' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525651' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000801s ]
SELECT `id` FROM `stock` WHERE `id` <> 44626327 AND `partno` = '525651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.008780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727587 [ RunTime:0.011649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33107624 LIMIT 5 [ RunTime:0.003678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107624 ORDER BY `minOrder` ASC [ RunTime:0.007150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33107624 ORDER BY `unit` DESC [ RunTime:0.004521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33107624 LIMIT 2 [ RunTime:0.007019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107624 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
select * from pdf where partno='525651' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525651' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000440s ]
SELECT `id` FROM `stock` WHERE `id` <> 33107624 AND `partno` = '525651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.005082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18727587 [ RunTime:0.002540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527036 LIMIT 5 [ RunTime:0.002420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527036 ORDER BY `minOrder` ASC [ RunTime:0.008445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527036 ORDER BY `unit` DESC [ RunTime:0.019341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527036 LIMIT 2 [ RunTime:0.007908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527036 ORDER BY `minOrder` ASC [ RunTime:0.007081s ]
select * from pdf where partno='525651' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.002358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525651' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002112s ]
SELECT `id` FROM `stock` WHERE `id` <> 58527036 AND `partno` = '525651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.001118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44637068 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44637068 ORDER BY `minOrder` ASC [ RunTime:0.002126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44637068 ORDER BY `unit` DESC [ RunTime:0.007461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44637068 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44637068 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='525692' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525692' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.012963s ]
SELECT `id` FROM `stock` WHERE `id` <> 44637068 AND `partno` = '525692' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.002611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720663 [ RunTime:0.002080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33121123 LIMIT 5 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33121123 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33121123 ORDER BY `unit` DESC [ RunTime:0.000661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33121123 LIMIT 2 [ RunTime:0.010007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33121123 ORDER BY `minOrder` ASC [ RunTime:0.004285s ]
select * from pdf where partno='525692' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525692' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000428s ]
SELECT `id` FROM `stock` WHERE `id` <> 33121123 AND `partno` = '525692' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.001859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720663 [ RunTime:0.001046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58530291 LIMIT 5 [ RunTime:0.002408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58530291 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58530291 ORDER BY `unit` DESC [ RunTime:0.020174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58530291 LIMIT 2 [ RunTime:0.001381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58530291 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='525692' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525692' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000759s ]
SELECT `id` FROM `stock` WHERE `id` <> 58530291 AND `partno` = '525692' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.009546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58530055 LIMIT 5 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58530055 ORDER BY `minOrder` ASC [ RunTime:0.008128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58530055 ORDER BY `unit` DESC [ RunTime:0.023392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58530055 LIMIT 2 [ RunTime:0.006805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58530055 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='525693' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.002207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525693' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000842s ]
SELECT `id` FROM `stock` WHERE `id` <> 58530055 AND `partno` = '525693' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.004116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58528327 LIMIT 5 [ RunTime:0.008825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58528327 ORDER BY `minOrder` ASC [ RunTime:0.002839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58528327 ORDER BY `unit` DESC [ RunTime:0.004312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58528327 LIMIT 2 [ RunTime:0.015982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58528327 ORDER BY `minOrder` ASC [ RunTime:0.006837s ]
select * from pdf where partno='525690' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525690' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.003389s ]
SELECT `id` FROM `stock` WHERE `id` <> 58528327 AND `partno` = '525690' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.012661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58528287 LIMIT 5 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58528287 ORDER BY `minOrder` ASC [ RunTime:0.001321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58528287 ORDER BY `unit` DESC [ RunTime:0.013404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58528287 LIMIT 2 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58528287 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='525691' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '525691' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000824s ]
SELECT `id` FROM `stock` WHERE `id` <> 58528287 AND `partno` = '525691' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423478 LIMIT 5 [ RunTime:0.003884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423478 ORDER BY `minOrder` ASC [ RunTime:0.013691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423478 ORDER BY `unit` DESC [ RunTime:0.020730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423478 LIMIT 2 [ RunTime:0.002115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423478 ORDER BY `minOrder` ASC [ RunTime:0.003187s ]
select * from pdf where partno='5256AB2VX729' and brandshort='APEM Inc.' limit 1 [ RunTime:0.002919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256AB2VX729' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.008459s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423478 AND `partno` = '5256AB2VX729' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.003539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365743 [ RunTime:0.002337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423275 LIMIT 5 [ RunTime:0.001599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423275 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423275 ORDER BY `unit` DESC [ RunTime:0.000715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423275 LIMIT 2 [ RunTime:0.002333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423275 ORDER BY `minOrder` ASC [ RunTime:0.008795s ]
select * from pdf where partno='5256WCDB16X372' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256WCDB16X372' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.003877s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423275 AND `partno` = '5256WCDB16X372' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448548 [ RunTime:0.003494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423268 LIMIT 5 [ RunTime:0.001878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423268 ORDER BY `minOrder` ASC [ RunTime:0.006694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423268 ORDER BY `unit` DESC [ RunTime:0.001745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423268 LIMIT 2 [ RunTime:0.002321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423268 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='5256WWCDB16X514' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256WWCDB16X514' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.000842s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423268 AND `partno` = '5256WWCDB16X514' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.004401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365664 [ RunTime:0.003975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423235 LIMIT 5 [ RunTime:0.002311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423235 ORDER BY `minOrder` ASC [ RunTime:0.001534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423235 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423235 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423235 ORDER BY `minOrder` ASC [ RunTime:0.002796s ]
select * from pdf where partno='5256WCDB17' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256WCDB17' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.004015s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423235 AND `partno` = '5256WCDB17' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.009041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448520 [ RunTime:0.003021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423201 LIMIT 5 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423201 ORDER BY `minOrder` ASC [ RunTime:0.000872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423201 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423201 LIMIT 2 [ RunTime:0.007712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423201 ORDER BY `minOrder` ASC [ RunTime:0.009272s ]
select * from pdf where partno='5256WCDB16' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256WCDB16' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.001035s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423201 AND `partno` = '5256WCDB16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.000831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365634 [ RunTime:0.005587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423176 LIMIT 5 [ RunTime:0.002433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423176 ORDER BY `minOrder` ASC [ RunTime:0.006572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423176 ORDER BY `unit` DESC [ RunTime:0.006486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423176 LIMIT 2 [ RunTime:0.004892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423176 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='5256WWA' and brandshort='APEM Inc.' limit 1 [ RunTime:0.011791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256WWA' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.001680s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423176 AND `partno` = '5256WWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.001042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365638 [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423155 LIMIT 5 [ RunTime:0.004923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423155 ORDER BY `minOrder` ASC [ RunTime:0.011903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423155 ORDER BY `unit` DESC [ RunTime:0.003056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423155 LIMIT 2 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423155 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='5256WADB16UL' and brandshort='APEM Inc.' limit 1 [ RunTime:0.002105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256WADB16UL' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423155 AND `partno` = '5256WADB16UL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.003185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448458 [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58422701 LIMIT 5 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58422701 ORDER BY `minOrder` ASC [ RunTime:0.003221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58422701 ORDER BY `unit` DESC [ RunTime:0.009675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58422701 LIMIT 2 [ RunTime:0.006008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58422701 ORDER BY `minOrder` ASC [ RunTime:0.006740s ]
select * from pdf where partno='5256ADB' and brandshort='APEM Inc.' limit 1 [ RunTime:0.005901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5256ADB' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.005075s ]
SELECT `id` FROM `stock` WHERE `id` <> 58422701 AND `partno` = '5256ADB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.026261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365451 [ RunTime:0.002366s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006425s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013191s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017001s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012547s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024474s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011822s ]
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 '5256%' OR `brand` LIKE '5256%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001401s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5256%' OR `brand` LIKE '5256%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004984s ]