SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002520s ]
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=SMBJ250&search=1' [ RunTime:0.004115s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002265s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003475s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.006595s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003305s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004377s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002171s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ250' LIMIT 1 [ RunTime:0.003562s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-16 15:42:51' WHERE `partno` = 'SMBJ250' [ RunTime:0.003115s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001631s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016122s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663641 LIMIT 5 [ RunTime:0.030077s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663641 ORDER BY `minOrder` ASC [ RunTime:0.039682s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663641 ORDER BY `unit` DESC [ RunTime:0.025457s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.021112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663641 LIMIT 2 [ RunTime:0.022317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663641 ORDER BY `minOrder` ASC [ RunTime:0.037201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801936 LIMIT 5 [ RunTime:0.031798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801936 ORDER BY `minOrder` ASC [ RunTime:0.025294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801936 ORDER BY `unit` DESC [ RunTime:0.027930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801936 LIMIT 2 [ RunTime:0.028862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801936 ORDER BY `minOrder` ASC [ RunTime:0.034385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830899 LIMIT 5 [ RunTime:0.087591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830899 ORDER BY `minOrder` ASC [ RunTime:0.021733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830899 ORDER BY `unit` DESC [ RunTime:0.000946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830899 LIMIT 2 [ RunTime:0.050596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830899 ORDER BY `minOrder` ASC [ RunTime:0.006701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692177 LIMIT 5 [ RunTime:0.035728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692177 ORDER BY `minOrder` ASC [ RunTime:0.058201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692177 ORDER BY `unit` DESC [ RunTime:0.079986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692177 LIMIT 2 [ RunTime:0.036588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692177 ORDER BY `minOrder` ASC [ RunTime:0.018926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930849 LIMIT 5 [ RunTime:0.044229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930849 ORDER BY `minOrder` ASC [ RunTime:0.023413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13930849 ORDER BY `unit` DESC [ RunTime:0.103481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13930849 LIMIT 2 [ RunTime:0.034135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930849 ORDER BY `minOrder` ASC [ RunTime:0.038346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818027 LIMIT 5 [ RunTime:0.028425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818027 ORDER BY `minOrder` ASC [ RunTime:0.020403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818027 ORDER BY `unit` DESC [ RunTime:0.010688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818027 LIMIT 2 [ RunTime:0.044382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818027 ORDER BY `minOrder` ASC [ RunTime:0.035910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808312 LIMIT 5 [ RunTime:0.019715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808312 ORDER BY `minOrder` ASC [ RunTime:0.010523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808312 ORDER BY `unit` DESC [ RunTime:0.018702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808312 LIMIT 2 [ RunTime:0.008184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808312 ORDER BY `minOrder` ASC [ RunTime:0.002816s ]
select * from pdf where partno='SMBJ250CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.021445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799710 LIMIT 5 [ RunTime:0.018801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799710 ORDER BY `minOrder` ASC [ RunTime:0.020085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799710 ORDER BY `unit` DESC [ RunTime:0.015591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799710 LIMIT 2 [ RunTime:0.027008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799710 ORDER BY `minOrder` ASC [ RunTime:0.009672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907809 LIMIT 5 [ RunTime:0.023082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907809 ORDER BY `minOrder` ASC [ RunTime:0.027508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907809 ORDER BY `unit` DESC [ RunTime:0.013271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907809 LIMIT 2 [ RunTime:0.000897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907809 ORDER BY `minOrder` ASC [ RunTime:0.009545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908375 LIMIT 5 [ RunTime:0.005981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908375 ORDER BY `minOrder` ASC [ RunTime:0.031445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908375 ORDER BY `unit` DESC [ RunTime:0.015237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908375 LIMIT 2 [ RunTime:0.021708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908375 ORDER BY `minOrder` ASC [ RunTime:0.022327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676744 LIMIT 5 [ RunTime:0.015111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676744 ORDER BY `minOrder` ASC [ RunTime:0.012949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676744 ORDER BY `unit` DESC [ RunTime:0.009288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676744 LIMIT 2 [ RunTime:0.007587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676744 ORDER BY `minOrder` ASC [ RunTime:0.008714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676743 LIMIT 5 [ RunTime:0.005114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676743 ORDER BY `minOrder` ASC [ RunTime:0.013200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676743 ORDER BY `unit` DESC [ RunTime:0.015445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676743 LIMIT 2 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676743 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673487 LIMIT 5 [ RunTime:0.015655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673487 ORDER BY `minOrder` ASC [ RunTime:0.011596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673487 ORDER BY `unit` DESC [ RunTime:0.003562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673487 LIMIT 2 [ RunTime:0.010343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673487 ORDER BY `minOrder` ASC [ RunTime:0.002695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672941 LIMIT 5 [ RunTime:0.001036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672941 ORDER BY `minOrder` ASC [ RunTime:0.003344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672941 ORDER BY `unit` DESC [ RunTime:0.004532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672941 LIMIT 2 [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672941 ORDER BY `minOrder` ASC [ RunTime:0.001709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670006 LIMIT 5 [ RunTime:0.002048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670006 ORDER BY `minOrder` ASC [ RunTime:0.009273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670006 ORDER BY `unit` DESC [ RunTime:0.001669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670006 LIMIT 2 [ RunTime:0.001741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670006 ORDER BY `minOrder` ASC [ RunTime:0.003000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831071 LIMIT 5 [ RunTime:0.002106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831071 ORDER BY `minOrder` ASC [ RunTime:0.019202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831071 ORDER BY `unit` DESC [ RunTime:0.013789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831071 LIMIT 2 [ RunTime:0.007999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831071 ORDER BY `minOrder` ASC [ RunTime:0.002394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820059 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820059 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820059 ORDER BY `unit` DESC [ RunTime:0.008700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820059 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820059 ORDER BY `minOrder` ASC [ RunTime:0.001874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817163 LIMIT 5 [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817163 ORDER BY `minOrder` ASC [ RunTime:0.014623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817163 ORDER BY `unit` DESC [ RunTime:0.009109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817163 LIMIT 2 [ RunTime:0.002620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817163 ORDER BY `minOrder` ASC [ RunTime:0.000992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817162 LIMIT 5 [ RunTime:0.036360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817162 ORDER BY `minOrder` ASC [ RunTime:0.002934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817162 ORDER BY `unit` DESC [ RunTime:0.003520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817162 LIMIT 2 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817162 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809236 LIMIT 5 [ RunTime:0.010040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809236 ORDER BY `minOrder` ASC [ RunTime:0.011941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809236 ORDER BY `unit` DESC [ RunTime:0.002351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809236 LIMIT 2 [ RunTime:0.014663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809236 ORDER BY `minOrder` ASC [ RunTime:0.002697s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141553 LIMIT 5 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141553 ORDER BY `minOrder` ASC [ RunTime:0.007389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141553 ORDER BY `unit` DESC [ RunTime:0.000837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141553 LIMIT 2 [ RunTime:0.000777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141553 ORDER BY `minOrder` ASC [ RunTime:0.004341s ]
select * from pdf where partno='smbj250a' and brandshort='bourns' limit 1 [ RunTime:0.009231s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbj250a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.016697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141186 LIMIT 5 [ RunTime:0.005264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141186 ORDER BY `minOrder` ASC [ RunTime:0.004320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141186 ORDER BY `unit` DESC [ RunTime:0.004165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141186 LIMIT 2 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141186 ORDER BY `minOrder` ASC [ RunTime:0.002892s ]
select * from pdf where partno='smbj250a' and brandshort='littelfuse' limit 1 [ RunTime:0.009963s ]
select foldpath,foldpath2,filename from pdf_file where id=422397 limit 1 [ RunTime:0.005734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbj250a' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.036181s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161589 LIMIT 5 [ RunTime:0.005977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161589 ORDER BY `minOrder` ASC [ RunTime:0.006936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161589 ORDER BY `unit` DESC [ RunTime:0.018951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161589 LIMIT 2 [ RunTime:0.008320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161589 ORDER BY `minOrder` ASC [ RunTime:0.015062s ]
select * from pdf where partno='SMBJ250AL0S0PZ' and brandshort='NextGen Components' limit 1 [ RunTime:0.010350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250AL0S0PZ' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.013692s ]
SELECT `id` FROM `stock` WHERE `id` <> 42161589 AND `partno` = 'SMBJ250AL0S0PZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.002035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663641 [ RunTime:0.012392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161577 LIMIT 5 [ RunTime:0.004754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161577 ORDER BY `minOrder` ASC [ RunTime:0.008636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161577 ORDER BY `unit` DESC [ RunTime:0.022847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161577 LIMIT 2 [ RunTime:0.009829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161577 ORDER BY `minOrder` ASC [ RunTime:0.019187s ]
select * from pdf where partno='SMBJ250CALS0EZ' and brandshort='NextGen Components' limit 1 [ RunTime:0.010260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CALS0EZ' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.013775s ]
SELECT `id` FROM `stock` WHERE `id` <> 42161577 AND `partno` = 'SMBJ250CALS0EZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801936 [ RunTime:0.012569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117018 LIMIT 5 [ RunTime:0.012167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117018 ORDER BY `minOrder` ASC [ RunTime:0.023408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117018 ORDER BY `unit` DESC [ RunTime:0.006298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117018 LIMIT 2 [ RunTime:0.003113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117018 ORDER BY `minOrder` ASC [ RunTime:0.008877s ]
select * from pdf where partno='SMBJ250A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006085s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117018 AND `partno` = 'SMBJ250A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.006306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830899 [ RunTime:0.000567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118064 LIMIT 5 [ RunTime:0.009217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118064 ORDER BY `minOrder` ASC [ RunTime:0.017880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118064 ORDER BY `unit` DESC [ RunTime:0.014781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118064 LIMIT 2 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118064 ORDER BY `minOrder` ASC [ RunTime:0.008429s ]
select * from pdf where partno='SMBJ250CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.012613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.019169s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118064 AND `partno` = 'SMBJ250CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.026117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692177 [ RunTime:0.007452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104915 LIMIT 5 [ RunTime:0.010678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104915 ORDER BY `minOrder` ASC [ RunTime:0.012529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104915 ORDER BY `unit` DESC [ RunTime:0.002801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104915 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104915 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='SMBJ250CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000941s ]
SELECT `id` FROM `stock` WHERE `id` <> 42104915 AND `partno` = 'SMBJ250CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.009579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808312 [ RunTime:0.005330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104521 LIMIT 5 [ RunTime:0.015777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104521 ORDER BY `minOrder` ASC [ RunTime:0.003900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104521 ORDER BY `unit` DESC [ RunTime:0.001479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104521 LIMIT 2 [ RunTime:0.014249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104521 ORDER BY `minOrder` ASC [ RunTime:0.006025s ]
select * from pdf where partno='SMBJ250A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003327s ]
SELECT `id` FROM `stock` WHERE `id` <> 42104521 AND `partno` = 'SMBJ250A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.014236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803982 [ RunTime:0.011381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42111965 LIMIT 5 [ RunTime:0.001390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111965 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42111965 ORDER BY `unit` DESC [ RunTime:0.005227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42111965 LIMIT 2 [ RunTime:0.007113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111965 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='SMBJ250CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.017597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.012039s ]
SELECT `id` FROM `stock` WHERE `id` <> 42111965 AND `partno` = 'SMBJ250CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.007035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818027 [ RunTime:0.008480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152577 LIMIT 5 [ RunTime:0.009560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152577 ORDER BY `minOrder` ASC [ RunTime:0.011585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152577 ORDER BY `unit` DESC [ RunTime:0.009912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152577 LIMIT 2 [ RunTime:0.015131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152577 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='SMBJ250CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.004061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.018833s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152577 AND `partno` = 'SMBJ250CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.011666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930849 [ RunTime:0.006308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150223 LIMIT 5 [ RunTime:0.008177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150223 ORDER BY `minOrder` ASC [ RunTime:0.007916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150223 ORDER BY `unit` DESC [ RunTime:0.001750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150223 LIMIT 2 [ RunTime:0.006894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150223 ORDER BY `minOrder` ASC [ RunTime:0.006845s ]
select * from pdf where partno='SMBJ250CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.006355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.005732s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150223 AND `partno` = 'SMBJ250CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.007823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109585 LIMIT 5 [ RunTime:0.014010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109585 ORDER BY `minOrder` ASC [ RunTime:0.025910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109585 ORDER BY `unit` DESC [ RunTime:0.009640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109585 LIMIT 2 [ RunTime:0.001943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109585 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='SMBJ250CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.006910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42296420 LIMIT 5 [ RunTime:0.003333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296420 ORDER BY `minOrder` ASC [ RunTime:0.001308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42296420 ORDER BY `unit` DESC [ RunTime:0.007733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42296420 LIMIT 2 [ RunTime:0.012336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296420 ORDER BY `minOrder` ASC [ RunTime:0.003286s ]
select * from pdf where partno='SMBJ250A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000610s ]
SELECT `id` FROM `stock` WHERE `id` <> 42296420 AND `partno` = 'SMBJ250A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820059 [ RunTime:0.002831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42286680 LIMIT 5 [ RunTime:0.003030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42286680 ORDER BY `minOrder` ASC [ RunTime:0.013232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42286680 ORDER BY `unit` DESC [ RunTime:0.000719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42286680 LIMIT 2 [ RunTime:0.002745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42286680 ORDER BY `minOrder` ASC [ RunTime:0.015138s ]
select * from pdf where partno='SMBJ250CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.005386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.004411s ]
SELECT `id` FROM `stock` WHERE `id` <> 42286680 AND `partno` = 'SMBJ250CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.020073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676743 [ RunTime:0.005490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42285527 LIMIT 5 [ RunTime:0.001895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285527 ORDER BY `minOrder` ASC [ RunTime:0.002642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42285527 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42285527 LIMIT 2 [ RunTime:0.005137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285527 ORDER BY `minOrder` ASC [ RunTime:0.003453s ]
select * from pdf where partno='SMBJ250CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.015386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000881s ]
SELECT `id` FROM `stock` WHERE `id` <> 42285527 AND `partno` = 'SMBJ250CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.001535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676744 [ RunTime:0.003767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42285170 LIMIT 5 [ RunTime:0.007207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285170 ORDER BY `minOrder` ASC [ RunTime:0.009014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42285170 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42285170 LIMIT 2 [ RunTime:0.001039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285170 ORDER BY `minOrder` ASC [ RunTime:0.015264s ]
select * from pdf where partno='SMBJ250E3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.007321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250E3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.002789s ]
SELECT `id` FROM `stock` WHERE `id` <> 42285170 AND `partno` = 'SMBJ250E3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.003037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817163 [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42285169 LIMIT 5 [ RunTime:0.001906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285169 ORDER BY `minOrder` ASC [ RunTime:0.002203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42285169 ORDER BY `unit` DESC [ RunTime:0.007474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42285169 LIMIT 2 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285169 ORDER BY `minOrder` ASC [ RunTime:0.002750s ]
select * from pdf where partno='SMBJ250AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.001581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.004093s ]
SELECT `id` FROM `stock` WHERE `id` <> 42285169 AND `partno` = 'SMBJ250AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.019449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817162 [ RunTime:0.007295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245334 LIMIT 5 [ RunTime:0.007256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245334 ORDER BY `minOrder` ASC [ RunTime:0.010735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245334 ORDER BY `unit` DESC [ RunTime:0.007059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245334 LIMIT 2 [ RunTime:0.036437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245334 ORDER BY `minOrder` ASC [ RunTime:0.007100s ]
select * from pdf where partno='SMBJ250CAL-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.024589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CAL-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.045337s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245334 AND `partno` = 'SMBJ250CAL-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.008796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672941 [ RunTime:0.014956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42223293 LIMIT 5 [ RunTime:0.007039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223293 ORDER BY `minOrder` ASC [ RunTime:0.018855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42223293 ORDER BY `unit` DESC [ RunTime:0.004106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42223293 LIMIT 2 [ RunTime:0.003163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223293 ORDER BY `minOrder` ASC [ RunTime:0.011344s ]
select * from pdf where partno='SMBJ250CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.018208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.022834s ]
SELECT `id` FROM `stock` WHERE `id` <> 42223293 AND `partno` = 'SMBJ250CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.046335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673487 [ RunTime:0.032906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221874 LIMIT 5 [ RunTime:0.021327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221874 ORDER BY `minOrder` ASC [ RunTime:0.043473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221874 ORDER BY `unit` DESC [ RunTime:0.032233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221874 LIMIT 2 [ RunTime:0.027579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221874 ORDER BY `minOrder` ASC [ RunTime:0.016319s ]
select * from pdf where partno='SMBJ250AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.015726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.018198s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221874 AND `partno` = 'SMBJ250AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.017481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912216 [ RunTime:0.035211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221079 LIMIT 5 [ RunTime:0.018268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221079 ORDER BY `minOrder` ASC [ RunTime:0.028254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221079 ORDER BY `unit` DESC [ RunTime:0.006120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221079 LIMIT 2 [ RunTime:0.010980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221079 ORDER BY `minOrder` ASC [ RunTime:0.008352s ]
select * from pdf where partno='SMBJ250A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.004884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.011666s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221079 AND `partno` = 'SMBJ250A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.006606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911107 [ RunTime:0.026747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215523 LIMIT 5 [ RunTime:0.001665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215523 ORDER BY `minOrder` ASC [ RunTime:0.002280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215523 ORDER BY `unit` DESC [ RunTime:0.006921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215523 LIMIT 2 [ RunTime:0.024028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215523 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
select * from pdf where partno='SMBJ250A-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.001914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ250A-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.012481s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215523 AND `partno` = 'SMBJ250A-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.003376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913082 [ RunTime:0.013654s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003712s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003346s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008480s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011876s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017898s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016172s ]
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 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009459s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ250%' OR `brand` LIKE 'SMBJ250%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017102s ]