SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002397s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.90' , `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.5SMC82CA&search=1' [ RunTime:0.002654s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002206s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002831s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.90' ) [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002247s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005547s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002905s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5SMC82CA' LIMIT 1 [ RunTime:0.009536s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-18 20:33:46' WHERE `partno` = '1.5SMC82CA' [ RunTime:0.002605s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002790s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024558s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661352 LIMIT 5 [ RunTime:0.020445s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661352 ORDER BY `minOrder` ASC [ RunTime:0.031454s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661352 ORDER BY `unit` DESC [ RunTime:0.022737s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661352 LIMIT 2 [ RunTime:0.019471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661352 ORDER BY `minOrder` ASC [ RunTime:0.021464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908221 LIMIT 5 [ RunTime:0.013510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908221 ORDER BY `minOrder` ASC [ RunTime:0.009669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908221 ORDER BY `unit` DESC [ RunTime:0.023512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908221 LIMIT 2 [ RunTime:0.009498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908221 ORDER BY `minOrder` ASC [ RunTime:0.019671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689305 LIMIT 5 [ RunTime:0.029496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689305 ORDER BY `minOrder` ASC [ RunTime:0.029937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689305 ORDER BY `unit` DESC [ RunTime:0.028574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689305 LIMIT 2 [ RunTime:0.009576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689305 ORDER BY `minOrder` ASC [ RunTime:0.012339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688561 LIMIT 5 [ RunTime:0.021182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688561 ORDER BY `minOrder` ASC [ RunTime:0.012948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688561 ORDER BY `unit` DESC [ RunTime:0.029864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688561 LIMIT 2 [ RunTime:0.023688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688561 ORDER BY `minOrder` ASC [ RunTime:0.012682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676997 LIMIT 5 [ RunTime:0.053456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676997 ORDER BY `minOrder` ASC [ RunTime:0.051895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676997 ORDER BY `unit` DESC [ RunTime:0.026880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676997 LIMIT 2 [ RunTime:0.066957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676997 ORDER BY `minOrder` ASC [ RunTime:0.016478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675530 LIMIT 5 [ RunTime:0.021792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675530 ORDER BY `minOrder` ASC [ RunTime:0.018445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675530 ORDER BY `unit` DESC [ RunTime:0.007762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675530 LIMIT 2 [ RunTime:0.061255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675530 ORDER BY `minOrder` ASC [ RunTime:0.009744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674578 LIMIT 5 [ RunTime:0.009446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674578 ORDER BY `minOrder` ASC [ RunTime:0.015704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674578 ORDER BY `unit` DESC [ RunTime:0.011650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674578 LIMIT 2 [ RunTime:0.014339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674578 ORDER BY `minOrder` ASC [ RunTime:0.010848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673900 LIMIT 5 [ RunTime:0.020385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673900 ORDER BY `minOrder` ASC [ RunTime:0.026870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673900 ORDER BY `unit` DESC [ RunTime:0.025405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673900 LIMIT 2 [ RunTime:0.011140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673900 ORDER BY `minOrder` ASC [ RunTime:0.011963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673579 LIMIT 5 [ RunTime:0.036489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673579 ORDER BY `minOrder` ASC [ RunTime:0.018696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673579 ORDER BY `unit` DESC [ RunTime:0.003190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673579 LIMIT 2 [ RunTime:0.006043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673579 ORDER BY `minOrder` ASC [ RunTime:0.003547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671972 LIMIT 5 [ RunTime:0.009413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671972 ORDER BY `minOrder` ASC [ RunTime:0.009755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671972 ORDER BY `unit` DESC [ RunTime:0.012066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671972 LIMIT 2 [ RunTime:0.007637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671972 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670894 LIMIT 5 [ RunTime:0.001133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670894 ORDER BY `minOrder` ASC [ RunTime:0.004657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670894 ORDER BY `unit` DESC [ RunTime:0.006280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670894 LIMIT 2 [ RunTime:0.021468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670894 ORDER BY `minOrder` ASC [ RunTime:0.022807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832480 LIMIT 5 [ RunTime:0.007500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832480 ORDER BY `minOrder` ASC [ RunTime:0.011915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832480 ORDER BY `unit` DESC [ RunTime:0.008505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832480 LIMIT 2 [ RunTime:0.008721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832480 ORDER BY `minOrder` ASC [ RunTime:0.002907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832479 LIMIT 5 [ RunTime:0.010823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832479 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832479 ORDER BY `unit` DESC [ RunTime:0.000927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832479 LIMIT 2 [ RunTime:0.004710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832479 ORDER BY `minOrder` ASC [ RunTime:0.006181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831897 LIMIT 5 [ RunTime:0.006348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831897 ORDER BY `minOrder` ASC [ RunTime:0.003079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831897 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831897 LIMIT 2 [ RunTime:0.002531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831897 ORDER BY `minOrder` ASC [ RunTime:0.012907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816905 LIMIT 5 [ RunTime:0.014560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816905 ORDER BY `minOrder` ASC [ RunTime:0.011385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816905 ORDER BY `unit` DESC [ RunTime:0.000719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816905 LIMIT 2 [ RunTime:0.008446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816905 ORDER BY `minOrder` ASC [ RunTime:0.002190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816699 LIMIT 5 [ RunTime:0.002958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816699 ORDER BY `minOrder` ASC [ RunTime:0.013832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816699 ORDER BY `unit` DESC [ RunTime:0.001754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816699 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816699 ORDER BY `minOrder` ASC [ RunTime:0.003333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816694 LIMIT 5 [ RunTime:0.001303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816694 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816694 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816694 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816694 ORDER BY `minOrder` ASC [ RunTime:0.002316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932106 LIMIT 5 [ RunTime:0.002945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932106 ORDER BY `minOrder` ASC [ RunTime:0.003885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932106 ORDER BY `unit` DESC [ RunTime:0.003121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932106 LIMIT 2 [ RunTime:0.010247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932106 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931628 LIMIT 5 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931628 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931628 ORDER BY `unit` DESC [ RunTime:0.002645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931628 LIMIT 2 [ RunTime:0.005030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931628 ORDER BY `minOrder` ASC [ RunTime:0.001276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920698 LIMIT 5 [ RunTime:0.006789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920698 ORDER BY `minOrder` ASC [ RunTime:0.002232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920698 ORDER BY `unit` DESC [ RunTime:0.004202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920698 LIMIT 2 [ RunTime:0.005376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920698 ORDER BY `minOrder` ASC [ RunTime:0.012975s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141661 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141661 ORDER BY `minOrder` ASC [ RunTime:0.005000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141661 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141661 LIMIT 2 [ RunTime:0.007058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141661 ORDER BY `minOrder` ASC [ RunTime:0.008815s ]
select * from pdf where partno='1.5smc82ca' and brandshort='bourns' limit 1 [ RunTime:0.005048s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc82ca' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.009738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140894 LIMIT 5 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140894 ORDER BY `minOrder` ASC [ RunTime:0.000922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140894 ORDER BY `unit` DESC [ RunTime:0.002411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140894 LIMIT 2 [ RunTime:0.002508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140894 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='1.5smc82cahm3_a/i' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc82cahm3_a/i' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.005581s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140894 AND `partno` = '1.5smc82cahm3_a/i' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026349 [ RunTime:0.004443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51026349 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026349 ORDER BY `minOrder` ASC [ RunTime:0.002978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51026349 ORDER BY `unit` DESC [ RunTime:0.009525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51026349 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51026349 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='1.5smc82cahm3_a/i' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.000523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc82cahm3_a/i' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.003106s ]
SELECT `id` FROM `stock` WHERE `id` <> 51026349 AND `partno` = '1.5smc82cahm3_a/i' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.002188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140894 [ RunTime:0.007161s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118795 LIMIT 5 [ RunTime:0.001154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118795 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118795 ORDER BY `unit` DESC [ RunTime:0.005553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118795 LIMIT 2 [ RunTime:0.008364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118795 ORDER BY `minOrder` ASC [ RunTime:0.001998s ]
select * from pdf where partno='1.5SMC82CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004141s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118795 AND `partno` = '1.5SMC82CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.023473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676997 [ RunTime:0.013315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174586 LIMIT 5 [ RunTime:0.006479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174586 ORDER BY `minOrder` ASC [ RunTime:0.011515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174586 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174586 LIMIT 2 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174586 ORDER BY `minOrder` ASC [ RunTime:0.008123s ]
select * from pdf where partno='1.5SMC82CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.005556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002804s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174586 AND `partno` = '1.5SMC82CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908221 [ RunTime:0.004082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142586 LIMIT 5 [ RunTime:0.011328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142586 ORDER BY `minOrder` ASC [ RunTime:0.003058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142586 ORDER BY `unit` DESC [ RunTime:0.005791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142586 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142586 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='1.5SMC82CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.013718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.007925s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142586 AND `partno` = '1.5SMC82CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.003270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661352 [ RunTime:0.006048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42284711 LIMIT 5 [ RunTime:0.011464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284711 ORDER BY `minOrder` ASC [ RunTime:0.030859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42284711 ORDER BY `unit` DESC [ RunTime:0.002948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42284711 LIMIT 2 [ RunTime:0.015532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284711 ORDER BY `minOrder` ASC [ RunTime:0.007711s ]
select * from pdf where partno='1.5SMC82CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000876s ]
SELECT `id` FROM `stock` WHERE `id` <> 42284711 AND `partno` = '1.5SMC82CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918814 [ RunTime:0.013847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42283281 LIMIT 5 [ RunTime:0.019207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42283281 ORDER BY `minOrder` ASC [ RunTime:0.002229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42283281 ORDER BY `unit` DESC [ RunTime:0.023116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42283281 LIMIT 2 [ RunTime:0.051473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42283281 ORDER BY `minOrder` ASC [ RunTime:0.012624s ]
select * from pdf where partno='1.5SMC82CA BK PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.030016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA BK PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.013897s ]
SELECT `id` FROM `stock` WHERE `id` <> 42283281 AND `partno` = '1.5SMC82CA BK PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.025341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919378 [ RunTime:0.015085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282398 LIMIT 5 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282398 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282398 ORDER BY `unit` DESC [ RunTime:0.011590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282398 LIMIT 2 [ RunTime:0.016121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282398 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='1.5SMC82CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002211s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282398 AND `partno` = '1.5SMC82CAHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675530 [ RunTime:0.002150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282397 LIMIT 5 [ RunTime:0.017088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282397 ORDER BY `minOrder` ASC [ RunTime:0.021509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282397 ORDER BY `unit` DESC [ RunTime:0.018726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282397 LIMIT 2 [ RunTime:0.019592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282397 ORDER BY `minOrder` ASC [ RunTime:0.016531s ]
select * from pdf where partno='1.5SMC82CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006694s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282397 AND `partno` = '1.5SMC82CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816905 [ RunTime:0.034343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282061 LIMIT 5 [ RunTime:0.006462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282061 ORDER BY `minOrder` ASC [ RunTime:0.036332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282061 ORDER BY `unit` DESC [ RunTime:0.026935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282061 LIMIT 2 [ RunTime:0.038529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282061 ORDER BY `minOrder` ASC [ RunTime:0.005674s ]
select * from pdf where partno='1.5SMC82CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.036404s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282061 AND `partno` = '1.5SMC82CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816699 [ RunTime:0.012195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42278687 LIMIT 5 [ RunTime:0.026345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278687 ORDER BY `minOrder` ASC [ RunTime:0.046476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42278687 ORDER BY `unit` DESC [ RunTime:0.017615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42278687 LIMIT 2 [ RunTime:0.003596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278687 ORDER BY `minOrder` ASC [ RunTime:0.005260s ]
select * from pdf where partno='1.5SMC82CA-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA-M3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007964s ]
SELECT `id` FROM `stock` WHERE `id` <> 42278687 AND `partno` = '1.5SMC82CA-M3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816694 [ RunTime:0.025617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42278669 LIMIT 5 [ RunTime:0.007044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278669 ORDER BY `minOrder` ASC [ RunTime:0.009314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42278669 ORDER BY `unit` DESC [ RunTime:0.006815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42278669 LIMIT 2 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278669 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
select * from pdf where partno='1.5SMC82CA-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA-M3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003171s ]
SELECT `id` FROM `stock` WHERE `id` <> 42278669 AND `partno` = '1.5SMC82CA-M3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918826 [ RunTime:0.001480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42270942 LIMIT 5 [ RunTime:0.011269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270942 ORDER BY `minOrder` ASC [ RunTime:0.006539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42270942 ORDER BY `unit` DESC [ RunTime:0.016380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42270942 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270942 ORDER BY `minOrder` ASC [ RunTime:0.003690s ]
select * from pdf where partno='1.5SMC82CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.014584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.005270s ]
SELECT `id` FROM `stock` WHERE `id` <> 42270942 AND `partno` = '1.5SMC82CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.011513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674578 [ RunTime:0.001855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263580 LIMIT 5 [ RunTime:0.022324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263580 ORDER BY `minOrder` ASC [ RunTime:0.006162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263580 ORDER BY `unit` DESC [ RunTime:0.005051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263580 LIMIT 2 [ RunTime:0.014193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263580 ORDER BY `minOrder` ASC [ RunTime:0.008287s ]
select * from pdf where partno='1.5SMC82CA TR13 PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.011759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA TR13 PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.004828s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263580 AND `partno` = '1.5SMC82CA TR13 PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.021036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920698 [ RunTime:0.015610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42259160 LIMIT 5 [ RunTime:0.007931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259160 ORDER BY `minOrder` ASC [ RunTime:0.016026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42259160 ORDER BY `unit` DESC [ RunTime:0.006248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42259160 LIMIT 2 [ RunTime:0.009507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259160 ORDER BY `minOrder` ASC [ RunTime:0.005772s ]
select * from pdf where partno='1.5SMC82CA-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.020011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA-E3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013971s ]
SELECT `id` FROM `stock` WHERE `id` <> 42259160 AND `partno` = '1.5SMC82CA-E3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673579 [ RunTime:0.010701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256175 LIMIT 5 [ RunTime:0.000891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256175 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256175 ORDER BY `unit` DESC [ RunTime:0.007633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256175 LIMIT 2 [ RunTime:0.011545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256175 ORDER BY `minOrder` ASC [ RunTime:0.002555s ]
select * from pdf where partno='1.5SMC82CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.014639s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256175 AND `partno` = '1.5SMC82CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.027178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916812 [ RunTime:0.025017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42255361 LIMIT 5 [ RunTime:0.018369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42255361 ORDER BY `minOrder` ASC [ RunTime:0.015402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42255361 ORDER BY `unit` DESC [ RunTime:0.021734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42255361 LIMIT 2 [ RunTime:0.047184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42255361 ORDER BY `minOrder` ASC [ RunTime:0.005641s ]
select * from pdf where partno='1.5SMC82CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.066627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.028712s ]
SELECT `id` FROM `stock` WHERE `id` <> 42255361 AND `partno` = '1.5SMC82CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.073489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673900 [ RunTime:0.029287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227708 LIMIT 5 [ RunTime:0.067191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227708 ORDER BY `minOrder` ASC [ RunTime:0.012461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227708 ORDER BY `unit` DESC [ RunTime:0.033373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227708 LIMIT 2 [ RunTime:0.086645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227708 ORDER BY `minOrder` ASC [ RunTime:0.016820s ]
select * from pdf where partno='1.5SMC82CA-AT/7' and brandshort='YAGEO' limit 1 [ RunTime:0.007806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA-AT/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227127 LIMIT 5 [ RunTime:0.031079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227127 ORDER BY `minOrder` ASC [ RunTime:0.009571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227127 ORDER BY `unit` DESC [ RunTime:0.011909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227127 LIMIT 2 [ RunTime:0.012446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227127 ORDER BY `minOrder` ASC [ RunTime:0.004772s ]
select * from pdf where partno='1.5SMC82CA-AT/13' and brandshort='YAGEO' limit 1 [ RunTime:0.010943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA-AT/13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222538 LIMIT 5 [ RunTime:0.009101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222538 ORDER BY `minOrder` ASC [ RunTime:0.005734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222538 ORDER BY `unit` DESC [ RunTime:0.031180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222538 LIMIT 2 [ RunTime:0.008729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222538 ORDER BY `minOrder` ASC [ RunTime:0.004469s ]
select * from pdf where partno='1.5SMC82CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.008110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221655 LIMIT 5 [ RunTime:0.030759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221655 ORDER BY `minOrder` ASC [ RunTime:0.027082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221655 ORDER BY `unit` DESC [ RunTime:0.010955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221655 LIMIT 2 [ RunTime:0.015163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221655 ORDER BY `minOrder` ASC [ RunTime:0.006974s ]
select * from pdf where partno='1.5SMC82CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.006407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42179070 LIMIT 5 [ RunTime:0.007780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179070 ORDER BY `minOrder` ASC [ RunTime:0.023459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42179070 ORDER BY `unit` DESC [ RunTime:0.003603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42179070 LIMIT 2 [ RunTime:0.004218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179070 ORDER BY `minOrder` ASC [ RunTime:0.018974s ]
select * from pdf where partno='1.5SMC82CA-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC82CA-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006016s ]
SELECT `id` FROM `stock` WHERE `id` <> 42179070 AND `partno` = '1.5SMC82CA-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908741 [ RunTime:0.017467s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009967s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006212s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027202s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031912s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013769s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034756s ]
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.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023778s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5SMC82CA%' OR `brand` LIKE '1.5SMC82CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011775s ]