SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002512s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.87' , `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=50330&search=1' [ RunTime:0.002146s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002245s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000484s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002409s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.87' ) [ RunTime:0.002094s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002037s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003280s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002364s ]
SELECT * FROM `stock_search` WHERE `partno` = '50330' LIMIT 1 [ RunTime:0.009370s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-18 08:38:12' WHERE `partno` = '50330' [ RunTime:0.001870s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002459s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033136s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023763 LIMIT 5 [ RunTime:0.012117s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19023763 ORDER BY `minOrder` ASC [ RunTime:0.019844s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19023763 ORDER BY `unit` DESC [ RunTime:0.006859s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19023763 LIMIT 2 [ RunTime:0.028938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19023763 ORDER BY `minOrder` ASC [ RunTime:0.020257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17387429 LIMIT 5 [ RunTime:0.031201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17387429 ORDER BY `minOrder` ASC [ RunTime:0.009697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17387429 ORDER BY `unit` DESC [ RunTime:0.055897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17387429 LIMIT 2 [ RunTime:0.029267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17387429 ORDER BY `minOrder` ASC [ RunTime:0.073957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17387131 LIMIT 5 [ RunTime:0.059944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17387131 ORDER BY `minOrder` ASC [ RunTime:0.128948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17387131 ORDER BY `unit` DESC [ RunTime:0.018825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17387131 LIMIT 2 [ RunTime:0.008856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17387131 ORDER BY `minOrder` ASC [ RunTime:0.024066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17386930 LIMIT 5 [ RunTime:0.063611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17386930 ORDER BY `minOrder` ASC [ RunTime:0.063630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17386930 ORDER BY `unit` DESC [ RunTime:0.043426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17386930 LIMIT 2 [ RunTime:0.044385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17386930 ORDER BY `minOrder` ASC [ RunTime:0.034679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274183 LIMIT 5 [ RunTime:0.034872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274183 ORDER BY `minOrder` ASC [ RunTime:0.019072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274183 ORDER BY `unit` DESC [ RunTime:0.037014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274183 LIMIT 2 [ RunTime:0.036637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274183 ORDER BY `minOrder` ASC [ RunTime:0.029022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187011 LIMIT 5 [ RunTime:0.073361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187011 ORDER BY `minOrder` ASC [ RunTime:0.063231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187011 ORDER BY `unit` DESC [ RunTime:0.040452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187011 LIMIT 2 [ RunTime:0.017673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187011 ORDER BY `minOrder` ASC [ RunTime:0.004840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13181975 LIMIT 5 [ RunTime:0.014759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13181975 ORDER BY `minOrder` ASC [ RunTime:0.020957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13181975 ORDER BY `unit` DESC [ RunTime:0.009447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13181975 LIMIT 2 [ RunTime:0.024717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13181975 ORDER BY `minOrder` ASC [ RunTime:0.009468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13181912 LIMIT 5 [ RunTime:0.020049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13181912 ORDER BY `minOrder` ASC [ RunTime:0.002354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13181912 ORDER BY `unit` DESC [ RunTime:0.012429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13181912 LIMIT 2 [ RunTime:0.008670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13181912 ORDER BY `minOrder` ASC [ RunTime:0.019196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794689 LIMIT 5 [ RunTime:0.009238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794689 ORDER BY `minOrder` ASC [ RunTime:0.015670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794689 ORDER BY `unit` DESC [ RunTime:0.008038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794689 LIMIT 2 [ RunTime:0.001496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794689 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794559 LIMIT 5 [ RunTime:0.015150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794559 ORDER BY `minOrder` ASC [ RunTime:0.001460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794559 ORDER BY `unit` DESC [ RunTime:0.006566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794559 LIMIT 2 [ RunTime:0.014730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794559 ORDER BY `minOrder` ASC [ RunTime:0.009800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794440 LIMIT 5 [ RunTime:0.008638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794440 ORDER BY `minOrder` ASC [ RunTime:0.005805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794440 ORDER BY `unit` DESC [ RunTime:0.001070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794440 LIMIT 2 [ RunTime:0.008183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794440 ORDER BY `minOrder` ASC [ RunTime:0.006822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794434 LIMIT 5 [ RunTime:0.010972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794434 ORDER BY `minOrder` ASC [ RunTime:0.028647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794434 ORDER BY `unit` DESC [ RunTime:0.028672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794434 LIMIT 2 [ RunTime:0.014383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794434 ORDER BY `minOrder` ASC [ RunTime:0.014355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794403 LIMIT 5 [ RunTime:0.013401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794403 ORDER BY `minOrder` ASC [ RunTime:0.016050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794403 ORDER BY `unit` DESC [ RunTime:0.003372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794403 LIMIT 2 [ RunTime:0.022356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794403 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
select * from pdf where partno='5033084452' and brandshort='Molex' limit 1 [ RunTime:0.005223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794377 LIMIT 5 [ RunTime:0.026317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794377 ORDER BY `minOrder` ASC [ RunTime:0.017956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794377 ORDER BY `unit` DESC [ RunTime:0.018168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794377 LIMIT 2 [ RunTime:0.008847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794377 ORDER BY `minOrder` ASC [ RunTime:0.008952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794374 LIMIT 5 [ RunTime:0.007525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794374 ORDER BY `minOrder` ASC [ RunTime:0.018102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794374 ORDER BY `unit` DESC [ RunTime:0.033332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794374 LIMIT 2 [ RunTime:0.042527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794374 ORDER BY `minOrder` ASC [ RunTime:0.004814s ]
select * from pdf where partno='5033042440' and brandshort='Molex' limit 1 [ RunTime:0.012906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794355 LIMIT 5 [ RunTime:0.018773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794355 ORDER BY `minOrder` ASC [ RunTime:0.055750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794355 ORDER BY `unit` DESC [ RunTime:0.102038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794355 LIMIT 2 [ RunTime:0.029579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794355 ORDER BY `minOrder` ASC [ RunTime:0.046954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794346 LIMIT 5 [ RunTime:0.016894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794346 ORDER BY `minOrder` ASC [ RunTime:0.041755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794346 ORDER BY `unit` DESC [ RunTime:0.071541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794346 LIMIT 2 [ RunTime:0.037922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794346 ORDER BY `minOrder` ASC [ RunTime:0.011697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794338 LIMIT 5 [ RunTime:0.020059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794338 ORDER BY `minOrder` ASC [ RunTime:0.032180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794338 ORDER BY `unit` DESC [ RunTime:0.031013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794338 LIMIT 2 [ RunTime:0.034231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794338 ORDER BY `minOrder` ASC [ RunTime:0.010989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794318 LIMIT 5 [ RunTime:0.018321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794318 ORDER BY `minOrder` ASC [ RunTime:0.021123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794318 ORDER BY `unit` DESC [ RunTime:0.015279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794318 LIMIT 2 [ RunTime:0.012522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794318 ORDER BY `minOrder` ASC [ RunTime:0.014545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794281 LIMIT 5 [ RunTime:0.045546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794281 ORDER BY `minOrder` ASC [ RunTime:0.007302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794281 ORDER BY `unit` DESC [ RunTime:0.014479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794281 LIMIT 2 [ RunTime:0.005394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794281 ORDER BY `minOrder` ASC [ RunTime:0.018100s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034259s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359950 LIMIT 5 [ RunTime:0.030445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359950 ORDER BY `minOrder` ASC [ RunTime:0.028492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359950 ORDER BY `unit` DESC [ RunTime:0.007933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359950 LIMIT 2 [ RunTime:0.007921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359950 ORDER BY `minOrder` ASC [ RunTime:0.013193s ]
select * from pdf where partno='5033084012' and brandshort='Molex' limit 1 [ RunTime:0.023908s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033084012' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59362109 LIMIT 5 [ RunTime:0.010389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362109 ORDER BY `minOrder` ASC [ RunTime:0.016197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59362109 ORDER BY `unit` DESC [ RunTime:0.012292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59362109 LIMIT 2 [ RunTime:0.003445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59362109 ORDER BY `minOrder` ASC [ RunTime:0.009121s ]
select * from pdf where partno='503308-2412' and brandshort='Molex' limit 1 [ RunTime:0.016218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '503308-2412' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359970 LIMIT 5 [ RunTime:0.022624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359970 ORDER BY `minOrder` ASC [ RunTime:0.013216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359970 ORDER BY `unit` DESC [ RunTime:0.024872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359970 LIMIT 2 [ RunTime:0.047720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359970 ORDER BY `minOrder` ASC [ RunTime:0.027294s ]
select * from pdf where partno='5033081810' and brandshort='Molex' limit 1 [ RunTime:0.020435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033081810' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.047423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63436934 LIMIT 5 [ RunTime:0.052131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63436934 ORDER BY `minOrder` ASC [ RunTime:0.066366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63436934 ORDER BY `unit` DESC [ RunTime:0.039127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63436934 LIMIT 2 [ RunTime:0.044046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63436934 ORDER BY `minOrder` ASC [ RunTime:0.012204s ]
select * from pdf where partno='50330F' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.032482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50330F' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.014295s ]
SELECT `id` FROM `stock` WHERE `id` <> 63436934 AND `partno` = '50330F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.047446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274183 [ RunTime:0.021311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63435945 LIMIT 5 [ RunTime:0.024873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63435945 ORDER BY `minOrder` ASC [ RunTime:0.022507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63435945 ORDER BY `unit` DESC [ RunTime:0.013426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63435945 LIMIT 2 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63435945 ORDER BY `minOrder` ASC [ RunTime:0.008373s ]
select * from pdf where partno='50330' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.017230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50330' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.007887s ]
SELECT `id` FROM `stock` WHERE `id` <> 63435945 AND `partno` = '50330' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.020793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023763 [ RunTime:0.023704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60668120 LIMIT 5 [ RunTime:0.014956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60668120 ORDER BY `minOrder` ASC [ RunTime:0.031949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60668120 ORDER BY `unit` DESC [ RunTime:0.006844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60668120 LIMIT 2 [ RunTime:0.007334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60668120 ORDER BY `minOrder` ASC [ RunTime:0.024006s ]
select * from pdf where partno='5033005310' and brandshort='Molex' limit 1 [ RunTime:0.024499s ]
select foldpath,foldpath2,filename from pdf_file where id=2005988 limit 1 [ RunTime:0.016431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033005310' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60667750 LIMIT 5 [ RunTime:0.012595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60667750 ORDER BY `minOrder` ASC [ RunTime:0.045971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60667750 ORDER BY `unit` DESC [ RunTime:0.009279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60667750 LIMIT 2 [ RunTime:0.030256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60667750 ORDER BY `minOrder` ASC [ RunTime:0.005704s ]
select * from pdf where partno='5033004310' and brandshort='Molex' limit 1 [ RunTime:0.030736s ]
select foldpath,foldpath2,filename from pdf_file where id=2005988 limit 1 [ RunTime:0.004381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033004310' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60667650 LIMIT 5 [ RunTime:0.032779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60667650 ORDER BY `minOrder` ASC [ RunTime:0.011237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60667650 ORDER BY `unit` DESC [ RunTime:0.012952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60667650 LIMIT 2 [ RunTime:0.015186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60667650 ORDER BY `minOrder` ASC [ RunTime:0.011194s ]
select * from pdf where partno='5033004110' and brandshort='Molex' limit 1 [ RunTime:0.011682s ]
select foldpath,foldpath2,filename from pdf_file where id=2005988 limit 1 [ RunTime:0.001739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033004110' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60667337 LIMIT 5 [ RunTime:0.025381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60667337 ORDER BY `minOrder` ASC [ RunTime:0.021325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60667337 ORDER BY `unit` DESC [ RunTime:0.019894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60667337 LIMIT 2 [ RunTime:0.038857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60667337 ORDER BY `minOrder` ASC [ RunTime:0.010641s ]
select * from pdf where partno='5033002910' and brandshort='Molex' limit 1 [ RunTime:0.014676s ]
select foldpath,foldpath2,filename from pdf_file where id=2005988 limit 1 [ RunTime:0.028430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033002910' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.041207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60664921 LIMIT 5 [ RunTime:0.017630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60664921 ORDER BY `minOrder` ASC [ RunTime:0.035300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60664921 ORDER BY `unit` DESC [ RunTime:0.068376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60664921 LIMIT 2 [ RunTime:0.013002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60664921 ORDER BY `minOrder` ASC [ RunTime:0.026116s ]
select * from pdf where partno='5033003710' and brandshort='Molex' limit 1 [ RunTime:0.054195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033003710' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.100834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59366438 LIMIT 5 [ RunTime:0.065142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366438 ORDER BY `minOrder` ASC [ RunTime:0.077121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59366438 ORDER BY `unit` DESC [ RunTime:0.088846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59366438 LIMIT 2 [ RunTime:0.085039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366438 ORDER BY `minOrder` ASC [ RunTime:0.059627s ]
select * from pdf where partno='5033086020' and brandshort='Molex' limit 1 [ RunTime:0.049428s ]
select foldpath,foldpath2,filename from pdf_file where id=853141 limit 1 [ RunTime:0.090991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033086020' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.069942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59366429 LIMIT 5 [ RunTime:0.052156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366429 ORDER BY `minOrder` ASC [ RunTime:0.057165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59366429 ORDER BY `unit` DESC [ RunTime:0.015661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59366429 LIMIT 2 [ RunTime:0.043096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366429 ORDER BY `minOrder` ASC [ RunTime:0.015007s ]
select * from pdf where partno='5033046010' and brandshort='Molex' limit 1 [ RunTime:0.036390s ]
select foldpath,foldpath2,filename from pdf_file where id=853136 limit 1 [ RunTime:0.020412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033046010' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.096152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59366219 LIMIT 5 [ RunTime:0.077608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366219 ORDER BY `minOrder` ASC [ RunTime:0.038894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59366219 ORDER BY `unit` DESC [ RunTime:0.040316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59366219 LIMIT 2 [ RunTime:0.048546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366219 ORDER BY `minOrder` ASC [ RunTime:0.055198s ]
select * from pdf where partno='5033041210' and brandshort='Molex' limit 1 [ RunTime:0.021950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033041210' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.034440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59366122 LIMIT 5 [ RunTime:0.062458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366122 ORDER BY `minOrder` ASC [ RunTime:0.060933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59366122 ORDER BY `unit` DESC [ RunTime:0.074909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59366122 LIMIT 2 [ RunTime:0.050005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366122 ORDER BY `minOrder` ASC [ RunTime:0.045130s ]
select * from pdf where partno='5033041610' and brandshort='Molex' limit 1 [ RunTime:0.064180s ]
select foldpath,foldpath2,filename from pdf_file where id=1657176 limit 1 [ RunTime:0.038196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033041610' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.078691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59366003 LIMIT 5 [ RunTime:0.029880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366003 ORDER BY `minOrder` ASC [ RunTime:0.040880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59366003 ORDER BY `unit` DESC [ RunTime:0.020651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59366003 LIMIT 2 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59366003 ORDER BY `minOrder` ASC [ RunTime:0.003923s ]
select * from pdf where partno='5033044410' and brandshort='Molex' limit 1 [ RunTime:0.027328s ]
select foldpath,foldpath2,filename from pdf_file where id=853135 limit 1 [ RunTime:0.008629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033044410' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59365962 LIMIT 5 [ RunTime:0.011885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365962 ORDER BY `minOrder` ASC [ RunTime:0.021805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59365962 ORDER BY `unit` DESC [ RunTime:0.020739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59365962 LIMIT 2 [ RunTime:0.006703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365962 ORDER BY `minOrder` ASC [ RunTime:0.026944s ]
select * from pdf where partno='5033084210' and brandshort='Molex' limit 1 [ RunTime:0.017781s ]
select foldpath,foldpath2,filename from pdf_file where id=853142 limit 1 [ RunTime:0.014593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033084210' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59365934 LIMIT 5 [ RunTime:0.019415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365934 ORDER BY `minOrder` ASC [ RunTime:0.002257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59365934 ORDER BY `unit` DESC [ RunTime:0.027626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59365934 LIMIT 2 [ RunTime:0.030512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365934 ORDER BY `minOrder` ASC [ RunTime:0.034577s ]
select * from pdf where partno='5033044210' and brandshort='Molex' limit 1 [ RunTime:0.008971s ]
select foldpath,foldpath2,filename from pdf_file where id=853134 limit 1 [ RunTime:0.019405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033044210' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.026850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59365900 LIMIT 5 [ RunTime:0.010037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365900 ORDER BY `minOrder` ASC [ RunTime:0.032109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59365900 ORDER BY `unit` DESC [ RunTime:0.028982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59365900 LIMIT 2 [ RunTime:0.030320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365900 ORDER BY `minOrder` ASC [ RunTime:0.019173s ]
select * from pdf where partno='5033045040' and brandshort='Molex' limit 1 [ RunTime:0.016521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033045040' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.050808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59365826 LIMIT 5 [ RunTime:0.019692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365826 ORDER BY `minOrder` ASC [ RunTime:0.029736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59365826 ORDER BY `unit` DESC [ RunTime:0.068311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59365826 LIMIT 2 [ RunTime:0.013641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365826 ORDER BY `minOrder` ASC [ RunTime:0.026067s ]
select * from pdf where partno='5033044440' and brandshort='Molex' limit 1 [ RunTime:0.018723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033044440' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.028748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59365497 LIMIT 5 [ RunTime:0.043165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365497 ORDER BY `minOrder` ASC [ RunTime:0.043588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59365497 ORDER BY `unit` DESC [ RunTime:0.026752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59365497 LIMIT 2 [ RunTime:0.034350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59365497 ORDER BY `minOrder` ASC [ RunTime:0.044745s ]
select * from pdf where partno='5033042610' and brandshort='Molex' limit 1 [ RunTime:0.080272s ]
select foldpath,foldpath2,filename from pdf_file where id=853132 limit 1 [ RunTime:0.034108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5033042610' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.053258s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038768s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068478s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034174s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031245s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061249s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046396s ]
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 '50330%' OR `brand` LIKE '50330%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063195s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '50330%' OR `brand` LIKE '50330%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.062141s ]