SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001577s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=ISP521-1&search=1' [ RunTime:0.003250s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002100s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010792s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002172s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.015619s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001761s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005683s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001951s ]
SELECT * FROM `stock_search` WHERE `partno` = 'ISP521-1' LIMIT 1 [ RunTime:0.053266s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-17 12:11:06' WHERE `partno` = 'ISP521-1' [ RunTime:0.014586s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001512s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023331s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692052 LIMIT 5 [ RunTime:0.009793s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692052 ORDER BY `minOrder` ASC [ RunTime:0.017750s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692052 ORDER BY `unit` DESC [ RunTime:0.005181s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692052 LIMIT 2 [ RunTime:0.001477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692052 ORDER BY `minOrder` ASC [ RunTime:0.004102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690896 LIMIT 5 [ RunTime:0.024855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690896 ORDER BY `minOrder` ASC [ RunTime:0.013783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690896 ORDER BY `unit` DESC [ RunTime:0.019230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690896 LIMIT 2 [ RunTime:0.004938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690896 ORDER BY `minOrder` ASC [ RunTime:0.004647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991426 LIMIT 5 [ RunTime:0.021533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991426 ORDER BY `minOrder` ASC [ RunTime:0.004083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991426 ORDER BY `unit` DESC [ RunTime:0.005093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991426 LIMIT 2 [ RunTime:0.003836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991426 ORDER BY `minOrder` ASC [ RunTime:0.002880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690898 LIMIT 5 [ RunTime:0.004069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690898 ORDER BY `minOrder` ASC [ RunTime:0.002305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690898 ORDER BY `unit` DESC [ RunTime:0.002277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690898 LIMIT 2 [ RunTime:0.015403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690898 ORDER BY `minOrder` ASC [ RunTime:0.002072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691666 LIMIT 5 [ RunTime:0.004917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691666 ORDER BY `minOrder` ASC [ RunTime:0.006340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691666 ORDER BY `unit` DESC [ RunTime:0.008815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691666 LIMIT 2 [ RunTime:0.005370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691666 ORDER BY `minOrder` ASC [ RunTime:0.002676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691655 LIMIT 5 [ RunTime:0.016572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691655 ORDER BY `minOrder` ASC [ RunTime:0.011934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691655 ORDER BY `unit` DESC [ RunTime:0.006750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691655 LIMIT 2 [ RunTime:0.010571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691655 ORDER BY `minOrder` ASC [ RunTime:0.006903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691652 LIMIT 5 [ RunTime:0.006260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691652 ORDER BY `minOrder` ASC [ RunTime:0.002487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691652 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691652 LIMIT 2 [ RunTime:0.011034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691652 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991530 LIMIT 5 [ RunTime:0.003804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991530 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991530 ORDER BY `unit` DESC [ RunTime:0.015188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991530 LIMIT 2 [ RunTime:0.013575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991530 ORDER BY `minOrder` ASC [ RunTime:0.003494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691668 LIMIT 5 [ RunTime:0.005190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691668 ORDER BY `minOrder` ASC [ RunTime:0.026297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691668 ORDER BY `unit` DESC [ RunTime:0.023478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691668 LIMIT 2 [ RunTime:0.017039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691668 ORDER BY `minOrder` ASC [ RunTime:0.011361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691600 LIMIT 5 [ RunTime:0.005388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691600 ORDER BY `minOrder` ASC [ RunTime:0.019565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691600 ORDER BY `unit` DESC [ RunTime:0.034938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691600 LIMIT 2 [ RunTime:0.019141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691600 ORDER BY `minOrder` ASC [ RunTime:0.003754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691681 LIMIT 5 [ RunTime:0.015248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691681 ORDER BY `minOrder` ASC [ RunTime:0.021456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691681 ORDER BY `unit` DESC [ RunTime:0.016256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691681 LIMIT 2 [ RunTime:0.019668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691681 ORDER BY `minOrder` ASC [ RunTime:0.013521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691689 LIMIT 5 [ RunTime:0.038890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691689 ORDER BY `minOrder` ASC [ RunTime:0.015329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691689 ORDER BY `unit` DESC [ RunTime:0.006172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691689 LIMIT 2 [ RunTime:0.006940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691689 ORDER BY `minOrder` ASC [ RunTime:0.005236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692167 LIMIT 5 [ RunTime:0.011323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692167 ORDER BY `minOrder` ASC [ RunTime:0.003785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692167 ORDER BY `unit` DESC [ RunTime:0.022648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692167 LIMIT 2 [ RunTime:0.011466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692167 ORDER BY `minOrder` ASC [ RunTime:0.001810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692104 LIMIT 5 [ RunTime:0.006452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692104 ORDER BY `minOrder` ASC [ RunTime:0.008259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692104 ORDER BY `unit` DESC [ RunTime:0.015317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692104 LIMIT 2 [ RunTime:0.011472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692104 ORDER BY `minOrder` ASC [ RunTime:0.011015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692036 LIMIT 5 [ RunTime:0.025792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692036 ORDER BY `minOrder` ASC [ RunTime:0.028130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692036 ORDER BY `unit` DESC [ RunTime:0.010448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692036 LIMIT 2 [ RunTime:0.019389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692036 ORDER BY `minOrder` ASC [ RunTime:0.004173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692035 LIMIT 5 [ RunTime:0.003856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692035 ORDER BY `minOrder` ASC [ RunTime:0.008150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692035 ORDER BY `unit` DESC [ RunTime:0.008954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692035 LIMIT 2 [ RunTime:0.025092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692035 ORDER BY `minOrder` ASC [ RunTime:0.010580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692032 LIMIT 5 [ RunTime:0.012473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692032 ORDER BY `minOrder` ASC [ RunTime:0.022454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692032 ORDER BY `unit` DESC [ RunTime:0.015443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692032 LIMIT 2 [ RunTime:0.006174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692032 ORDER BY `minOrder` ASC [ RunTime:0.004069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691981 LIMIT 5 [ RunTime:0.012864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691981 ORDER BY `minOrder` ASC [ RunTime:0.021734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691981 ORDER BY `unit` DESC [ RunTime:0.015292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691981 LIMIT 2 [ RunTime:0.009231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691981 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991690 LIMIT 5 [ RunTime:0.006173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991690 ORDER BY `minOrder` ASC [ RunTime:0.013198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991690 ORDER BY `unit` DESC [ RunTime:0.010103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991690 LIMIT 2 [ RunTime:0.005404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991690 ORDER BY `minOrder` ASC [ RunTime:0.006409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991664 LIMIT 5 [ RunTime:0.006429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991664 ORDER BY `minOrder` ASC [ RunTime:0.007331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991664 ORDER BY `unit` DESC [ RunTime:0.008522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991664 LIMIT 2 [ RunTime:0.009010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991664 ORDER BY `minOrder` ASC [ RunTime:0.006098s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007857s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262751 LIMIT 5 [ RunTime:0.010135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262751 ORDER BY `minOrder` ASC [ RunTime:0.004783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262751 ORDER BY `unit` DESC [ RunTime:0.010747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262751 LIMIT 2 [ RunTime:0.009417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262751 ORDER BY `minOrder` ASC [ RunTime:0.005434s ]
select * from pdf where partno='ISP521-1XGBSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.009422s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XGBSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.009823s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262751 AND `partno` = 'ISP521-1XGBSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.032161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690896 [ RunTime:0.006656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262759 LIMIT 5 [ RunTime:0.008498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262759 ORDER BY `minOrder` ASC [ RunTime:0.023331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262759 ORDER BY `unit` DESC [ RunTime:0.017612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262759 LIMIT 2 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262759 ORDER BY `minOrder` ASC [ RunTime:0.000998s ]
select * from pdf where partno='ISP521-1XBLSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.002973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XBLSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006085s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262759 AND `partno` = 'ISP521-1XBLSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.007675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991426 [ RunTime:0.002995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262762 LIMIT 5 [ RunTime:0.002219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262762 ORDER BY `minOrder` ASC [ RunTime:0.005527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262762 ORDER BY `unit` DESC [ RunTime:0.009528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262762 LIMIT 2 [ RunTime:0.009731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262762 ORDER BY `minOrder` ASC [ RunTime:0.001772s ]
select * from pdf where partno='ISP521-1XSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.004252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.011145s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262762 AND `partno` = 'ISP521-1XSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.008264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690898 [ RunTime:0.024100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260248 LIMIT 5 [ RunTime:0.021538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260248 ORDER BY `minOrder` ASC [ RunTime:0.035195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260248 ORDER BY `unit` DESC [ RunTime:0.019766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260248 LIMIT 2 [ RunTime:0.008453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260248 ORDER BY `minOrder` ASC [ RunTime:0.005948s ]
select * from pdf where partno='ISP521-1X' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.018547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1X' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.013200s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260248 AND `partno` = 'ISP521-1X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.018115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692052 [ RunTime:0.016331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263157 LIMIT 5 [ RunTime:0.007686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263157 ORDER BY `minOrder` ASC [ RunTime:0.017177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263157 ORDER BY `unit` DESC [ RunTime:0.019897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263157 LIMIT 2 [ RunTime:0.028028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263157 ORDER BY `minOrder` ASC [ RunTime:0.004783s ]
select * from pdf where partno='ISP521-1XGBSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.025017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XGBSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.055899s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263157 AND `partno` = 'ISP521-1XGBSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.044416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691666 [ RunTime:0.067404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263146 LIMIT 5 [ RunTime:0.030928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263146 ORDER BY `minOrder` ASC [ RunTime:0.051493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263146 ORDER BY `unit` DESC [ RunTime:0.025553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263146 LIMIT 2 [ RunTime:0.012803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263146 ORDER BY `minOrder` ASC [ RunTime:0.080252s ]
select * from pdf where partno='ISP521-1XBLG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.017491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XBLG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.020049s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263146 AND `partno` = 'ISP521-1XBLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.016332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691655 [ RunTime:0.017298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263138 LIMIT 5 [ RunTime:0.020175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263138 ORDER BY `minOrder` ASC [ RunTime:0.044096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263138 ORDER BY `unit` DESC [ RunTime:0.030537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263138 LIMIT 2 [ RunTime:0.044025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263138 ORDER BY `minOrder` ASC [ RunTime:0.017613s ]
select * from pdf where partno='ISP521-1XBLSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.036642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XBLSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.013124s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263138 AND `partno` = 'ISP521-1XBLSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.061637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691652 [ RunTime:0.030285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263188 LIMIT 5 [ RunTime:0.035475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263188 ORDER BY `minOrder` ASC [ RunTime:0.042947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263188 ORDER BY `unit` DESC [ RunTime:0.039344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263188 LIMIT 2 [ RunTime:0.065003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263188 ORDER BY `minOrder` ASC [ RunTime:0.004681s ]
select * from pdf where partno='ISP521-1XGBG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XGBG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.031556s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263188 AND `partno` = 'ISP521-1XGBG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.015637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691668 [ RunTime:0.008472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263770 LIMIT 5 [ RunTime:0.016754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263770 ORDER BY `minOrder` ASC [ RunTime:0.034776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263770 ORDER BY `unit` DESC [ RunTime:0.012319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263770 LIMIT 2 [ RunTime:0.007017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263770 ORDER BY `minOrder` ASC [ RunTime:0.009970s ]
select * from pdf where partno='ISP521-1XBL' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.007939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XBL' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.010623s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263770 AND `partno` = 'ISP521-1XBL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.022035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991530 [ RunTime:0.014215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263773 LIMIT 5 [ RunTime:0.003146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263773 ORDER BY `minOrder` ASC [ RunTime:0.006447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263773 ORDER BY `unit` DESC [ RunTime:0.007499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263773 LIMIT 2 [ RunTime:0.008551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263773 ORDER BY `minOrder` ASC [ RunTime:0.011828s ]
select * from pdf where partno='ISP521-1XGB' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XGB' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.005678s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263773 AND `partno` = 'ISP521-1XGB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.020308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691600 [ RunTime:0.004960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263171 LIMIT 5 [ RunTime:0.019734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263171 ORDER BY `minOrder` ASC [ RunTime:0.042729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263171 ORDER BY `unit` DESC [ RunTime:0.042798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263171 LIMIT 2 [ RunTime:0.038224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263171 ORDER BY `minOrder` ASC [ RunTime:0.017110s ]
select * from pdf where partno='ISP521-1XG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.048857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.089068s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263171 AND `partno` = 'ISP521-1XG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.072319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691681 [ RunTime:0.014980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263791 LIMIT 5 [ RunTime:0.019217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263791 ORDER BY `minOrder` ASC [ RunTime:0.026876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263791 ORDER BY `unit` DESC [ RunTime:0.060974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263791 LIMIT 2 [ RunTime:0.031308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263791 ORDER BY `minOrder` ASC [ RunTime:0.043271s ]
select * from pdf where partno='ISP521-1XSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.046341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1XSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.037768s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263791 AND `partno` = 'ISP521-1XSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.081348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691689 [ RunTime:0.026141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264632 LIMIT 5 [ RunTime:0.021255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264632 ORDER BY `minOrder` ASC [ RunTime:0.015555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264632 ORDER BY `unit` DESC [ RunTime:0.041516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264632 LIMIT 2 [ RunTime:0.025321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264632 ORDER BY `minOrder` ASC [ RunTime:0.022990s ]
select * from pdf where partno='ISP521-1BLSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.024935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1BLSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.026655s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264632 AND `partno` = 'ISP521-1BLSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.027944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991690 [ RunTime:0.027137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264621 LIMIT 5 [ RunTime:0.019512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264621 ORDER BY `minOrder` ASC [ RunTime:0.032852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264621 ORDER BY `unit` DESC [ RunTime:0.027992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264621 LIMIT 2 [ RunTime:0.009692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264621 ORDER BY `minOrder` ASC [ RunTime:0.002800s ]
select * from pdf where partno='ISP521-1GBSMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.015779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1GBSMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.026687s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264621 AND `partno` = 'ISP521-1GBSMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.006833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171142 [ RunTime:0.014726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264609 LIMIT 5 [ RunTime:0.001141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264609 ORDER BY `minOrder` ASC [ RunTime:0.012249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264609 ORDER BY `unit` DESC [ RunTime:0.029773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264609 LIMIT 2 [ RunTime:0.019375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264609 ORDER BY `minOrder` ASC [ RunTime:0.005130s ]
select * from pdf where partno='ISP521-1SMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.000897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1SMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.020160s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264609 AND `partno` = 'ISP521-1SMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.009562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692167 [ RunTime:0.002192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264512 LIMIT 5 [ RunTime:0.006855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264512 ORDER BY `minOrder` ASC [ RunTime:0.031385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264512 ORDER BY `unit` DESC [ RunTime:0.022788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264512 LIMIT 2 [ RunTime:0.019495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264512 ORDER BY `minOrder` ASC [ RunTime:0.006016s ]
select * from pdf where partno='ISP521-1BLSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.016534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1BLSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006705s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264512 AND `partno` = 'ISP521-1BLSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.007869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171130 [ RunTime:0.002381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264506 LIMIT 5 [ RunTime:0.012339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264506 ORDER BY `minOrder` ASC [ RunTime:0.009956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264506 ORDER BY `unit` DESC [ RunTime:0.003339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264506 LIMIT 2 [ RunTime:0.002158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264506 ORDER BY `minOrder` ASC [ RunTime:0.006514s ]
select * from pdf where partno='ISP521-1GBSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1GBSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.011917s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264506 AND `partno` = 'ISP521-1GBSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.003159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991664 [ RunTime:0.005807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264494 LIMIT 5 [ RunTime:0.006352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264494 ORDER BY `minOrder` ASC [ RunTime:0.008585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264494 ORDER BY `unit` DESC [ RunTime:0.002604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264494 LIMIT 2 [ RunTime:0.004647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264494 ORDER BY `minOrder` ASC [ RunTime:0.006146s ]
select * from pdf where partno='ISP521-1SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.010788s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264494 AND `partno` = 'ISP521-1SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.001553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692104 [ RunTime:0.008864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264484 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264484 ORDER BY `minOrder` ASC [ RunTime:0.003632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264484 ORDER BY `unit` DESC [ RunTime:0.009260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264484 LIMIT 2 [ RunTime:0.012850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264484 ORDER BY `minOrder` ASC [ RunTime:0.006855s ]
select * from pdf where partno='ISP521-1BLG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.007547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1BLG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.013809s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264484 AND `partno` = 'ISP521-1BLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.017397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692036 [ RunTime:0.022445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64264483 LIMIT 5 [ RunTime:0.019621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264483 ORDER BY `minOrder` ASC [ RunTime:0.013356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64264483 ORDER BY `unit` DESC [ RunTime:0.013724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64264483 LIMIT 2 [ RunTime:0.008554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64264483 ORDER BY `minOrder` ASC [ RunTime:0.004063s ]
select * from pdf where partno='ISP521-1G' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISP521-1G' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.011239s ]
SELECT `id` FROM `stock` WHERE `id` <> 64264483 AND `partno` = 'ISP521-1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.006241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692035 [ RunTime:0.000667s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001301s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013173s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012326s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009650s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002148s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003577s ]
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 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012451s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ISP521-1%' OR `brand` LIKE 'ISP521-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010325s ]