SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002717s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=SMBJ75CA&search=1' [ RunTime:0.016131s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001670s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008856s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003280s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.006148s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002946s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005676s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002495s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ75CA' LIMIT 1 [ RunTime:0.014477s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-12 01:24:16' WHERE `partno` = 'SMBJ75CA' [ RunTime:0.023816s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002888s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032374s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663670 LIMIT 5 [ RunTime:0.013324s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663670 ORDER BY `minOrder` ASC [ RunTime:0.019566s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663670 ORDER BY `unit` DESC [ RunTime:0.019628s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663670 LIMIT 2 [ RunTime:0.005515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663670 ORDER BY `minOrder` ASC [ RunTime:0.008892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663425 LIMIT 5 [ RunTime:0.010487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663425 ORDER BY `minOrder` ASC [ RunTime:0.009508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663425 ORDER BY `unit` DESC [ RunTime:0.014852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663425 LIMIT 2 [ RunTime:0.037171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663425 ORDER BY `minOrder` ASC [ RunTime:0.009051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921904 LIMIT 5 [ RunTime:0.026734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921904 ORDER BY `minOrder` ASC [ RunTime:0.011232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921904 ORDER BY `unit` DESC [ RunTime:0.017206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921904 LIMIT 2 [ RunTime:0.034991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921904 ORDER BY `minOrder` ASC [ RunTime:0.023911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905701 LIMIT 5 [ RunTime:0.025524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905701 ORDER BY `minOrder` ASC [ RunTime:0.009560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905701 ORDER BY `unit` DESC [ RunTime:0.042723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905701 LIMIT 2 [ RunTime:0.010298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905701 ORDER BY `minOrder` ASC [ RunTime:0.007157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663971 LIMIT 5 [ RunTime:0.012841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663971 ORDER BY `minOrder` ASC [ RunTime:0.042846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663971 ORDER BY `unit` DESC [ RunTime:0.031495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663971 LIMIT 2 [ RunTime:0.046659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663971 ORDER BY `minOrder` ASC [ RunTime:0.012013s ]
select * from pdf where partno='SMBJ75CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.027428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829449 LIMIT 5 [ RunTime:0.033080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829449 ORDER BY `minOrder` ASC [ RunTime:0.018605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829449 ORDER BY `unit` DESC [ RunTime:0.024893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829449 LIMIT 2 [ RunTime:0.046233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829449 ORDER BY `minOrder` ASC [ RunTime:0.020339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662346 LIMIT 5 [ RunTime:0.039603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662346 ORDER BY `minOrder` ASC [ RunTime:0.032188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662346 ORDER BY `unit` DESC [ RunTime:0.077144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662346 LIMIT 2 [ RunTime:0.020624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662346 ORDER BY `minOrder` ASC [ RunTime:0.014934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828264 LIMIT 5 [ RunTime:0.038735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828264 ORDER BY `minOrder` ASC [ RunTime:0.052035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828264 ORDER BY `unit` DESC [ RunTime:0.017760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828264 LIMIT 2 [ RunTime:0.041408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828264 ORDER BY `minOrder` ASC [ RunTime:0.035072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827505 LIMIT 5 [ RunTime:0.052646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827505 ORDER BY `minOrder` ASC [ RunTime:0.081068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827505 ORDER BY `unit` DESC [ RunTime:0.024868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827505 LIMIT 2 [ RunTime:0.027064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827505 ORDER BY `minOrder` ASC [ RunTime:0.021210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928542 LIMIT 5 [ RunTime:0.047935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928542 ORDER BY `minOrder` ASC [ RunTime:0.041672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928542 ORDER BY `unit` DESC [ RunTime:0.017283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928542 LIMIT 2 [ RunTime:0.018895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928542 ORDER BY `minOrder` ASC [ RunTime:0.023249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800703 LIMIT 5 [ RunTime:0.019179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800703 ORDER BY `minOrder` ASC [ RunTime:0.022085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800703 ORDER BY `unit` DESC [ RunTime:0.023124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800703 LIMIT 2 [ RunTime:0.007311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800703 ORDER BY `minOrder` ASC [ RunTime:0.008794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828274 LIMIT 5 [ RunTime:0.024692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828274 ORDER BY `minOrder` ASC [ RunTime:0.026064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828274 ORDER BY `unit` DESC [ RunTime:0.025135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828274 LIMIT 2 [ RunTime:0.022848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828274 ORDER BY `minOrder` ASC [ RunTime:0.006249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829418 LIMIT 5 [ RunTime:0.006161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829418 ORDER BY `minOrder` ASC [ RunTime:0.019854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829418 ORDER BY `unit` DESC [ RunTime:0.021483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829418 LIMIT 2 [ RunTime:0.025018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829418 ORDER BY `minOrder` ASC [ RunTime:0.013049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815581 LIMIT 5 [ RunTime:0.022109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815581 ORDER BY `minOrder` ASC [ RunTime:0.032209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815581 ORDER BY `unit` DESC [ RunTime:0.014157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815581 LIMIT 2 [ RunTime:0.057941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815581 ORDER BY `minOrder` ASC [ RunTime:0.033461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799709 LIMIT 5 [ RunTime:0.031598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799709 ORDER BY `minOrder` ASC [ RunTime:0.033465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799709 ORDER BY `unit` DESC [ RunTime:0.020281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799709 LIMIT 2 [ RunTime:0.017449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799709 ORDER BY `minOrder` ASC [ RunTime:0.012981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908332 LIMIT 5 [ RunTime:0.003973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908332 ORDER BY `minOrder` ASC [ RunTime:0.011409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908332 ORDER BY `unit` DESC [ RunTime:0.016460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908332 LIMIT 2 [ RunTime:0.036892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908332 ORDER BY `minOrder` ASC [ RunTime:0.025516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803665 LIMIT 5 [ RunTime:0.023904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803665 ORDER BY `minOrder` ASC [ RunTime:0.040134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803665 ORDER BY `unit` DESC [ RunTime:0.093074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803665 LIMIT 2 [ RunTime:0.050045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803665 ORDER BY `minOrder` ASC [ RunTime:0.052569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691492 LIMIT 5 [ RunTime:0.051406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691492 ORDER BY `minOrder` ASC [ RunTime:0.043805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691492 ORDER BY `unit` DESC [ RunTime:0.028203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691492 LIMIT 2 [ RunTime:0.070050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691492 ORDER BY `minOrder` ASC [ RunTime:0.020209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689140 LIMIT 5 [ RunTime:0.022431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689140 ORDER BY `minOrder` ASC [ RunTime:0.022033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689140 ORDER BY `unit` DESC [ RunTime:0.019179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689140 LIMIT 2 [ RunTime:0.043797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689140 ORDER BY `minOrder` ASC [ RunTime:0.000785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673165 LIMIT 5 [ RunTime:0.050873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673165 ORDER BY `minOrder` ASC [ RunTime:0.039530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673165 ORDER BY `unit` DESC [ RunTime:0.031763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673165 LIMIT 2 [ RunTime:0.038005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673165 ORDER BY `minOrder` ASC [ RunTime:0.008632s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141557 LIMIT 5 [ RunTime:0.008528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141557 ORDER BY `minOrder` ASC [ RunTime:0.028799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141557 ORDER BY `unit` DESC [ RunTime:0.061923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141557 LIMIT 2 [ RunTime:0.005461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141557 ORDER BY `minOrder` ASC [ RunTime:0.006668s ]
select * from pdf where partno='smbj75ca-q' and brandshort='bourns' limit 1 [ RunTime:0.024090s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbj75ca-q' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.020340s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161970 LIMIT 5 [ RunTime:0.014934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161970 ORDER BY `minOrder` ASC [ RunTime:0.027722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161970 ORDER BY `unit` DESC [ RunTime:0.031141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161970 LIMIT 2 [ RunTime:0.005329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161970 ORDER BY `minOrder` ASC [ RunTime:0.015317s ]
select * from pdf where partno='SMBJ75CA' and brandshort='MDD' limit 1 [ RunTime:0.058678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.033106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160206 LIMIT 5 [ RunTime:0.014079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160206 ORDER BY `minOrder` ASC [ RunTime:0.036540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160206 ORDER BY `unit` DESC [ RunTime:0.027793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160206 LIMIT 2 [ RunTime:0.025317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160206 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
select * from pdf where partno='SMBJ75CAL0S0DR' and brandshort='NextGen Components' limit 1 [ RunTime:0.028120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CAL0S0DR' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.014181s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160206 AND `partno` = 'SMBJ75CAL0S0DR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.013851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663425 [ RunTime:0.010935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114992 LIMIT 5 [ RunTime:0.010607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114992 ORDER BY `minOrder` ASC [ RunTime:0.007126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114992 ORDER BY `unit` DESC [ RunTime:0.012316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114992 LIMIT 2 [ RunTime:0.023474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114992 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='SMBJ75CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.008690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.012974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42148935 LIMIT 5 [ RunTime:0.016525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148935 ORDER BY `minOrder` ASC [ RunTime:0.019120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42148935 ORDER BY `unit` DESC [ RunTime:0.012688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42148935 LIMIT 2 [ RunTime:0.006836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148935 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
select * from pdf where partno='SMBJ75CA' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.006222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42130335 LIMIT 5 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42130335 ORDER BY `minOrder` ASC [ RunTime:0.015127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42130335 ORDER BY `unit` DESC [ RunTime:0.010122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42130335 LIMIT 2 [ RunTime:0.013812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42130335 ORDER BY `minOrder` ASC [ RunTime:0.006863s ]
select * from pdf where partno='SMBJ75CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.021028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.018506s ]
SELECT `id` FROM `stock` WHERE `id` <> 42130335 AND `partno` = 'SMBJ75CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.004903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829449 [ RunTime:0.028657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42102005 LIMIT 5 [ RunTime:0.024682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102005 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42102005 ORDER BY `unit` DESC [ RunTime:0.007703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42102005 LIMIT 2 [ RunTime:0.005919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102005 ORDER BY `minOrder` ASC [ RunTime:0.003373s ]
select * from pdf where partno='SMBJ75CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.014024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113734 LIMIT 5 [ RunTime:0.015463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113734 ORDER BY `minOrder` ASC [ RunTime:0.052565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113734 ORDER BY `unit` DESC [ RunTime:0.023820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113734 LIMIT 2 [ RunTime:0.042787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113734 ORDER BY `minOrder` ASC [ RunTime:0.004235s ]
select * from pdf where partno='SMBJ75CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.035162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.018641s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113734 AND `partno` = 'SMBJ75CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.014369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662346 [ RunTime:0.035137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42125425 LIMIT 5 [ RunTime:0.027476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125425 ORDER BY `minOrder` ASC [ RunTime:0.030874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42125425 ORDER BY `unit` DESC [ RunTime:0.041179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42125425 LIMIT 2 [ RunTime:0.052850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42125425 ORDER BY `minOrder` ASC [ RunTime:0.020891s ]
select * from pdf where partno='SMBJ75CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.051518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.038149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128154 LIMIT 5 [ RunTime:0.026095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128154 ORDER BY `minOrder` ASC [ RunTime:0.035534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128154 ORDER BY `unit` DESC [ RunTime:0.049821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128154 LIMIT 2 [ RunTime:0.053772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128154 ORDER BY `minOrder` ASC [ RunTime:0.034530s ]
select * from pdf where partno='SMBJ75CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.039317s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128154 AND `partno` = 'SMBJ75CA-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.017667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827505 [ RunTime:0.040742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145561 LIMIT 5 [ RunTime:0.025391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145561 ORDER BY `minOrder` ASC [ RunTime:0.026950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145561 ORDER BY `unit` DESC [ RunTime:0.050609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145561 LIMIT 2 [ RunTime:0.022488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145561 ORDER BY `minOrder` ASC [ RunTime:0.010634s ]
select * from pdf where partno='SMBJ75CAH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.009796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CAH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.031623s ]
SELECT `id` FROM `stock` WHERE `id` <> 42145561 AND `partno` = 'SMBJ75CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.024134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828274 [ RunTime:0.013648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42126412 LIMIT 5 [ RunTime:0.010602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126412 ORDER BY `minOrder` ASC [ RunTime:0.011981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42126412 ORDER BY `unit` DESC [ RunTime:0.010583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42126412 LIMIT 2 [ RunTime:0.018107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126412 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
select * from pdf where partno='SMBJ75CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.006494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.006552s ]
SELECT `id` FROM `stock` WHERE `id` <> 42126412 AND `partno` = 'SMBJ75CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.009815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928542 [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128191 LIMIT 5 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128191 ORDER BY `minOrder` ASC [ RunTime:0.004674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128191 ORDER BY `unit` DESC [ RunTime:0.008337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128191 LIMIT 2 [ RunTime:0.008666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128191 ORDER BY `minOrder` ASC [ RunTime:0.004312s ]
select * from pdf where partno='SMBJ75CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002879s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128191 AND `partno` = 'SMBJ75CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815581 [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42167860 LIMIT 5 [ RunTime:0.000922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167860 ORDER BY `minOrder` ASC [ RunTime:0.004988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42167860 ORDER BY `unit` DESC [ RunTime:0.005625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42167860 LIMIT 2 [ RunTime:0.010594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167860 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
select * from pdf where partno='SMBJ75CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42177965 LIMIT 5 [ RunTime:0.003333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42177965 ORDER BY `minOrder` ASC [ RunTime:0.001251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42177965 ORDER BY `unit` DESC [ RunTime:0.011406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42177965 LIMIT 2 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42177965 ORDER BY `minOrder` ASC [ RunTime:0.007018s ]
select * from pdf where partno='SMBJ75CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.004961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.031502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42409842 LIMIT 5 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409842 ORDER BY `minOrder` ASC [ RunTime:0.015673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42409842 ORDER BY `unit` DESC [ RunTime:0.001303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42409842 LIMIT 2 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409842 ORDER BY `minOrder` ASC [ RunTime:0.001794s ]
select * from pdf where partno='SMBJ75CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001094s ]
SELECT `id` FROM `stock` WHERE `id` <> 42409842 AND `partno` = 'SMBJ75CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823645 [ RunTime:0.005818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42398509 LIMIT 5 [ RunTime:0.007843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398509 ORDER BY `minOrder` ASC [ RunTime:0.004331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42398509 ORDER BY `unit` DESC [ RunTime:0.003088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42398509 LIMIT 2 [ RunTime:0.002212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398509 ORDER BY `minOrder` ASC [ RunTime:0.004788s ]
select * from pdf where partno='SMBJ75CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001287s ]
SELECT `id` FROM `stock` WHERE `id` <> 42398509 AND `partno` = 'SMBJ75CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823406 [ RunTime:0.018113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42269216 LIMIT 5 [ RunTime:0.006357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269216 ORDER BY `minOrder` ASC [ RunTime:0.001216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42269216 ORDER BY `unit` DESC [ RunTime:0.000993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42269216 LIMIT 2 [ RunTime:0.009360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269216 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='SMBJ75CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.001463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.001302s ]
SELECT `id` FROM `stock` WHERE `id` <> 42269216 AND `partno` = 'SMBJ75CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.003227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917380 [ RunTime:0.021505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262896 LIMIT 5 [ RunTime:0.012151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262896 ORDER BY `minOrder` ASC [ RunTime:0.015263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262896 ORDER BY `unit` DESC [ RunTime:0.021495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262896 LIMIT 2 [ RunTime:0.017251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262896 ORDER BY `minOrder` ASC [ RunTime:0.012238s ]
select * from pdf where partno='SMBJ75CA' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.020905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CA' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.030479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42258990 LIMIT 5 [ RunTime:0.019322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258990 ORDER BY `minOrder` ASC [ RunTime:0.008846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42258990 ORDER BY `unit` DESC [ RunTime:0.015366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42258990 LIMIT 2 [ RunTime:0.019907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258990 ORDER BY `minOrder` ASC [ RunTime:0.008848s ]
select * from pdf where partno='SMBJ75CAHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.036957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CAHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004673s ]
SELECT `id` FROM `stock` WHERE `id` <> 42258990 AND `partno` = 'SMBJ75CAHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812891 [ RunTime:0.018702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256806 LIMIT 5 [ RunTime:0.014131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256806 ORDER BY `minOrder` ASC [ RunTime:0.003188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256806 ORDER BY `unit` DESC [ RunTime:0.014454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256806 LIMIT 2 [ RunTime:0.024037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256806 ORDER BY `minOrder` ASC [ RunTime:0.007738s ]
select * from pdf where partno='SMBJ75CAHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.017677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ75CAHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003768s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256806 AND `partno` = 'SMBJ75CAHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915832 [ RunTime:0.001392s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003231s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007217s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006360s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009688s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007526s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002580s ]
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 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001507s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ75CA%' OR `brand` LIKE 'SMBJ75CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014418s ]