SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001948s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.194' , `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=SF12&search=1' [ RunTime:0.007598s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001887s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003157s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002159s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.194' ) [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001822s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004628s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001836s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SF12' LIMIT 1 [ RunTime:0.010491s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-03 05:16:39' WHERE `partno` = 'SF12' [ RunTime:0.012062s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003963s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027225s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11679807 LIMIT 5 [ RunTime:0.003530s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11679807 ORDER BY `minOrder` ASC [ RunTime:0.004560s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11679807 ORDER BY `unit` DESC [ RunTime:0.005785s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11679807 LIMIT 2 [ RunTime:0.018528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11679807 ORDER BY `minOrder` ASC [ RunTime:0.020701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681419 LIMIT 5 [ RunTime:0.005095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681419 ORDER BY `minOrder` ASC [ RunTime:0.006765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681419 ORDER BY `unit` DESC [ RunTime:0.039160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681419 LIMIT 2 [ RunTime:0.004269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681419 ORDER BY `minOrder` ASC [ RunTime:0.013775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872703 LIMIT 5 [ RunTime:0.009290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872703 ORDER BY `minOrder` ASC [ RunTime:0.012184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12872703 ORDER BY `unit` DESC [ RunTime:0.009587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12872703 LIMIT 2 [ RunTime:0.016357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872703 ORDER BY `minOrder` ASC [ RunTime:0.002600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879747 LIMIT 5 [ RunTime:0.013706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879747 ORDER BY `minOrder` ASC [ RunTime:0.011702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879747 ORDER BY `unit` DESC [ RunTime:0.010937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879747 LIMIT 2 [ RunTime:0.010696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879747 ORDER BY `minOrder` ASC [ RunTime:0.013260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879755 LIMIT 5 [ RunTime:0.010600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879755 ORDER BY `minOrder` ASC [ RunTime:0.011077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879755 ORDER BY `unit` DESC [ RunTime:0.007042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879755 LIMIT 2 [ RunTime:0.007550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879755 ORDER BY `minOrder` ASC [ RunTime:0.001629s ]
select * from pdf where partno='SF1211-66344' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.010463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879799 LIMIT 5 [ RunTime:0.012746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879799 ORDER BY `minOrder` ASC [ RunTime:0.009119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879799 ORDER BY `unit` DESC [ RunTime:0.002868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879799 LIMIT 2 [ RunTime:0.006356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879799 ORDER BY `minOrder` ASC [ RunTime:0.005635s ]
select * from pdf where partno='SF1211-66198-TD' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.011725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881468 LIMIT 5 [ RunTime:0.015046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881468 ORDER BY `minOrder` ASC [ RunTime:0.023551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881468 ORDER BY `unit` DESC [ RunTime:0.009832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881468 LIMIT 2 [ RunTime:0.012369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881468 ORDER BY `minOrder` ASC [ RunTime:0.011634s ]
select * from pdf where partno='SF1211-66344-2S' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.010225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12877121 LIMIT 5 [ RunTime:0.010173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12877121 ORDER BY `minOrder` ASC [ RunTime:0.010619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12877121 ORDER BY `unit` DESC [ RunTime:0.005226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12877121 LIMIT 2 [ RunTime:0.006989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12877121 ORDER BY `minOrder` ASC [ RunTime:0.005116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682657 LIMIT 5 [ RunTime:0.014802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682657 ORDER BY `minOrder` ASC [ RunTime:0.018891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682657 ORDER BY `unit` DESC [ RunTime:0.012151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682657 LIMIT 2 [ RunTime:0.002059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682657 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
select * from pdf where partno='SF1211-60193-1S' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.011570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16583763 LIMIT 5 [ RunTime:0.006279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16583763 ORDER BY `minOrder` ASC [ RunTime:0.021935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16583763 ORDER BY `unit` DESC [ RunTime:0.008535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16583763 LIMIT 2 [ RunTime:0.006118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16583763 ORDER BY `minOrder` ASC [ RunTime:0.032858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14629193 LIMIT 5 [ RunTime:0.007370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14629193 ORDER BY `minOrder` ASC [ RunTime:0.010397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14629193 ORDER BY `unit` DESC [ RunTime:0.018854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14629193 LIMIT 2 [ RunTime:0.013297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14629193 ORDER BY `minOrder` ASC [ RunTime:0.001947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16585108 LIMIT 5 [ RunTime:0.005163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16585108 ORDER BY `minOrder` ASC [ RunTime:0.013119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16585108 ORDER BY `unit` DESC [ RunTime:0.018078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16585108 LIMIT 2 [ RunTime:0.005145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16585108 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584648 LIMIT 5 [ RunTime:0.004256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584648 ORDER BY `minOrder` ASC [ RunTime:0.005153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16584648 ORDER BY `unit` DESC [ RunTime:0.015309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16584648 LIMIT 2 [ RunTime:0.010018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584648 ORDER BY `minOrder` ASC [ RunTime:0.005398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753759 LIMIT 5 [ RunTime:0.006297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753759 ORDER BY `minOrder` ASC [ RunTime:0.002271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13753759 ORDER BY `unit` DESC [ RunTime:0.003235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13753759 LIMIT 2 [ RunTime:0.015028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753759 ORDER BY `minOrder` ASC [ RunTime:0.004196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647155 LIMIT 5 [ RunTime:0.003394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647155 ORDER BY `minOrder` ASC [ RunTime:0.008268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647155 ORDER BY `unit` DESC [ RunTime:0.014242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647155 LIMIT 2 [ RunTime:0.007728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647155 ORDER BY `minOrder` ASC [ RunTime:0.011448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647154 LIMIT 5 [ RunTime:0.007166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647154 ORDER BY `minOrder` ASC [ RunTime:0.004950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647154 ORDER BY `unit` DESC [ RunTime:0.030297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647154 LIMIT 2 [ RunTime:0.022677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647154 ORDER BY `minOrder` ASC [ RunTime:0.003136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643563 LIMIT 5 [ RunTime:0.016180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643563 ORDER BY `minOrder` ASC [ RunTime:0.010626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643563 ORDER BY `unit` DESC [ RunTime:0.026328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643563 LIMIT 2 [ RunTime:0.015491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643563 ORDER BY `minOrder` ASC [ RunTime:0.005903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19640308 LIMIT 5 [ RunTime:0.008122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640308 ORDER BY `minOrder` ASC [ RunTime:0.012331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19640308 ORDER BY `unit` DESC [ RunTime:0.019319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19640308 LIMIT 2 [ RunTime:0.003597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640308 ORDER BY `minOrder` ASC [ RunTime:0.001815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18599654 LIMIT 5 [ RunTime:0.003085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18599654 ORDER BY `minOrder` ASC [ RunTime:0.002633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18599654 ORDER BY `unit` DESC [ RunTime:0.011792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18599654 LIMIT 2 [ RunTime:0.010627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18599654 ORDER BY `minOrder` ASC [ RunTime:0.006280s ]
select * from pdf where partno='SF1212AD.SL.GN' and brandshort='Sunon Fans' limit 1 [ RunTime:0.027047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16596832 LIMIT 5 [ RunTime:0.035569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16596832 ORDER BY `minOrder` ASC [ RunTime:0.025632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16596832 ORDER BY `unit` DESC [ RunTime:0.010535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16596832 LIMIT 2 [ RunTime:0.009993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16596832 ORDER BY `minOrder` ASC [ RunTime:0.007964s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274396 LIMIT 5 [ RunTime:0.002213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274396 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274396 ORDER BY `unit` DESC [ RunTime:0.009807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274396 LIMIT 2 [ RunTime:0.007686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274396 ORDER BY `minOrder` ASC [ RunTime:0.013863s ]
select * from pdf where partno='sf1211-6021' and brandshort='amphenol / sv microwave' limit 1 [ RunTime:0.004261s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf1211-6021' OR `brand` LIKE 'amphenol / sv microwave%' ) ) LIMIT 1 [ RunTime:0.003619s ]
SELECT `id` FROM `stock` WHERE `id` <> 32274396 AND `partno` = 'sf1211-6021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol / sv microwave%' ) [ RunTime:0.010478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134557 LIMIT 5 [ RunTime:0.010201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134557 ORDER BY `minOrder` ASC [ RunTime:0.021741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134557 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134557 LIMIT 2 [ RunTime:0.018790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134557 ORDER BY `minOrder` ASC [ RunTime:0.005205s ]
select * from pdf where partno='sf126e/11pc35/11pc35/1000mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.007302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126e/11pc35/11pc35/1000mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.018157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282543 LIMIT 5 [ RunTime:0.008283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282543 ORDER BY `minOrder` ASC [ RunTime:0.014801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282543 ORDER BY `unit` DESC [ RunTime:0.002611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282543 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282543 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='sf126e/11pc35/11pc35/914mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.010529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126e/11pc35/11pc35/914mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.019453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134733 LIMIT 5 [ RunTime:0.009698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134733 ORDER BY `minOrder` ASC [ RunTime:0.011335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134733 ORDER BY `unit` DESC [ RunTime:0.013815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134733 LIMIT 2 [ RunTime:0.000848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134733 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='sf126ea/11sma/11sma/1000mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.004318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126ea/11sma/11sma/1000mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.005454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302100 LIMIT 5 [ RunTime:0.007313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302100 ORDER BY `minOrder` ASC [ RunTime:0.029754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32302100 ORDER BY `unit` DESC [ RunTime:0.008801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32302100 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302100 ORDER BY `minOrder` ASC [ RunTime:0.009159s ]
select * from pdf where partno='sf126ea/11n/21n/1500mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.039355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126ea/11n/21n/1500mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.023569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274046 LIMIT 5 [ RunTime:0.028567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274046 ORDER BY `minOrder` ASC [ RunTime:0.025143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274046 ORDER BY `unit` DESC [ RunTime:0.012266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274046 LIMIT 2 [ RunTime:0.014161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274046 ORDER BY `minOrder` ASC [ RunTime:0.006227s ]
select * from pdf where partno='sf126ea/11n/21n/1500mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.011040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126ea/11n/21n/1500mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.020773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32261966 LIMIT 5 [ RunTime:0.004183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261966 ORDER BY `minOrder` ASC [ RunTime:0.008234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32261966 ORDER BY `unit` DESC [ RunTime:0.008204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32261966 LIMIT 2 [ RunTime:0.009215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261966 ORDER BY `minOrder` ASC [ RunTime:0.005074s ]
select * from pdf where partno='sf126ea/11n/21n/1500mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.003107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126ea/11n/21n/1500mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.015060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32260964 LIMIT 5 [ RunTime:0.020205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32260964 ORDER BY `minOrder` ASC [ RunTime:0.007878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32260964 ORDER BY `unit` DESC [ RunTime:0.006956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32260964 LIMIT 2 [ RunTime:0.011595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32260964 ORDER BY `minOrder` ASC [ RunTime:0.005095s ]
select * from pdf where partno='sf126ea/11n/21n/1500mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.008092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126ea/11n/21n/1500mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.011685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32204950 LIMIT 5 [ RunTime:0.007226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204950 ORDER BY `minOrder` ASC [ RunTime:0.031177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32204950 ORDER BY `unit` DESC [ RunTime:0.012114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32204950 LIMIT 2 [ RunTime:0.014434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204950 ORDER BY `minOrder` ASC [ RunTime:0.005054s ]
select * from pdf where partno='sf126ea/11n/21n/1500mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.001284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126ea/11n/21n/1500mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.002165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32167837 LIMIT 5 [ RunTime:0.003488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32167837 ORDER BY `minOrder` ASC [ RunTime:0.015888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32167837 ORDER BY `unit` DESC [ RunTime:0.015981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32167837 LIMIT 2 [ RunTime:0.005782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32167837 ORDER BY `minOrder` ASC [ RunTime:0.008939s ]
select * from pdf where partno='sf126ea/11n/21n/1500mm' and brandshort='huber+suhner' limit 1 [ RunTime:0.001363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sf126ea/11n/21n/1500mm' OR `brand` LIKE 'huber+suhner%' ) ) LIMIT 1 [ RunTime:0.004775s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44085741 LIMIT 5 [ RunTime:0.010619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44085741 ORDER BY `minOrder` ASC [ RunTime:0.011521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44085741 ORDER BY `unit` DESC [ RunTime:0.007483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44085741 LIMIT 2 [ RunTime:0.022739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44085741 ORDER BY `minOrder` ASC [ RunTime:0.006392s ]
select * from pdf where partno='SF1200-TAP' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.019460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1200-TAP' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016455s ]
SELECT `id` FROM `stock` WHERE `id` <> 44085741 AND `partno` = 'SF1200-TAP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.022330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909789 LIMIT 5 [ RunTime:0.006129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909789 ORDER BY `minOrder` ASC [ RunTime:0.010044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909789 ORDER BY `unit` DESC [ RunTime:0.014077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909789 LIMIT 2 [ RunTime:0.007993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909789 ORDER BY `minOrder` ASC [ RunTime:0.007942s ]
select * from pdf where partno='SF1211-66199' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.012543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-66199' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.004166s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909789 AND `partno` = 'SF1211-66199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.017399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11679807 [ RunTime:0.019477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908646 LIMIT 5 [ RunTime:0.015010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908646 ORDER BY `minOrder` ASC [ RunTime:0.010706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908646 ORDER BY `unit` DESC [ RunTime:0.002044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908646 LIMIT 2 [ RunTime:0.012679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908646 ORDER BY `minOrder` ASC [ RunTime:0.008654s ]
select * from pdf where partno='SF1287-6001' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.023188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1287-6001' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.002771s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908646 AND `partno` = 'SF1287-6001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.021485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57319696 LIMIT 5 [ RunTime:0.007867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57319696 ORDER BY `minOrder` ASC [ RunTime:0.007902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57319696 ORDER BY `unit` DESC [ RunTime:0.009435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57319696 LIMIT 2 [ RunTime:0.009171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57319696 ORDER BY `minOrder` ASC [ RunTime:0.002749s ]
select * from pdf where partno='SF1224E-1' and brandshort='Akoustis- RFMi' limit 1 [ RunTime:0.003028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1224E-1' OR `brand` LIKE 'Akoustis- RFMi%' ) ) LIMIT 1 [ RunTime:0.006056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909856 LIMIT 5 [ RunTime:0.029642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909856 ORDER BY `minOrder` ASC [ RunTime:0.007796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909856 ORDER BY `unit` DESC [ RunTime:0.023080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909856 LIMIT 2 [ RunTime:0.017282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909856 ORDER BY `minOrder` ASC [ RunTime:0.015104s ]
select * from pdf where partno='SF1211-6058' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.019930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-6058' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.011274s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909856 AND `partno` = 'SF1211-6058' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.014758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872703 [ RunTime:0.019549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61910591 LIMIT 5 [ RunTime:0.032519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910591 ORDER BY `minOrder` ASC [ RunTime:0.019278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61910591 ORDER BY `unit` DESC [ RunTime:0.009646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61910591 LIMIT 2 [ RunTime:0.024424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910591 ORDER BY `minOrder` ASC [ RunTime:0.005718s ]
select * from pdf where partno='SF1211-66198' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.019141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-66198' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.027352s ]
SELECT `id` FROM `stock` WHERE `id` <> 61910591 AND `partno` = 'SF1211-66198' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.025382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681419 [ RunTime:0.007271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61911017 LIMIT 5 [ RunTime:0.007088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911017 ORDER BY `minOrder` ASC [ RunTime:0.008221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61911017 ORDER BY `unit` DESC [ RunTime:0.006210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61911017 LIMIT 2 [ RunTime:0.012591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911017 ORDER BY `minOrder` ASC [ RunTime:0.002207s ]
select * from pdf where partno='SF1211-6045' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.008316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-6045' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.017879s ]
SELECT `id` FROM `stock` WHERE `id` <> 61911017 AND `partno` = 'SF1211-6045' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.046417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879747 [ RunTime:0.005231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61910636 LIMIT 5 [ RunTime:0.019138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910636 ORDER BY `minOrder` ASC [ RunTime:0.020297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61910636 ORDER BY `unit` DESC [ RunTime:0.025742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61910636 LIMIT 2 [ RunTime:0.007326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910636 ORDER BY `minOrder` ASC [ RunTime:0.002182s ]
select * from pdf where partno='SF1211-6021' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.003536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-6021' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.014359s ]
SELECT `id` FROM `stock` WHERE `id` <> 61910636 AND `partno` = 'SF1211-6021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.015523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879956 [ RunTime:0.034007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909867 LIMIT 5 [ RunTime:0.005997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909867 ORDER BY `minOrder` ASC [ RunTime:0.014083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909867 ORDER BY `unit` DESC [ RunTime:0.029355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909867 LIMIT 2 [ RunTime:0.022544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909867 ORDER BY `minOrder` ASC [ RunTime:0.005783s ]
select * from pdf where partno='SF1211-6025' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.026856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-6025' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.025767s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909867 AND `partno` = 'SF1211-6025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.040706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55634769 LIMIT 5 [ RunTime:0.056058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55634769 ORDER BY `minOrder` ASC [ RunTime:0.066050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55634769 ORDER BY `unit` DESC [ RunTime:0.005525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55634769 LIMIT 2 [ RunTime:0.021279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55634769 ORDER BY `minOrder` ASC [ RunTime:0.003589s ]
select * from pdf where partno='SF126E/11SMA/11SMA/1000MM' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.012823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF126E/11SMA/11SMA/1000MM' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.004436s ]
SELECT `id` FROM `stock` WHERE `id` <> 55634769 AND `partno` = 'SF126E/11SMA/11SMA/1000MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.012661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584648 [ RunTime:0.005793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61910660 LIMIT 5 [ RunTime:0.013691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910660 ORDER BY `minOrder` ASC [ RunTime:0.010352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61910660 ORDER BY `unit` DESC [ RunTime:0.002863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61910660 LIMIT 2 [ RunTime:0.013358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910660 ORDER BY `minOrder` ASC [ RunTime:0.004195s ]
select * from pdf where partno='SF1211-66198-TD' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.009957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-66198-TD' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.007957s ]
SELECT `id` FROM `stock` WHERE `id` <> 61910660 AND `partno` = 'SF1211-66198-TD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.006862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879799 [ RunTime:0.014241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61911029 LIMIT 5 [ RunTime:0.021833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911029 ORDER BY `minOrder` ASC [ RunTime:0.037524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61911029 ORDER BY `unit` DESC [ RunTime:0.004937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61911029 LIMIT 2 [ RunTime:0.006695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61911029 ORDER BY `minOrder` ASC [ RunTime:0.006693s ]
select * from pdf where partno='SF1211-60193-1S' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.002644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-60193-1S' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.004260s ]
SELECT `id` FROM `stock` WHERE `id` <> 61911029 AND `partno` = 'SF1211-60193-1S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.012609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682657 [ RunTime:0.007372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61910611 LIMIT 5 [ RunTime:0.003084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910611 ORDER BY `minOrder` ASC [ RunTime:0.018648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61910611 ORDER BY `unit` DESC [ RunTime:0.020470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61910611 LIMIT 2 [ RunTime:0.002053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61910611 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
select * from pdf where partno='SF1212-6002' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.011417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1212-6002' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.009869s ]
SELECT `id` FROM `stock` WHERE `id` <> 61910611 AND `partno` = 'SF1212-6002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.003734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681884 [ RunTime:0.005835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912891 LIMIT 5 [ RunTime:0.012045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912891 ORDER BY `minOrder` ASC [ RunTime:0.007113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912891 ORDER BY `unit` DESC [ RunTime:0.007282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912891 LIMIT 2 [ RunTime:0.003595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912891 ORDER BY `minOrder` ASC [ RunTime:0.008472s ]
select * from pdf where partno='SF1212-6000' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1212-6000' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.006598s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912891 AND `partno` = 'SF1212-6000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.014059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682803 [ RunTime:0.009789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61913560 LIMIT 5 [ RunTime:0.011613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913560 ORDER BY `minOrder` ASC [ RunTime:0.015863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61913560 ORDER BY `unit` DESC [ RunTime:0.000543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61913560 LIMIT 2 [ RunTime:0.003038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61913560 ORDER BY `minOrder` ASC [ RunTime:0.004285s ]
select * from pdf where partno='SF1211-66344-2S' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.005500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-66344-2S' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.006158s ]
SELECT `id` FROM `stock` WHERE `id` <> 61913560 AND `partno` = 'SF1211-66344-2S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.017142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881468 [ RunTime:0.002771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912886 LIMIT 5 [ RunTime:0.004244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912886 ORDER BY `minOrder` ASC [ RunTime:0.003481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912886 ORDER BY `unit` DESC [ RunTime:0.019183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912886 LIMIT 2 [ RunTime:0.007374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912886 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='SF1211-6063' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.015278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-6063' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.013959s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912886 AND `partno` = 'SF1211-6063' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.011997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12877121 [ RunTime:0.009435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56024731 LIMIT 5 [ RunTime:0.004555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56024731 ORDER BY `minOrder` ASC [ RunTime:0.007555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56024731 ORDER BY `unit` DESC [ RunTime:0.011305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56024731 LIMIT 2 [ RunTime:0.010652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56024731 ORDER BY `minOrder` ASC [ RunTime:0.003979s ]
select * from pdf where partno='SF126E/11SMA/11SMA/500MM' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.016262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF126E/11SMA/11SMA/500MM' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.017694s ]
SELECT `id` FROM `stock` WHERE `id` <> 56024731 AND `partno` = 'SF126E/11SMA/11SMA/500MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.014192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753759 [ RunTime:0.008159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915913 LIMIT 5 [ RunTime:0.010062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915913 ORDER BY `minOrder` ASC [ RunTime:0.024409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915913 ORDER BY `unit` DESC [ RunTime:0.004162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915913 LIMIT 2 [ RunTime:0.005254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915913 ORDER BY `minOrder` ASC [ RunTime:0.008101s ]
select * from pdf where partno='SF1211-6061' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.019137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF1211-6061' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.011152s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915913 AND `partno` = 'SF1211-6061' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.009295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56029398 LIMIT 5 [ RunTime:0.002035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56029398 ORDER BY `minOrder` ASC [ RunTime:0.006939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56029398 ORDER BY `unit` DESC [ RunTime:0.004535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56029398 LIMIT 2 [ RunTime:0.007952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56029398 ORDER BY `minOrder` ASC [ RunTime:0.003528s ]
select * from pdf where partno='SF126EA/11N/21N/1500MM' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.003722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF126EA/11N/21N/1500MM' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.010379s ]
SELECT `id` FROM `stock` WHERE `id` <> 56029398 AND `partno` = 'SF126EA/11N/21N/1500MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.005779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14629915 [ RunTime:0.005613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56029391 LIMIT 5 [ RunTime:0.008655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56029391 ORDER BY `minOrder` ASC [ RunTime:0.010078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56029391 ORDER BY `unit` DESC [ RunTime:0.002385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56029391 LIMIT 2 [ RunTime:0.003356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56029391 ORDER BY `minOrder` ASC [ RunTime:0.002242s ]
select * from pdf where partno='SF126E/11PC35/11PC35/914MM' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.004821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF126E/11PC35/11PC35/914MM' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.008596s ]
SELECT `id` FROM `stock` WHERE `id` <> 56029391 AND `partno` = 'SF126E/11PC35/11PC35/914MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.013240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14629714 [ RunTime:0.008533s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010823s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008091s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012294s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015072s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007766s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002445s ]
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 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017396s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SF12%' OR `brand` LIKE 'SF12%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034097s ]