SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001263s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=641&search=1' [ RunTime:0.003300s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001259s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000469s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002347s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002382s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001814s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002285s ]
SELECT * FROM `stock_search` WHERE `partno` = '641' LIMIT 1 [ RunTime:0.008308s ]
UPDATE `stock_search` SET `count` = 26 , `updatetime` = '2026-08-25 19:40:29' WHERE `partno` = '641' [ RunTime:0.006286s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002584s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074931s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13534440 LIMIT 5 [ RunTime:0.016944s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534440 ORDER BY `minOrder` ASC [ RunTime:0.010063s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13534440 ORDER BY `unit` DESC [ RunTime:0.007991s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13534440 LIMIT 2 [ RunTime:0.019516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534440 ORDER BY `minOrder` ASC [ RunTime:0.016622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593732 LIMIT 5 [ RunTime:0.026328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593732 ORDER BY `minOrder` ASC [ RunTime:0.014663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593732 ORDER BY `unit` DESC [ RunTime:0.012834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593732 LIMIT 2 [ RunTime:0.016237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593732 ORDER BY `minOrder` ASC [ RunTime:0.015278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609590 LIMIT 5 [ RunTime:0.008079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609590 ORDER BY `minOrder` ASC [ RunTime:0.005808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609590 ORDER BY `unit` DESC [ RunTime:0.005577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609590 LIMIT 2 [ RunTime:0.003138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609590 ORDER BY `minOrder` ASC [ RunTime:0.003378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516439 LIMIT 5 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516439 ORDER BY `minOrder` ASC [ RunTime:0.001833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516439 ORDER BY `unit` DESC [ RunTime:0.007704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516439 LIMIT 2 [ RunTime:0.002987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516439 ORDER BY `minOrder` ASC [ RunTime:0.002261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483277 LIMIT 5 [ RunTime:0.010983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483277 ORDER BY `minOrder` ASC [ RunTime:0.005018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483277 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483277 LIMIT 2 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483277 ORDER BY `minOrder` ASC [ RunTime:0.001125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13533730 LIMIT 5 [ RunTime:0.006615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13533730 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13533730 ORDER BY `unit` DESC [ RunTime:0.008226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13533730 LIMIT 2 [ RunTime:0.002544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13533730 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16222181 LIMIT 5 [ RunTime:0.000991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16222181 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16222181 ORDER BY `unit` DESC [ RunTime:0.001168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16222181 LIMIT 2 [ RunTime:0.001230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16222181 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='641963-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19759800 LIMIT 5 [ RunTime:0.003893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19759800 ORDER BY `minOrder` ASC [ RunTime:0.016078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19759800 ORDER BY `unit` DESC [ RunTime:0.016351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19759800 LIMIT 2 [ RunTime:0.016047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19759800 ORDER BY `minOrder` ASC [ RunTime:0.005149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482075 LIMIT 5 [ RunTime:0.020943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482075 ORDER BY `minOrder` ASC [ RunTime:0.013011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482075 ORDER BY `unit` DESC [ RunTime:0.005834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482075 LIMIT 2 [ RunTime:0.012361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482075 ORDER BY `minOrder` ASC [ RunTime:0.002815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610647 LIMIT 5 [ RunTime:0.018178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610647 ORDER BY `minOrder` ASC [ RunTime:0.015218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610647 ORDER BY `unit` DESC [ RunTime:0.042649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610647 LIMIT 2 [ RunTime:0.014837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610647 ORDER BY `minOrder` ASC [ RunTime:0.019501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516745 LIMIT 5 [ RunTime:0.015780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516745 ORDER BY `minOrder` ASC [ RunTime:0.009592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516745 ORDER BY `unit` DESC [ RunTime:0.019968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516745 LIMIT 2 [ RunTime:0.010574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516745 ORDER BY `minOrder` ASC [ RunTime:0.006744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417349 LIMIT 5 [ RunTime:0.005355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417349 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417349 ORDER BY `unit` DESC [ RunTime:0.010802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417349 LIMIT 2 [ RunTime:0.006825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417349 ORDER BY `minOrder` ASC [ RunTime:0.003880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16224802 LIMIT 5 [ RunTime:0.004084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224802 ORDER BY `minOrder` ASC [ RunTime:0.005288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16224802 ORDER BY `unit` DESC [ RunTime:0.001357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16224802 LIMIT 2 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224802 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19747071 LIMIT 5 [ RunTime:0.007220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747071 ORDER BY `minOrder` ASC [ RunTime:0.001910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19747071 ORDER BY `unit` DESC [ RunTime:0.001021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19747071 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747071 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
select * from pdf where partno='641968-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612850 LIMIT 5 [ RunTime:0.002738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612850 ORDER BY `minOrder` ASC [ RunTime:0.004537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612850 ORDER BY `unit` DESC [ RunTime:0.003819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612850 LIMIT 2 [ RunTime:0.002301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612850 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772453 LIMIT 5 [ RunTime:0.002043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772453 ORDER BY `minOrder` ASC [ RunTime:0.000746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19772453 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19772453 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772453 ORDER BY `minOrder` ASC [ RunTime:0.002534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11613719 LIMIT 5 [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11613719 ORDER BY `minOrder` ASC [ RunTime:0.004557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11613719 ORDER BY `unit` DESC [ RunTime:0.023459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11613719 LIMIT 2 [ RunTime:0.017804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11613719 ORDER BY `minOrder` ASC [ RunTime:0.001295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16225945 LIMIT 5 [ RunTime:0.003806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225945 ORDER BY `minOrder` ASC [ RunTime:0.007707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16225945 ORDER BY `unit` DESC [ RunTime:0.005271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16225945 LIMIT 2 [ RunTime:0.013322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225945 ORDER BY `minOrder` ASC [ RunTime:0.002022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474618 LIMIT 5 [ RunTime:0.009151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474618 ORDER BY `minOrder` ASC [ RunTime:0.011392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15474618 ORDER BY `unit` DESC [ RunTime:0.003353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15474618 LIMIT 2 [ RunTime:0.008378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474618 ORDER BY `minOrder` ASC [ RunTime:0.007473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478550 LIMIT 5 [ RunTime:0.015308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478550 ORDER BY `minOrder` ASC [ RunTime:0.000827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15478550 ORDER BY `unit` DESC [ RunTime:0.006127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15478550 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478550 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281138 LIMIT 5 [ RunTime:0.001031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281138 ORDER BY `minOrder` ASC [ RunTime:0.001456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281138 ORDER BY `unit` DESC [ RunTime:0.003285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281138 LIMIT 2 [ RunTime:0.010955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281138 ORDER BY `minOrder` ASC [ RunTime:0.005997s ]
select * from pdf where partno='641777-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001557s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641777-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.029008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281140 LIMIT 5 [ RunTime:0.005389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281140 ORDER BY `minOrder` ASC [ RunTime:0.012648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281140 ORDER BY `unit` DESC [ RunTime:0.013267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281140 LIMIT 2 [ RunTime:0.019933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281140 ORDER BY `minOrder` ASC [ RunTime:0.019316s ]
select * from pdf where partno='641963-1' and brandshort='te connectivity' limit 1 [ RunTime:0.024445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641963-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.021972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281142 LIMIT 5 [ RunTime:0.011965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281142 ORDER BY `minOrder` ASC [ RunTime:0.008884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281142 ORDER BY `unit` DESC [ RunTime:0.018932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281142 LIMIT 2 [ RunTime:0.020516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281142 ORDER BY `minOrder` ASC [ RunTime:0.008578s ]
select * from pdf where partno='641966-1' and brandshort='te connectivity' limit 1 [ RunTime:0.020501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641966-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.036019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280121 LIMIT 5 [ RunTime:0.010804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280121 ORDER BY `minOrder` ASC [ RunTime:0.027481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280121 ORDER BY `unit` DESC [ RunTime:0.027468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280121 LIMIT 2 [ RunTime:0.010110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280121 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='641964-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641964-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.015525s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280121 AND `partno` = '641964-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.023424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281141 LIMIT 5 [ RunTime:0.026389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281141 ORDER BY `minOrder` ASC [ RunTime:0.013619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281141 ORDER BY `unit` DESC [ RunTime:0.001477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281141 LIMIT 2 [ RunTime:0.009802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281141 ORDER BY `minOrder` ASC [ RunTime:0.005263s ]
select * from pdf where partno='641964-1' and brandshort='te connectivity' limit 1 [ RunTime:0.009137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641964-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.038552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237226 LIMIT 5 [ RunTime:0.020673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237226 ORDER BY `minOrder` ASC [ RunTime:0.013377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237226 ORDER BY `unit` DESC [ RunTime:0.011946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237226 LIMIT 2 [ RunTime:0.007720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237226 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='64128k fc bw-3' and brandshort='displaytech' limit 1 [ RunTime:0.000855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64128k fc bw-3' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.008507s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237226 AND `partno` = '64128k fc bw-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.016636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17043263 [ RunTime:0.019828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281143 LIMIT 5 [ RunTime:0.005676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281143 ORDER BY `minOrder` ASC [ RunTime:0.004146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281143 ORDER BY `unit` DESC [ RunTime:0.006020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281143 LIMIT 2 [ RunTime:0.006789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281143 ORDER BY `minOrder` ASC [ RunTime:0.001941s ]
select * from pdf where partno='641968-1' and brandshort='te connectivity' limit 1 [ RunTime:0.000939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641968-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.015267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281139 LIMIT 5 [ RunTime:0.007405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281139 ORDER BY `minOrder` ASC [ RunTime:0.013411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281139 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281139 LIMIT 2 [ RunTime:0.018797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281139 ORDER BY `minOrder` ASC [ RunTime:0.006533s ]
select * from pdf where partno='641831-1' and brandshort='te connectivity' limit 1 [ RunTime:0.014005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641831-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.028262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237227 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237227 ORDER BY `minOrder` ASC [ RunTime:0.008356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237227 ORDER BY `unit` DESC [ RunTime:0.000753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237227 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237227 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='64128m fc bw-3' and brandshort='displaytech' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64128m fc bw-3' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.000616s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237227 AND `partno` = '64128m fc bw-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955424 [ RunTime:0.000855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281144 LIMIT 5 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281144 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281144 ORDER BY `unit` DESC [ RunTime:0.009179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281144 LIMIT 2 [ RunTime:0.005536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281144 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
select * from pdf where partno='641976-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.011724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641976-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000784s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281144 AND `partno` = '641976-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.015241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280225 LIMIT 5 [ RunTime:0.019544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280225 ORDER BY `minOrder` ASC [ RunTime:0.019836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280225 ORDER BY `unit` DESC [ RunTime:0.010126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280225 LIMIT 2 [ RunTime:0.007995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280225 ORDER BY `minOrder` ASC [ RunTime:0.000895s ]
select * from pdf where partno='641970-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641970-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000999s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280225 AND `partno` = '641970-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280526 LIMIT 5 [ RunTime:0.002914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280526 ORDER BY `minOrder` ASC [ RunTime:0.012034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280526 ORDER BY `unit` DESC [ RunTime:0.002541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280526 LIMIT 2 [ RunTime:0.005044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280526 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='641976-4' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.008762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641976-4' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.012913s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280526 AND `partno` = '641976-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.004521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32236461 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236461 ORDER BY `minOrder` ASC [ RunTime:0.008476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32236461 ORDER BY `unit` DESC [ RunTime:0.013822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32236461 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236461 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='64128k cog fa bw' and brandshort='displaytech' limit 1 [ RunTime:0.000638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64128k cog fa bw' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.001702s ]
SELECT `id` FROM `stock` WHERE `id` <> 32236461 AND `partno` = '64128k cog fa bw' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58134994 [ RunTime:0.002657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237513 LIMIT 5 [ RunTime:0.002618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237513 ORDER BY `minOrder` ASC [ RunTime:0.028521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237513 ORDER BY `unit` DESC [ RunTime:0.021698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237513 LIMIT 2 [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237513 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
select * from pdf where partno='64128m fc bw-rgb' and brandshort='displaytech' limit 1 [ RunTime:0.006643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64128m fc bw-rgb' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.001537s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237513 AND `partno` = '64128m fc bw-rgb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.002412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260129 [ RunTime:0.015621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32290392 LIMIT 5 [ RunTime:0.003623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290392 ORDER BY `minOrder` ASC [ RunTime:0.013454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32290392 ORDER BY `unit` DESC [ RunTime:0.025220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32290392 LIMIT 2 [ RunTime:0.042913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290392 ORDER BY `minOrder` ASC [ RunTime:0.002662s ]
select * from pdf where partno='641k' and brandshort='wakefield thermal' limit 1 [ RunTime:0.007920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641k' OR `brand` LIKE 'wakefield thermal%' ) ) LIMIT 1 [ RunTime:0.015851s ]
SELECT `id` FROM `stock` WHERE `id` <> 32290392 AND `partno` = '641k' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.022853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43885061 [ RunTime:0.006137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32236693 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236693 ORDER BY `minOrder` ASC [ RunTime:0.033386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32236693 ORDER BY `unit` DESC [ RunTime:0.003582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32236693 LIMIT 2 [ RunTime:0.010225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236693 ORDER BY `minOrder` ASC [ RunTime:0.009494s ]
select * from pdf where partno='64128l fc bw-rgb' and brandshort='displaytech' limit 1 [ RunTime:0.008133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64128l fc bw-rgb' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.013514s ]
SELECT `id` FROM `stock` WHERE `id` <> 32236693 AND `partno` = '64128l fc bw-rgb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.016820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58135048 [ RunTime:0.011718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137094 LIMIT 5 [ RunTime:0.008928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137094 ORDER BY `minOrder` ASC [ RunTime:0.012715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137094 ORDER BY `unit` DESC [ RunTime:0.006720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137094 LIMIT 2 [ RunTime:0.002296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137094 ORDER BY `minOrder` ASC [ RunTime:0.013423s ]
select * from pdf where partno='6412 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.015844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6412 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.023842s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137094 AND `partno` = '6412 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.022886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514075 [ RunTime:0.005812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137066 LIMIT 5 [ RunTime:0.009061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137066 ORDER BY `minOrder` ASC [ RunTime:0.003153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137066 ORDER BY `unit` DESC [ RunTime:0.001935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137066 LIMIT 2 [ RunTime:0.008885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137066 ORDER BY `minOrder` ASC [ RunTime:0.006583s ]
select * from pdf where partno='6415' and brandshort='volex' limit 1 [ RunTime:0.005675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6415' OR `brand` LIKE 'volex%' ) ) LIMIT 1 [ RunTime:0.007492s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137066 AND `partno` = '6415' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%volex%' ) [ RunTime:0.007460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280525 LIMIT 5 [ RunTime:0.004977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280525 ORDER BY `minOrder` ASC [ RunTime:0.017077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280525 ORDER BY `unit` DESC [ RunTime:0.009167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280525 LIMIT 2 [ RunTime:0.019367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280525 ORDER BY `minOrder` ASC [ RunTime:0.001810s ]
select * from pdf where partno='641972-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.023072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641972-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.017877s ]
SELECT `id` FROM `stock` WHERE `id` <> 32280525 AND `partno` = '641972-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.021911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137159 LIMIT 5 [ RunTime:0.035216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137159 ORDER BY `minOrder` ASC [ RunTime:0.007464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137159 ORDER BY `unit` DESC [ RunTime:0.010341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137159 LIMIT 2 [ RunTime:0.056560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137159 ORDER BY `minOrder` ASC [ RunTime:0.014383s ]
select * from pdf where partno='6413 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.028148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6413 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.015304s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137159 AND `partno` = '6413 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.039712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514114 [ RunTime:0.028204s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361483 LIMIT 5 [ RunTime:0.004935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361483 ORDER BY `minOrder` ASC [ RunTime:0.017346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361483 ORDER BY `unit` DESC [ RunTime:0.024835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361483 LIMIT 2 [ RunTime:0.030489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361483 ORDER BY `minOrder` ASC [ RunTime:0.015321s ]
select * from pdf where partno='641623-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641623-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002716s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361483 AND `partno` = '641623-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63108045 LIMIT 5 [ RunTime:0.022589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63108045 ORDER BY `minOrder` ASC [ RunTime:0.129530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63108045 ORDER BY `unit` DESC [ RunTime:0.016419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63108045 LIMIT 2 [ RunTime:0.024869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63108045 ORDER BY `minOrder` ASC [ RunTime:0.014793s ]
select * from pdf where partno='6418370001' and brandshort='TE Connectivity' limit 1 [ RunTime:0.015832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6418370001' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.051562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343988 LIMIT 5 [ RunTime:0.018089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343988 ORDER BY `minOrder` ASC [ RunTime:0.076999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343988 ORDER BY `unit` DESC [ RunTime:0.046293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343988 LIMIT 2 [ RunTime:0.029301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343988 ORDER BY `minOrder` ASC [ RunTime:0.051726s ]
select * from pdf where partno='641550-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641550-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032724s ]
SELECT `id` FROM `stock` WHERE `id` <> 60343988 AND `partno` = '641550-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60346468 LIMIT 5 [ RunTime:0.018859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60346468 ORDER BY `minOrder` ASC [ RunTime:0.042372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60346468 ORDER BY `unit` DESC [ RunTime:0.023474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60346468 LIMIT 2 [ RunTime:0.014336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60346468 ORDER BY `minOrder` ASC [ RunTime:0.016847s ]
select * from pdf where partno='641300-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.041323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641300-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.073180s ]
SELECT `id` FROM `stock` WHERE `id` <> 60346468 AND `partno` = '641300-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.085239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12015828 [ RunTime:0.083020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60639801 LIMIT 5 [ RunTime:0.044043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639801 ORDER BY `minOrder` ASC [ RunTime:0.014014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60639801 ORDER BY `unit` DESC [ RunTime:0.037320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60639801 LIMIT 2 [ RunTime:0.025850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60639801 ORDER BY `minOrder` ASC [ RunTime:0.031887s ]
select * from pdf where partno='641321-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.036374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641321-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033729s ]
SELECT `id` FROM `stock` WHERE `id` <> 60639801 AND `partno` = '641321-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.028907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516439 [ RunTime:0.017340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361781 LIMIT 5 [ RunTime:0.025380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361781 ORDER BY `minOrder` ASC [ RunTime:0.012535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361781 ORDER BY `unit` DESC [ RunTime:0.008905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361781 LIMIT 2 [ RunTime:0.002974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361781 ORDER BY `minOrder` ASC [ RunTime:0.018357s ]
select * from pdf where partno='641994-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641994-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011166s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361781 AND `partno` = '641994-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612850 [ RunTime:0.022626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343071 LIMIT 5 [ RunTime:0.008364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343071 ORDER BY `minOrder` ASC [ RunTime:0.029910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343071 ORDER BY `unit` DESC [ RunTime:0.022542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343071 LIMIT 2 [ RunTime:0.029581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343071 ORDER BY `minOrder` ASC [ RunTime:0.010079s ]
select * from pdf where partno='641294-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641294-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59948034 LIMIT 5 [ RunTime:0.012962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948034 ORDER BY `minOrder` ASC [ RunTime:0.019009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59948034 ORDER BY `unit` DESC [ RunTime:0.020109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59948034 LIMIT 2 [ RunTime:0.012493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948034 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
select * from pdf where partno='641685-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641685-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.025727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60363105 LIMIT 5 [ RunTime:0.003756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363105 ORDER BY `minOrder` ASC [ RunTime:0.014512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60363105 ORDER BY `unit` DESC [ RunTime:0.019572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60363105 LIMIT 2 [ RunTime:0.013212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60363105 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
select * from pdf where partno='641778-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641778-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010409s ]
SELECT `id` FROM `stock` WHERE `id` <> 60363105 AND `partno` = '641778-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484344 [ RunTime:0.001292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640341 LIMIT 5 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640341 ORDER BY `minOrder` ASC [ RunTime:0.000945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640341 ORDER BY `unit` DESC [ RunTime:0.009742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640341 LIMIT 2 [ RunTime:0.001370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640341 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='641324-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641324-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001313s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640341 AND `partno` = '641324-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516745 [ RunTime:0.015164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59437570 LIMIT 5 [ RunTime:0.017540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437570 ORDER BY `minOrder` ASC [ RunTime:0.007701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59437570 ORDER BY `unit` DESC [ RunTime:0.007498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59437570 LIMIT 2 [ RunTime:0.016061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437570 ORDER BY `minOrder` ASC [ RunTime:0.012297s ]
select * from pdf where partno='641963-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641963-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001331s ]
SELECT `id` FROM `stock` WHERE `id` <> 59437570 AND `partno` = '641963-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16222181 [ RunTime:0.017665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361701 LIMIT 5 [ RunTime:0.007424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361701 ORDER BY `minOrder` ASC [ RunTime:0.007903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361701 ORDER BY `unit` DESC [ RunTime:0.012018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361701 LIMIT 2 [ RunTime:0.009701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361701 ORDER BY `minOrder` ASC [ RunTime:0.002386s ]
select * from pdf where partno='641777-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641777-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000672s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361701 AND `partno` = '641777-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11485069 [ RunTime:0.033933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640513 LIMIT 5 [ RunTime:0.004959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640513 ORDER BY `minOrder` ASC [ RunTime:0.030763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640513 ORDER BY `unit` DESC [ RunTime:0.026171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640513 LIMIT 2 [ RunTime:0.055720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640513 ORDER BY `minOrder` ASC [ RunTime:0.025102s ]
select * from pdf where partno='641256-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.036529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641256-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026744s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640513 AND `partno` = '641256-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417349 [ RunTime:0.002479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59440137 LIMIT 5 [ RunTime:0.024979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59440137 ORDER BY `minOrder` ASC [ RunTime:0.013360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59440137 ORDER BY `unit` DESC [ RunTime:0.018392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59440137 LIMIT 2 [ RunTime:0.015257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59440137 ORDER BY `minOrder` ASC [ RunTime:0.012606s ]
select * from pdf where partno='641974-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641974-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000664s ]
SELECT `id` FROM `stock` WHERE `id` <> 59440137 AND `partno` = '641974-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763139 [ RunTime:0.024063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59439456 LIMIT 5 [ RunTime:0.005802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439456 ORDER BY `minOrder` ASC [ RunTime:0.031581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59439456 ORDER BY `unit` DESC [ RunTime:0.025516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59439456 LIMIT 2 [ RunTime:0.021976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439456 ORDER BY `minOrder` ASC [ RunTime:0.013894s ]
select * from pdf where partno='641828-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641828-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.021125s ]
SELECT `id` FROM `stock` WHERE `id` <> 59439456 AND `partno` = '641828-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.024621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16224802 [ RunTime:0.005518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438656 LIMIT 5 [ RunTime:0.011930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438656 ORDER BY `minOrder` ASC [ RunTime:0.063595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438656 ORDER BY `unit` DESC [ RunTime:0.042656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438656 LIMIT 2 [ RunTime:0.003500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438656 ORDER BY `minOrder` ASC [ RunTime:0.012101s ]
select * from pdf where partno='641966-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.042800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641966-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006018s ]
SELECT `id` FROM `stock` WHERE `id` <> 59438656 AND `partno` = '641966-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.027280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763306 [ RunTime:0.016347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362793 LIMIT 5 [ RunTime:0.014572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362793 ORDER BY `minOrder` ASC [ RunTime:0.045616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362793 ORDER BY `unit` DESC [ RunTime:0.007375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362793 LIMIT 2 [ RunTime:0.021668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362793 ORDER BY `minOrder` ASC [ RunTime:0.036158s ]
select * from pdf where partno='641533-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.060877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641533-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019220s ]
SELECT `id` FROM `stock` WHERE `id` <> 60362793 AND `partno` = '641533-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483947 [ RunTime:0.026907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905811 LIMIT 5 [ RunTime:0.030538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905811 ORDER BY `minOrder` ASC [ RunTime:0.027609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905811 ORDER BY `unit` DESC [ RunTime:0.020338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905811 LIMIT 2 [ RunTime:0.023473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905811 ORDER BY `minOrder` ASC [ RunTime:0.013145s ]
select * from pdf where partno='641239-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641239-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.039750s ]
SELECT `id` FROM `stock` WHERE `id` <> 59905811 AND `partno` = '641239-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.027378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11613719 [ RunTime:0.033020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59443279 LIMIT 5 [ RunTime:0.067153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443279 ORDER BY `minOrder` ASC [ RunTime:0.038290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59443279 ORDER BY `unit` DESC [ RunTime:0.017594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59443279 LIMIT 2 [ RunTime:0.038402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443279 ORDER BY `minOrder` ASC [ RunTime:0.032848s ]
select * from pdf where partno='641967-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.032959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641967-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016054s ]
SELECT `id` FROM `stock` WHERE `id` <> 59443279 AND `partno` = '641967-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19824056 [ RunTime:0.026212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59439555 LIMIT 5 [ RunTime:0.003263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439555 ORDER BY `minOrder` ASC [ RunTime:0.026884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59439555 ORDER BY `unit` DESC [ RunTime:0.027800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59439555 LIMIT 2 [ RunTime:0.017433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439555 ORDER BY `minOrder` ASC [ RunTime:0.014894s ]
select * from pdf where partno='641215-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.027373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '641215-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027700s ]
SELECT `id` FROM `stock` WHERE `id` <> 59439555 AND `partno` = '641215-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.043074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474618 [ RunTime:0.031885s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094967s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037099s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078264s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083724s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048770s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051766s ]
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 '641%' OR `brand` LIKE '641%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040549s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '641%' OR `brand` LIKE '641%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.098737s ]