SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002131s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.90' , `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=1.5SMC12A&search=1' [ RunTime:0.056694s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001930s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.018852s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003269s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.90' ) [ RunTime:0.022369s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002045s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.033970s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001676s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5SMC12A' LIMIT 1 [ RunTime:0.003179s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-18 20:33:18' WHERE `partno` = '1.5SMC12A' [ RunTime:0.022376s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001877s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112928s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678832 LIMIT 5 [ RunTime:0.061497s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678832 ORDER BY `minOrder` ASC [ RunTime:0.042669s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.027507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678832 ORDER BY `unit` DESC [ RunTime:0.025462s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678832 LIMIT 2 [ RunTime:0.019451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678832 ORDER BY `minOrder` ASC [ RunTime:0.014310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692940 LIMIT 5 [ RunTime:0.018472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692940 ORDER BY `minOrder` ASC [ RunTime:0.052481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692940 ORDER BY `unit` DESC [ RunTime:0.098326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692940 LIMIT 2 [ RunTime:0.050248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692940 ORDER BY `minOrder` ASC [ RunTime:0.015398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803703 LIMIT 5 [ RunTime:0.047731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803703 ORDER BY `minOrder` ASC [ RunTime:0.045869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803703 ORDER BY `unit` DESC [ RunTime:0.093936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803703 LIMIT 2 [ RunTime:0.066346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803703 ORDER BY `minOrder` ASC [ RunTime:0.019561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803174 LIMIT 5 [ RunTime:0.114510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803174 ORDER BY `minOrder` ASC [ RunTime:0.056261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803174 ORDER BY `unit` DESC [ RunTime:0.077058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803174 LIMIT 2 [ RunTime:0.015552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803174 ORDER BY `minOrder` ASC [ RunTime:0.048918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803115 LIMIT 5 [ RunTime:0.035595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803115 ORDER BY `minOrder` ASC [ RunTime:0.104316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803115 ORDER BY `unit` DESC [ RunTime:0.031501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803115 LIMIT 2 [ RunTime:0.047520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803115 ORDER BY `minOrder` ASC [ RunTime:0.023266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674684 LIMIT 5 [ RunTime:0.030877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674684 ORDER BY `minOrder` ASC [ RunTime:0.017801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674684 ORDER BY `unit` DESC [ RunTime:0.031433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674684 LIMIT 2 [ RunTime:0.008851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674684 ORDER BY `minOrder` ASC [ RunTime:0.008576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674613 LIMIT 5 [ RunTime:0.022005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674613 ORDER BY `minOrder` ASC [ RunTime:0.014298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674613 ORDER BY `unit` DESC [ RunTime:0.007058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674613 LIMIT 2 [ RunTime:0.027440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674613 ORDER BY `minOrder` ASC [ RunTime:0.019300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673785 LIMIT 5 [ RunTime:0.013424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673785 ORDER BY `minOrder` ASC [ RunTime:0.026222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673785 ORDER BY `unit` DESC [ RunTime:0.015020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673785 LIMIT 2 [ RunTime:0.025982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673785 ORDER BY `minOrder` ASC [ RunTime:0.025364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673680 LIMIT 5 [ RunTime:0.008083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673680 ORDER BY `minOrder` ASC [ RunTime:0.014332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673680 ORDER BY `unit` DESC [ RunTime:0.017443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673680 LIMIT 2 [ RunTime:0.012298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673680 ORDER BY `minOrder` ASC [ RunTime:0.024324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673289 LIMIT 5 [ RunTime:0.048661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673289 ORDER BY `minOrder` ASC [ RunTime:0.004284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673289 ORDER BY `unit` DESC [ RunTime:0.030707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673289 LIMIT 2 [ RunTime:0.012812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673289 ORDER BY `minOrder` ASC [ RunTime:0.005595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672838 LIMIT 5 [ RunTime:0.012048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672838 ORDER BY `minOrder` ASC [ RunTime:0.029242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672838 ORDER BY `unit` DESC [ RunTime:0.010683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672838 LIMIT 2 [ RunTime:0.016358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672838 ORDER BY `minOrder` ASC [ RunTime:0.000845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670897 LIMIT 5 [ RunTime:0.022926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670897 ORDER BY `minOrder` ASC [ RunTime:0.013909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670897 ORDER BY `unit` DESC [ RunTime:0.020775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670897 LIMIT 2 [ RunTime:0.023332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670897 ORDER BY `minOrder` ASC [ RunTime:0.005473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832434 LIMIT 5 [ RunTime:0.024015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832434 ORDER BY `minOrder` ASC [ RunTime:0.010897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832434 ORDER BY `unit` DESC [ RunTime:0.024384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832434 LIMIT 2 [ RunTime:0.003691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832434 ORDER BY `minOrder` ASC [ RunTime:0.008351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832433 LIMIT 5 [ RunTime:0.011619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832433 ORDER BY `minOrder` ASC [ RunTime:0.008450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832433 ORDER BY `unit` DESC [ RunTime:0.005338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832433 LIMIT 2 [ RunTime:0.005073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832433 ORDER BY `minOrder` ASC [ RunTime:0.001175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832084 LIMIT 5 [ RunTime:0.015724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832084 ORDER BY `minOrder` ASC [ RunTime:0.016374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832084 ORDER BY `unit` DESC [ RunTime:0.022976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832084 LIMIT 2 [ RunTime:0.020555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832084 ORDER BY `minOrder` ASC [ RunTime:0.016579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831877 LIMIT 5 [ RunTime:0.012751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831877 ORDER BY `minOrder` ASC [ RunTime:0.011763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831877 ORDER BY `unit` DESC [ RunTime:0.005705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831877 LIMIT 2 [ RunTime:0.008362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831877 ORDER BY `minOrder` ASC [ RunTime:0.007248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831876 LIMIT 5 [ RunTime:0.019380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831876 ORDER BY `minOrder` ASC [ RunTime:0.024272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831876 ORDER BY `unit` DESC [ RunTime:0.021073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831876 LIMIT 2 [ RunTime:0.015590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831876 ORDER BY `minOrder` ASC [ RunTime:0.009190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831537 LIMIT 5 [ RunTime:0.034527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831537 ORDER BY `minOrder` ASC [ RunTime:0.012804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831537 ORDER BY `unit` DESC [ RunTime:0.010659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831537 LIMIT 2 [ RunTime:0.013613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831537 ORDER BY `minOrder` ASC [ RunTime:0.004190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829493 LIMIT 5 [ RunTime:0.004284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829493 ORDER BY `minOrder` ASC [ RunTime:0.001979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829493 ORDER BY `unit` DESC [ RunTime:0.008687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829493 LIMIT 2 [ RunTime:0.007096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829493 ORDER BY `minOrder` ASC [ RunTime:0.003446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818267 LIMIT 5 [ RunTime:0.010193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818267 ORDER BY `minOrder` ASC [ RunTime:0.012946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818267 ORDER BY `unit` DESC [ RunTime:0.004383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818267 LIMIT 2 [ RunTime:0.003907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818267 ORDER BY `minOrder` ASC [ RunTime:0.006046s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140966 LIMIT 5 [ RunTime:0.003184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140966 ORDER BY `minOrder` ASC [ RunTime:0.007829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140966 ORDER BY `unit` DESC [ RunTime:0.001172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140966 LIMIT 2 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140966 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
select * from pdf where partno='1.5smc12ahe3_a/i' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.001085s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc12ahe3_a/i' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.008823s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140966 AND `partno` = '1.5smc12ahe3_a/i' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.000869s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42131546 LIMIT 5 [ RunTime:0.024418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131546 ORDER BY `minOrder` ASC [ RunTime:0.015553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42131546 ORDER BY `unit` DESC [ RunTime:0.003474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42131546 LIMIT 2 [ RunTime:0.013344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131546 ORDER BY `minOrder` ASC [ RunTime:0.010120s ]
select * from pdf where partno='1.5SMC12A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.014482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.015132s ]
SELECT `id` FROM `stock` WHERE `id` <> 42131546 AND `partno` = '1.5SMC12A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.025140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692940 [ RunTime:0.013306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142943 LIMIT 5 [ RunTime:0.015673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142943 ORDER BY `minOrder` ASC [ RunTime:0.033597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142943 ORDER BY `unit` DESC [ RunTime:0.010195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142943 LIMIT 2 [ RunTime:0.018744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142943 ORDER BY `minOrder` ASC [ RunTime:0.002605s ]
select * from pdf where partno='1.5SMC12A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.012629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.018889s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142943 AND `partno` = '1.5SMC12A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.037562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804646 [ RunTime:0.015973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42131977 LIMIT 5 [ RunTime:0.027682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131977 ORDER BY `minOrder` ASC [ RunTime:0.039792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42131977 ORDER BY `unit` DESC [ RunTime:0.037107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42131977 LIMIT 2 [ RunTime:0.033713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131977 ORDER BY `minOrder` ASC [ RunTime:0.018393s ]
select * from pdf where partno='1.5SMC12A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.035814s ]
SELECT `id` FROM `stock` WHERE `id` <> 42131977 AND `partno` = '1.5SMC12A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803115 [ RunTime:0.031398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105224 LIMIT 5 [ RunTime:0.009494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105224 ORDER BY `minOrder` ASC [ RunTime:0.015662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105224 ORDER BY `unit` DESC [ RunTime:0.020154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105224 LIMIT 2 [ RunTime:0.008908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105224 ORDER BY `minOrder` ASC [ RunTime:0.025085s ]
select * from pdf where partno='1.5SMC12A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.029247s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105224 AND `partno` = '1.5SMC12A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.024180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678832 [ RunTime:0.021691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174328 LIMIT 5 [ RunTime:0.018024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174328 ORDER BY `minOrder` ASC [ RunTime:0.014558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174328 ORDER BY `unit` DESC [ RunTime:0.007995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174328 LIMIT 2 [ RunTime:0.013007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174328 ORDER BY `minOrder` ASC [ RunTime:0.007163s ]
select * from pdf where partno='1.5SMC12AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.027650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.025725s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174328 AND `partno` = '1.5SMC12AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.011395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803703 [ RunTime:0.027642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170729 LIMIT 5 [ RunTime:0.023829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170729 ORDER BY `minOrder` ASC [ RunTime:0.035773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170729 ORDER BY `unit` DESC [ RunTime:0.016444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170729 LIMIT 2 [ RunTime:0.022306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170729 ORDER BY `minOrder` ASC [ RunTime:0.022840s ]
select * from pdf where partno='1.5SMC12A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.011363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.022517s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170729 AND `partno` = '1.5SMC12A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.028227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803174 [ RunTime:0.004794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42273687 LIMIT 5 [ RunTime:0.009765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273687 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42273687 ORDER BY `unit` DESC [ RunTime:0.017871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42273687 LIMIT 2 [ RunTime:0.005701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273687 ORDER BY `minOrder` ASC [ RunTime:0.008745s ]
select * from pdf where partno='1.5SMC12AT3' and brandshort='onsemi' limit 1 [ RunTime:0.014044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12AT3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.004211s ]
SELECT `id` FROM `stock` WHERE `id` <> 42273687 AND `partno` = '1.5SMC12AT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.009275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918392 [ RunTime:0.011138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42271604 LIMIT 5 [ RunTime:0.011651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271604 ORDER BY `minOrder` ASC [ RunTime:0.002935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42271604 ORDER BY `unit` DESC [ RunTime:0.006665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42271604 LIMIT 2 [ RunTime:0.006415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271604 ORDER BY `minOrder` ASC [ RunTime:0.007813s ]
select * from pdf where partno='1.5SMC12AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019416s ]
SELECT `id` FROM `stock` WHERE `id` <> 42271604 AND `partno` = '1.5SMC12AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815406 [ RunTime:0.009873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267049 LIMIT 5 [ RunTime:0.001817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267049 ORDER BY `minOrder` ASC [ RunTime:0.016675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267049 ORDER BY `unit` DESC [ RunTime:0.003292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267049 LIMIT 2 [ RunTime:0.027417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267049 ORDER BY `minOrder` ASC [ RunTime:0.007464s ]
select * from pdf where partno='1.5SMC12AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007439s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267049 AND `partno` = '1.5SMC12AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815386 [ RunTime:0.026138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263611 LIMIT 5 [ RunTime:0.019636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263611 ORDER BY `minOrder` ASC [ RunTime:0.009768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263611 ORDER BY `unit` DESC [ RunTime:0.014110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263611 LIMIT 2 [ RunTime:0.018669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263611 ORDER BY `minOrder` ASC [ RunTime:0.009576s ]
select * from pdf where partno='1.5SMC12AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009624s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263611 AND `partno` = '1.5SMC12AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918165 [ RunTime:0.002549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263380 LIMIT 5 [ RunTime:0.016770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263380 ORDER BY `minOrder` ASC [ RunTime:0.017835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263380 ORDER BY `unit` DESC [ RunTime:0.013351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263380 LIMIT 2 [ RunTime:0.017380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263380 ORDER BY `minOrder` ASC [ RunTime:0.005005s ]
select * from pdf where partno='1.5SMC12A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.023680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004737s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263380 AND `partno` = '1.5SMC12A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.004445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673785 [ RunTime:0.003830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262197 LIMIT 5 [ RunTime:0.015600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262197 ORDER BY `minOrder` ASC [ RunTime:0.013591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262197 ORDER BY `unit` DESC [ RunTime:0.026103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262197 LIMIT 2 [ RunTime:0.017276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262197 ORDER BY `minOrder` ASC [ RunTime:0.006079s ]
select * from pdf where partno='1.5SMC12A TR13 PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.002558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A TR13 PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.009527s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262197 AND `partno` = '1.5SMC12A TR13 PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.025314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674684 [ RunTime:0.050601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42261706 LIMIT 5 [ RunTime:0.001297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261706 ORDER BY `minOrder` ASC [ RunTime:0.006250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42261706 ORDER BY `unit` DESC [ RunTime:0.006874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42261706 LIMIT 2 [ RunTime:0.003998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261706 ORDER BY `minOrder` ASC [ RunTime:0.013414s ]
select * from pdf where partno='1.5SMC12AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008612s ]
SELECT `id` FROM `stock` WHERE `id` <> 42261706 AND `partno` = '1.5SMC12AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918103 [ RunTime:0.008529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257529 LIMIT 5 [ RunTime:0.019415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257529 ORDER BY `minOrder` ASC [ RunTime:0.055556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257529 ORDER BY `unit` DESC [ RunTime:0.013243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257529 LIMIT 2 [ RunTime:0.018782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257529 ORDER BY `minOrder` ASC [ RunTime:0.019659s ]
select * from pdf where partno='1.5SMC12A-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-M3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016214s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257529 AND `partno` = '1.5SMC12A-M3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815286 [ RunTime:0.007847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246599 LIMIT 5 [ RunTime:0.002669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246599 ORDER BY `minOrder` ASC [ RunTime:0.010549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246599 ORDER BY `unit` DESC [ RunTime:0.006280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246599 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246599 ORDER BY `minOrder` ASC [ RunTime:0.001720s ]
select * from pdf where partno='1.5SMC12A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.010267s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246599 AND `partno` = '1.5SMC12A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.017018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916636 [ RunTime:0.010619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246109 LIMIT 5 [ RunTime:0.005846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246109 ORDER BY `minOrder` ASC [ RunTime:0.000983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246109 ORDER BY `unit` DESC [ RunTime:0.003284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246109 LIMIT 2 [ RunTime:0.008241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246109 ORDER BY `minOrder` ASC [ RunTime:0.016962s ]
select * from pdf where partno='1.5SMC12AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.010070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.010433s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246109 AND `partno` = '1.5SMC12AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.016393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673680 [ RunTime:0.020542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245921 LIMIT 5 [ RunTime:0.007685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245921 ORDER BY `minOrder` ASC [ RunTime:0.021993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245921 ORDER BY `unit` DESC [ RunTime:0.034464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245921 LIMIT 2 [ RunTime:0.039821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245921 ORDER BY `minOrder` ASC [ RunTime:0.039487s ]
select * from pdf where partno='1.5SMC12A-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.028490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-E3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.050591s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245921 AND `partno` = '1.5SMC12A-E3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.057933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673289 [ RunTime:0.063099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245364 LIMIT 5 [ RunTime:0.036948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245364 ORDER BY `minOrder` ASC [ RunTime:0.123212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245364 ORDER BY `unit` DESC [ RunTime:0.081094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245364 LIMIT 2 [ RunTime:0.019516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245364 ORDER BY `minOrder` ASC [ RunTime:0.060072s ]
select * from pdf where partno='1.5SMC12A-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.072309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-M3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.044992s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245364 AND `partno` = '1.5SMC12A-M3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.067804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674613 [ RunTime:0.098226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227752 LIMIT 5 [ RunTime:0.062290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227752 ORDER BY `minOrder` ASC [ RunTime:0.017248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227752 ORDER BY `unit` DESC [ RunTime:0.021468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227752 LIMIT 2 [ RunTime:0.029885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227752 ORDER BY `minOrder` ASC [ RunTime:0.076656s ]
select * from pdf where partno='1.5SMC12A-AT/7' and brandshort='YAGEO' limit 1 [ RunTime:0.031561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-AT/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.059008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227143 LIMIT 5 [ RunTime:0.017338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227143 ORDER BY `minOrder` ASC [ RunTime:0.024247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227143 ORDER BY `unit` DESC [ RunTime:0.026495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227143 LIMIT 2 [ RunTime:0.020309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227143 ORDER BY `minOrder` ASC [ RunTime:0.015958s ]
select * from pdf where partno='1.5SMC12A-AT/13' and brandshort='YAGEO' limit 1 [ RunTime:0.056951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC12A-AT/13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.017145s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038696s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052244s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007894s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054143s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028445s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035646s ]
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 '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068111s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5SMC12A%' OR `brand` LIKE '1.5SMC12A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.058165s ]