SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002276s ]
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=1.5smc150a&search=1' [ RunTime:0.004726s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001680s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004979s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001593s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.001718s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001279s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001604s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001123s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5smc150a' LIMIT 1 [ RunTime:0.019921s ]
UPDATE `stock_search` SET `count` = 17 , `updatetime` = '2026-08-18 01:21:03' WHERE `partno` = '1.5smc150a' [ RunTime:0.010413s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001329s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026753s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679227 LIMIT 5 [ RunTime:0.037194s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679227 ORDER BY `minOrder` ASC [ RunTime:0.025753s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679227 ORDER BY `unit` DESC [ RunTime:0.021898s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679227 LIMIT 2 [ RunTime:0.027282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679227 ORDER BY `minOrder` ASC [ RunTime:0.017712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907391 LIMIT 5 [ RunTime:0.016723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907391 ORDER BY `minOrder` ASC [ RunTime:0.014989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907391 ORDER BY `unit` DESC [ RunTime:0.030063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907391 LIMIT 2 [ RunTime:0.068668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907391 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803708 LIMIT 5 [ RunTime:0.059307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803708 ORDER BY `minOrder` ASC [ RunTime:0.062168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803708 ORDER BY `unit` DESC [ RunTime:0.081658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803708 LIMIT 2 [ RunTime:0.103984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803708 ORDER BY `minOrder` ASC [ RunTime:0.038730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908246 LIMIT 5 [ RunTime:0.021026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908246 ORDER BY `minOrder` ASC [ RunTime:0.009216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908246 ORDER BY `unit` DESC [ RunTime:0.021871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908246 LIMIT 2 [ RunTime:0.012628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908246 ORDER BY `minOrder` ASC [ RunTime:0.015508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802861 LIMIT 5 [ RunTime:0.020929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802861 ORDER BY `minOrder` ASC [ RunTime:0.002550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802861 ORDER BY `unit` DESC [ RunTime:0.005477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802861 LIMIT 2 [ RunTime:0.006712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802861 ORDER BY `minOrder` ASC [ RunTime:0.005627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692017 LIMIT 5 [ RunTime:0.012195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692017 ORDER BY `minOrder` ASC [ RunTime:0.008874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692017 ORDER BY `unit` DESC [ RunTime:0.010559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692017 LIMIT 2 [ RunTime:0.002597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692017 ORDER BY `minOrder` ASC [ RunTime:0.019810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691200 LIMIT 5 [ RunTime:0.014110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691200 ORDER BY `minOrder` ASC [ RunTime:0.009666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691200 ORDER BY `unit` DESC [ RunTime:0.011511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691200 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691200 ORDER BY `minOrder` ASC [ RunTime:0.002418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689286 LIMIT 5 [ RunTime:0.005480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689286 ORDER BY `minOrder` ASC [ RunTime:0.002721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689286 ORDER BY `unit` DESC [ RunTime:0.003416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689286 LIMIT 2 [ RunTime:0.012684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689286 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673665 LIMIT 5 [ RunTime:0.004827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673665 ORDER BY `minOrder` ASC [ RunTime:0.009266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673665 ORDER BY `unit` DESC [ RunTime:0.006920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673665 LIMIT 2 [ RunTime:0.004074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673665 ORDER BY `minOrder` ASC [ RunTime:0.008568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673291 LIMIT 5 [ RunTime:0.006549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673291 ORDER BY `minOrder` ASC [ RunTime:0.001913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673291 ORDER BY `unit` DESC [ RunTime:0.018257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673291 LIMIT 2 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673291 ORDER BY `minOrder` ASC [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672811 LIMIT 5 [ RunTime:0.001715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672811 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672811 ORDER BY `unit` DESC [ RunTime:0.000599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672811 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672811 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832440 LIMIT 5 [ RunTime:0.008128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832440 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832440 ORDER BY `unit` DESC [ RunTime:0.006983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832440 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832440 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815054 LIMIT 5 [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815054 ORDER BY `minOrder` ASC [ RunTime:0.004947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815054 ORDER BY `unit` DESC [ RunTime:0.007344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815054 LIMIT 2 [ RunTime:0.007266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815054 ORDER BY `minOrder` ASC [ RunTime:0.004209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814972 LIMIT 5 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814972 ORDER BY `minOrder` ASC [ RunTime:0.002822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814972 ORDER BY `unit` DESC [ RunTime:0.000696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814972 LIMIT 2 [ RunTime:0.001507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814972 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814007 LIMIT 5 [ RunTime:0.001292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814007 ORDER BY `minOrder` ASC [ RunTime:0.005504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814007 ORDER BY `unit` DESC [ RunTime:0.021326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814007 LIMIT 2 [ RunTime:0.006704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814007 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932096 LIMIT 5 [ RunTime:0.001215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932096 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932096 ORDER BY `unit` DESC [ RunTime:0.001820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932096 LIMIT 2 [ RunTime:0.002750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932096 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931907 LIMIT 5 [ RunTime:0.003088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931907 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931907 ORDER BY `unit` DESC [ RunTime:0.009154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931907 LIMIT 2 [ RunTime:0.002083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931907 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931906 LIMIT 5 [ RunTime:0.001166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931906 ORDER BY `minOrder` ASC [ RunTime:0.004674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931906 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931906 LIMIT 2 [ RunTime:0.001313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931906 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929244 LIMIT 5 [ RunTime:0.000999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929244 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13929244 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13929244 LIMIT 2 [ RunTime:0.014073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929244 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917699 LIMIT 5 [ RunTime:0.008025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917699 ORDER BY `minOrder` ASC [ RunTime:0.010322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917699 ORDER BY `unit` DESC [ RunTime:0.002489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917699 LIMIT 2 [ RunTime:0.004392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917699 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141653 LIMIT 5 [ RunTime:0.001430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141653 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141653 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141653 LIMIT 2 [ RunTime:0.007945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141653 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
select * from pdf where partno='1.5smc150a' and brandshort='bourns' limit 1 [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc150a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.000445s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118095 LIMIT 5 [ RunTime:0.006167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118095 ORDER BY `minOrder` ASC [ RunTime:0.003801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118095 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118095 LIMIT 2 [ RunTime:0.010811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118095 ORDER BY `minOrder` ASC [ RunTime:0.011369s ]
select * from pdf where partno='1.5SMC150A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002563s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118095 AND `partno` = '1.5SMC150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679227 [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117903 LIMIT 5 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117903 ORDER BY `minOrder` ASC [ RunTime:0.002062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117903 ORDER BY `unit` DESC [ RunTime:0.003267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117903 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117903 ORDER BY `minOrder` ASC [ RunTime:0.004001s ]
select * from pdf where partno='1.5SMC150A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015128s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117903 AND `partno` = '1.5SMC150A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802861 [ RunTime:0.002244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132633 LIMIT 5 [ RunTime:0.002926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132633 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132633 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132633 LIMIT 2 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132633 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='1.5SMC150A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000456s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132633 AND `partno` = '1.5SMC150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907391 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174641 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174641 ORDER BY `minOrder` ASC [ RunTime:0.009198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174641 ORDER BY `unit` DESC [ RunTime:0.007695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174641 LIMIT 2 [ RunTime:0.001872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174641 ORDER BY `minOrder` ASC [ RunTime:0.005581s ]
select * from pdf where partno='1.5SMC150A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.005725s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174641 AND `partno` = '1.5SMC150A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.005382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908246 [ RunTime:0.001986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174348 LIMIT 5 [ RunTime:0.003711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174348 ORDER BY `minOrder` ASC [ RunTime:0.008031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174348 ORDER BY `unit` DESC [ RunTime:0.026988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174348 LIMIT 2 [ RunTime:0.006858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174348 ORDER BY `minOrder` ASC [ RunTime:0.018376s ]
select * from pdf where partno='1.5SMC150AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.003440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.003511s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174348 AND `partno` = '1.5SMC150AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.003889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803708 [ RunTime:0.001020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262199 LIMIT 5 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262199 ORDER BY `minOrder` ASC [ RunTime:0.011775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262199 ORDER BY `unit` DESC [ RunTime:0.009430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262199 LIMIT 2 [ RunTime:0.015375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262199 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='1.5SMC150A TR13 PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.004058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A TR13 PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.003687s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262199 AND `partno` = '1.5SMC150A TR13 PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.012956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815054 [ RunTime:0.011647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257531 LIMIT 5 [ RunTime:0.003035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257531 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257531 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257531 LIMIT 2 [ RunTime:0.022688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257531 ORDER BY `minOrder` ASC [ RunTime:0.010780s ]
select * from pdf where partno='1.5SMC150A-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A-M3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001580s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257531 AND `partno` = '1.5SMC150A-M3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917699 [ RunTime:0.011617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257503 LIMIT 5 [ RunTime:0.001733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257503 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257503 ORDER BY `unit` DESC [ RunTime:0.001969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257503 LIMIT 2 [ RunTime:0.001092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257503 ORDER BY `minOrder` ASC [ RunTime:0.010791s ]
select * from pdf where partno='1.5SMC150A-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A-M3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011007s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257503 AND `partno` = '1.5SMC150A-M3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814972 [ RunTime:0.001898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246600 LIMIT 5 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246600 ORDER BY `minOrder` ASC [ RunTime:0.001619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246600 ORDER BY `unit` DESC [ RunTime:0.015329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246600 LIMIT 2 [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246600 ORDER BY `minOrder` ASC [ RunTime:0.004839s ]
select * from pdf where partno='1.5SMC150A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000638s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246600 AND `partno` = '1.5SMC150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.012979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673665 [ RunTime:0.022434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246123 LIMIT 5 [ RunTime:0.013776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246123 ORDER BY `minOrder` ASC [ RunTime:0.010650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246123 ORDER BY `unit` DESC [ RunTime:0.001157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246123 LIMIT 2 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246123 ORDER BY `minOrder` ASC [ RunTime:0.006263s ]
select * from pdf where partno='1.5SMC150AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.010027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.021483s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246123 AND `partno` = '1.5SMC150AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.011379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814007 [ RunTime:0.021650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245923 LIMIT 5 [ RunTime:0.009019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245923 ORDER BY `minOrder` ASC [ RunTime:0.016355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245923 ORDER BY `unit` DESC [ RunTime:0.000708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245923 LIMIT 2 [ RunTime:0.010302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245923 ORDER BY `minOrder` ASC [ RunTime:0.001823s ]
select * from pdf where partno='1.5SMC150A-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A-E3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.020742s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245923 AND `partno` = '1.5SMC150A-E3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.018952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673291 [ RunTime:0.034725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227678 LIMIT 5 [ RunTime:0.036829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227678 ORDER BY `minOrder` ASC [ RunTime:0.016865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227678 ORDER BY `unit` DESC [ RunTime:0.048265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227678 LIMIT 2 [ RunTime:0.009846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227678 ORDER BY `minOrder` ASC [ RunTime:0.002010s ]
select * from pdf where partno='1.5SMC150A-AT/7' and brandshort='YAGEO' limit 1 [ RunTime:0.034000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A-AT/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.049518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227167 LIMIT 5 [ RunTime:0.004816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227167 ORDER BY `minOrder` ASC [ RunTime:0.046583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227167 ORDER BY `unit` DESC [ RunTime:0.025478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227167 LIMIT 2 [ RunTime:0.045294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227167 ORDER BY `minOrder` ASC [ RunTime:0.048487s ]
select * from pdf where partno='1.5SMC150A-AT/13' and brandshort='YAGEO' limit 1 [ RunTime:0.035439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A-AT/13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222608 LIMIT 5 [ RunTime:0.035673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222608 ORDER BY `minOrder` ASC [ RunTime:0.008038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222608 ORDER BY `unit` DESC [ RunTime:0.021312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222608 LIMIT 2 [ RunTime:0.035061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222608 ORDER BY `minOrder` ASC [ RunTime:0.014558s ]
select * from pdf where partno='1.5SMC150A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.018014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221683 LIMIT 5 [ RunTime:0.027862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221683 ORDER BY `minOrder` ASC [ RunTime:0.038930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221683 ORDER BY `unit` DESC [ RunTime:0.012820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221683 LIMIT 2 [ RunTime:0.042448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221683 ORDER BY `minOrder` ASC [ RunTime:0.020910s ]
select * from pdf where partno='1.5SMC150A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.034038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC150A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020445s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019980s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034752s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017015s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032433s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020300s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014906s ]
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 '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012958s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5smc150a%' OR `brand` LIKE '1.5smc150a%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026173s ]