SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001195s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=764&search=1' [ RunTime:0.001686s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001028s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001837s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001094s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.010563s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002161s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014070s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001434s ]
SELECT * FROM `stock_search` WHERE `partno` = '764' LIMIT 1 [ RunTime:0.013744s ]
UPDATE `stock_search` SET `count` = 11 , `updatetime` = '2026-08-24 15:58:07' WHERE `partno` = '764' [ RunTime:0.022314s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001431s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056101s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12491717 LIMIT 5 [ RunTime:0.024819s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12491717 ORDER BY `minOrder` ASC [ RunTime:0.022562s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.027802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12491717 ORDER BY `unit` DESC [ RunTime:0.040072s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.021986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12491717 LIMIT 2 [ RunTime:0.095110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12491717 ORDER BY `minOrder` ASC [ RunTime:0.078774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12490774 LIMIT 5 [ RunTime:0.037369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12490774 ORDER BY `minOrder` ASC [ RunTime:0.017581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12490774 ORDER BY `unit` DESC [ RunTime:0.021284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12490774 LIMIT 2 [ RunTime:0.012935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12490774 ORDER BY `minOrder` ASC [ RunTime:0.017551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499807 LIMIT 5 [ RunTime:0.033511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499807 ORDER BY `minOrder` ASC [ RunTime:0.059787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13499807 ORDER BY `unit` DESC [ RunTime:0.020026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13499807 LIMIT 2 [ RunTime:0.027959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13499807 ORDER BY `minOrder` ASC [ RunTime:0.022201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423810 LIMIT 5 [ RunTime:0.048590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423810 ORDER BY `minOrder` ASC [ RunTime:0.003767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16423810 ORDER BY `unit` DESC [ RunTime:0.042422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16423810 LIMIT 2 [ RunTime:0.001337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423810 ORDER BY `minOrder` ASC [ RunTime:0.023180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13494558 LIMIT 5 [ RunTime:0.025604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494558 ORDER BY `minOrder` ASC [ RunTime:0.086561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13494558 ORDER BY `unit` DESC [ RunTime:0.071113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13494558 LIMIT 2 [ RunTime:0.028524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13494558 ORDER BY `minOrder` ASC [ RunTime:0.015767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112967 LIMIT 5 [ RunTime:0.050202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112967 ORDER BY `minOrder` ASC [ RunTime:0.048382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13112967 ORDER BY `unit` DESC [ RunTime:0.071252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13112967 LIMIT 2 [ RunTime:0.068342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112967 ORDER BY `minOrder` ASC [ RunTime:0.031482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867371 LIMIT 5 [ RunTime:0.015109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867371 ORDER BY `minOrder` ASC [ RunTime:0.037686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867371 ORDER BY `unit` DESC [ RunTime:0.052535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867371 LIMIT 2 [ RunTime:0.004736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867371 ORDER BY `minOrder` ASC [ RunTime:0.010791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17289813 LIMIT 5 [ RunTime:0.027154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17289813 ORDER BY `minOrder` ASC [ RunTime:0.025062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17289813 ORDER BY `unit` DESC [ RunTime:0.034191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17289813 LIMIT 2 [ RunTime:0.007794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17289813 ORDER BY `minOrder` ASC [ RunTime:0.040213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370888 LIMIT 5 [ RunTime:0.035339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370888 ORDER BY `minOrder` ASC [ RunTime:0.038400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17370888 ORDER BY `unit` DESC [ RunTime:0.007687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17370888 LIMIT 2 [ RunTime:0.006253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370888 ORDER BY `minOrder` ASC [ RunTime:0.017798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19555971 LIMIT 5 [ RunTime:0.009673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19555971 ORDER BY `minOrder` ASC [ RunTime:0.015830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19555971 ORDER BY `unit` DESC [ RunTime:0.056541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19555971 LIMIT 2 [ RunTime:0.034378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19555971 ORDER BY `minOrder` ASC [ RunTime:0.002374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400294 LIMIT 5 [ RunTime:0.006627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400294 ORDER BY `minOrder` ASC [ RunTime:0.037217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11400294 ORDER BY `unit` DESC [ RunTime:0.027981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11400294 LIMIT 2 [ RunTime:0.061731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11400294 ORDER BY `minOrder` ASC [ RunTime:0.011564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12270283 LIMIT 5 [ RunTime:0.015022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12270283 ORDER BY `minOrder` ASC [ RunTime:0.039887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12270283 ORDER BY `unit` DESC [ RunTime:0.047222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12270283 LIMIT 2 [ RunTime:0.035224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12270283 ORDER BY `minOrder` ASC [ RunTime:0.006262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12270281 LIMIT 5 [ RunTime:0.013889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12270281 ORDER BY `minOrder` ASC [ RunTime:0.009485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12270281 ORDER BY `unit` DESC [ RunTime:0.036641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12270281 LIMIT 2 [ RunTime:0.008347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12270281 ORDER BY `minOrder` ASC [ RunTime:0.015669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12270282 LIMIT 5 [ RunTime:0.008814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12270282 ORDER BY `minOrder` ASC [ RunTime:0.031669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12270282 ORDER BY `unit` DESC [ RunTime:0.021116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12270282 LIMIT 2 [ RunTime:0.002046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12270282 ORDER BY `minOrder` ASC [ RunTime:0.019231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11255826 LIMIT 5 [ RunTime:0.043318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11255826 ORDER BY `minOrder` ASC [ RunTime:0.006907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11255826 ORDER BY `unit` DESC [ RunTime:0.001194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11255826 LIMIT 2 [ RunTime:0.015380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11255826 ORDER BY `minOrder` ASC [ RunTime:0.026879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15379070 LIMIT 5 [ RunTime:0.024308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15379070 ORDER BY `minOrder` ASC [ RunTime:0.035010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15379070 ORDER BY `unit` DESC [ RunTime:0.012289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15379070 LIMIT 2 [ RunTime:0.053285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15379070 ORDER BY `minOrder` ASC [ RunTime:0.016966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12274794 LIMIT 5 [ RunTime:0.008644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12274794 ORDER BY `minOrder` ASC [ RunTime:0.015484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12274794 ORDER BY `unit` DESC [ RunTime:0.013773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12274794 LIMIT 2 [ RunTime:0.004054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12274794 ORDER BY `minOrder` ASC [ RunTime:0.019712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4557 LIMIT 5 [ RunTime:0.012772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4557 ORDER BY `minOrder` ASC [ RunTime:0.006044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4557 ORDER BY `unit` DESC [ RunTime:0.006637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4557 LIMIT 2 [ RunTime:0.019203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4557 ORDER BY `minOrder` ASC [ RunTime:0.017601s ]
select * from pdf where partno='764I YELLOW' and brandshort='3M' limit 1 [ RunTime:0.012845s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764I YELLOW' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.017241s ]
SELECT `id` FROM `stock` WHERE `id` <> 4557 AND `partno` = '764I YELLOW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.002672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15379071 LIMIT 5 [ RunTime:0.003378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15379071 ORDER BY `minOrder` ASC [ RunTime:0.008676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15379071 ORDER BY `unit` DESC [ RunTime:0.002673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15379071 LIMIT 2 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15379071 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13271532 LIMIT 5 [ RunTime:0.003443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13271532 ORDER BY `minOrder` ASC [ RunTime:0.012079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13271532 ORDER BY `unit` DESC [ RunTime:0.002671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13271532 LIMIT 2 [ RunTime:0.006218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13271532 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32232678 LIMIT 5 [ RunTime:0.001469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232678 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32232678 ORDER BY `unit` DESC [ RunTime:0.000496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32232678 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232678 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='7646' and brandshort='vcc' limit 1 [ RunTime:0.001872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7646' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.006552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269856 LIMIT 5 [ RunTime:0.003773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269856 ORDER BY `minOrder` ASC [ RunTime:0.002430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269856 ORDER BY `unit` DESC [ RunTime:0.002172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269856 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269856 ORDER BY `minOrder` ASC [ RunTime:0.005125s ]
select * from pdf where partno='76460-5020' and brandshort='molex' limit 1 [ RunTime:0.001155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76460-5020' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.006068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270409 LIMIT 5 [ RunTime:0.010847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270409 ORDER BY `minOrder` ASC [ RunTime:0.004689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270409 ORDER BY `unit` DESC [ RunTime:0.006930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270409 LIMIT 2 [ RunTime:0.016756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270409 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='76450-1608' and brandshort='molex' limit 1 [ RunTime:0.010303s ]
select foldpath,foldpath2,filename from pdf_file where id=1874072 limit 1 [ RunTime:0.003541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76450-1608' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270410 LIMIT 5 [ RunTime:0.007944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270410 ORDER BY `minOrder` ASC [ RunTime:0.001070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270410 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270410 LIMIT 2 [ RunTime:0.001615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270410 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='76450-5608' and brandshort='molex' limit 1 [ RunTime:0.000995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76450-5608' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270408 LIMIT 5 [ RunTime:0.002602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270408 ORDER BY `minOrder` ASC [ RunTime:0.005301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270408 ORDER BY `unit` DESC [ RunTime:0.013221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270408 LIMIT 2 [ RunTime:0.013815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270408 ORDER BY `minOrder` ASC [ RunTime:0.003463s ]
select * from pdf where partno='76410-1607' and brandshort='molex' limit 1 [ RunTime:0.005005s ]
select foldpath,foldpath2,filename from pdf_file where id=1519062 limit 1 [ RunTime:0.002248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76410-1607' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269892 LIMIT 5 [ RunTime:0.001546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269892 ORDER BY `minOrder` ASC [ RunTime:0.008677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269892 ORDER BY `unit` DESC [ RunTime:0.000749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269892 LIMIT 2 [ RunTime:0.001342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269892 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='76455-7107' and brandshort='molex' limit 1 [ RunTime:0.001645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76455-7107' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.013993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270504 LIMIT 5 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270504 ORDER BY `minOrder` ASC [ RunTime:0.002192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270504 ORDER BY `unit` DESC [ RunTime:0.002692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270504 LIMIT 2 [ RunTime:0.001029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270504 ORDER BY `minOrder` ASC [ RunTime:0.003337s ]
select * from pdf where partno='76410-1107' and brandshort='molex' limit 1 [ RunTime:0.001386s ]
select foldpath,foldpath2,filename from pdf_file where id=1519062 limit 1 [ RunTime:0.002860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76410-1107' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270471 LIMIT 5 [ RunTime:0.004890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270471 ORDER BY `minOrder` ASC [ RunTime:0.002347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270471 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270471 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270471 ORDER BY `minOrder` ASC [ RunTime:0.006435s ]
select * from pdf where partno='76460-5010' and brandshort='molex' limit 1 [ RunTime:0.009378s ]
select foldpath,foldpath2,filename from pdf_file where id=1545940 limit 1 [ RunTime:0.027666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76460-5010' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.028146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270454 LIMIT 5 [ RunTime:0.011780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270454 ORDER BY `minOrder` ASC [ RunTime:0.004396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270454 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270454 LIMIT 2 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270454 ORDER BY `minOrder` ASC [ RunTime:0.004100s ]
select * from pdf where partno='76460-3010' and brandshort='molex' limit 1 [ RunTime:0.007259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76460-3010' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.016984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269802 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269802 ORDER BY `minOrder` ASC [ RunTime:0.001049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269802 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269802 LIMIT 2 [ RunTime:0.007630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269802 ORDER BY `minOrder` ASC [ RunTime:0.007143s ]
select * from pdf where partno='76460-1016' and brandshort='molex' limit 1 [ RunTime:0.001290s ]
select foldpath,foldpath2,filename from pdf_file where id=1881190 limit 1 [ RunTime:0.002525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76460-1016' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.014054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269855 LIMIT 5 [ RunTime:0.006164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269855 ORDER BY `minOrder` ASC [ RunTime:0.019066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269855 ORDER BY `unit` DESC [ RunTime:0.013226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269855 LIMIT 2 [ RunTime:0.018476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269855 ORDER BY `minOrder` ASC [ RunTime:0.002879s ]
select * from pdf where partno='76450-5107' and brandshort='molex' limit 1 [ RunTime:0.001447s ]
select foldpath,foldpath2,filename from pdf_file where id=1579959 limit 1 [ RunTime:0.004102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76450-5107' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.014310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270453 LIMIT 5 [ RunTime:0.004731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270453 ORDER BY `minOrder` ASC [ RunTime:0.018857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270453 ORDER BY `unit` DESC [ RunTime:0.010817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270453 LIMIT 2 [ RunTime:0.010881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270453 ORDER BY `minOrder` ASC [ RunTime:0.007524s ]
select * from pdf where partno='76450-1607' and brandshort='molex' limit 1 [ RunTime:0.001275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76450-1607' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.019403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221452 LIMIT 5 [ RunTime:0.028456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221452 ORDER BY `minOrder` ASC [ RunTime:0.017534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221452 ORDER BY `unit` DESC [ RunTime:0.019714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221452 LIMIT 2 [ RunTime:0.013745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221452 ORDER BY `minOrder` ASC [ RunTime:0.005536s ]
select * from pdf where partno='76424-510-000 lh75-130 black kit' and brandshort='pactec' limit 1 [ RunTime:0.002748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76424-510-000 lh75-130 black kit' OR `brand` LIKE 'pactec%' ) ) LIMIT 1 [ RunTime:0.016802s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221452 AND `partno` = '76424-510-000 lh75-130 black kit' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pactec%' ) [ RunTime:0.001535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270488 LIMIT 5 [ RunTime:0.011950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270488 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270488 ORDER BY `unit` DESC [ RunTime:0.032499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270488 LIMIT 2 [ RunTime:0.021829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270488 ORDER BY `minOrder` ASC [ RunTime:0.007458s ]
select * from pdf where partno='76410-7607' and brandshort='molex' limit 1 [ RunTime:0.018626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76410-7607' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.022475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32233066 LIMIT 5 [ RunTime:0.023751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233066 ORDER BY `minOrder` ASC [ RunTime:0.010056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32233066 ORDER BY `unit` DESC [ RunTime:0.019172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32233066 LIMIT 2 [ RunTime:0.044347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233066 ORDER BY `minOrder` ASC [ RunTime:0.041760s ]
select * from pdf where partno='7646' and brandshort='jkl components' limit 1 [ RunTime:0.032776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7646' OR `brand` LIKE 'jkl components%' ) ) LIMIT 1 [ RunTime:0.006340s ]
SELECT `id` FROM `stock` WHERE `id` <> 32233066 AND `partno` = '7646' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jkl components%' ) [ RunTime:0.018649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15242365 [ RunTime:0.012936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098814 LIMIT 5 [ RunTime:0.012342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098814 ORDER BY `minOrder` ASC [ RunTime:0.005587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098814 ORDER BY `unit` DESC [ RunTime:0.010443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098814 LIMIT 2 [ RunTime:0.033664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098814 ORDER BY `minOrder` ASC [ RunTime:0.009133s ]
select * from pdf where partno='764-1"x36yd-white' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.001296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764-1\"x36yd-white' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.011147s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098814 AND `partno` = '764-1\"x36yd-white' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.026145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098813 LIMIT 5 [ RunTime:0.034274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098813 ORDER BY `minOrder` ASC [ RunTime:0.007568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098813 ORDER BY `unit` DESC [ RunTime:0.019206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098813 LIMIT 2 [ RunTime:0.014774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098813 ORDER BY `minOrder` ASC [ RunTime:0.002480s ]
select * from pdf where partno='764-1"x36yd-orange' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.005867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764-1\"x36yd-orange' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.026118s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098813 AND `partno` = '764-1\"x36yd-orange' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.034354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098863 LIMIT 5 [ RunTime:0.008445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098863 ORDER BY `minOrder` ASC [ RunTime:0.023101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098863 ORDER BY `unit` DESC [ RunTime:0.014142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098863 LIMIT 2 [ RunTime:0.014205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098863 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
select * from pdf where partno='764-1"x36yd-yellow' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.001249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764-1\"x36yd-yellow' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.014860s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098863 AND `partno` = '764-1\"x36yd-yellow' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.003522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098446 LIMIT 5 [ RunTime:0.016050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098446 ORDER BY `minOrder` ASC [ RunTime:0.012734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098446 ORDER BY `unit` DESC [ RunTime:0.005321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098446 LIMIT 2 [ RunTime:0.000847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098446 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='764-1"x36yd-green' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.004751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764-1\"x36yd-green' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.001032s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098446 AND `partno` = '764-1\"x36yd-green' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.009383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51098861 LIMIT 5 [ RunTime:0.013461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098861 ORDER BY `minOrder` ASC [ RunTime:0.007032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51098861 ORDER BY `unit` DESC [ RunTime:0.001025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51098861 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51098861 ORDER BY `minOrder` ASC [ RunTime:0.000884s ]
select * from pdf where partno='764-1"x36yd-red' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.017425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764-1\"x36yd-red' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.029907s ]
SELECT `id` FROM `stock` WHERE `id` <> 51098861 AND `partno` = '764-1\"x36yd-red' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.020257s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943979 LIMIT 5 [ RunTime:0.003543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943979 ORDER BY `minOrder` ASC [ RunTime:0.008354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943979 ORDER BY `unit` DESC [ RunTime:0.017314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943979 LIMIT 2 [ RunTime:0.004230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943979 ORDER BY `minOrder` ASC [ RunTime:0.005881s ]
select * from pdf where partno='764953107' and brandshort='Molex' limit 1 [ RunTime:0.034233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764953107' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58726298 LIMIT 5 [ RunTime:0.000759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726298 ORDER BY `minOrder` ASC [ RunTime:0.027289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58726298 ORDER BY `unit` DESC [ RunTime:0.020860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58726298 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726298 ORDER BY `minOrder` ASC [ RunTime:0.004927s ]
select * from pdf where partno='764-00/002' and brandshort='Qualtek' limit 1 [ RunTime:0.021166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764-00/002' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.005529s ]
SELECT `id` FROM `stock` WHERE `id` <> 58726298 AND `partno` = '764-00/002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.024898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943127 LIMIT 5 [ RunTime:0.013343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943127 ORDER BY `minOrder` ASC [ RunTime:0.015579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943127 ORDER BY `unit` DESC [ RunTime:0.026287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943127 LIMIT 2 [ RunTime:0.016314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943127 ORDER BY `minOrder` ASC [ RunTime:0.006857s ]
select * from pdf where partno='764551108' and brandshort='Molex' limit 1 [ RunTime:0.005108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764551108' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58341518 LIMIT 5 [ RunTime:0.004839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58341518 ORDER BY `minOrder` ASC [ RunTime:0.006049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58341518 ORDER BY `unit` DESC [ RunTime:0.022817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58341518 LIMIT 2 [ RunTime:0.000785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58341518 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='764100000' and brandshort='WEC' limit 1 [ RunTime:0.005374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764100000' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.004260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000642 LIMIT 5 [ RunTime:0.011154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000642 ORDER BY `minOrder` ASC [ RunTime:0.008207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000642 ORDER BY `unit` DESC [ RunTime:0.003669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000642 LIMIT 2 [ RunTime:0.006453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000642 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='76404TS 0081000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76404TS 0081000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.010244s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000642 AND `partno` = '76404TS 0081000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.001614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13499807 [ RunTime:0.002239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58152506 LIMIT 5 [ RunTime:0.001489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152506 ORDER BY `minOrder` ASC [ RunTime:0.001185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58152506 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58152506 LIMIT 2 [ RunTime:0.008061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152506 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='7644E-3-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7644E-3-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.007896s ]
SELECT `id` FROM `stock` WHERE `id` <> 58152506 AND `partno` = '7644E-3-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.003921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58154578 LIMIT 5 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154578 ORDER BY `minOrder` ASC [ RunTime:0.001544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58154578 ORDER BY `unit` DESC [ RunTime:0.000935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58154578 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154578 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='7646E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.003491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7646E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.006208s ]
SELECT `id` FROM `stock` WHERE `id` <> 58154578 AND `partno` = '7646E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.009097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58154580 LIMIT 5 [ RunTime:0.024895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154580 ORDER BY `minOrder` ASC [ RunTime:0.002884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58154580 ORDER BY `unit` DESC [ RunTime:0.004517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58154580 LIMIT 2 [ RunTime:0.010061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154580 ORDER BY `minOrder` ASC [ RunTime:0.001341s ]
select * from pdf where partno='7640E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.004220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7640E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.019810s ]
SELECT `id` FROM `stock` WHERE `id` <> 58154580 AND `partno` = '7640E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.006246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58154588 LIMIT 5 [ RunTime:0.002310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154588 ORDER BY `minOrder` ASC [ RunTime:0.001338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58154588 ORDER BY `unit` DESC [ RunTime:0.005400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58154588 LIMIT 2 [ RunTime:0.021576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154588 ORDER BY `minOrder` ASC [ RunTime:0.004983s ]
select * from pdf where partno='7642E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7642E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.006531s ]
SELECT `id` FROM `stock` WHERE `id` <> 58154588 AND `partno` = '7642E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.003303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58154609 LIMIT 5 [ RunTime:0.007133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154609 ORDER BY `minOrder` ASC [ RunTime:0.011023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58154609 ORDER BY `unit` DESC [ RunTime:0.006419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58154609 LIMIT 2 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154609 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='7643E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7643E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.015502s ]
SELECT `id` FROM `stock` WHERE `id` <> 58154609 AND `partno` = '7643E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.022239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58152623 LIMIT 5 [ RunTime:0.003653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152623 ORDER BY `minOrder` ASC [ RunTime:0.002252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58152623 ORDER BY `unit` DESC [ RunTime:0.010057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58152623 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152623 ORDER BY `minOrder` ASC [ RunTime:0.002908s ]
select * from pdf where partno='7640E-3-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.028519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7640E-3-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.018323s ]
SELECT `id` FROM `stock` WHERE `id` <> 58152623 AND `partno` = '7640E-3-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.011340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126898 LIMIT 5 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126898 ORDER BY `minOrder` ASC [ RunTime:0.014914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126898 ORDER BY `unit` DESC [ RunTime:0.002908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126898 LIMIT 2 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126898 ORDER BY `minOrder` ASC [ RunTime:0.009743s ]
select * from pdf where partno='7640' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.014277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7640' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.009467s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126898 AND `partno` = '7640' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.011491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423810 [ RunTime:0.018516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58152650 LIMIT 5 [ RunTime:0.001039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152650 ORDER BY `minOrder` ASC [ RunTime:0.009825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58152650 ORDER BY `unit` DESC [ RunTime:0.000972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58152650 LIMIT 2 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152650 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
select * from pdf where partno='7643E-3-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7643E-3-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.002799s ]
SELECT `id` FROM `stock` WHERE `id` <> 58152650 AND `partno` = '7643E-3-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.002495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58152684 LIMIT 5 [ RunTime:0.003246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152684 ORDER BY `minOrder` ASC [ RunTime:0.001096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58152684 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58152684 LIMIT 2 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152684 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='7641E-3-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.002236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7641E-3-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.002978s ]
SELECT `id` FROM `stock` WHERE `id` <> 58152684 AND `partno` = '7641E-3-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.002935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58154655 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154655 ORDER BY `minOrder` ASC [ RunTime:0.003099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58154655 ORDER BY `unit` DESC [ RunTime:0.012946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58154655 LIMIT 2 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154655 ORDER BY `minOrder` ASC [ RunTime:0.001781s ]
select * from pdf where partno='7648E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.006300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7648E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.008739s ]
SELECT `id` FROM `stock` WHERE `id` <> 58154655 AND `partno` = '7648E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.005938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58154657 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154657 ORDER BY `minOrder` ASC [ RunTime:0.007351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58154657 ORDER BY `unit` DESC [ RunTime:0.002960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58154657 LIMIT 2 [ RunTime:0.002559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58154657 ORDER BY `minOrder` ASC [ RunTime:0.008415s ]
select * from pdf where partno='7645E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.017929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7645E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.016849s ]
SELECT `id` FROM `stock` WHERE `id` <> 58154657 AND `partno` = '7645E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.009605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58152721 LIMIT 5 [ RunTime:0.002471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152721 ORDER BY `minOrder` ASC [ RunTime:0.016647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58152721 ORDER BY `unit` DESC [ RunTime:0.009960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58152721 LIMIT 2 [ RunTime:0.010640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152721 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='7642E-3-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.003826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7642E-3-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.005119s ]
SELECT `id` FROM `stock` WHERE `id` <> 58152721 AND `partno` = '7642E-3-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.000727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943139 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943139 ORDER BY `minOrder` ASC [ RunTime:0.004246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943139 ORDER BY `unit` DESC [ RunTime:0.001522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943139 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943139 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='76455-1105' and brandshort='Molex' limit 1 [ RunTime:0.000797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76455-1105' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58152788 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152788 ORDER BY `minOrder` ASC [ RunTime:0.001177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58152788 ORDER BY `unit` DESC [ RunTime:0.007112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58152788 LIMIT 2 [ RunTime:0.004099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58152788 ORDER BY `minOrder` ASC [ RunTime:0.002712s ]
select * from pdf where partno='7646E-3-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.012536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7646E-3-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.005866s ]
SELECT `id` FROM `stock` WHERE `id` <> 58152788 AND `partno` = '7646E-3-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.012962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58726322 LIMIT 5 [ RunTime:0.006899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726322 ORDER BY `minOrder` ASC [ RunTime:0.001565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58726322 ORDER BY `unit` DESC [ RunTime:0.002229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58726322 LIMIT 2 [ RunTime:0.007886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726322 ORDER BY `minOrder` ASC [ RunTime:0.005377s ]
select * from pdf where partno='764-00/003' and brandshort='Qualtek' limit 1 [ RunTime:0.003822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '764-00/003' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.003811s ]
SELECT `id` FROM `stock` WHERE `id` <> 58726322 AND `partno` = '764-00/003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.001844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112967 [ RunTime:0.000547s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002406s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019023s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001371s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001149s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003491s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001331s ]
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 '764%' OR `brand` LIKE '764%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001043s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '764%' OR `brand` LIKE '764%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005537s ]