SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002140s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.48' , `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=GSB1&search=1' [ RunTime:0.005506s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002673s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001816s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002596s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.48' ) [ RunTime:0.004341s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002349s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002365s ]
SELECT * FROM `stock_search` WHERE `partno` = 'GSB1' LIMIT 1 [ RunTime:0.001611s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-30 15:22:58' WHERE `partno` = 'GSB1' [ RunTime:0.002077s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002508s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011254s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195456 LIMIT 5 [ RunTime:0.006469s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195456 ORDER BY `minOrder` ASC [ RunTime:0.001219s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13195456 ORDER BY `unit` DESC [ RunTime:0.000736s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13195456 LIMIT 2 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195456 ORDER BY `minOrder` ASC [ RunTime:0.002907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934222 LIMIT 5 [ RunTime:0.006147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934222 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934222 ORDER BY `unit` DESC [ RunTime:0.002038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934222 LIMIT 2 [ RunTime:0.001009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934222 ORDER BY `minOrder` ASC [ RunTime:0.005465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934275 LIMIT 5 [ RunTime:0.003606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934275 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934275 ORDER BY `unit` DESC [ RunTime:0.002715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934275 LIMIT 2 [ RunTime:0.007093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934275 ORDER BY `minOrder` ASC [ RunTime:0.003954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934223 LIMIT 5 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934223 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934223 ORDER BY `unit` DESC [ RunTime:0.006149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934223 LIMIT 2 [ RunTime:0.006944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934223 ORDER BY `minOrder` ASC [ RunTime:0.005346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934224 LIMIT 5 [ RunTime:0.016946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934224 ORDER BY `minOrder` ASC [ RunTime:0.007090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934224 ORDER BY `unit` DESC [ RunTime:0.002172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934224 LIMIT 2 [ RunTime:0.015670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934224 ORDER BY `minOrder` ASC [ RunTime:0.032366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934274 LIMIT 5 [ RunTime:0.017187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934274 ORDER BY `minOrder` ASC [ RunTime:0.013674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934274 ORDER BY `unit` DESC [ RunTime:0.005349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934274 LIMIT 2 [ RunTime:0.003320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934274 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932182 LIMIT 5 [ RunTime:0.002430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932182 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932182 ORDER BY `unit` DESC [ RunTime:0.001317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932182 LIMIT 2 [ RunTime:0.003707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932182 ORDER BY `minOrder` ASC [ RunTime:0.013906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934343 LIMIT 5 [ RunTime:0.014396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934343 ORDER BY `minOrder` ASC [ RunTime:0.014414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934343 ORDER BY `unit` DESC [ RunTime:0.007324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934343 LIMIT 2 [ RunTime:0.004966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934343 ORDER BY `minOrder` ASC [ RunTime:0.002734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934234 LIMIT 5 [ RunTime:0.004081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934234 ORDER BY `minOrder` ASC [ RunTime:0.001883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934234 ORDER BY `unit` DESC [ RunTime:0.006121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934234 LIMIT 2 [ RunTime:0.004221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934234 ORDER BY `minOrder` ASC [ RunTime:0.001016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932183 LIMIT 5 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932183 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932183 ORDER BY `unit` DESC [ RunTime:0.003618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932183 LIMIT 2 [ RunTime:0.009867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932183 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932184 LIMIT 5 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932184 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932184 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932184 LIMIT 2 [ RunTime:0.005777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932184 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934250 LIMIT 5 [ RunTime:0.001340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934250 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934250 ORDER BY `unit` DESC [ RunTime:0.001101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934250 LIMIT 2 [ RunTime:0.008989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934250 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932289 LIMIT 5 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932289 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932289 ORDER BY `unit` DESC [ RunTime:0.002268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932289 LIMIT 2 [ RunTime:0.014746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932289 ORDER BY `minOrder` ASC [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932187 LIMIT 5 [ RunTime:0.001309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932187 ORDER BY `minOrder` ASC [ RunTime:0.005631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932187 ORDER BY `unit` DESC [ RunTime:0.000510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932187 LIMIT 2 [ RunTime:0.008609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932187 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934259 LIMIT 5 [ RunTime:0.006214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934259 ORDER BY `minOrder` ASC [ RunTime:0.003762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934259 ORDER BY `unit` DESC [ RunTime:0.014146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934259 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934259 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195369 LIMIT 5 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195369 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13195369 ORDER BY `unit` DESC [ RunTime:0.010550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13195369 LIMIT 2 [ RunTime:0.020213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195369 ORDER BY `minOrder` ASC [ RunTime:0.007206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932546 LIMIT 5 [ RunTime:0.008447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932546 ORDER BY `minOrder` ASC [ RunTime:0.010452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932546 ORDER BY `unit` DESC [ RunTime:0.016219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932546 LIMIT 2 [ RunTime:0.016965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932546 ORDER BY `minOrder` ASC [ RunTime:0.010852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4673 LIMIT 5 [ RunTime:0.003600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4673 ORDER BY `minOrder` ASC [ RunTime:0.019666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4673 ORDER BY `unit` DESC [ RunTime:0.001126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4673 LIMIT 2 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4673 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB19110KEU' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.001655s ]
SELECT `id` FROM `stock` WHERE `id` <> 4673 AND `partno` = 'GSB19110KEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol communications solutions%' ) [ RunTime:0.002984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934251 LIMIT 5 [ RunTime:0.004721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934251 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11934251 ORDER BY `unit` DESC [ RunTime:0.012681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11934251 LIMIT 2 [ RunTime:0.017637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11934251 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195432 LIMIT 5 [ RunTime:0.017157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195432 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13195432 ORDER BY `unit` DESC [ RunTime:0.009816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13195432 LIMIT 2 [ RunTime:0.008542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13195432 ORDER BY `minOrder` ASC [ RunTime:0.003785s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257167 LIMIT 5 [ RunTime:0.012881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257167 ORDER BY `minOrder` ASC [ RunTime:0.001252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257167 ORDER BY `unit` DESC [ RunTime:0.013459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257167 LIMIT 2 [ RunTime:0.019729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257167 ORDER BY `minOrder` ASC [ RunTime:0.003172s ]
select * from pdf where partno='gsb12j21c1eu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.006182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb12j21c1eu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.012870s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257167 AND `partno` = 'gsb12j21c1eu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.011242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257526 LIMIT 5 [ RunTime:0.011274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257526 ORDER BY `minOrder` ASC [ RunTime:0.004028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257526 ORDER BY `unit` DESC [ RunTime:0.004579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257526 LIMIT 2 [ RunTime:0.003233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257526 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
select * from pdf where partno='gsb1c4621ds2hr' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.006553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb1c4621ds2hr' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.007015s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257526 AND `partno` = 'gsb1c4621ds2hr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.009216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257525 LIMIT 5 [ RunTime:0.003588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257525 ORDER BY `minOrder` ASC [ RunTime:0.001700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257525 ORDER BY `unit` DESC [ RunTime:0.001910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257525 LIMIT 2 [ RunTime:0.025704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257525 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
select * from pdf where partno='gsb1c4621ds1hr' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.006857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb1c4621ds1hr' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.004666s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257525 AND `partno` = 'gsb1c4621ds1hr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.010515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257168 LIMIT 5 [ RunTime:0.023524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257168 ORDER BY `minOrder` ASC [ RunTime:0.045908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257168 ORDER BY `unit` DESC [ RunTime:0.018640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257168 LIMIT 2 [ RunTime:0.012620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257168 ORDER BY `minOrder` ASC [ RunTime:0.007353s ]
select * from pdf where partno='gsb19110keu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb19110keu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.003534s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257168 AND `partno` = 'gsb19110keu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257524 LIMIT 5 [ RunTime:0.001142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257524 ORDER BY `minOrder` ASC [ RunTime:0.029453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257524 ORDER BY `unit` DESC [ RunTime:0.055533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257524 LIMIT 2 [ RunTime:0.012326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257524 ORDER BY `minOrder` ASC [ RunTime:0.015034s ]
select * from pdf where partno='gsb1c411111ds1hr' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.021019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb1c411111ds1hr' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.028306s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257524 AND `partno` = 'gsb1c411111ds1hr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.038601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257734 LIMIT 5 [ RunTime:0.013235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257734 ORDER BY `minOrder` ASC [ RunTime:0.033091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257734 ORDER BY `unit` DESC [ RunTime:0.027243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257734 LIMIT 2 [ RunTime:0.027897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257734 ORDER BY `minOrder` ASC [ RunTime:0.025339s ]
select * from pdf where partno='gsb11120keu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.046564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb11120keu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.010639s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257734 AND `partno` = 'gsb11120keu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.025310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257735 LIMIT 5 [ RunTime:0.014497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257735 ORDER BY `minOrder` ASC [ RunTime:0.042743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257735 ORDER BY `unit` DESC [ RunTime:0.011212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257735 LIMIT 2 [ RunTime:0.007791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257735 ORDER BY `minOrder` ASC [ RunTime:0.006797s ]
select * from pdf where partno='gsb1212103eu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb1212103eu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.011017s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257735 AND `partno` = 'gsb1212103eu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.010375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257736 LIMIT 5 [ RunTime:0.000777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257736 ORDER BY `minOrder` ASC [ RunTime:0.001508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257736 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257736 LIMIT 2 [ RunTime:0.008096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257736 ORDER BY `minOrder` ASC [ RunTime:0.002062s ]
select * from pdf where partno='gsb12121rskeu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb12121rskeu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.003195s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257736 AND `partno` = 'gsb12121rskeu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257656 LIMIT 5 [ RunTime:0.003042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257656 ORDER BY `minOrder` ASC [ RunTime:0.006977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257656 ORDER BY `unit` DESC [ RunTime:0.001452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257656 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257656 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='gsb1c411101ds1hr' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.000941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb1c411101ds1hr' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000762s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257656 AND `partno` = 'gsb1c411101ds1hr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.003703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258273 LIMIT 5 [ RunTime:0.015497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258273 ORDER BY `minOrder` ASC [ RunTime:0.006662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258273 ORDER BY `unit` DESC [ RunTime:0.001403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258273 LIMIT 2 [ RunTime:0.005832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258273 ORDER BY `minOrder` ASC [ RunTime:0.002845s ]
select * from pdf where partno='gsb19111khr' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb19111khr' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.003029s ]
SELECT `id` FROM `stock` WHERE `id` <> 32258273 AND `partno` = 'gsb19111khr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.003236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257655 LIMIT 5 [ RunTime:0.011849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257655 ORDER BY `minOrder` ASC [ RunTime:0.008968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257655 ORDER BY `unit` DESC [ RunTime:0.003928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257655 LIMIT 2 [ RunTime:0.011995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257655 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
select * from pdf where partno='gsb1c211110ds1hr' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb1c211110ds1hr' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.002836s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257655 AND `partno` = 'gsb1c211110ds1hr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258274 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258274 ORDER BY `minOrder` ASC [ RunTime:0.003608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258274 ORDER BY `unit` DESC [ RunTime:0.000700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258274 LIMIT 2 [ RunTime:0.002820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258274 ORDER BY `minOrder` ASC [ RunTime:0.001476s ]
select * from pdf where partno='gsb19111rkeu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb19111rkeu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.005122s ]
SELECT `id` FROM `stock` WHERE `id` <> 32258274 AND `partno` = 'gsb19111rkeu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.004033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257657 LIMIT 5 [ RunTime:0.003837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257657 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257657 ORDER BY `unit` DESC [ RunTime:0.003747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257657 LIMIT 2 [ RunTime:0.001770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257657 ORDER BY `minOrder` ASC [ RunTime:0.003364s ]
select * from pdf where partno='gsb1ca11101dshr' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.004620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb1ca11101dshr' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.004996s ]
SELECT `id` FROM `stock` WHERE `id` <> 32257657 AND `partno` = 'gsb1ca11101dshr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.002797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258272 LIMIT 5 [ RunTime:0.004314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258272 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258272 ORDER BY `unit` DESC [ RunTime:0.007738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258272 LIMIT 2 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258272 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='gsb19111keu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.003048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb19111keu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000897s ]
SELECT `id` FROM `stock` WHERE `id` <> 32258272 AND `partno` = 'gsb19111keu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258271 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258271 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258271 ORDER BY `unit` DESC [ RunTime:0.004383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258271 LIMIT 2 [ RunTime:0.004035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258271 ORDER BY `minOrder` ASC [ RunTime:0.005917s ]
select * from pdf where partno='gsb12121031eu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.010164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb12121031eu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.006517s ]
SELECT `id` FROM `stock` WHERE `id` <> 32258271 AND `partno` = 'gsb12121031eu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.002394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258270 LIMIT 5 [ RunTime:0.006849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258270 ORDER BY `minOrder` ASC [ RunTime:0.003850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258270 ORDER BY `unit` DESC [ RunTime:0.004002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258270 LIMIT 2 [ RunTime:0.006099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258270 ORDER BY `minOrder` ASC [ RunTime:0.003587s ]
select * from pdf where partno='gsb11121keu' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.004864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb11121keu' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.016563s ]
SELECT `id` FROM `stock` WHERE `id` <> 32258270 AND `partno` = 'gsb11121keu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258269 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258269 ORDER BY `minOrder` ASC [ RunTime:0.012708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258269 ORDER BY `unit` DESC [ RunTime:0.001720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258269 LIMIT 2 [ RunTime:0.023020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258269 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='gsb11111alf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.000979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gsb11111alf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.004511s ]
SELECT `id` FROM `stock` WHERE `id` <> 32258269 AND `partno` = 'gsb11111alf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.004580s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393529 LIMIT 5 [ RunTime:0.005933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393529 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393529 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393529 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393529 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='GSB1C41110SSHR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C41110SSHR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.004647s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393529 AND `partno` = 'GSB1C41110SSHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932653 [ RunTime:0.003201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394175 LIMIT 5 [ RunTime:0.007143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394175 ORDER BY `minOrder` ASC [ RunTime:0.003529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394175 ORDER BY `unit` DESC [ RunTime:0.001502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394175 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394175 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='GSB1C4K11DSHR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.001219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C4K11DSHR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.008357s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394175 AND `partno` = 'GSB1C4K11DSHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934343 [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394013 LIMIT 5 [ RunTime:0.006928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394013 ORDER BY `minOrder` ASC [ RunTime:0.004124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394013 ORDER BY `unit` DESC [ RunTime:0.002063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394013 LIMIT 2 [ RunTime:0.001220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394013 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='GSB12J21C1EU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.001086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB12J21C1EU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.001449s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394013 AND `partno` = 'GSB12J21C1EU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195662 [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394767 LIMIT 5 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394767 ORDER BY `minOrder` ASC [ RunTime:0.013725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394767 ORDER BY `unit` DESC [ RunTime:0.006431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394767 LIMIT 2 [ RunTime:0.002959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394767 ORDER BY `minOrder` ASC [ RunTime:0.006145s ]
select * from pdf where partno='GSB1C4611DYHR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.002257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C4611DYHR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.012182s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394767 AND `partno` = 'GSB1C4611DYHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195456 [ RunTime:0.002138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394053 LIMIT 5 [ RunTime:0.004544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394053 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394053 ORDER BY `unit` DESC [ RunTime:0.000730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394053 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394053 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='GSB1C4111DYHR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.001174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C4111DYHR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.003723s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394053 AND `partno` = 'GSB1C4111DYHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934275 [ RunTime:0.000695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393959 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393959 ORDER BY `minOrder` ASC [ RunTime:0.008856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393959 ORDER BY `unit` DESC [ RunTime:0.001789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393959 LIMIT 2 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393959 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='GSB1C4621DS1HR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.008178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C4621DS1HR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.001409s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393959 AND `partno` = 'GSB1C4621DS1HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934222 [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394024 LIMIT 5 [ RunTime:0.004287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394024 ORDER BY `minOrder` ASC [ RunTime:0.002907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394024 ORDER BY `unit` DESC [ RunTime:0.003321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394024 LIMIT 2 [ RunTime:0.009002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394024 ORDER BY `minOrder` ASC [ RunTime:0.010012s ]
select * from pdf where partno='GSB1C211110DS1HR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.006408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C211110DS1HR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.009065s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394024 AND `partno` = 'GSB1C211110DS1HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393960 LIMIT 5 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393960 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393960 ORDER BY `unit` DESC [ RunTime:0.003056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393960 LIMIT 2 [ RunTime:0.009242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393960 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='GSB1C4621DS2HR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C4621DS2HR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.008229s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393960 AND `partno` = 'GSB1C4621DS2HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934224 [ RunTime:0.000731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393553 LIMIT 5 [ RunTime:0.005502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393553 ORDER BY `minOrder` ASC [ RunTime:0.003564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393553 ORDER BY `unit` DESC [ RunTime:0.004683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393553 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393553 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='GSB1CA11101DSHR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1CA11101DSHR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.009033s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393553 AND `partno` = 'GSB1CA11101DSHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195626 [ RunTime:0.001120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394758 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394758 ORDER BY `minOrder` ASC [ RunTime:0.006336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394758 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394758 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394758 ORDER BY `minOrder` ASC [ RunTime:0.002257s ]
select * from pdf where partno='GSB19151TP2EU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB19151TP2EU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.003127s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394758 AND `partno` = 'GSB19151TP2EU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394517 LIMIT 5 [ RunTime:0.005992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394517 ORDER BY `minOrder` ASC [ RunTime:0.003605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394517 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394517 LIMIT 2 [ RunTime:0.006870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394517 ORDER BY `minOrder` ASC [ RunTime:0.002222s ]
select * from pdf where partno='GSB11124KEU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.001707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB11124KEU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.000907s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394517 AND `partno` = 'GSB11124KEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932182 [ RunTime:0.008547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394875 LIMIT 5 [ RunTime:0.004495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394875 ORDER BY `minOrder` ASC [ RunTime:0.001166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394875 ORDER BY `unit` DESC [ RunTime:0.002939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394875 LIMIT 2 [ RunTime:0.013469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394875 ORDER BY `minOrder` ASC [ RunTime:0.002914s ]
select * from pdf where partno='GSB11111ALF' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.007617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB11111ALF' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.001053s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394875 AND `partno` = 'GSB11111ALF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394099 LIMIT 5 [ RunTime:0.001700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394099 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394099 ORDER BY `unit` DESC [ RunTime:0.001032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394099 LIMIT 2 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394099 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
select * from pdf where partno='GSB12221LFRSPEU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.006630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB12221LFRSPEU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.000651s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394099 AND `partno` = 'GSB12221LFRSPEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13196440 [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394520 LIMIT 5 [ RunTime:0.006618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394520 ORDER BY `minOrder` ASC [ RunTime:0.005975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394520 ORDER BY `unit` DESC [ RunTime:0.001705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394520 LIMIT 2 [ RunTime:0.010354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394520 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='GSB19120KHR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.001170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB19120KHR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.007823s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394520 AND `partno` = 'GSB19120KHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.014533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932184 [ RunTime:0.008674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394014 LIMIT 5 [ RunTime:0.004116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394014 ORDER BY `minOrder` ASC [ RunTime:0.001328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394014 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394014 LIMIT 2 [ RunTime:0.003921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394014 ORDER BY `minOrder` ASC [ RunTime:0.001750s ]
select * from pdf where partno='GSB19111KHR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.007027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB19111KHR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.009420s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394014 AND `partno` = 'GSB19111KHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.012316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195369 [ RunTime:0.021311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394031 LIMIT 5 [ RunTime:0.033033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394031 ORDER BY `minOrder` ASC [ RunTime:0.033188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394031 ORDER BY `unit` DESC [ RunTime:0.010283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394031 LIMIT 2 [ RunTime:0.023926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394031 ORDER BY `minOrder` ASC [ RunTime:0.012188s ]
select * from pdf where partno='GSB11111KEU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.007310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB11111KEU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.013751s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394031 AND `partno` = 'GSB11111KEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.016575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11934255 [ RunTime:0.001029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393575 LIMIT 5 [ RunTime:0.006061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393575 ORDER BY `minOrder` ASC [ RunTime:0.011332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393575 ORDER BY `unit` DESC [ RunTime:0.016485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393575 LIMIT 2 [ RunTime:0.011414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393575 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='GSB1C411101DS1HR' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.023924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB1C411101DS1HR' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.009819s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393575 AND `partno` = 'GSB1C411101DS1HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.017058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13195605 [ RunTime:0.023433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394755 LIMIT 5 [ RunTime:0.012332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394755 ORDER BY `minOrder` ASC [ RunTime:0.012419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394755 ORDER BY `unit` DESC [ RunTime:0.014528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394755 LIMIT 2 [ RunTime:0.014647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394755 ORDER BY `minOrder` ASC [ RunTime:0.007241s ]
select * from pdf where partno='GSB12120RSKEU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.003334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB12120RSKEU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.021396s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394755 AND `partno` = 'GSB12120RSKEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932289 [ RunTime:0.011471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59394505 LIMIT 5 [ RunTime:0.023539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394505 ORDER BY `minOrder` ASC [ RunTime:0.054142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59394505 ORDER BY `unit` DESC [ RunTime:0.032501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59394505 LIMIT 2 [ RunTime:0.009946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59394505 ORDER BY `minOrder` ASC [ RunTime:0.051855s ]
select * from pdf where partno='GSB12121RSKEU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.060127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB12121RSKEU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.083728s ]
SELECT `id` FROM `stock` WHERE `id` <> 59394505 AND `partno` = 'GSB12121RSKEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.034726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59393974 LIMIT 5 [ RunTime:0.026616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393974 ORDER BY `minOrder` ASC [ RunTime:0.043048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59393974 ORDER BY `unit` DESC [ RunTime:0.041547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59393974 LIMIT 2 [ RunTime:0.087967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59393974 ORDER BY `minOrder` ASC [ RunTime:0.003306s ]
select * from pdf where partno='GSB12110RSKEU' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.036340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GSB12110RSKEU' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.031936s ]
SELECT `id` FROM `stock` WHERE `id` <> 59393974 AND `partno` = 'GSB12110RSKEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.028552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932666 [ RunTime:0.077677s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032712s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043044s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057081s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013852s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007693s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023116s ]
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 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010253s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'GSB1%' OR `brand` LIKE 'GSB1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016507s ]