SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001331s ]
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=SMAJ7.0C&search=1' [ RunTime:0.007190s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002686s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011063s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003282s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003982s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002847s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010927s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002908s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ7.0C' LIMIT 1 [ RunTime:0.008980s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-25 02:58:24' WHERE `partno` = 'SMAJ7.0C' [ RunTime:0.023087s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001786s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024918s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801867 LIMIT 5 [ RunTime:0.025483s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801867 ORDER BY `minOrder` ASC [ RunTime:0.010174s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801867 ORDER BY `unit` DESC [ RunTime:0.006575s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801867 LIMIT 2 [ RunTime:0.030290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801867 ORDER BY `minOrder` ASC [ RunTime:0.017932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802229 LIMIT 5 [ RunTime:0.008273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802229 ORDER BY `minOrder` ASC [ RunTime:0.024937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802229 ORDER BY `unit` DESC [ RunTime:0.014362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802229 LIMIT 2 [ RunTime:0.017005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802229 ORDER BY `minOrder` ASC [ RunTime:0.004544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807397 LIMIT 5 [ RunTime:0.026873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807397 ORDER BY `minOrder` ASC [ RunTime:0.025305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807397 ORDER BY `unit` DESC [ RunTime:0.034852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807397 LIMIT 2 [ RunTime:0.016798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807397 ORDER BY `minOrder` ASC [ RunTime:0.004101s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825935 LIMIT 5 [ RunTime:0.026045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825935 ORDER BY `minOrder` ASC [ RunTime:0.020217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825935 ORDER BY `unit` DESC [ RunTime:0.012521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825935 LIMIT 2 [ RunTime:0.020011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825935 ORDER BY `minOrder` ASC [ RunTime:0.015390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679228 LIMIT 5 [ RunTime:0.016489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679228 ORDER BY `minOrder` ASC [ RunTime:0.010913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679228 ORDER BY `unit` DESC [ RunTime:0.016814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679228 LIMIT 2 [ RunTime:0.014773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679228 ORDER BY `minOrder` ASC [ RunTime:0.024962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684240 LIMIT 5 [ RunTime:0.024271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684240 ORDER BY `minOrder` ASC [ RunTime:0.021554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684240 ORDER BY `unit` DESC [ RunTime:0.024126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684240 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684240 ORDER BY `minOrder` ASC [ RunTime:0.017308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665025 LIMIT 5 [ RunTime:0.021485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665025 ORDER BY `minOrder` ASC [ RunTime:0.023410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665025 ORDER BY `unit` DESC [ RunTime:0.021268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665025 LIMIT 2 [ RunTime:0.050817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665025 ORDER BY `minOrder` ASC [ RunTime:0.010907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662184 LIMIT 5 [ RunTime:0.007293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662184 ORDER BY `minOrder` ASC [ RunTime:0.020181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662184 ORDER BY `unit` DESC [ RunTime:0.007775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662184 LIMIT 2 [ RunTime:0.013347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662184 ORDER BY `minOrder` ASC [ RunTime:0.002070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918274 LIMIT 5 [ RunTime:0.007586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918274 ORDER BY `minOrder` ASC [ RunTime:0.007592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918274 ORDER BY `unit` DESC [ RunTime:0.017270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918274 LIMIT 2 [ RunTime:0.025953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918274 ORDER BY `minOrder` ASC [ RunTime:0.004733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661530 LIMIT 5 [ RunTime:0.007932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661530 ORDER BY `minOrder` ASC [ RunTime:0.011434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661530 ORDER BY `unit` DESC [ RunTime:0.003084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661530 LIMIT 2 [ RunTime:0.024805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661530 ORDER BY `minOrder` ASC [ RunTime:0.013973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662366 LIMIT 5 [ RunTime:0.016801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662366 ORDER BY `minOrder` ASC [ RunTime:0.054909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662366 ORDER BY `unit` DESC [ RunTime:0.026910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662366 LIMIT 2 [ RunTime:0.021636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662366 ORDER BY `minOrder` ASC [ RunTime:0.007748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907443 LIMIT 5 [ RunTime:0.015501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907443 ORDER BY `minOrder` ASC [ RunTime:0.006312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907443 ORDER BY `unit` DESC [ RunTime:0.017768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907443 LIMIT 2 [ RunTime:0.010081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907443 ORDER BY `minOrder` ASC [ RunTime:0.002635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664528 LIMIT 5 [ RunTime:0.006691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664528 ORDER BY `minOrder` ASC [ RunTime:0.005649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664528 ORDER BY `unit` DESC [ RunTime:0.011024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664528 LIMIT 2 [ RunTime:0.003324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664528 ORDER BY `minOrder` ASC [ RunTime:0.002538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079 LIMIT 5 [ RunTime:0.024866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079 ORDER BY `minOrder` ASC [ RunTime:0.013070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079 ORDER BY `unit` DESC [ RunTime:0.008501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079 LIMIT 2 [ RunTime:0.012285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079 ORDER BY `minOrder` ASC [ RunTime:0.003477s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='DIODES' limit 1 [ RunTime:0.006079s ]
select foldpath,foldpath2,filename from pdf_file where id=422494 limit 1 [ RunTime:0.001038s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'DIODES%' ) ) LIMIT 1 [ RunTime:0.017685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691425 LIMIT 5 [ RunTime:0.009391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691425 ORDER BY `minOrder` ASC [ RunTime:0.007050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691425 ORDER BY `unit` DESC [ RunTime:0.019212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691425 LIMIT 2 [ RunTime:0.001960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691425 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670444 LIMIT 5 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670444 ORDER BY `minOrder` ASC [ RunTime:0.011843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670444 ORDER BY `unit` DESC [ RunTime:0.006933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670444 LIMIT 2 [ RunTime:0.004613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670444 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669502 LIMIT 5 [ RunTime:0.003915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669502 ORDER BY `minOrder` ASC [ RunTime:0.002239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669502 ORDER BY `unit` DESC [ RunTime:0.003969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669502 LIMIT 2 [ RunTime:0.006114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669502 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668688 LIMIT 5 [ RunTime:0.003395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668688 ORDER BY `minOrder` ASC [ RunTime:0.008048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668688 ORDER BY `unit` DESC [ RunTime:0.029389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668688 LIMIT 2 [ RunTime:0.016344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668688 ORDER BY `minOrder` ASC [ RunTime:0.016867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668390 LIMIT 5 [ RunTime:0.004957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668390 ORDER BY `minOrder` ASC [ RunTime:0.009529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668390 ORDER BY `unit` DESC [ RunTime:0.020583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668390 LIMIT 2 [ RunTime:0.012771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668390 ORDER BY `minOrder` ASC [ RunTime:0.019518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668388 LIMIT 5 [ RunTime:0.016071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668388 ORDER BY `minOrder` ASC [ RunTime:0.013342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668388 ORDER BY `unit` DESC [ RunTime:0.021706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668388 LIMIT 2 [ RunTime:0.006876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668388 ORDER BY `minOrder` ASC [ RunTime:0.006273s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001371s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160982 LIMIT 5 [ RunTime:0.008478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160982 ORDER BY `minOrder` ASC [ RunTime:0.007609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160982 ORDER BY `unit` DESC [ RunTime:0.005744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160982 LIMIT 2 [ RunTime:0.015678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160982 ORDER BY `minOrder` ASC [ RunTime:0.011417s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='MDD' limit 1 [ RunTime:0.003975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.026595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42095153 LIMIT 5 [ RunTime:0.009040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095153 ORDER BY `minOrder` ASC [ RunTime:0.013499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42095153 ORDER BY `unit` DESC [ RunTime:0.028976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42095153 LIMIT 2 [ RunTime:0.007531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095153 ORDER BY `minOrder` ASC [ RunTime:0.008677s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.022113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099731 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099731 ORDER BY `minOrder` ASC [ RunTime:0.004842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099731 ORDER BY `unit` DESC [ RunTime:0.001377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099731 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099731 ORDER BY `minOrder` ASC [ RunTime:0.003381s ]
select * from pdf where partno='SMAJ7.0CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.005680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.018915s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099731 AND `partno` = 'SMAJ7.0CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.010674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802229 [ RunTime:0.023860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147856 LIMIT 5 [ RunTime:0.017114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147856 ORDER BY `minOrder` ASC [ RunTime:0.009552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147856 ORDER BY `unit` DESC [ RunTime:0.022736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147856 LIMIT 2 [ RunTime:0.028352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147856 ORDER BY `minOrder` ASC [ RunTime:0.007185s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.004333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.002768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42110658 LIMIT 5 [ RunTime:0.001059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110658 ORDER BY `minOrder` ASC [ RunTime:0.001341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42110658 ORDER BY `unit` DESC [ RunTime:0.002507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42110658 LIMIT 2 [ RunTime:0.017803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110658 ORDER BY `minOrder` ASC [ RunTime:0.004043s ]
select * from pdf where partno='SMAJ7.0CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.015251s ]
SELECT `id` FROM `stock` WHERE `id` <> 42110658 AND `partno` = 'SMAJ7.0CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.009647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661530 [ RunTime:0.012578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149133 LIMIT 5 [ RunTime:0.004026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149133 ORDER BY `minOrder` ASC [ RunTime:0.015242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149133 ORDER BY `unit` DESC [ RunTime:0.013045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149133 LIMIT 2 [ RunTime:0.009275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149133 ORDER BY `minOrder` ASC [ RunTime:0.009599s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.009343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112930 LIMIT 5 [ RunTime:0.007665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112930 ORDER BY `minOrder` ASC [ RunTime:0.021589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112930 ORDER BY `unit` DESC [ RunTime:0.035923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112930 LIMIT 2 [ RunTime:0.035065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112930 ORDER BY `minOrder` ASC [ RunTime:0.035556s ]
select * from pdf where partno='SMAJ7.0CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.032236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.025306s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112930 AND `partno` = 'SMAJ7.0CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.022249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825935 [ RunTime:0.071443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123946 LIMIT 5 [ RunTime:0.023579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123946 ORDER BY `minOrder` ASC [ RunTime:0.041245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123946 ORDER BY `unit` DESC [ RunTime:0.032989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123946 LIMIT 2 [ RunTime:0.011494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123946 ORDER BY `minOrder` ASC [ RunTime:0.005103s ]
select * from pdf where partno='SMAJ7.0CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.019912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.045881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101509 LIMIT 5 [ RunTime:0.042621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101509 ORDER BY `minOrder` ASC [ RunTime:0.029505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101509 ORDER BY `unit` DESC [ RunTime:0.011286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101509 LIMIT 2 [ RunTime:0.034696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101509 ORDER BY `minOrder` ASC [ RunTime:0.040857s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.047276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114284 LIMIT 5 [ RunTime:0.032216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114284 ORDER BY `minOrder` ASC [ RunTime:0.040115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114284 ORDER BY `unit` DESC [ RunTime:0.045086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114284 LIMIT 2 [ RunTime:0.010896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114284 ORDER BY `minOrder` ASC [ RunTime:0.011801s ]
select * from pdf where partno='SMAJ7.0CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.027832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.037227s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114284 AND `partno` = 'SMAJ7.0CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.025322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679228 [ RunTime:0.019795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124465 LIMIT 5 [ RunTime:0.018766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124465 ORDER BY `minOrder` ASC [ RunTime:0.024310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124465 ORDER BY `unit` DESC [ RunTime:0.016790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124465 LIMIT 2 [ RunTime:0.018083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124465 ORDER BY `minOrder` ASC [ RunTime:0.025486s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.045376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.027538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159930 LIMIT 5 [ RunTime:0.024912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159930 ORDER BY `minOrder` ASC [ RunTime:0.022167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159930 ORDER BY `unit` DESC [ RunTime:0.012160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159930 LIMIT 2 [ RunTime:0.080942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159930 ORDER BY `minOrder` ASC [ RunTime:0.010782s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='HY Electronic Cayman Limited' limit 1 [ RunTime:0.065826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'HY Electronic (Cayman) Limited%' ) ) LIMIT 1 [ RunTime:0.073201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169740 LIMIT 5 [ RunTime:0.050885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169740 ORDER BY `minOrder` ASC [ RunTime:0.069233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169740 ORDER BY `unit` DESC [ RunTime:0.065017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169740 LIMIT 2 [ RunTime:0.080768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169740 ORDER BY `minOrder` ASC [ RunTime:0.030252s ]
select * from pdf where partno='SMAJ7.0CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.071137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42176634 LIMIT 5 [ RunTime:0.037560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42176634 ORDER BY `minOrder` ASC [ RunTime:0.127088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42176634 ORDER BY `unit` DESC [ RunTime:0.066626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42176634 LIMIT 2 [ RunTime:0.074121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42176634 ORDER BY `minOrder` ASC [ RunTime:0.029967s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.024427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.023114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295391 LIMIT 5 [ RunTime:0.023456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295391 ORDER BY `minOrder` ASC [ RunTime:0.075841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295391 ORDER BY `unit` DESC [ RunTime:0.050188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295391 LIMIT 2 [ RunTime:0.062697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295391 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
select * from pdf where partno='SMAJ7.0CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.073162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.021840s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295391 AND `partno` = 'SMAJ7.0CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.016314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921061 [ RunTime:0.014793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42287968 LIMIT 5 [ RunTime:0.017566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42287968 ORDER BY `minOrder` ASC [ RunTime:0.013850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42287968 ORDER BY `unit` DESC [ RunTime:0.042083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42287968 LIMIT 2 [ RunTime:0.013178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42287968 ORDER BY `minOrder` ASC [ RunTime:0.010381s ]
select * from pdf where partno='SMAJ7.0CAHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.035495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CAHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.059933s ]
SELECT `id` FROM `stock` WHERE `id` <> 42287968 AND `partno` = 'SMAJ7.0CAHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.045724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920249 [ RunTime:0.020044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42238849 LIMIT 5 [ RunTime:0.033377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238849 ORDER BY `minOrder` ASC [ RunTime:0.007607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42238849 ORDER BY `unit` DESC [ RunTime:0.016915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42238849 LIMIT 2 [ RunTime:0.002793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238849 ORDER BY `minOrder` ASC [ RunTime:0.002855s ]
select * from pdf where partno='SMAJ7.0CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.010264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.015517s ]
SELECT `id` FROM `stock` WHERE `id` <> 42238849 AND `partno` = 'SMAJ7.0CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.027850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811617 [ RunTime:0.014667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42238848 LIMIT 5 [ RunTime:0.023508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238848 ORDER BY `minOrder` ASC [ RunTime:0.013252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42238848 ORDER BY `unit` DESC [ RunTime:0.013854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42238848 LIMIT 2 [ RunTime:0.015223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238848 ORDER BY `minOrder` ASC [ RunTime:0.012480s ]
select * from pdf where partno='SMAJ7.0CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.022302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.012661s ]
SELECT `id` FROM `stock` WHERE `id` <> 42238848 AND `partno` = 'SMAJ7.0CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.016246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811616 [ RunTime:0.020204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42233726 LIMIT 5 [ RunTime:0.032146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233726 ORDER BY `minOrder` ASC [ RunTime:0.033235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42233726 ORDER BY `unit` DESC [ RunTime:0.008268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42233726 LIMIT 2 [ RunTime:0.051260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233726 ORDER BY `minOrder` ASC [ RunTime:0.013643s ]
select * from pdf where partno='SMAJ7.0CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.018086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019719s ]
SELECT `id` FROM `stock` WHERE `id` <> 42233726 AND `partno` = 'SMAJ7.0CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.025305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810707 [ RunTime:0.021172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42233725 LIMIT 5 [ RunTime:0.045160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233725 ORDER BY `minOrder` ASC [ RunTime:0.019057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42233725 ORDER BY `unit` DESC [ RunTime:0.039721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42233725 LIMIT 2 [ RunTime:0.020397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42233725 ORDER BY `minOrder` ASC [ RunTime:0.019103s ]
select * from pdf where partno='SMAJ7.0CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.012367s ]
SELECT `id` FROM `stock` WHERE `id` <> 42233725 AND `partno` = 'SMAJ7.0CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670444 [ RunTime:0.015040s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059361s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017356s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037572s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016292s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021769s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042313s ]
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 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042286s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ7.0C%' OR `brand` LIKE 'SMAJ7.0C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.052605s ]