SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002457s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=SMB10J22A&search=1' [ RunTime:0.005760s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002724s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004233s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002644s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002322s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000488s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002300s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMB10J22A' LIMIT 1 [ RunTime:0.010458s ]
UPDATE `stock_search` SET `count` = 14 , `updatetime` = '2026-08-22 12:52:26' WHERE `partno` = 'SMB10J22A' [ RunTime:0.006727s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002414s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018998s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906279 LIMIT 5 [ RunTime:0.012500s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906279 ORDER BY `minOrder` ASC [ RunTime:0.010225s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906279 ORDER BY `unit` DESC [ RunTime:0.004474s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906279 LIMIT 2 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906279 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689015 LIMIT 5 [ RunTime:0.010499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689015 ORDER BY `minOrder` ASC [ RunTime:0.002597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689015 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689015 LIMIT 2 [ RunTime:0.016962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689015 ORDER BY `minOrder` ASC [ RunTime:0.010535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674269 LIMIT 5 [ RunTime:0.013048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674269 ORDER BY `minOrder` ASC [ RunTime:0.026189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674269 ORDER BY `unit` DESC [ RunTime:0.014812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674269 LIMIT 2 [ RunTime:0.012133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674269 ORDER BY `minOrder` ASC [ RunTime:0.005429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674153 LIMIT 5 [ RunTime:0.003427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674153 ORDER BY `minOrder` ASC [ RunTime:0.013124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674153 ORDER BY `unit` DESC [ RunTime:0.008133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674153 LIMIT 2 [ RunTime:0.002833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674153 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673022 LIMIT 5 [ RunTime:0.007815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673022 ORDER BY `minOrder` ASC [ RunTime:0.015500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673022 ORDER BY `unit` DESC [ RunTime:0.014374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673022 LIMIT 2 [ RunTime:0.006271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673022 ORDER BY `minOrder` ASC [ RunTime:0.006877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832808 LIMIT 5 [ RunTime:0.011841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832808 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832808 ORDER BY `unit` DESC [ RunTime:0.011184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832808 LIMIT 2 [ RunTime:0.010916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832808 ORDER BY `minOrder` ASC [ RunTime:0.002571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832807 LIMIT 5 [ RunTime:0.014459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832807 ORDER BY `minOrder` ASC [ RunTime:0.008946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832807 ORDER BY `unit` DESC [ RunTime:0.020235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832807 LIMIT 2 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832807 ORDER BY `minOrder` ASC [ RunTime:0.002619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829703 LIMIT 5 [ RunTime:0.004903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829703 ORDER BY `minOrder` ASC [ RunTime:0.025015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829703 ORDER BY `unit` DESC [ RunTime:0.011627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829703 LIMIT 2 [ RunTime:0.021158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829703 ORDER BY `minOrder` ASC [ RunTime:0.039542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815785 LIMIT 5 [ RunTime:0.019150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815785 ORDER BY `minOrder` ASC [ RunTime:0.023341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815785 ORDER BY `unit` DESC [ RunTime:0.007213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815785 LIMIT 2 [ RunTime:0.007517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815785 ORDER BY `minOrder` ASC [ RunTime:0.003050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814862 LIMIT 5 [ RunTime:0.013900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814862 ORDER BY `minOrder` ASC [ RunTime:0.032676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814862 ORDER BY `unit` DESC [ RunTime:0.054598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814862 LIMIT 2 [ RunTime:0.032443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814862 ORDER BY `minOrder` ASC [ RunTime:0.016640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814814 LIMIT 5 [ RunTime:0.053727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814814 ORDER BY `minOrder` ASC [ RunTime:0.023443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814814 ORDER BY `unit` DESC [ RunTime:0.044830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814814 LIMIT 2 [ RunTime:0.031133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814814 ORDER BY `minOrder` ASC [ RunTime:0.001417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814459 LIMIT 5 [ RunTime:0.002314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814459 ORDER BY `minOrder` ASC [ RunTime:0.027812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814459 ORDER BY `unit` DESC [ RunTime:0.016964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814459 LIMIT 2 [ RunTime:0.007849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814459 ORDER BY `minOrder` ASC [ RunTime:0.018842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814458 LIMIT 5 [ RunTime:0.007345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814458 ORDER BY `minOrder` ASC [ RunTime:0.006304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814458 ORDER BY `unit` DESC [ RunTime:0.015476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814458 LIMIT 2 [ RunTime:0.004230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814458 ORDER BY `minOrder` ASC [ RunTime:0.002782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813250 LIMIT 5 [ RunTime:0.051958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813250 ORDER BY `minOrder` ASC [ RunTime:0.040989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813250 ORDER BY `unit` DESC [ RunTime:0.059606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813250 LIMIT 2 [ RunTime:0.016210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813250 ORDER BY `minOrder` ASC [ RunTime:0.013782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931511 LIMIT 5 [ RunTime:0.037432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931511 ORDER BY `minOrder` ASC [ RunTime:0.025984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931511 ORDER BY `unit` DESC [ RunTime:0.007254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931511 LIMIT 2 [ RunTime:0.023817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931511 ORDER BY `minOrder` ASC [ RunTime:0.005441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918150 LIMIT 5 [ RunTime:0.010785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918150 ORDER BY `minOrder` ASC [ RunTime:0.005862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918150 ORDER BY `unit` DESC [ RunTime:0.004919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918150 LIMIT 2 [ RunTime:0.008993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918150 ORDER BY `minOrder` ASC [ RunTime:0.005560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918038 LIMIT 5 [ RunTime:0.013012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918038 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918038 ORDER BY `unit` DESC [ RunTime:0.014835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918038 LIMIT 2 [ RunTime:0.030506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918038 ORDER BY `minOrder` ASC [ RunTime:0.014978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917466 LIMIT 5 [ RunTime:0.007386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917466 ORDER BY `minOrder` ASC [ RunTime:0.011572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917466 ORDER BY `unit` DESC [ RunTime:0.013109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917466 LIMIT 2 [ RunTime:0.003846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917466 ORDER BY `minOrder` ASC [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917135 LIMIT 5 [ RunTime:0.015645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917135 ORDER BY `minOrder` ASC [ RunTime:0.016302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917135 ORDER BY `unit` DESC [ RunTime:0.042853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917135 LIMIT 2 [ RunTime:0.033717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917135 ORDER BY `minOrder` ASC [ RunTime:0.013754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917056 LIMIT 5 [ RunTime:0.011695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917056 ORDER BY `minOrder` ASC [ RunTime:0.009952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917056 ORDER BY `unit` DESC [ RunTime:0.018078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917056 LIMIT 2 [ RunTime:0.004134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917056 ORDER BY `minOrder` ASC [ RunTime:0.011506s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005553s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42268540 LIMIT 5 [ RunTime:0.007525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268540 ORDER BY `minOrder` ASC [ RunTime:0.020489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42268540 ORDER BY `unit` DESC [ RunTime:0.006055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42268540 LIMIT 2 [ RunTime:0.014278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268540 ORDER BY `minOrder` ASC [ RunTime:0.033968s ]
select * from pdf where partno='SMB10J22AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.022496s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015411s ]
SELECT `id` FROM `stock` WHERE `id` <> 42268540 AND `partno` = 'SMB10J22AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.054270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918150 [ RunTime:0.003810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42268506 LIMIT 5 [ RunTime:0.007930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268506 ORDER BY `minOrder` ASC [ RunTime:0.013502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42268506 ORDER BY `unit` DESC [ RunTime:0.007749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42268506 LIMIT 2 [ RunTime:0.012225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268506 ORDER BY `minOrder` ASC [ RunTime:0.005689s ]
select * from pdf where partno='SMB10J22AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008172s ]
SELECT `id` FROM `stock` WHERE `id` <> 42268506 AND `partno` = 'SMB10J22AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815785 [ RunTime:0.005983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267666 LIMIT 5 [ RunTime:0.020369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267666 ORDER BY `minOrder` ASC [ RunTime:0.056090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267666 ORDER BY `unit` DESC [ RunTime:0.033552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267666 LIMIT 2 [ RunTime:0.015329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267666 ORDER BY `minOrder` ASC [ RunTime:0.007470s ]
select * from pdf where partno='SMB10J22AHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.056754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.029984s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267666 AND `partno` = 'SMB10J22AHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.028479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674153 [ RunTime:0.010448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267665 LIMIT 5 [ RunTime:0.014584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267665 ORDER BY `minOrder` ASC [ RunTime:0.014247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267665 ORDER BY `unit` DESC [ RunTime:0.039124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267665 LIMIT 2 [ RunTime:0.054892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267665 ORDER BY `minOrder` ASC [ RunTime:0.017086s ]
select * from pdf where partno='SMB10J22AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.023285s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267665 AND `partno` = 'SMB10J22AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814459 [ RunTime:0.013226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42266846 LIMIT 5 [ RunTime:0.008321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266846 ORDER BY `minOrder` ASC [ RunTime:0.030497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42266846 ORDER BY `unit` DESC [ RunTime:0.032948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42266846 LIMIT 2 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266846 ORDER BY `minOrder` ASC [ RunTime:0.015165s ]
select * from pdf where partno='SMB10J22AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007295s ]
SELECT `id` FROM `stock` WHERE `id` <> 42266846 AND `partno` = 'SMB10J22AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918038 [ RunTime:0.051338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42265221 LIMIT 5 [ RunTime:0.020785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42265221 ORDER BY `minOrder` ASC [ RunTime:0.023667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42265221 ORDER BY `unit` DESC [ RunTime:0.007763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42265221 LIMIT 2 [ RunTime:0.095885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42265221 ORDER BY `minOrder` ASC [ RunTime:0.049035s ]
select * from pdf where partno='SMB10J22AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.035110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.017864s ]
SELECT `id` FROM `stock` WHERE `id` <> 42265221 AND `partno` = 'SMB10J22AHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.025213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917056 [ RunTime:0.094155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42265216 LIMIT 5 [ RunTime:0.036750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42265216 ORDER BY `minOrder` ASC [ RunTime:0.025625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42265216 ORDER BY `unit` DESC [ RunTime:0.019837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42265216 LIMIT 2 [ RunTime:0.026318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42265216 ORDER BY `minOrder` ASC [ RunTime:0.014504s ]
select * from pdf where partno='SMB10J22AHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013329s ]
SELECT `id` FROM `stock` WHERE `id` <> 42265216 AND `partno` = 'SMB10J22AHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814458 [ RunTime:0.005311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42261002 LIMIT 5 [ RunTime:0.004351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261002 ORDER BY `minOrder` ASC [ RunTime:0.009844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42261002 ORDER BY `unit` DESC [ RunTime:0.021504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42261002 LIMIT 2 [ RunTime:0.025422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261002 ORDER BY `minOrder` ASC [ RunTime:0.017862s ]
select * from pdf where partno='SMB10J22AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004579s ]
SELECT `id` FROM `stock` WHERE `id` <> 42261002 AND `partno` = 'SMB10J22AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917466 [ RunTime:0.008129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42254379 LIMIT 5 [ RunTime:0.016887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42254379 ORDER BY `minOrder` ASC [ RunTime:0.014076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42254379 ORDER BY `unit` DESC [ RunTime:0.046225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42254379 LIMIT 2 [ RunTime:0.030569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42254379 ORDER BY `minOrder` ASC [ RunTime:0.024586s ]
select * from pdf where partno='SMB10J22A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.041990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22A-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.031219s ]
SELECT `id` FROM `stock` WHERE `id` <> 42254379 AND `partno` = 'SMB10J22A-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.087610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814862 [ RunTime:0.030129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42253869 LIMIT 5 [ RunTime:0.033259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253869 ORDER BY `minOrder` ASC [ RunTime:0.014611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42253869 ORDER BY `unit` DESC [ RunTime:0.018090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42253869 LIMIT 2 [ RunTime:0.018593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253869 ORDER BY `minOrder` ASC [ RunTime:0.011402s ]
select * from pdf where partno='SMB10J22A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.110555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.052296s ]
SELECT `id` FROM `stock` WHERE `id` <> 42253869 AND `partno` = 'SMB10J22A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.091443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674269 [ RunTime:0.052834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42253852 LIMIT 5 [ RunTime:0.075903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253852 ORDER BY `minOrder` ASC [ RunTime:0.064638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42253852 ORDER BY `unit` DESC [ RunTime:0.025984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42253852 LIMIT 2 [ RunTime:0.083441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253852 ORDER BY `minOrder` ASC [ RunTime:0.020755s ]
select * from pdf where partno='SMB10J22A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.041037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22A-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011591s ]
SELECT `id` FROM `stock` WHERE `id` <> 42253852 AND `partno` = 'SMB10J22A-M3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.041943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814814 [ RunTime:0.081403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42253837 LIMIT 5 [ RunTime:0.087557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253837 ORDER BY `minOrder` ASC [ RunTime:0.057698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42253837 ORDER BY `unit` DESC [ RunTime:0.023858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42253837 LIMIT 2 [ RunTime:0.077759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42253837 ORDER BY `minOrder` ASC [ RunTime:0.008233s ]
select * from pdf where partno='SMB10J22A-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22A-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.045589s ]
SELECT `id` FROM `stock` WHERE `id` <> 42253837 AND `partno` = 'SMB10J22A-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.047742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917135 [ RunTime:0.114227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42243800 LIMIT 5 [ RunTime:0.042361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243800 ORDER BY `minOrder` ASC [ RunTime:0.074407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42243800 ORDER BY `unit` DESC [ RunTime:0.058556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42243800 LIMIT 2 [ RunTime:0.033788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243800 ORDER BY `minOrder` ASC [ RunTime:0.018695s ]
select * from pdf where partno='SMB10J22AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.044515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.011941s ]
SELECT `id` FROM `stock` WHERE `id` <> 42243800 AND `partno` = 'SMB10J22AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813250 [ RunTime:0.047142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42241557 LIMIT 5 [ RunTime:0.068022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241557 ORDER BY `minOrder` ASC [ RunTime:0.033099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42241557 ORDER BY `unit` DESC [ RunTime:0.054040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42241557 LIMIT 2 [ RunTime:0.079674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42241557 ORDER BY `minOrder` ASC [ RunTime:0.058048s ]
select * from pdf where partno='SMB10J22A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.029074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.110996s ]
SELECT `id` FROM `stock` WHERE `id` <> 42241557 AND `partno` = 'SMB10J22A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.064392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673022 [ RunTime:0.063351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234600 LIMIT 5 [ RunTime:0.025393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234600 ORDER BY `minOrder` ASC [ RunTime:0.096276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234600 ORDER BY `unit` DESC [ RunTime:0.024848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234600 LIMIT 2 [ RunTime:0.044507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234600 ORDER BY `minOrder` ASC [ RunTime:0.004100s ]
select * from pdf where partno='SMB10J22AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.046476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.016750s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234600 AND `partno` = 'SMB10J22AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.061226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913954 [ RunTime:0.045812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42229782 LIMIT 5 [ RunTime:0.043534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229782 ORDER BY `minOrder` ASC [ RunTime:0.058097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42229782 ORDER BY `unit` DESC [ RunTime:0.035239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42229782 LIMIT 2 [ RunTime:0.055493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229782 ORDER BY `minOrder` ASC [ RunTime:0.022487s ]
select * from pdf where partno='SMB10J22A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.052034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMB10J22A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.035090s ]
SELECT `id` FROM `stock` WHERE `id` <> 42229782 AND `partno` = 'SMB10J22A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.044132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913907 [ RunTime:0.057501s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052377s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024273s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061941s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006016s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007480s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066669s ]
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 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012327s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMB10J22A%' OR `brand` LIKE 'SMB10J22A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.044554s ]