SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001167s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=BAV70W&search=1' [ RunTime:0.021210s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002212s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011452s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001714s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.004786s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001193s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.024411s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001576s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BAV70W' LIMIT 1 [ RunTime:0.057739s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-29 10:55:20' WHERE `partno` = 'BAV70W' [ RunTime:0.023889s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002650s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039390s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049469s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037322s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58627800 LIMIT 5 [ RunTime:0.057151s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627800 ORDER BY `minOrder` ASC [ RunTime:0.020187s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58627800 ORDER BY `unit` DESC [ RunTime:0.018408s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58627800 LIMIT 2 [ RunTime:0.020214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627800 ORDER BY `minOrder` ASC [ RunTime:0.011729s ]
select * from pdf where partno='BAV70W,115' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.025694s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W,115' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.023904s ]
SELECT `id` FROM `stock` WHERE `id` <> 58627800 AND `partno` = 'BAV70W,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.030749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58631182 LIMIT 5 [ RunTime:0.044074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631182 ORDER BY `minOrder` ASC [ RunTime:0.027409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58631182 ORDER BY `unit` DESC [ RunTime:0.006222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58631182 LIMIT 2 [ RunTime:0.057326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631182 ORDER BY `minOrder` ASC [ RunTime:0.002191s ]
select * from pdf where partno='BAV70W/ZL,115' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.007945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W/ZL,115' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.012933s ]
SELECT `id` FROM `stock` WHERE `id` <> 58631182 AND `partno` = 'BAV70W/ZL,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.022117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58629045 LIMIT 5 [ RunTime:0.008849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58629045 ORDER BY `minOrder` ASC [ RunTime:0.009496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58629045 ORDER BY `unit` DESC [ RunTime:0.002006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58629045 LIMIT 2 [ RunTime:0.016446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58629045 ORDER BY `minOrder` ASC [ RunTime:0.012402s ]
select * from pdf where partno='BAV70WT-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.013084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70WT-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.004031s ]
SELECT `id` FROM `stock` WHERE `id` <> 58629045 AND `partno` = 'BAV70WT-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.024472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630300 LIMIT 5 [ RunTime:0.019203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630300 ORDER BY `minOrder` ASC [ RunTime:0.025526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630300 ORDER BY `unit` DESC [ RunTime:0.020323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630300 LIMIT 2 [ RunTime:0.003298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630300 ORDER BY `minOrder` ASC [ RunTime:0.017424s ]
select * from pdf where partno='BAV70W_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.011479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.011152s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630300 AND `partno` = 'BAV70W_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.022618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58628402 LIMIT 5 [ RunTime:0.024553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58628402 ORDER BY `minOrder` ASC [ RunTime:0.016554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58628402 ORDER BY `unit` DESC [ RunTime:0.012727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58628402 LIMIT 2 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58628402 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='BAV70W-QF' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.013252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W-QF' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000937s ]
SELECT `id` FROM `stock` WHERE `id` <> 58628402 AND `partno` = 'BAV70W-QF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.016222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58629836 LIMIT 5 [ RunTime:0.014773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58629836 ORDER BY `minOrder` ASC [ RunTime:0.009786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58629836 ORDER BY `unit` DESC [ RunTime:0.016451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58629836 LIMIT 2 [ RunTime:0.002579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58629836 ORDER BY `minOrder` ASC [ RunTime:0.008341s ]
select * from pdf where partno='BAV70W-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.009185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002878s ]
SELECT `id` FROM `stock` WHERE `id` <> 58629836 AND `partno` = 'BAV70W-AQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.003323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630190 LIMIT 5 [ RunTime:0.027126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630190 ORDER BY `minOrder` ASC [ RunTime:0.017839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630190 ORDER BY `unit` DESC [ RunTime:0.005163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630190 LIMIT 2 [ RunTime:0.024356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630190 ORDER BY `minOrder` ASC [ RunTime:0.016306s ]
select * from pdf where partno='BAV70W' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.022349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.012985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58627799 LIMIT 5 [ RunTime:0.015082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627799 ORDER BY `minOrder` ASC [ RunTime:0.026232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58627799 ORDER BY `unit` DESC [ RunTime:0.026633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58627799 LIMIT 2 [ RunTime:0.036664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627799 ORDER BY `minOrder` ASC [ RunTime:0.012318s ]
select * from pdf where partno='BAV70WT1G' and brandshort='onsemi' limit 1 [ RunTime:0.021232s ]
select foldpath,foldpath2,filename from pdf_file where id=672055 limit 1 [ RunTime:0.044858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70WT1G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.022931s ]
SELECT `id` FROM `stock` WHERE `id` <> 58627799 AND `partno` = 'BAV70WT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.031180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58627850 LIMIT 5 [ RunTime:0.030784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627850 ORDER BY `minOrder` ASC [ RunTime:0.025217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58627850 ORDER BY `unit` DESC [ RunTime:0.006859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58627850 LIMIT 2 [ RunTime:0.013198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627850 ORDER BY `minOrder` ASC [ RunTime:0.037019s ]
select * from pdf where partno='BAV70W' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.036921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.041806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630314 LIMIT 5 [ RunTime:0.028062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630314 ORDER BY `minOrder` ASC [ RunTime:0.043519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630314 ORDER BY `unit` DESC [ RunTime:0.030818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630314 LIMIT 2 [ RunTime:0.010745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630314 ORDER BY `minOrder` ASC [ RunTime:0.019634s ]
select * from pdf where partno='BAV70W-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.029766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.027478s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630314 AND `partno` = 'BAV70W-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.067535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58627851 LIMIT 5 [ RunTime:0.053569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627851 ORDER BY `minOrder` ASC [ RunTime:0.085218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58627851 ORDER BY `unit` DESC [ RunTime:0.058809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58627851 LIMIT 2 [ RunTime:0.033607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627851 ORDER BY `minOrder` ASC [ RunTime:0.021657s ]
select * from pdf where partno='BAV70W-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.015041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.053184s ]
SELECT `id` FROM `stock` WHERE `id` <> 58627851 AND `partno` = 'BAV70W-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.103338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58631883 LIMIT 5 [ RunTime:0.010085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631883 ORDER BY `minOrder` ASC [ RunTime:0.049141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58631883 ORDER BY `unit` DESC [ RunTime:0.014539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58631883 LIMIT 2 [ RunTime:0.012630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631883 ORDER BY `minOrder` ASC [ RunTime:0.004204s ]
select * from pdf where partno='BAV70WH RFG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70WH RFG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.014760s ]
SELECT `id` FROM `stock` WHERE `id` <> 58631883 AND `partno` = 'BAV70WH RFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.026488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58631348 LIMIT 5 [ RunTime:0.018896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631348 ORDER BY `minOrder` ASC [ RunTime:0.044555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58631348 ORDER BY `unit` DESC [ RunTime:0.018047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58631348 LIMIT 2 [ RunTime:0.013831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631348 ORDER BY `minOrder` ASC [ RunTime:0.007135s ]
select * from pdf where partno='BAV70W,135' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.011323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W,135' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003831s ]
SELECT `id` FROM `stock` WHERE `id` <> 58631348 AND `partno` = 'BAV70W,135' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.000898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633925 LIMIT 5 [ RunTime:0.006932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633925 ORDER BY `minOrder` ASC [ RunTime:0.018996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58633925 ORDER BY `unit` DESC [ RunTime:0.003764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58633925 LIMIT 2 [ RunTime:0.001291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633925 ORDER BY `minOrder` ASC [ RunTime:0.007447s ]
select * from pdf where partno='BAV70WTHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.012146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70WTHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.006912s ]
SELECT `id` FROM `stock` WHERE `id` <> 58633925 AND `partno` = 'BAV70WTHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.002545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58634289 LIMIT 5 [ RunTime:0.009169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634289 ORDER BY `minOrder` ASC [ RunTime:0.023807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58634289 ORDER BY `unit` DESC [ RunTime:0.007555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58634289 LIMIT 2 [ RunTime:0.005075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634289 ORDER BY `minOrder` ASC [ RunTime:0.007665s ]
select * from pdf where partno='BAV70W-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.007576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.005836s ]
SELECT `id` FROM `stock` WHERE `id` <> 58634289 AND `partno` = 'BAV70W-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.023917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58634088 LIMIT 5 [ RunTime:0.008712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634088 ORDER BY `minOrder` ASC [ RunTime:0.005593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58634088 ORDER BY `unit` DESC [ RunTime:0.011851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58634088 LIMIT 2 [ RunTime:0.002246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634088 ORDER BY `minOrder` ASC [ RunTime:0.015918s ]
select * from pdf where partno='BAV70W' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.024308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.028312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633210 LIMIT 5 [ RunTime:0.016545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633210 ORDER BY `minOrder` ASC [ RunTime:0.011831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58633210 ORDER BY `unit` DESC [ RunTime:0.016025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58633210 LIMIT 2 [ RunTime:0.002322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633210 ORDER BY `minOrder` ASC [ RunTime:0.006089s ]
select * from pdf where partno='BAV70WQ-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.026867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70WQ-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.012918s ]
SELECT `id` FROM `stock` WHERE `id` <> 58633210 AND `partno` = 'BAV70WQ-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.011585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633184 LIMIT 5 [ RunTime:0.040678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633184 ORDER BY `minOrder` ASC [ RunTime:0.046063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58633184 ORDER BY `unit` DESC [ RunTime:0.009213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58633184 LIMIT 2 [ RunTime:0.030224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633184 ORDER BY `minOrder` ASC [ RunTime:0.003208s ]
select * from pdf where partno='BAV70W-QX' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.009442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W-QX' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.010794s ]
SELECT `id` FROM `stock` WHERE `id` <> 58633184 AND `partno` = 'BAV70W-QX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.023434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630138 LIMIT 5 [ RunTime:0.035623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630138 ORDER BY `minOrder` ASC [ RunTime:0.014563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630138 ORDER BY `unit` DESC [ RunTime:0.026089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630138 LIMIT 2 [ RunTime:0.022602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630138 ORDER BY `minOrder` ASC [ RunTime:0.014367s ]
select * from pdf where partno='BAV70WH6433XTMA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.023998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70WH6433XTMA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.012021s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630138 AND `partno` = 'BAV70WH6433XTMA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.031428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630108 LIMIT 5 [ RunTime:0.010311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630108 ORDER BY `minOrder` ASC [ RunTime:0.030629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630108 ORDER BY `unit` DESC [ RunTime:0.018569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630108 LIMIT 2 [ RunTime:0.028489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630108 ORDER BY `minOrder` ASC [ RunTime:0.016868s ]
select * from pdf where partno='BAV70W/ZLF' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.044696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV70W/ZLF' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.046460s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630108 AND `partno` = 'BAV70W/ZLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.023700s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041488s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023334s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042873s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016379s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017414s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010884s ]
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 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017976s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BAV70W%' OR `brand` LIKE 'BAV70W%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008322s ]