SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002437s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=09826&search=1' [ RunTime:0.003905s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001859s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004862s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002977s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.001544s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002264s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007192s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002066s ]
SELECT * FROM `stock_search` WHERE `partno` = '09826' LIMIT 1 [ RunTime:0.014309s ]
UPDATE `stock_search` SET `count` = 34 , `updatetime` = '2026-08-16 07:22:49' WHERE `partno` = '09826' [ RunTime:0.019639s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001993s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072946s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14517021 LIMIT 5 [ RunTime:0.030558s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517021 ORDER BY `minOrder` ASC [ RunTime:0.040022s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14517021 ORDER BY `unit` DESC [ RunTime:0.005039s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14517021 LIMIT 2 [ RunTime:0.033966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517021 ORDER BY `minOrder` ASC [ RunTime:0.024307s ]
select * from pdf where partno='0982670701' and brandshort='Molex' limit 1 [ RunTime:0.009966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13643019 LIMIT 5 [ RunTime:0.036271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643019 ORDER BY `minOrder` ASC [ RunTime:0.026279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13643019 ORDER BY `unit` DESC [ RunTime:0.016963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13643019 LIMIT 2 [ RunTime:0.008835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643019 ORDER BY `minOrder` ASC [ RunTime:0.014496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13643746 LIMIT 5 [ RunTime:0.019260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643746 ORDER BY `minOrder` ASC [ RunTime:0.027723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13643746 ORDER BY `unit` DESC [ RunTime:0.019614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13643746 LIMIT 2 [ RunTime:0.018736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643746 ORDER BY `minOrder` ASC [ RunTime:0.009302s ]
select * from pdf where partno='0982670469' and brandshort='Molex' limit 1 [ RunTime:0.004737s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.003090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13642291 LIMIT 5 [ RunTime:0.026826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642291 ORDER BY `minOrder` ASC [ RunTime:0.026729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13642291 ORDER BY `unit` DESC [ RunTime:0.009389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13642291 LIMIT 2 [ RunTime:0.010103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642291 ORDER BY `minOrder` ASC [ RunTime:0.015294s ]
select * from pdf where partno='0982660161' and brandshort='Molex' limit 1 [ RunTime:0.011945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13642293 LIMIT 5 [ RunTime:0.010512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642293 ORDER BY `minOrder` ASC [ RunTime:0.029815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13642293 ORDER BY `unit` DESC [ RunTime:0.026270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13642293 LIMIT 2 [ RunTime:0.016097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642293 ORDER BY `minOrder` ASC [ RunTime:0.009220s ]
select * from pdf where partno='0982670477' and brandshort='Molex' limit 1 [ RunTime:0.021886s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14520617 LIMIT 5 [ RunTime:0.015062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14520617 ORDER BY `minOrder` ASC [ RunTime:0.004819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14520617 ORDER BY `unit` DESC [ RunTime:0.014911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14520617 LIMIT 2 [ RunTime:0.009006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14520617 ORDER BY `minOrder` ASC [ RunTime:0.006634s ]
select * from pdf where partno='0982670707' and brandshort='Molex' limit 1 [ RunTime:0.005929s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522385 LIMIT 5 [ RunTime:0.003686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522385 ORDER BY `minOrder` ASC [ RunTime:0.008136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14522385 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14522385 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522385 ORDER BY `minOrder` ASC [ RunTime:0.002606s ]
select * from pdf where partno='0982670255' and brandshort='Molex' limit 1 [ RunTime:0.000623s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.006130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13645864 LIMIT 5 [ RunTime:0.011470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13645864 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13645864 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13645864 LIMIT 2 [ RunTime:0.002630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13645864 ORDER BY `minOrder` ASC [ RunTime:0.008689s ]
select * from pdf where partno='0982660427' and brandshort='Molex' limit 1 [ RunTime:0.000457s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14517032 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517032 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14517032 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14517032 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517032 ORDER BY `minOrder` ASC [ RunTime:0.004864s ]
select * from pdf where partno='0982670361' and brandshort='Molex' limit 1 [ RunTime:0.007660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13655654 LIMIT 5 [ RunTime:0.004944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13655654 ORDER BY `minOrder` ASC [ RunTime:0.007594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13655654 ORDER BY `unit` DESC [ RunTime:0.001508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13655654 LIMIT 2 [ RunTime:0.008183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13655654 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14524113 LIMIT 5 [ RunTime:0.000869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524113 ORDER BY `minOrder` ASC [ RunTime:0.006955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14524113 ORDER BY `unit` DESC [ RunTime:0.008737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14524113 LIMIT 2 [ RunTime:0.005249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524113 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='0982660425' and brandshort='Molex' limit 1 [ RunTime:0.005731s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.000854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14524117 LIMIT 5 [ RunTime:0.020896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524117 ORDER BY `minOrder` ASC [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14524117 ORDER BY `unit` DESC [ RunTime:0.002608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14524117 LIMIT 2 [ RunTime:0.014892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524117 ORDER BY `minOrder` ASC [ RunTime:0.001970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13641527 LIMIT 5 [ RunTime:0.028180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641527 ORDER BY `minOrder` ASC [ RunTime:0.007465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13641527 ORDER BY `unit` DESC [ RunTime:0.017266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13641527 LIMIT 2 [ RunTime:0.022574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641527 ORDER BY `minOrder` ASC [ RunTime:0.016275s ]
select * from pdf where partno='0982670254' and brandshort='Molex' limit 1 [ RunTime:0.009198s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.012561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522796 LIMIT 5 [ RunTime:0.027059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522796 ORDER BY `minOrder` ASC [ RunTime:0.028212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14522796 ORDER BY `unit` DESC [ RunTime:0.009579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14522796 LIMIT 2 [ RunTime:0.012218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522796 ORDER BY `minOrder` ASC [ RunTime:0.004924s ]
select * from pdf where partno='0982670321' and brandshort='Molex' limit 1 [ RunTime:0.009999s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522370 LIMIT 5 [ RunTime:0.001464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522370 ORDER BY `minOrder` ASC [ RunTime:0.019191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14522370 ORDER BY `unit` DESC [ RunTime:0.006456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14522370 LIMIT 2 [ RunTime:0.032751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522370 ORDER BY `minOrder` ASC [ RunTime:0.026721s ]
select * from pdf where partno='0982670711' and brandshort='Molex' limit 1 [ RunTime:0.045310s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.016597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13648110 LIMIT 5 [ RunTime:0.036593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13648110 ORDER BY `minOrder` ASC [ RunTime:0.033935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13648110 ORDER BY `unit` DESC [ RunTime:0.010289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13648110 LIMIT 2 [ RunTime:0.008807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13648110 ORDER BY `minOrder` ASC [ RunTime:0.017410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14518500 LIMIT 5 [ RunTime:0.022453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14518500 ORDER BY `minOrder` ASC [ RunTime:0.037244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14518500 ORDER BY `unit` DESC [ RunTime:0.010541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14518500 LIMIT 2 [ RunTime:0.008358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14518500 ORDER BY `minOrder` ASC [ RunTime:0.001904s ]
select * from pdf where partno='0982660116' and brandshort='Molex' limit 1 [ RunTime:0.035906s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.038877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13641471 LIMIT 5 [ RunTime:0.010542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641471 ORDER BY `minOrder` ASC [ RunTime:0.049594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13641471 ORDER BY `unit` DESC [ RunTime:0.002818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13641471 LIMIT 2 [ RunTime:0.009560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641471 ORDER BY `minOrder` ASC [ RunTime:0.004925s ]
select * from pdf where partno='0982660432' and brandshort='Molex' limit 1 [ RunTime:0.013736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13643000 LIMIT 5 [ RunTime:0.018597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643000 ORDER BY `minOrder` ASC [ RunTime:0.041350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13643000 ORDER BY `unit` DESC [ RunTime:0.012974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13643000 LIMIT 2 [ RunTime:0.054612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643000 ORDER BY `minOrder` ASC [ RunTime:0.008126s ]
select * from pdf where partno='0982670467' and brandshort='Molex' limit 1 [ RunTime:0.013188s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.008939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13641474 LIMIT 5 [ RunTime:0.022240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641474 ORDER BY `minOrder` ASC [ RunTime:0.023893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13641474 ORDER BY `unit` DESC [ RunTime:0.034246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13641474 LIMIT 2 [ RunTime:0.039832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641474 ORDER BY `minOrder` ASC [ RunTime:0.044728s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011961s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929855 LIMIT 5 [ RunTime:0.035596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929855 ORDER BY `minOrder` ASC [ RunTime:0.103255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929855 ORDER BY `unit` DESC [ RunTime:0.077667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929855 LIMIT 2 [ RunTime:0.045132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929855 ORDER BY `minOrder` ASC [ RunTime:0.021012s ]
select * from pdf where partno='0982660084' and brandshort='Molex' limit 1 [ RunTime:0.083464s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660084' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.033947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929421 LIMIT 5 [ RunTime:0.034067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929421 ORDER BY `minOrder` ASC [ RunTime:0.057077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929421 ORDER BY `unit` DESC [ RunTime:0.102509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929421 LIMIT 2 [ RunTime:0.042272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929421 ORDER BY `minOrder` ASC [ RunTime:0.081879s ]
select * from pdf where partno='0982670701' and brandshort='Molex' limit 1 [ RunTime:0.000737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670701' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.082929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930714 LIMIT 5 [ RunTime:0.036016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930714 ORDER BY `minOrder` ASC [ RunTime:0.055210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930714 ORDER BY `unit` DESC [ RunTime:0.077724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930714 LIMIT 2 [ RunTime:0.013650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930714 ORDER BY `minOrder` ASC [ RunTime:0.021211s ]
select * from pdf where partno='0982660161' and brandshort='Molex' limit 1 [ RunTime:0.027078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660161' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.049612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930698 LIMIT 5 [ RunTime:0.047461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930698 ORDER BY `minOrder` ASC [ RunTime:0.064580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930698 ORDER BY `unit` DESC [ RunTime:0.046650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930698 LIMIT 2 [ RunTime:0.030412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930698 ORDER BY `minOrder` ASC [ RunTime:0.058746s ]
select * from pdf where partno='0982670477' and brandshort='Molex' limit 1 [ RunTime:0.015328s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.036591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670477' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.077422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929459 LIMIT 5 [ RunTime:0.047427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929459 ORDER BY `minOrder` ASC [ RunTime:0.046147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929459 ORDER BY `unit` DESC [ RunTime:0.081599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929459 LIMIT 2 [ RunTime:0.022179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929459 ORDER BY `minOrder` ASC [ RunTime:0.042504s ]
select * from pdf where partno='0982670773' and brandshort='Molex' limit 1 [ RunTime:0.040318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670773' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.048640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929876 LIMIT 5 [ RunTime:0.095577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929876 ORDER BY `minOrder` ASC [ RunTime:0.023432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929876 ORDER BY `unit` DESC [ RunTime:0.023359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929876 LIMIT 2 [ RunTime:0.016406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929876 ORDER BY `minOrder` ASC [ RunTime:0.006304s ]
select * from pdf where partno='0982660432' and brandshort='Molex' limit 1 [ RunTime:0.005961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660432' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930489 LIMIT 5 [ RunTime:0.077621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930489 ORDER BY `minOrder` ASC [ RunTime:0.038688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930489 ORDER BY `unit` DESC [ RunTime:0.020880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930489 LIMIT 2 [ RunTime:0.077638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930489 ORDER BY `minOrder` ASC [ RunTime:0.013697s ]
select * from pdf where partno='0982670469' and brandshort='Molex' limit 1 [ RunTime:0.015158s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.027452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670469' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.061230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929740 LIMIT 5 [ RunTime:0.044252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929740 ORDER BY `minOrder` ASC [ RunTime:0.030582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929740 ORDER BY `unit` DESC [ RunTime:0.023467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929740 LIMIT 2 [ RunTime:0.028098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929740 ORDER BY `minOrder` ASC [ RunTime:0.006233s ]
select * from pdf where partno='0982660835' and brandshort='Molex' limit 1 [ RunTime:0.031926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660835' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.028509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930383 LIMIT 5 [ RunTime:0.013338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930383 ORDER BY `minOrder` ASC [ RunTime:0.026728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930383 ORDER BY `unit` DESC [ RunTime:0.011744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930383 LIMIT 2 [ RunTime:0.012433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930383 ORDER BY `minOrder` ASC [ RunTime:0.026137s ]
select * from pdf where partno='0982670361' and brandshort='Molex' limit 1 [ RunTime:0.003291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670361' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.022927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930107 LIMIT 5 [ RunTime:0.026757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930107 ORDER BY `minOrder` ASC [ RunTime:0.011542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930107 ORDER BY `unit` DESC [ RunTime:0.011507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930107 LIMIT 2 [ RunTime:0.014447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930107 ORDER BY `minOrder` ASC [ RunTime:0.014295s ]
select * from pdf where partno='0982680711' and brandshort='Molex' limit 1 [ RunTime:0.011023s ]
select foldpath,foldpath2,filename from pdf_file where id=2014980 limit 1 [ RunTime:0.004815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982680711' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929866 LIMIT 5 [ RunTime:0.022759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929866 ORDER BY `minOrder` ASC [ RunTime:0.020719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929866 ORDER BY `unit` DESC [ RunTime:0.002652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929866 LIMIT 2 [ RunTime:0.001786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929866 ORDER BY `minOrder` ASC [ RunTime:0.001317s ]
select * from pdf where partno='0982660427' and brandshort='Molex' limit 1 [ RunTime:0.000576s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.000304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660427' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929494 LIMIT 5 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929494 ORDER BY `minOrder` ASC [ RunTime:0.036819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929494 ORDER BY `unit` DESC [ RunTime:0.013272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929494 LIMIT 2 [ RunTime:0.010845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929494 ORDER BY `minOrder` ASC [ RunTime:0.020041s ]
select * from pdf where partno='0982670255' and brandshort='Molex' limit 1 [ RunTime:0.003131s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670255' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929276 LIMIT 5 [ RunTime:0.007288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929276 ORDER BY `minOrder` ASC [ RunTime:0.012072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929276 ORDER BY `unit` DESC [ RunTime:0.026224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929276 LIMIT 2 [ RunTime:0.017725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929276 ORDER BY `minOrder` ASC [ RunTime:0.002076s ]
select * from pdf where partno='0982660216' and brandshort='Molex' limit 1 [ RunTime:0.000878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660216' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930953 LIMIT 5 [ RunTime:0.029462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930953 ORDER BY `minOrder` ASC [ RunTime:0.010890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930953 ORDER BY `unit` DESC [ RunTime:0.005140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930953 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930953 ORDER BY `minOrder` ASC [ RunTime:0.004747s ]
select * from pdf where partno='0982660326' and brandshort='Molex' limit 1 [ RunTime:0.001376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660326' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929735 LIMIT 5 [ RunTime:0.014852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929735 ORDER BY `minOrder` ASC [ RunTime:0.006900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929735 ORDER BY `unit` DESC [ RunTime:0.047579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929735 LIMIT 2 [ RunTime:0.011399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929735 ORDER BY `minOrder` ASC [ RunTime:0.005709s ]
select * from pdf where partno='0982660105' and brandshort='Molex' limit 1 [ RunTime:0.002016s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.002833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660105' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62931192 LIMIT 5 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62931192 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62931192 ORDER BY `unit` DESC [ RunTime:0.000700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62931192 LIMIT 2 [ RunTime:0.009668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62931192 ORDER BY `minOrder` ASC [ RunTime:0.015043s ]
select * from pdf where partno='0982670254' and brandshort='Molex' limit 1 [ RunTime:0.005610s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.007712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670254' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62931402 LIMIT 5 [ RunTime:0.001795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62931402 ORDER BY `minOrder` ASC [ RunTime:0.013730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62931402 ORDER BY `unit` DESC [ RunTime:0.009512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62931402 LIMIT 2 [ RunTime:0.002968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62931402 ORDER BY `minOrder` ASC [ RunTime:0.002657s ]
select * from pdf where partno='0982680221' and brandshort='Molex' limit 1 [ RunTime:0.012362s ]
select foldpath,foldpath2,filename from pdf_file where id=1277586 limit 1 [ RunTime:0.007632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982680221' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929907 LIMIT 5 [ RunTime:0.013584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929907 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929907 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929907 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929907 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='0982660436' and brandshort='Molex' limit 1 [ RunTime:0.003698s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.000352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660436' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929857 LIMIT 5 [ RunTime:0.012603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929857 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929857 ORDER BY `unit` DESC [ RunTime:0.001704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929857 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929857 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='0982660430' and brandshort='Molex' limit 1 [ RunTime:0.000980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660430' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930408 LIMIT 5 [ RunTime:0.004380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930408 ORDER BY `minOrder` ASC [ RunTime:0.003843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930408 ORDER BY `unit` DESC [ RunTime:0.001623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930408 LIMIT 2 [ RunTime:0.020324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930408 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='0982670467' and brandshort='Molex' limit 1 [ RunTime:0.000623s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670467' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011069s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001013s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003735s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009861s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006988s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000848s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005322s ]
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 '09826%' OR `brand` LIKE '09826%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000912s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '09826%' OR `brand` LIKE '09826%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016615s ]