SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.007442s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.114' , `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=SMBJ64AH&search=1' [ RunTime:0.016056s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002794s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.059143s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002374s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.114' ) [ RunTime:0.006201s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001826s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013409s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001873s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ64AH' LIMIT 1 [ RunTime:0.024630s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-15 14:32:39' WHERE `partno` = 'SMBJ64AH' [ RunTime:0.052291s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002188s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073555s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830253 LIMIT 5 [ RunTime:0.010912s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830253 ORDER BY `minOrder` ASC [ RunTime:0.003093s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830253 ORDER BY `unit` DESC [ RunTime:0.009680s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830253 LIMIT 2 [ RunTime:0.010605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830253 ORDER BY `minOrder` ASC [ RunTime:0.019440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691188 LIMIT 5 [ RunTime:0.036206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691188 ORDER BY `minOrder` ASC [ RunTime:0.030179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691188 ORDER BY `unit` DESC [ RunTime:0.023285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691188 LIMIT 2 [ RunTime:0.032824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691188 ORDER BY `minOrder` ASC [ RunTime:0.006063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671535 LIMIT 5 [ RunTime:0.003763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671535 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671535 ORDER BY `unit` DESC [ RunTime:0.004664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671535 LIMIT 2 [ RunTime:0.017904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671535 ORDER BY `minOrder` ASC [ RunTime:0.007445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671238 LIMIT 5 [ RunTime:0.003930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671238 ORDER BY `minOrder` ASC [ RunTime:0.007575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671238 ORDER BY `unit` DESC [ RunTime:0.012230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671238 LIMIT 2 [ RunTime:0.005793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671238 ORDER BY `minOrder` ASC [ RunTime:0.005703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669587 LIMIT 5 [ RunTime:0.031978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669587 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669587 ORDER BY `unit` DESC [ RunTime:0.000831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669587 LIMIT 2 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669587 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832916 LIMIT 5 [ RunTime:0.007401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832916 ORDER BY `minOrder` ASC [ RunTime:0.000806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832916 ORDER BY `unit` DESC [ RunTime:0.022632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832916 LIMIT 2 [ RunTime:0.017326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832916 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832915 LIMIT 5 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832915 ORDER BY `minOrder` ASC [ RunTime:0.004025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832915 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832915 LIMIT 2 [ RunTime:0.008775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832915 ORDER BY `minOrder` ASC [ RunTime:0.004740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831869 LIMIT 5 [ RunTime:0.003579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831869 ORDER BY `minOrder` ASC [ RunTime:0.001852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831869 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831869 LIMIT 2 [ RunTime:0.004412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831869 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829807 LIMIT 5 [ RunTime:0.002158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829807 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829807 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829807 LIMIT 2 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829807 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829330 LIMIT 5 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829330 ORDER BY `minOrder` ASC [ RunTime:0.001875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829330 ORDER BY `unit` DESC [ RunTime:0.001355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829330 LIMIT 2 [ RunTime:0.001050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829330 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811678 LIMIT 5 [ RunTime:0.000922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811678 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811678 ORDER BY `unit` DESC [ RunTime:0.001375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811678 LIMIT 2 [ RunTime:0.013318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811678 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811440 LIMIT 5 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811440 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811440 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811440 LIMIT 2 [ RunTime:0.002109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811440 ORDER BY `minOrder` ASC [ RunTime:0.004301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811294 LIMIT 5 [ RunTime:0.003840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811294 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811294 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811294 LIMIT 2 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811294 ORDER BY `minOrder` ASC [ RunTime:0.004363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811219 LIMIT 5 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811219 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811219 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811219 LIMIT 2 [ RunTime:0.002477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811219 ORDER BY `minOrder` ASC [ RunTime:0.002810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914723 LIMIT 5 [ RunTime:0.002160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914723 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914723 ORDER BY `unit` DESC [ RunTime:0.000539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914723 LIMIT 2 [ RunTime:0.001793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914723 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914394 LIMIT 5 [ RunTime:0.005558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914394 ORDER BY `minOrder` ASC [ RunTime:0.004973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914394 ORDER BY `unit` DESC [ RunTime:0.003317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914394 LIMIT 2 [ RunTime:0.004245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914394 ORDER BY `minOrder` ASC [ RunTime:0.002795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913691 LIMIT 5 [ RunTime:0.012206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913691 ORDER BY `minOrder` ASC [ RunTime:0.004218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913691 ORDER BY `unit` DESC [ RunTime:0.003476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913691 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913691 ORDER BY `minOrder` ASC [ RunTime:0.002502s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002467s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152536 LIMIT 5 [ RunTime:0.010198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152536 ORDER BY `minOrder` ASC [ RunTime:0.016161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152536 ORDER BY `unit` DESC [ RunTime:0.014842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152536 LIMIT 2 [ RunTime:0.029800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152536 ORDER BY `minOrder` ASC [ RunTime:0.007178s ]
select * from pdf where partno='SMBJ64AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.007441s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.012688s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152536 AND `partno` = 'SMBJ64AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.003282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830253 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42241021 LIMIT 5 [ RunTime:0.004799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241021 ORDER BY `minOrder` ASC [ RunTime:0.012606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42241021 ORDER BY `unit` DESC [ RunTime:0.003006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42241021 LIMIT 2 [ RunTime:0.007975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241021 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
select * from pdf where partno='SMBJ64AHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002525s ]
SELECT `id` FROM `stock` WHERE `id` <> 42241021 AND `partno` = 'SMBJ64AHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811678 [ RunTime:0.016071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42240997 LIMIT 5 [ RunTime:0.011850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240997 ORDER BY `minOrder` ASC [ RunTime:0.012007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42240997 ORDER BY `unit` DESC [ RunTime:0.006958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42240997 LIMIT 2 [ RunTime:0.005304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240997 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='SMBJ64AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009831s ]
SELECT `id` FROM `stock` WHERE `id` <> 42240997 AND `partno` = 'SMBJ64AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.013696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914394 [ RunTime:0.008340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237312 LIMIT 5 [ RunTime:0.011954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237312 ORDER BY `minOrder` ASC [ RunTime:0.006939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237312 ORDER BY `unit` DESC [ RunTime:0.023899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237312 LIMIT 2 [ RunTime:0.015015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237312 ORDER BY `minOrder` ASC [ RunTime:0.005216s ]
select * from pdf where partno='SMBJ64AHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021655s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237312 AND `partno` = 'SMBJ64AHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671238 [ RunTime:0.011719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234462 LIMIT 5 [ RunTime:0.026130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234462 ORDER BY `minOrder` ASC [ RunTime:0.028852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234462 ORDER BY `unit` DESC [ RunTime:0.015913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234462 LIMIT 2 [ RunTime:0.001314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234462 ORDER BY `minOrder` ASC [ RunTime:0.001419s ]
select * from pdf where partno='SMBJ64AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.022734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021848s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234462 AND `partno` = 'SMBJ64AHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.024491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671535 [ RunTime:0.043735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42230454 LIMIT 5 [ RunTime:0.030121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230454 ORDER BY `minOrder` ASC [ RunTime:0.042110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42230454 ORDER BY `unit` DESC [ RunTime:0.062909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42230454 LIMIT 2 [ RunTime:0.034570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230454 ORDER BY `minOrder` ASC [ RunTime:0.020193s ]
select * from pdf where partno='SMBJ64AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013737s ]
SELECT `id` FROM `stock` WHERE `id` <> 42230454 AND `partno` = 'SMBJ64AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914723 [ RunTime:0.043524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42229303 LIMIT 5 [ RunTime:0.010097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229303 ORDER BY `minOrder` ASC [ RunTime:0.009633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42229303 ORDER BY `unit` DESC [ RunTime:0.001806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42229303 LIMIT 2 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229303 ORDER BY `minOrder` ASC [ RunTime:0.012841s ]
select * from pdf where partno='SMBJ64AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014693s ]
SELECT `id` FROM `stock` WHERE `id` <> 42229303 AND `partno` = 'SMBJ64AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811440 [ RunTime:0.013135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227451 LIMIT 5 [ RunTime:0.028110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227451 ORDER BY `minOrder` ASC [ RunTime:0.014043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227451 ORDER BY `unit` DESC [ RunTime:0.008081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227451 LIMIT 2 [ RunTime:0.022949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227451 ORDER BY `minOrder` ASC [ RunTime:0.013614s ]
select * from pdf where partno='SMBJ64AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.036556s ]
SELECT `id` FROM `stock` WHERE `id` <> 42227451 AND `partno` = 'SMBJ64AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.008807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811294 [ RunTime:0.020871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42226808 LIMIT 5 [ RunTime:0.031082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226808 ORDER BY `minOrder` ASC [ RunTime:0.030885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42226808 ORDER BY `unit` DESC [ RunTime:0.020186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42226808 LIMIT 2 [ RunTime:0.002162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226808 ORDER BY `minOrder` ASC [ RunTime:0.003952s ]
select * from pdf where partno='SMBJ64AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.021021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021251s ]
SELECT `id` FROM `stock` WHERE `id` <> 42226808 AND `partno` = 'SMBJ64AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811219 [ RunTime:0.008343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225836 LIMIT 5 [ RunTime:0.006262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225836 ORDER BY `minOrder` ASC [ RunTime:0.014035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225836 ORDER BY `unit` DESC [ RunTime:0.021301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225836 LIMIT 2 [ RunTime:0.026977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225836 ORDER BY `minOrder` ASC [ RunTime:0.006471s ]
select * from pdf where partno='SMBJ64AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.013644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.007183s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225836 AND `partno` = 'SMBJ64AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.032458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913691 [ RunTime:0.013902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42213822 LIMIT 5 [ RunTime:0.016255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213822 ORDER BY `minOrder` ASC [ RunTime:0.013849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42213822 ORDER BY `unit` DESC [ RunTime:0.033228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42213822 LIMIT 2 [ RunTime:0.015996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213822 ORDER BY `minOrder` ASC [ RunTime:0.005861s ]
select * from pdf where partno='SMBJ64AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.011013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ64AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.031120s ]
SELECT `id` FROM `stock` WHERE `id` <> 42213822 AND `partno` = 'SMBJ64AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.028884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669587 [ RunTime:0.001407s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024650s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015084s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003257s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014049s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011191s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029772s ]
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 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029073s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ64AH%' OR `brand` LIKE 'SMBJ64AH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016733s ]