SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001560s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=170335&search=1' [ RunTime:0.005653s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001316s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004001s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001755s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.002593s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001402s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003343s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001190s ]
SELECT * FROM `stock_search` WHERE `partno` = '170335' LIMIT 1 [ RunTime:0.008394s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 15:22:34' WHERE `partno` = '170335' [ RunTime:0.004697s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002384s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029125s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417244 LIMIT 5 [ RunTime:0.006786s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417244 ORDER BY `minOrder` ASC [ RunTime:0.012536s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417244 ORDER BY `unit` DESC [ RunTime:0.014105s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417244 LIMIT 2 [ RunTime:0.004695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417244 ORDER BY `minOrder` ASC [ RunTime:0.001947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17520560 LIMIT 5 [ RunTime:0.004748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17520560 ORDER BY `minOrder` ASC [ RunTime:0.002897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17520560 ORDER BY `unit` DESC [ RunTime:0.005354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17520560 LIMIT 2 [ RunTime:0.003494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17520560 ORDER BY `minOrder` ASC [ RunTime:0.008061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17520387 LIMIT 5 [ RunTime:0.010810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17520387 ORDER BY `minOrder` ASC [ RunTime:0.013025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17520387 ORDER BY `unit` DESC [ RunTime:0.016370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17520387 LIMIT 2 [ RunTime:0.016759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17520387 ORDER BY `minOrder` ASC [ RunTime:0.012106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17305153 LIMIT 5 [ RunTime:0.004132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17305153 ORDER BY `minOrder` ASC [ RunTime:0.005357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17305153 ORDER BY `unit` DESC [ RunTime:0.018497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17305153 LIMIT 2 [ RunTime:0.019909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17305153 ORDER BY `minOrder` ASC [ RunTime:0.008596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16696609 LIMIT 5 [ RunTime:0.027531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16696609 ORDER BY `minOrder` ASC [ RunTime:0.047832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16696609 ORDER BY `unit` DESC [ RunTime:0.033186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16696609 LIMIT 2 [ RunTime:0.005807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16696609 ORDER BY `minOrder` ASC [ RunTime:0.005635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13950827 LIMIT 5 [ RunTime:0.022271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13950827 ORDER BY `minOrder` ASC [ RunTime:0.010913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13950827 ORDER BY `unit` DESC [ RunTime:0.024837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13950827 LIMIT 2 [ RunTime:0.006382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13950827 ORDER BY `minOrder` ASC [ RunTime:0.018066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550518 LIMIT 5 [ RunTime:0.040669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550518 ORDER BY `minOrder` ASC [ RunTime:0.049325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13550518 ORDER BY `unit` DESC [ RunTime:0.038977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13550518 LIMIT 2 [ RunTime:0.019782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550518 ORDER BY `minOrder` ASC [ RunTime:0.009544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492831 LIMIT 5 [ RunTime:0.017119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492831 ORDER BY `minOrder` ASC [ RunTime:0.019680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492831 ORDER BY `unit` DESC [ RunTime:0.013754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492831 LIMIT 2 [ RunTime:0.025011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492831 ORDER BY `minOrder` ASC [ RunTime:0.019415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492732 LIMIT 5 [ RunTime:0.027036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492732 ORDER BY `minOrder` ASC [ RunTime:0.034771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492732 ORDER BY `unit` DESC [ RunTime:0.003306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492732 LIMIT 2 [ RunTime:0.030587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492732 ORDER BY `minOrder` ASC [ RunTime:0.016778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492669 LIMIT 5 [ RunTime:0.025750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492669 ORDER BY `minOrder` ASC [ RunTime:0.029053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492669 ORDER BY `unit` DESC [ RunTime:0.025923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492669 LIMIT 2 [ RunTime:0.032868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492669 ORDER BY `minOrder` ASC [ RunTime:0.021898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492434 LIMIT 5 [ RunTime:0.027283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492434 ORDER BY `minOrder` ASC [ RunTime:0.093743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492434 ORDER BY `unit` DESC [ RunTime:0.022756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492434 LIMIT 2 [ RunTime:0.036004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492434 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492425 LIMIT 5 [ RunTime:0.032848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492425 ORDER BY `minOrder` ASC [ RunTime:0.059010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492425 ORDER BY `unit` DESC [ RunTime:0.020128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492425 LIMIT 2 [ RunTime:0.020957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492425 ORDER BY `minOrder` ASC [ RunTime:0.050185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492390 LIMIT 5 [ RunTime:0.073150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492390 ORDER BY `minOrder` ASC [ RunTime:0.008605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492390 ORDER BY `unit` DESC [ RunTime:0.045052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492390 LIMIT 2 [ RunTime:0.039560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492390 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492348 LIMIT 5 [ RunTime:0.027192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492348 ORDER BY `minOrder` ASC [ RunTime:0.034056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492348 ORDER BY `unit` DESC [ RunTime:0.010756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492348 LIMIT 2 [ RunTime:0.027259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492348 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492335 LIMIT 5 [ RunTime:0.046461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492335 ORDER BY `minOrder` ASC [ RunTime:0.026686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492335 ORDER BY `unit` DESC [ RunTime:0.026620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492335 LIMIT 2 [ RunTime:0.055116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492335 ORDER BY `minOrder` ASC [ RunTime:0.006029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492334 LIMIT 5 [ RunTime:0.020277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492334 ORDER BY `minOrder` ASC [ RunTime:0.033257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492334 ORDER BY `unit` DESC [ RunTime:0.058842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492334 LIMIT 2 [ RunTime:0.034797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492334 ORDER BY `minOrder` ASC [ RunTime:0.003718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492322 LIMIT 5 [ RunTime:0.007553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492322 ORDER BY `minOrder` ASC [ RunTime:0.022250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492322 ORDER BY `unit` DESC [ RunTime:0.023207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492322 LIMIT 2 [ RunTime:0.033121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492322 ORDER BY `minOrder` ASC [ RunTime:0.018542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492312 LIMIT 5 [ RunTime:0.038253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492312 ORDER BY `minOrder` ASC [ RunTime:0.006125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492312 ORDER BY `unit` DESC [ RunTime:0.056045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492312 LIMIT 2 [ RunTime:0.059611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492312 ORDER BY `minOrder` ASC [ RunTime:0.025711s ]
select * from pdf where partno='1703355605' and brandshort='Molex' limit 1 [ RunTime:0.014549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492014 LIMIT 5 [ RunTime:0.049599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492014 ORDER BY `minOrder` ASC [ RunTime:0.034779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492014 ORDER BY `unit` DESC [ RunTime:0.022954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492014 LIMIT 2 [ RunTime:0.011853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492014 ORDER BY `minOrder` ASC [ RunTime:0.009812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492006 LIMIT 5 [ RunTime:0.001253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492006 ORDER BY `minOrder` ASC [ RunTime:0.021318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492006 ORDER BY `unit` DESC [ RunTime:0.009988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492006 LIMIT 2 [ RunTime:0.008361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492006 ORDER BY `minOrder` ASC [ RunTime:0.011685s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008805s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818428 LIMIT 5 [ RunTime:0.012359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818428 ORDER BY `minOrder` ASC [ RunTime:0.020731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818428 ORDER BY `unit` DESC [ RunTime:0.003097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818428 LIMIT 2 [ RunTime:0.020172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818428 ORDER BY `minOrder` ASC [ RunTime:0.003094s ]
select * from pdf where partno='170335-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020546s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170335-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003609s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818428 AND `partno` = '170335-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417244 [ RunTime:0.009304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56188180 LIMIT 5 [ RunTime:0.013710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56188180 ORDER BY `minOrder` ASC [ RunTime:0.049804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56188180 ORDER BY `unit` DESC [ RunTime:0.004298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56188180 LIMIT 2 [ RunTime:0.031983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56188180 ORDER BY `minOrder` ASC [ RunTime:0.004245s ]
select * from pdf where partno='1703357' and brandshort='TKD' limit 1 [ RunTime:0.011631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703357' OR `brand` LIKE 'TKD%' ) ) LIMIT 1 [ RunTime:0.027092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56188163 LIMIT 5 [ RunTime:0.025815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56188163 ORDER BY `minOrder` ASC [ RunTime:0.043863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56188163 ORDER BY `unit` DESC [ RunTime:0.030945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56188163 LIMIT 2 [ RunTime:0.035872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56188163 ORDER BY `minOrder` ASC [ RunTime:0.005370s ]
select * from pdf where partno='1703351' and brandshort='TKD' limit 1 [ RunTime:0.016226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351' OR `brand` LIKE 'TKD%' ) ) LIMIT 1 [ RunTime:0.010318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57716250 LIMIT 5 [ RunTime:0.044675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57716250 ORDER BY `minOrder` ASC [ RunTime:0.025768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57716250 ORDER BY `unit` DESC [ RunTime:0.023207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57716250 LIMIT 2 [ RunTime:0.022215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57716250 ORDER BY `minOrder` ASC [ RunTime:0.017373s ]
select * from pdf where partno='170335' and brandshort='Brady Corporation' limit 1 [ RunTime:0.034619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170335' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022887s ]
SELECT `id` FROM `stock` WHERE `id` <> 57716250 AND `partno` = '170335' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.041568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550518 [ RunTime:0.063723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54130463 LIMIT 5 [ RunTime:0.042806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130463 ORDER BY `minOrder` ASC [ RunTime:0.024285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54130463 ORDER BY `unit` DESC [ RunTime:0.014895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54130463 LIMIT 2 [ RunTime:0.021081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130463 ORDER BY `minOrder` ASC [ RunTime:0.018632s ]
select * from pdf where partno='1703355607' and brandshort='Molex' limit 1 [ RunTime:0.049008s ]
select foldpath,foldpath2,filename from pdf_file where id=1535754 limit 1 [ RunTime:0.031087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703355607' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.039658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54130462 LIMIT 5 [ RunTime:0.058197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130462 ORDER BY `minOrder` ASC [ RunTime:0.017099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54130462 ORDER BY `unit` DESC [ RunTime:0.021982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54130462 LIMIT 2 [ RunTime:0.010126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130462 ORDER BY `minOrder` ASC [ RunTime:0.002651s ]
select * from pdf where partno='1703353607' and brandshort='Molex' limit 1 [ RunTime:0.010053s ]
select foldpath,foldpath2,filename from pdf_file where id=1874955 limit 1 [ RunTime:0.024616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703353607' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.034745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54130417 LIMIT 5 [ RunTime:0.048737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130417 ORDER BY `minOrder` ASC [ RunTime:0.028090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54130417 ORDER BY `unit` DESC [ RunTime:0.008165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54130417 LIMIT 2 [ RunTime:0.023461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130417 ORDER BY `minOrder` ASC [ RunTime:0.024434s ]
select * from pdf where partno='1703351627' and brandshort='Molex' limit 1 [ RunTime:0.029213s ]
select foldpath,foldpath2,filename from pdf_file where id=1834728 limit 1 [ RunTime:0.003419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351627' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.041084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54130082 LIMIT 5 [ RunTime:0.049240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130082 ORDER BY `minOrder` ASC [ RunTime:0.021971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54130082 ORDER BY `unit` DESC [ RunTime:0.027227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54130082 LIMIT 2 [ RunTime:0.028718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54130082 ORDER BY `minOrder` ASC [ RunTime:0.001368s ]
select * from pdf where partno='1703351428' and brandshort='Molex' limit 1 [ RunTime:0.028666s ]
select foldpath,foldpath2,filename from pdf_file where id=1577273 limit 1 [ RunTime:0.024114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351428' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54129573 LIMIT 5 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129573 ORDER BY `minOrder` ASC [ RunTime:0.022002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54129573 ORDER BY `unit` DESC [ RunTime:0.009272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54129573 LIMIT 2 [ RunTime:0.006497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129573 ORDER BY `minOrder` ASC [ RunTime:0.006449s ]
select * from pdf where partno='1703351604' and brandshort='Molex' limit 1 [ RunTime:0.014962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351604' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54129569 LIMIT 5 [ RunTime:0.019171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129569 ORDER BY `minOrder` ASC [ RunTime:0.009343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54129569 ORDER BY `unit` DESC [ RunTime:0.009669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54129569 LIMIT 2 [ RunTime:0.009537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129569 ORDER BY `minOrder` ASC [ RunTime:0.004917s ]
select * from pdf where partno='1703355605' and brandshort='Molex' limit 1 [ RunTime:0.004093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703355605' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.036533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54129548 LIMIT 5 [ RunTime:0.019904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129548 ORDER BY `minOrder` ASC [ RunTime:0.018897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54129548 ORDER BY `unit` DESC [ RunTime:0.021012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54129548 LIMIT 2 [ RunTime:0.017201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129548 ORDER BY `minOrder` ASC [ RunTime:0.010194s ]
select * from pdf where partno='1703351217' and brandshort='Molex' limit 1 [ RunTime:0.010041s ]
select foldpath,foldpath2,filename from pdf_file where id=2087010 limit 1 [ RunTime:0.022917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351217' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54129401 LIMIT 5 [ RunTime:0.012249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129401 ORDER BY `minOrder` ASC [ RunTime:0.012311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54129401 ORDER BY `unit` DESC [ RunTime:0.019229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54129401 LIMIT 2 [ RunTime:0.010356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129401 ORDER BY `minOrder` ASC [ RunTime:0.002043s ]
select * from pdf where partno='1703351207' and brandshort='Molex' limit 1 [ RunTime:0.003869s ]
select foldpath,foldpath2,filename from pdf_file where id=2062282 limit 1 [ RunTime:0.006767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351207' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.039742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54129290 LIMIT 5 [ RunTime:0.024623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129290 ORDER BY `minOrder` ASC [ RunTime:0.032646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54129290 ORDER BY `unit` DESC [ RunTime:0.005201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54129290 LIMIT 2 [ RunTime:0.018954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129290 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
select * from pdf where partno='1703353605' and brandshort='Molex' limit 1 [ RunTime:0.008943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703353605' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54128999 LIMIT 5 [ RunTime:0.009800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128999 ORDER BY `minOrder` ASC [ RunTime:0.013453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54128999 ORDER BY `unit` DESC [ RunTime:0.003760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54128999 LIMIT 2 [ RunTime:0.009541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128999 ORDER BY `minOrder` ASC [ RunTime:0.012950s ]
select * from pdf where partno='1703351127' and brandshort='Molex' limit 1 [ RunTime:0.067625s ]
select foldpath,foldpath2,filename from pdf_file where id=1837816 limit 1 [ RunTime:0.033195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351127' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.044129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54128586 LIMIT 5 [ RunTime:0.016663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128586 ORDER BY `minOrder` ASC [ RunTime:0.019501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54128586 ORDER BY `unit` DESC [ RunTime:0.024644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54128586 LIMIT 2 [ RunTime:0.021482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128586 ORDER BY `minOrder` ASC [ RunTime:0.016463s ]
select * from pdf where partno='1703351107' and brandshort='Molex' limit 1 [ RunTime:0.005074s ]
select foldpath,foldpath2,filename from pdf_file where id=2027372 limit 1 [ RunTime:0.017094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351107' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.052607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54128272 LIMIT 5 [ RunTime:0.004387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128272 ORDER BY `minOrder` ASC [ RunTime:0.029350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54128272 ORDER BY `unit` DESC [ RunTime:0.032703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54128272 LIMIT 2 [ RunTime:0.037214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128272 ORDER BY `minOrder` ASC [ RunTime:0.008708s ]
select * from pdf where partno='1703351407' and brandshort='Molex' limit 1 [ RunTime:0.032373s ]
select foldpath,foldpath2,filename from pdf_file where id=2087008 limit 1 [ RunTime:0.004640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703351407' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.045970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54128175 LIMIT 5 [ RunTime:0.013141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128175 ORDER BY `minOrder` ASC [ RunTime:0.020307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54128175 ORDER BY `unit` DESC [ RunTime:0.007557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54128175 LIMIT 2 [ RunTime:0.034538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54128175 ORDER BY `minOrder` ASC [ RunTime:0.019754s ]
select * from pdf where partno='1703355106' and brandshort='Molex' limit 1 [ RunTime:0.004239s ]
select foldpath,foldpath2,filename from pdf_file where id=1535754 limit 1 [ RunTime:0.024907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703355106' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.036559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54127946 LIMIT 5 [ RunTime:0.021939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54127946 ORDER BY `minOrder` ASC [ RunTime:0.056721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54127946 ORDER BY `unit` DESC [ RunTime:0.012873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54127946 LIMIT 2 [ RunTime:0.026864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54127946 ORDER BY `minOrder` ASC [ RunTime:0.003300s ]
select * from pdf where partno='1703355207' and brandshort='Molex' limit 1 [ RunTime:0.029684s ]
select foldpath,foldpath2,filename from pdf_file where id=1535754 limit 1 [ RunTime:0.004817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703355207' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.028330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54127881 LIMIT 5 [ RunTime:0.023640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54127881 ORDER BY `minOrder` ASC [ RunTime:0.008515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54127881 ORDER BY `unit` DESC [ RunTime:0.009195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54127881 LIMIT 2 [ RunTime:0.035518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54127881 ORDER BY `minOrder` ASC [ RunTime:0.002499s ]
select * from pdf where partno='1703355807' and brandshort='Molex' limit 1 [ RunTime:0.008606s ]
select foldpath,foldpath2,filename from pdf_file where id=1535754 limit 1 [ RunTime:0.002058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703355807' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54127595 LIMIT 5 [ RunTime:0.015621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54127595 ORDER BY `minOrder` ASC [ RunTime:0.024916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54127595 ORDER BY `unit` DESC [ RunTime:0.022463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54127595 LIMIT 2 [ RunTime:0.011088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54127595 ORDER BY `minOrder` ASC [ RunTime:0.011988s ]
select * from pdf where partno='1703353106' and brandshort='Molex' limit 1 [ RunTime:0.007582s ]
select foldpath,foldpath2,filename from pdf_file where id=1874955 limit 1 [ RunTime:0.008507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1703353106' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.031155s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010611s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001775s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001808s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023055s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007867s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023696s ]
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 '170335%' OR `brand` LIKE '170335%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019597s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '170335%' OR `brand` LIKE '170335%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018922s ]