SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001600s ]
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=MBN15SB1W01&search=1' [ RunTime:0.001775s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002060s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005013s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001752s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000954s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001486s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006154s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002365s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MBN15SB1W01' LIMIT 1 [ RunTime:0.016552s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-22 20:16:33' WHERE `partno` = 'MBN15SB1W01' [ RunTime:0.004436s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001606s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059652s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17271263 LIMIT 5 [ RunTime:0.016004s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.027834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17271263 ORDER BY `minOrder` ASC [ RunTime:0.028737s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17271263 ORDER BY `unit` DESC [ RunTime:0.038308s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17271263 LIMIT 2 [ RunTime:0.016634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17271263 ORDER BY `minOrder` ASC [ RunTime:0.070397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12414013 LIMIT 5 [ RunTime:0.043467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12414013 ORDER BY `minOrder` ASC [ RunTime:0.020438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12414013 ORDER BY `unit` DESC [ RunTime:0.063128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12414013 LIMIT 2 [ RunTime:0.024703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12414013 ORDER BY `minOrder` ASC [ RunTime:0.016581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17272713 LIMIT 5 [ RunTime:0.074467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272713 ORDER BY `minOrder` ASC [ RunTime:0.048692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17272713 ORDER BY `unit` DESC [ RunTime:0.049126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17272713 LIMIT 2 [ RunTime:0.038981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272713 ORDER BY `minOrder` ASC [ RunTime:0.023688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17272712 LIMIT 5 [ RunTime:0.024510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272712 ORDER BY `minOrder` ASC [ RunTime:0.064131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17272712 ORDER BY `unit` DESC [ RunTime:0.099202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17272712 LIMIT 2 [ RunTime:0.056997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272712 ORDER BY `minOrder` ASC [ RunTime:0.012523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17272707 LIMIT 5 [ RunTime:0.018948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272707 ORDER BY `minOrder` ASC [ RunTime:0.037019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17272707 ORDER BY `unit` DESC [ RunTime:0.045123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17272707 LIMIT 2 [ RunTime:0.018537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272707 ORDER BY `minOrder` ASC [ RunTime:0.033708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17272208 LIMIT 5 [ RunTime:0.029028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272208 ORDER BY `minOrder` ASC [ RunTime:0.077455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17272208 ORDER BY `unit` DESC [ RunTime:0.013704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17272208 LIMIT 2 [ RunTime:0.025042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17272208 ORDER BY `minOrder` ASC [ RunTime:0.009610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17271264 LIMIT 5 [ RunTime:0.015419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17271264 ORDER BY `minOrder` ASC [ RunTime:0.023748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17271264 ORDER BY `unit` DESC [ RunTime:0.026295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17271264 LIMIT 2 [ RunTime:0.004963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17271264 ORDER BY `minOrder` ASC [ RunTime:0.011695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12418618 LIMIT 5 [ RunTime:0.022018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418618 ORDER BY `minOrder` ASC [ RunTime:0.043020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12418618 ORDER BY `unit` DESC [ RunTime:0.040959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12418618 LIMIT 2 [ RunTime:0.060942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418618 ORDER BY `minOrder` ASC [ RunTime:0.002206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12418617 LIMIT 5 [ RunTime:0.024104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418617 ORDER BY `minOrder` ASC [ RunTime:0.040386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12418617 ORDER BY `unit` DESC [ RunTime:0.010305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12418617 LIMIT 2 [ RunTime:0.026386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418617 ORDER BY `minOrder` ASC [ RunTime:0.016985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12418616 LIMIT 5 [ RunTime:0.017397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418616 ORDER BY `minOrder` ASC [ RunTime:0.029125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12418616 ORDER BY `unit` DESC [ RunTime:0.028942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12418616 LIMIT 2 [ RunTime:0.033310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418616 ORDER BY `minOrder` ASC [ RunTime:0.021809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12418591 LIMIT 5 [ RunTime:0.081349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418591 ORDER BY `minOrder` ASC [ RunTime:0.044683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12418591 ORDER BY `unit` DESC [ RunTime:0.010003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12418591 LIMIT 2 [ RunTime:0.051196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12418591 ORDER BY `minOrder` ASC [ RunTime:0.006651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12417316 LIMIT 5 [ RunTime:0.013450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12417316 ORDER BY `minOrder` ASC [ RunTime:0.034738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12417316 ORDER BY `unit` DESC [ RunTime:0.016765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12417316 LIMIT 2 [ RunTime:0.018517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12417316 ORDER BY `minOrder` ASC [ RunTime:0.004294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416797 LIMIT 5 [ RunTime:0.026216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416797 ORDER BY `minOrder` ASC [ RunTime:0.065815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416797 ORDER BY `unit` DESC [ RunTime:0.033198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416797 LIMIT 2 [ RunTime:0.066697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416797 ORDER BY `minOrder` ASC [ RunTime:0.016661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416796 LIMIT 5 [ RunTime:0.017920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416796 ORDER BY `minOrder` ASC [ RunTime:0.036879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416796 ORDER BY `unit` DESC [ RunTime:0.094812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416796 LIMIT 2 [ RunTime:0.036693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416796 ORDER BY `minOrder` ASC [ RunTime:0.012419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416778 LIMIT 5 [ RunTime:0.060209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416778 ORDER BY `minOrder` ASC [ RunTime:0.056278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416778 ORDER BY `unit` DESC [ RunTime:0.041266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416778 LIMIT 2 [ RunTime:0.022602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416778 ORDER BY `minOrder` ASC [ RunTime:0.028836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416777 LIMIT 5 [ RunTime:0.037881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416777 ORDER BY `minOrder` ASC [ RunTime:0.046803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416777 ORDER BY `unit` DESC [ RunTime:0.048598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416777 LIMIT 2 [ RunTime:0.049241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416777 ORDER BY `minOrder` ASC [ RunTime:0.010646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12416770 LIMIT 5 [ RunTime:0.023578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416770 ORDER BY `minOrder` ASC [ RunTime:0.055568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12416770 ORDER BY `unit` DESC [ RunTime:0.014409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12416770 LIMIT 2 [ RunTime:0.037168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12416770 ORDER BY `minOrder` ASC [ RunTime:0.054968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11350805 LIMIT 5 [ RunTime:0.020674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350805 ORDER BY `minOrder` ASC [ RunTime:0.058966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11350805 ORDER BY `unit` DESC [ RunTime:0.089069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11350805 LIMIT 2 [ RunTime:0.017784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350805 ORDER BY `minOrder` ASC [ RunTime:0.034076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11350790 LIMIT 5 [ RunTime:0.036908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350790 ORDER BY `minOrder` ASC [ RunTime:0.046769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11350790 ORDER BY `unit` DESC [ RunTime:0.049690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11350790 LIMIT 2 [ RunTime:0.113798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350790 ORDER BY `minOrder` ASC [ RunTime:0.033901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11350789 LIMIT 5 [ RunTime:0.068647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350789 ORDER BY `minOrder` ASC [ RunTime:0.058395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11350789 ORDER BY `unit` DESC [ RunTime:0.035666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11350789 LIMIT 2 [ RunTime:0.030685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11350789 ORDER BY `minOrder` ASC [ RunTime:0.004965s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083360 LIMIT 5 [ RunTime:0.040182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083360 ORDER BY `minOrder` ASC [ RunTime:0.030746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083360 ORDER BY `unit` DESC [ RunTime:0.020145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083360 LIMIT 2 [ RunTime:0.036486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083360 ORDER BY `minOrder` ASC [ RunTime:0.021212s ]
select * from pdf where partno='mbn15sb1w01-ef' and brandshort='nkk switches' limit 1 [ RunTime:0.065312s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mbn15sb1w01-ef' OR `brand` LIKE 'nkk switches%' ) ) LIMIT 1 [ RunTime:0.018027s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43824428 LIMIT 5 [ RunTime:0.026458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824428 ORDER BY `minOrder` ASC [ RunTime:0.028642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43824428 ORDER BY `unit` DESC [ RunTime:0.061043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43824428 LIMIT 2 [ RunTime:0.028620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824428 ORDER BY `minOrder` ASC [ RunTime:0.029391s ]
select * from pdf where partno='MBN15SB1W01' and brandshort='NKK Switches' limit 1 [ RunTime:0.051022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.032676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43824429 LIMIT 5 [ RunTime:0.039674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824429 ORDER BY `minOrder` ASC [ RunTime:0.045218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43824429 ORDER BY `unit` DESC [ RunTime:0.033154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43824429 LIMIT 2 [ RunTime:0.025698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43824429 ORDER BY `minOrder` ASC [ RunTime:0.041843s ]
select * from pdf where partno='MBN15SB1W01-DA' and brandshort='NKK Switches' limit 1 [ RunTime:0.045153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-DA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.054252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43836787 LIMIT 5 [ RunTime:0.041009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43836787 ORDER BY `minOrder` ASC [ RunTime:0.034351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43836787 ORDER BY `unit` DESC [ RunTime:0.060618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43836787 LIMIT 2 [ RunTime:0.035586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43836787 ORDER BY `minOrder` ASC [ RunTime:0.029115s ]
select * from pdf where partno='MBN15SB1W01-CC' and brandshort='NKK Switches' limit 1 [ RunTime:0.055089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-CC' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.032976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844506 LIMIT 5 [ RunTime:0.028644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844506 ORDER BY `minOrder` ASC [ RunTime:0.034757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844506 ORDER BY `unit` DESC [ RunTime:0.049674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844506 LIMIT 2 [ RunTime:0.035030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844506 ORDER BY `minOrder` ASC [ RunTime:0.041979s ]
select * from pdf where partno='MBN15SB1W01-4C-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.021061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4C-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.020562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844505 LIMIT 5 [ RunTime:0.014646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844505 ORDER BY `minOrder` ASC [ RunTime:0.031679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844505 ORDER BY `unit` DESC [ RunTime:0.028683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844505 LIMIT 2 [ RunTime:0.017587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844505 ORDER BY `minOrder` ASC [ RunTime:0.038264s ]
select * from pdf where partno='MBN15SB1W01-4A-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.031178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4A-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.018472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844504 LIMIT 5 [ RunTime:0.051534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844504 ORDER BY `minOrder` ASC [ RunTime:0.087461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844504 ORDER BY `unit` DESC [ RunTime:0.035659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844504 LIMIT 2 [ RunTime:0.021251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844504 ORDER BY `minOrder` ASC [ RunTime:0.026023s ]
select * from pdf where partno='MBN15SB1W01-4B-B' and brandshort='NKK Switches' limit 1 [ RunTime:0.029000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4B-B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.047408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844503 LIMIT 5 [ RunTime:0.043799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844503 ORDER BY `minOrder` ASC [ RunTime:0.042724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844503 ORDER BY `unit` DESC [ RunTime:0.037899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844503 LIMIT 2 [ RunTime:0.058720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844503 ORDER BY `minOrder` ASC [ RunTime:0.028807s ]
select * from pdf where partno='MBN15SB1W01-4H-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.026473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4H-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.070659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844502 LIMIT 5 [ RunTime:0.062511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844502 ORDER BY `minOrder` ASC [ RunTime:0.080518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844502 ORDER BY `unit` DESC [ RunTime:0.052325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844502 LIMIT 2 [ RunTime:0.028549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844502 ORDER BY `minOrder` ASC [ RunTime:0.015257s ]
select * from pdf where partno='MBN15SB1W01-4G-B' and brandshort='NKK Switches' limit 1 [ RunTime:0.020742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4G-B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.024989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844501 LIMIT 5 [ RunTime:0.056142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844501 ORDER BY `minOrder` ASC [ RunTime:0.047550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844501 ORDER BY `unit` DESC [ RunTime:0.031187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844501 LIMIT 2 [ RunTime:0.036564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844501 ORDER BY `minOrder` ASC [ RunTime:0.057662s ]
select * from pdf where partno='MBN15SB1W01-5H-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.039005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-5H-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.028958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844500 LIMIT 5 [ RunTime:0.019227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844500 ORDER BY `minOrder` ASC [ RunTime:0.023056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844500 ORDER BY `unit` DESC [ RunTime:0.070696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844500 LIMIT 2 [ RunTime:0.041465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844500 ORDER BY `minOrder` ASC [ RunTime:0.007520s ]
select * from pdf where partno='MBN15SB1W01-4G-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.044861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4G-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.026145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844499 LIMIT 5 [ RunTime:0.042928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844499 ORDER BY `minOrder` ASC [ RunTime:0.029949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844499 ORDER BY `unit` DESC [ RunTime:0.042212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844499 LIMIT 2 [ RunTime:0.059520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844499 ORDER BY `minOrder` ASC [ RunTime:0.025750s ]
select * from pdf where partno='MBN15SB1W01-5A-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.031188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-5A-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.057768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844498 LIMIT 5 [ RunTime:0.022926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844498 ORDER BY `minOrder` ASC [ RunTime:0.061101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844498 ORDER BY `unit` DESC [ RunTime:0.046052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844498 LIMIT 2 [ RunTime:0.051121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844498 ORDER BY `minOrder` ASC [ RunTime:0.009962s ]
select * from pdf where partno='MBN15SB1W01-5C-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.007926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-5C-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.026925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844497 LIMIT 5 [ RunTime:0.005692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844497 ORDER BY `minOrder` ASC [ RunTime:0.041253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844497 ORDER BY `unit` DESC [ RunTime:0.015893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844497 LIMIT 2 [ RunTime:0.047506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844497 ORDER BY `minOrder` ASC [ RunTime:0.033899s ]
select * from pdf where partno='MBN15SB1W01-4H-H' and brandshort='NKK Switches' limit 1 [ RunTime:0.020874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4H-H' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.013285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43844468 LIMIT 5 [ RunTime:0.043767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844468 ORDER BY `minOrder` ASC [ RunTime:0.033487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43844468 ORDER BY `unit` DESC [ RunTime:0.020830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43844468 LIMIT 2 [ RunTime:0.049629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43844468 ORDER BY `minOrder` ASC [ RunTime:0.017990s ]
select * from pdf where partno='MBN15SB1W01-4F-A' and brandshort='NKK Switches' limit 1 [ RunTime:0.026393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-4F-A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.055166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43842268 LIMIT 5 [ RunTime:0.013734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43842268 ORDER BY `minOrder` ASC [ RunTime:0.025699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43842268 ORDER BY `unit` DESC [ RunTime:0.023108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43842268 LIMIT 2 [ RunTime:0.029756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43842268 ORDER BY `minOrder` ASC [ RunTime:0.029986s ]
select * from pdf where partno='MBN15SB1W01-AT4043' and brandshort='NKK Switches' limit 1 [ RunTime:0.065038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-AT4043' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.044103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43841790 LIMIT 5 [ RunTime:0.048203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841790 ORDER BY `minOrder` ASC [ RunTime:0.017344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43841790 ORDER BY `unit` DESC [ RunTime:0.018231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43841790 LIMIT 2 [ RunTime:0.032413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841790 ORDER BY `minOrder` ASC [ RunTime:0.010495s ]
select * from pdf where partno='MBN15SB1W01-EF' and brandshort='NKK Switches' limit 1 [ RunTime:0.013158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-EF' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.066090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43841789 LIMIT 5 [ RunTime:0.038098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841789 ORDER BY `minOrder` ASC [ RunTime:0.046620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43841789 ORDER BY `unit` DESC [ RunTime:0.027349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43841789 LIMIT 2 [ RunTime:0.022702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841789 ORDER BY `minOrder` ASC [ RunTime:0.016462s ]
select * from pdf where partno='MBN15SB1W01-EA' and brandshort='NKK Switches' limit 1 [ RunTime:0.037804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-EA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.027838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43841788 LIMIT 5 [ RunTime:0.020964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841788 ORDER BY `minOrder` ASC [ RunTime:0.015433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43841788 ORDER BY `unit` DESC [ RunTime:0.023549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43841788 LIMIT 2 [ RunTime:0.021627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841788 ORDER BY `minOrder` ASC [ RunTime:0.007907s ]
select * from pdf where partno='MBN15SB1W01-EC' and brandshort='NKK Switches' limit 1 [ RunTime:0.017873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-EC' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.030177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43841292 LIMIT 5 [ RunTime:0.038548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841292 ORDER BY `minOrder` ASC [ RunTime:0.023109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43841292 ORDER BY `unit` DESC [ RunTime:0.019396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43841292 LIMIT 2 [ RunTime:0.046368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841292 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
select * from pdf where partno='MBN15SB1W01-DB' and brandshort='NKK Switches' limit 1 [ RunTime:0.017950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-DB' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.032778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43841291 LIMIT 5 [ RunTime:0.007629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841291 ORDER BY `minOrder` ASC [ RunTime:0.005154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43841291 ORDER BY `unit` DESC [ RunTime:0.026042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43841291 LIMIT 2 [ RunTime:0.035410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43841291 ORDER BY `minOrder` ASC [ RunTime:0.027674s ]
select * from pdf where partno='MBN15SB1W01-DF' and brandshort='NKK Switches' limit 1 [ RunTime:0.018207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MBN15SB1W01-DF' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.031351s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015589s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019398s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024799s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035677s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014614s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019190s ]
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 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007095s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MBN15SB1W01%' OR `brand` LIKE 'MBN15SB1W01%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014403s ]