SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002142s ]
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=BAV74&search=1' [ RunTime:0.021620s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001435s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.015155s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001186s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.019485s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001325s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006241s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001502s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BAV74' LIMIT 1 [ RunTime:0.036909s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-29 10:55:20' WHERE `partno` = 'BAV74' [ RunTime:0.018203s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001439s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017362s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16343 LIMIT 5 [ RunTime:0.009685s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16343 ORDER BY `minOrder` ASC [ RunTime:0.065359s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16343 ORDER BY `unit` DESC [ RunTime:0.023121s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16343 LIMIT 2 [ RunTime:0.048581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16343 ORDER BY `minOrder` ASC [ RunTime:0.020503s ]
select * from pdf where partno='BAV74LT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.045901s ]
select foldpath,foldpath2,filename from pdf_file where id=668717 limit 1 [ RunTime:0.018064s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.044150s ]
SELECT `id` FROM `stock` WHERE `id` <> 16343 AND `partno` = 'BAV74LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.022849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7483 [ RunTime:0.024543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15323 [ RunTime:0.022786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633174 [ RunTime:0.012082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15323 LIMIT 5 [ RunTime:0.039054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15323 ORDER BY `minOrder` ASC [ RunTime:0.008383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15323 ORDER BY `unit` DESC [ RunTime:0.019843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15323 LIMIT 2 [ RunTime:0.001690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15323 ORDER BY `minOrder` ASC [ RunTime:0.026964s ]
select * from pdf where partno='BAV74LT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.034720s ]
select foldpath,foldpath2,filename from pdf_file where id=668717 limit 1 [ RunTime:0.002633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.006176s ]
SELECT `id` FROM `stock` WHERE `id` <> 15323 AND `partno` = 'BAV74LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.006333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7483 [ RunTime:0.008168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16343 [ RunTime:0.009982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633174 [ RunTime:0.014199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7483 LIMIT 5 [ RunTime:0.012595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7483 ORDER BY `minOrder` ASC [ RunTime:0.005347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7483 ORDER BY `unit` DESC [ RunTime:0.025657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7483 LIMIT 2 [ RunTime:0.012697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7483 ORDER BY `minOrder` ASC [ RunTime:0.005278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.006291s ]
SELECT `id` FROM `stock` WHERE `id` <> 7483 AND `partno` = 'BAV74LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.031823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15323 [ RunTime:0.025579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16343 [ RunTime:0.006870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633174 [ RunTime:0.005028s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006891s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44728342 LIMIT 5 [ RunTime:0.025455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44728342 ORDER BY `minOrder` ASC [ RunTime:0.006060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44728342 ORDER BY `unit` DESC [ RunTime:0.012685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44728342 LIMIT 2 [ RunTime:0.025645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44728342 ORDER BY `minOrder` ASC [ RunTime:0.002108s ]
select * from pdf where partno='BAV74LT3' and brandshort='onsemi' limit 1 [ RunTime:0.014159s ]
select foldpath,foldpath2,filename from pdf_file where id=668717 limit 1 [ RunTime:0.001176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.015481s ]
SELECT `id` FROM `stock` WHERE `id` <> 44728342 AND `partno` = 'BAV74LT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.004410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33223002 [ RunTime:0.026702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33223002 LIMIT 5 [ RunTime:0.009731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33223002 ORDER BY `minOrder` ASC [ RunTime:0.018332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33223002 ORDER BY `unit` DESC [ RunTime:0.007280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33223002 LIMIT 2 [ RunTime:0.004490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33223002 ORDER BY `minOrder` ASC [ RunTime:0.008502s ]
select * from pdf where partno='BAV74LT3' and brandshort='onsemi' limit 1 [ RunTime:0.002845s ]
select foldpath,foldpath2,filename from pdf_file where id=668717 limit 1 [ RunTime:0.000432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.003037s ]
SELECT `id` FROM `stock` WHERE `id` <> 33223002 AND `partno` = 'BAV74LT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.027079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44728342 [ RunTime:0.021955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630130 LIMIT 5 [ RunTime:0.005321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630130 ORDER BY `minOrder` ASC [ RunTime:0.036028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630130 ORDER BY `unit` DESC [ RunTime:0.010376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630130 LIMIT 2 [ RunTime:0.022167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630130 ORDER BY `minOrder` ASC [ RunTime:0.020909s ]
select * from pdf where partno='BAV74' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.013276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.027320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630131 LIMIT 5 [ RunTime:0.044276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630131 ORDER BY `minOrder` ASC [ RunTime:0.049905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630131 ORDER BY `unit` DESC [ RunTime:0.040029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630131 LIMIT 2 [ RunTime:0.017986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630131 ORDER BY `minOrder` ASC [ RunTime:0.019712s ]
select * from pdf where partno='BAV74' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.024880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.020127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630132 LIMIT 5 [ RunTime:0.008732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630132 ORDER BY `minOrder` ASC [ RunTime:0.016123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630132 ORDER BY `unit` DESC [ RunTime:0.005386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630132 LIMIT 2 [ RunTime:0.036433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630132 ORDER BY `minOrder` ASC [ RunTime:0.027366s ]
select * from pdf where partno='BAV74' and brandshort='Siemens' limit 1 [ RunTime:0.047617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.032555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58627804 LIMIT 5 [ RunTime:0.022111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627804 ORDER BY `minOrder` ASC [ RunTime:0.028902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58627804 ORDER BY `unit` DESC [ RunTime:0.017894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58627804 LIMIT 2 [ RunTime:0.009469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58627804 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
select * from pdf where partno='BAV74,215' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.014359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74,215' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.014192s ]
SELECT `id` FROM `stock` WHERE `id` <> 58627804 AND `partno` = 'BAV74,215' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.056502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58634056 LIMIT 5 [ RunTime:0.015706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634056 ORDER BY `minOrder` ASC [ RunTime:0.055774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58634056 ORDER BY `unit` DESC [ RunTime:0.015736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58634056 LIMIT 2 [ RunTime:0.074230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634056 ORDER BY `minOrder` ASC [ RunTime:0.034393s ]
select * from pdf where partno='BAV74-QR' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.059783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74-QR' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.030690s ]
SELECT `id` FROM `stock` WHERE `id` <> 58634056 AND `partno` = 'BAV74-QR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.117876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58634034 LIMIT 5 [ RunTime:0.065516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634034 ORDER BY `minOrder` ASC [ RunTime:0.015545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58634034 ORDER BY `unit` DESC [ RunTime:0.033168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58634034 LIMIT 2 [ RunTime:0.031728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634034 ORDER BY `minOrder` ASC [ RunTime:0.013316s ]
select * from pdf where partno='BAV74_D87Z' and brandshort='onsemi' limit 1 [ RunTime:0.019768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74_D87Z' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.033513s ]
SELECT `id` FROM `stock` WHERE `id` <> 58634034 AND `partno` = 'BAV74_D87Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.052198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58634023 LIMIT 5 [ RunTime:0.043816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634023 ORDER BY `minOrder` ASC [ RunTime:0.016155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58634023 ORDER BY `unit` DESC [ RunTime:0.021337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58634023 LIMIT 2 [ RunTime:0.009190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634023 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
select * from pdf where partno='BAV74-13P' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74-13P' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.022291s ]
SELECT `id` FROM `stock` WHERE `id` <> 58634023 AND `partno` = 'BAV74-13P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.011358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58634014 LIMIT 5 [ RunTime:0.008451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634014 ORDER BY `minOrder` ASC [ RunTime:0.004160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58634014 ORDER BY `unit` DESC [ RunTime:0.002871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58634014 LIMIT 2 [ RunTime:0.002788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58634014 ORDER BY `minOrder` ASC [ RunTime:0.008159s ]
select * from pdf where partno='BAV74LT3G' and brandshort='onsemi' limit 1 [ RunTime:0.023200s ]
select foldpath,foldpath2,filename from pdf_file where id=668717 limit 1 [ RunTime:0.009104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT3G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.023549s ]
SELECT `id` FROM `stock` WHERE `id` <> 58634014 AND `partno` = 'BAV74LT3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.021823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633527 LIMIT 5 [ RunTime:0.007111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633527 ORDER BY `minOrder` ASC [ RunTime:0.014409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58633527 ORDER BY `unit` DESC [ RunTime:0.015516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58633527 LIMIT 2 [ RunTime:0.025316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633527 ORDER BY `minOrder` ASC [ RunTime:0.017237s ]
select * from pdf where partno='BAV74-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.017721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.025642s ]
SELECT `id` FROM `stock` WHERE `id` <> 58633527 AND `partno` = 'BAV74-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.008665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633524 LIMIT 5 [ RunTime:0.023352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633524 ORDER BY `minOrder` ASC [ RunTime:0.013432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58633524 ORDER BY `unit` DESC [ RunTime:0.024534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58633524 LIMIT 2 [ RunTime:0.044177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633524 ORDER BY `minOrder` ASC [ RunTime:0.048205s ]
select * from pdf where partno='BAV74,235' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.046534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74,235' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.011421s ]
SELECT `id` FROM `stock` WHERE `id` <> 58633524 AND `partno` = 'BAV74,235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.018627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58633174 LIMIT 5 [ RunTime:0.030883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633174 ORDER BY `minOrder` ASC [ RunTime:0.029718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58633174 ORDER BY `unit` DESC [ RunTime:0.016078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58633174 LIMIT 2 [ RunTime:0.039461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58633174 ORDER BY `minOrder` ASC [ RunTime:0.032072s ]
select * from pdf where partno='BAV74LT1G' and brandshort='onsemi' limit 1 [ RunTime:0.019769s ]
select foldpath,foldpath2,filename from pdf_file where id=668717 limit 1 [ RunTime:0.021681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT1G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.054588s ]
SELECT `id` FROM `stock` WHERE `id` <> 58633174 AND `partno` = 'BAV74LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.028309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7483 [ RunTime:0.020968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15323 [ RunTime:0.015995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16343 [ RunTime:0.003769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630390 LIMIT 5 [ RunTime:0.040467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630390 ORDER BY `minOrder` ASC [ RunTime:0.024726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630390 ORDER BY `unit` DESC [ RunTime:0.022013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630390 LIMIT 2 [ RunTime:0.042338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630390 ORDER BY `minOrder` ASC [ RunTime:0.018325s ]
select * from pdf where partno='BAV74' and brandshort='onsemi' limit 1 [ RunTime:0.012071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.071578s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630390 AND `partno` = 'BAV74' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.018235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630082 LIMIT 5 [ RunTime:0.024069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630082 ORDER BY `minOrder` ASC [ RunTime:0.015600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630082 ORDER BY `unit` DESC [ RunTime:0.014251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630082 LIMIT 2 [ RunTime:0.014389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630082 ORDER BY `minOrder` ASC [ RunTime:0.004440s ]
select * from pdf where partno='BAV74LT1' and brandshort='onsemi' limit 1 [ RunTime:0.018752s ]
select foldpath,foldpath2,filename from pdf_file where id=381758 limit 1 [ RunTime:0.038339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAV74LT1' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.020392s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630082 AND `partno` = 'BAV74LT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.003100s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010339s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010851s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014964s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005967s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014121s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008076s ]
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 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007732s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BAV74%' OR `brand` LIKE 'BAV74%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003413s ]