SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001620s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.227' , `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=1N5245&search=1' [ RunTime:0.003483s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001284s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001631s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002015s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001512s ]
SELECT * FROM `stock_search` WHERE `partno` = '1N5245' LIMIT 1 [ RunTime:0.007395s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-26 11:52:17' WHERE `partno` = '1N5245' [ RunTime:0.001738s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002093s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012063s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052995s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012211s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51776112 LIMIT 5 [ RunTime:0.008605s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51776112 ORDER BY `minOrder` ASC [ RunTime:0.019382s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51776112 ORDER BY `unit` DESC [ RunTime:0.015333s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51776112 LIMIT 2 [ RunTime:0.020927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51776112 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
select * from pdf where partno='1N5245BTR' and brandshort='onsemi' limit 1 [ RunTime:0.027147s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245BTR' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.035308s ]
SELECT `id` FROM `stock` WHERE `id` <> 51776112 AND `partno` = '1N5245BTR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.029249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44751453 LIMIT 5 [ RunTime:0.016674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44751453 ORDER BY `minOrder` ASC [ RunTime:0.003803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44751453 ORDER BY `unit` DESC [ RunTime:0.025502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44751453 LIMIT 2 [ RunTime:0.047911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44751453 ORDER BY `minOrder` ASC [ RunTime:0.024095s ]
select * from pdf where partno='1N5245B' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.030475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.041670s ]
SELECT `id` FROM `stock` WHERE `id` <> 44751453 AND `partno` = '1N5245B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.038325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40012756 [ RunTime:0.046843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40012756 LIMIT 5 [ RunTime:0.017036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40012756 ORDER BY `minOrder` ASC [ RunTime:0.016897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40012756 ORDER BY `unit` DESC [ RunTime:0.041022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40012756 LIMIT 2 [ RunTime:0.043517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40012756 ORDER BY `minOrder` ASC [ RunTime:0.016888s ]
select * from pdf where partno='1N5245B' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.027688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.029185s ]
SELECT `id` FROM `stock` WHERE `id` <> 40012756 AND `partno` = '1N5245B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.047045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44751453 [ RunTime:0.016270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51777172 LIMIT 5 [ RunTime:0.031938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51777172 ORDER BY `minOrder` ASC [ RunTime:0.005376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51777172 ORDER BY `unit` DESC [ RunTime:0.009846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51777172 LIMIT 2 [ RunTime:0.035051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51777172 ORDER BY `minOrder` ASC [ RunTime:0.011066s ]
select * from pdf where partno='1N5245B-TR' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B-TR' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013743s ]
SELECT `id` FROM `stock` WHERE `id` <> 51777172 AND `partno` = '1N5245B-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.022298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51779369 LIMIT 5 [ RunTime:0.036281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51779369 ORDER BY `minOrder` ASC [ RunTime:0.028790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51779369 ORDER BY `unit` DESC [ RunTime:0.004355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51779369 LIMIT 2 [ RunTime:0.015338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51779369 ORDER BY `minOrder` ASC [ RunTime:0.009451s ]
select * from pdf where partno='1N5245B-TAP' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B-TAP' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009386s ]
SELECT `id` FROM `stock` WHERE `id` <> 51779369 AND `partno` = '1N5245B-TAP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.016358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51782253 LIMIT 5 [ RunTime:0.022908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51782253 ORDER BY `minOrder` ASC [ RunTime:0.014237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51782253 ORDER BY `unit` DESC [ RunTime:0.029244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51782253 LIMIT 2 [ RunTime:0.021839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51782253 ORDER BY `minOrder` ASC [ RunTime:0.005725s ]
select * from pdf where partno='1N5245B R0G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.036118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B R0G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.025877s ]
SELECT `id` FROM `stock` WHERE `id` <> 51782253 AND `partno` = '1N5245B R0G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.080352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51777150 LIMIT 5 [ RunTime:0.013344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51777150 ORDER BY `minOrder` ASC [ RunTime:0.014856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51777150 ORDER BY `unit` DESC [ RunTime:0.026532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51777150 LIMIT 2 [ RunTime:0.050736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51777150 ORDER BY `minOrder` ASC [ RunTime:0.004074s ]
select * from pdf where partno='1N5245B TR PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.010304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B TR PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.048765s ]
SELECT `id` FROM `stock` WHERE `id` <> 51777150 AND `partno` = '1N5245B TR PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.041426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51776060 LIMIT 5 [ RunTime:0.031121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51776060 ORDER BY `minOrder` ASC [ RunTime:0.021720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51776060 ORDER BY `unit` DESC [ RunTime:0.019605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51776060 LIMIT 2 [ RunTime:0.014473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51776060 ORDER BY `minOrder` ASC [ RunTime:0.028373s ]
select * from pdf where partno='1N5245B' and brandshort='onsemi' limit 1 [ RunTime:0.030917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.045907s ]
SELECT `id` FROM `stock` WHERE `id` <> 51776060 AND `partno` = '1N5245B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.029947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51790524 LIMIT 5 [ RunTime:0.018817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51790524 ORDER BY `minOrder` ASC [ RunTime:0.033237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51790524 ORDER BY `unit` DESC [ RunTime:0.024601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51790524 LIMIT 2 [ RunTime:0.038053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51790524 ORDER BY `minOrder` ASC [ RunTime:0.001691s ]
select * from pdf where partno='1N5245B A0G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.019966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B A0G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.020554s ]
SELECT `id` FROM `stock` WHERE `id` <> 51790524 AND `partno` = '1N5245B A0G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.035748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51782918 LIMIT 5 [ RunTime:0.019330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51782918 ORDER BY `minOrder` ASC [ RunTime:0.049650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51782918 ORDER BY `unit` DESC [ RunTime:0.013050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51782918 LIMIT 2 [ RunTime:0.019675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51782918 ORDER BY `minOrder` ASC [ RunTime:0.018698s ]
select * from pdf where partno='1N5245B' and brandshort='Microchip Technology' limit 1 [ RunTime:0.055988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.062386s ]
SELECT `id` FROM `stock` WHERE `id` <> 51782918 AND `partno` = '1N5245B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.058065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51780113 LIMIT 5 [ RunTime:0.038228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51780113 ORDER BY `minOrder` ASC [ RunTime:0.048727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51780113 ORDER BY `unit` DESC [ RunTime:0.012443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51780113 LIMIT 2 [ RunTime:0.020192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51780113 ORDER BY `minOrder` ASC [ RunTime:0.019305s ]
select * from pdf where partno='1N5245BUR-1/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.017987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245BUR-1/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.033988s ]
SELECT `id` FROM `stock` WHERE `id` <> 51780113 AND `partno` = '1N5245BUR-1/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.041492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51821594 LIMIT 5 [ RunTime:0.026136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51821594 ORDER BY `minOrder` ASC [ RunTime:0.059331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51821594 ORDER BY `unit` DESC [ RunTime:0.009536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51821594 LIMIT 2 [ RunTime:0.038024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51821594 ORDER BY `minOrder` ASC [ RunTime:0.029096s ]
select * from pdf where partno='1N5245D-1' and brandshort='Microchip Technology' limit 1 [ RunTime:0.043540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245D-1' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.021402s ]
SELECT `id` FROM `stock` WHERE `id` <> 51821594 AND `partno` = '1N5245D-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.015693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51818876 LIMIT 5 [ RunTime:0.008232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51818876 ORDER BY `minOrder` ASC [ RunTime:0.008835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51818876 ORDER BY `unit` DESC [ RunTime:0.018166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51818876 LIMIT 2 [ RunTime:0.015806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51818876 ORDER BY `minOrder` ASC [ RunTime:0.004489s ]
select * from pdf where partno='1N5245D' and brandshort='Microchip Technology' limit 1 [ RunTime:0.008157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245D' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.009738s ]
SELECT `id` FROM `stock` WHERE `id` <> 51818876 AND `partno` = '1N5245D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.022016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51816145 LIMIT 5 [ RunTime:0.006240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51816145 ORDER BY `minOrder` ASC [ RunTime:0.018684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51816145 ORDER BY `unit` DESC [ RunTime:0.017710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51816145 LIMIT 2 [ RunTime:0.036877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51816145 ORDER BY `minOrder` ASC [ RunTime:0.007828s ]
select * from pdf where partno='1N5245BUR-1' and brandshort='Microchip Technology' limit 1 [ RunTime:0.039914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245BUR-1' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.011646s ]
SELECT `id` FROM `stock` WHERE `id` <> 51816145 AND `partno` = '1N5245BUR-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.030804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51815935 LIMIT 5 [ RunTime:0.011858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51815935 ORDER BY `minOrder` ASC [ RunTime:0.001305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51815935 ORDER BY `unit` DESC [ RunTime:0.008602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51815935 LIMIT 2 [ RunTime:0.008835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51815935 ORDER BY `minOrder` ASC [ RunTime:0.005791s ]
select * from pdf where partno='1N5245A' and brandshort='Microchip Technology' limit 1 [ RunTime:0.010125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245A' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.020881s ]
SELECT `id` FROM `stock` WHERE `id` <> 51815935 AND `partno` = '1N5245A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.009001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51813898 LIMIT 5 [ RunTime:0.012022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51813898 ORDER BY `minOrder` ASC [ RunTime:0.045500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51813898 ORDER BY `unit` DESC [ RunTime:0.033900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51813898 LIMIT 2 [ RunTime:0.012490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51813898 ORDER BY `minOrder` ASC [ RunTime:0.020350s ]
select * from pdf where partno='1N5245B/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.025915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.007599s ]
SELECT `id` FROM `stock` WHERE `id` <> 51813898 AND `partno` = '1N5245B/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.013016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51813699 LIMIT 5 [ RunTime:0.019782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51813699 ORDER BY `minOrder` ASC [ RunTime:0.012662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51813699 ORDER BY `unit` DESC [ RunTime:0.003754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51813699 LIMIT 2 [ RunTime:0.006069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51813699 ORDER BY `minOrder` ASC [ RunTime:0.010436s ]
select * from pdf where partno='1N5245/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.043779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.004469s ]
SELECT `id` FROM `stock` WHERE `id` <> 51813699 AND `partno` = '1N5245/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.034638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51813150 LIMIT 5 [ RunTime:0.038225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51813150 ORDER BY `minOrder` ASC [ RunTime:0.023506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51813150 ORDER BY `unit` DESC [ RunTime:0.023092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51813150 LIMIT 2 [ RunTime:0.024930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51813150 ORDER BY `minOrder` ASC [ RunTime:0.022733s ]
select * from pdf where partno='1N5245B-1' and brandshort='Microchip Technology' limit 1 [ RunTime:0.018035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245B-1' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.006065s ]
SELECT `id` FROM `stock` WHERE `id` <> 51813150 AND `partno` = '1N5245B-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.007725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51812947 LIMIT 5 [ RunTime:0.032188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51812947 ORDER BY `minOrder` ASC [ RunTime:0.012519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51812947 ORDER BY `unit` DESC [ RunTime:0.008975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51812947 LIMIT 2 [ RunTime:0.004318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51812947 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='1N5245' and brandshort='Microchip Technology' limit 1 [ RunTime:0.022163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.017492s ]
SELECT `id` FROM `stock` WHERE `id` <> 51812947 AND `partno` = '1N5245' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.033020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51804155 LIMIT 5 [ RunTime:0.009461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51804155 ORDER BY `minOrder` ASC [ RunTime:0.041469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51804155 ORDER BY `unit` DESC [ RunTime:0.033010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51804155 LIMIT 2 [ RunTime:0.029244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51804155 ORDER BY `minOrder` ASC [ RunTime:0.007211s ]
select * from pdf where partno='1N5245C-TR' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5245C-TR' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007642s ]
SELECT `id` FROM `stock` WHERE `id` <> 51804155 AND `partno` = '1N5245C-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.020978s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008729s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038649s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079438s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046608s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014202s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020138s ]
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 '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047572s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1N5245%' OR `brand` LIKE '1N5245%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030419s ]