SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001101s ]
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.0&search=1' [ RunTime:0.003393s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002153s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.017716s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003565s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003504s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002240s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012404s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002073s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ7.0' LIMIT 1 [ RunTime:0.040160s ]
UPDATE `stock_search` SET `count` = 16 , `updatetime` = '2026-08-24 04:05:38' WHERE `partno` = 'SMAJ7.0' [ RunTime:0.050841s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001349s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.136198s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.049530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801867 LIMIT 5 [ RunTime:0.021173s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801867 ORDER BY `minOrder` ASC [ RunTime:0.040633s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.029521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801867 ORDER BY `unit` DESC [ RunTime:0.040273s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.066704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801867 LIMIT 2 [ RunTime:0.034484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801867 ORDER BY `minOrder` ASC [ RunTime:0.018366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802229 LIMIT 5 [ RunTime:0.057756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802229 ORDER BY `minOrder` ASC [ RunTime:0.188368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802229 ORDER BY `unit` DESC [ RunTime:0.163375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802229 LIMIT 2 [ RunTime:0.100079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802229 ORDER BY `minOrder` ASC [ RunTime:0.055869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802230 LIMIT 5 [ RunTime:0.042570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802230 ORDER BY `minOrder` ASC [ RunTime:0.109368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802230 ORDER BY `unit` DESC [ RunTime:0.112256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802230 LIMIT 2 [ RunTime:0.056608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802230 ORDER BY `minOrder` ASC [ RunTime:0.022311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802618 LIMIT 5 [ RunTime:0.055095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802618 ORDER BY `minOrder` ASC [ RunTime:0.059910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802618 ORDER BY `unit` DESC [ RunTime:0.127356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802618 LIMIT 2 [ RunTime:0.027494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802618 ORDER BY `minOrder` ASC [ RunTime:0.004549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807397 LIMIT 5 [ RunTime:0.035675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807397 ORDER BY `minOrder` ASC [ RunTime:0.016648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807397 ORDER BY `unit` DESC [ RunTime:0.012420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807397 LIMIT 2 [ RunTime:0.010426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807397 ORDER BY `minOrder` ASC [ RunTime:0.007879s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.014124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825935 LIMIT 5 [ RunTime:0.021496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825935 ORDER BY `minOrder` ASC [ RunTime:0.027565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825935 ORDER BY `unit` DESC [ RunTime:0.027877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825935 LIMIT 2 [ RunTime:0.005548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825935 ORDER BY `minOrder` ASC [ RunTime:0.026440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662186 LIMIT 5 [ RunTime:0.027246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662186 ORDER BY `minOrder` ASC [ RunTime:0.007773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662186 ORDER BY `unit` DESC [ RunTime:0.008809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662186 LIMIT 2 [ RunTime:0.011803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662186 ORDER BY `minOrder` ASC [ RunTime:0.005338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799622 LIMIT 5 [ RunTime:0.013470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799622 ORDER BY `minOrder` ASC [ RunTime:0.022129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799622 ORDER BY `unit` DESC [ RunTime:0.019564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799622 LIMIT 2 [ RunTime:0.030113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799622 ORDER BY `minOrder` ASC [ RunTime:0.003754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679228 LIMIT 5 [ RunTime:0.006299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679228 ORDER BY `minOrder` ASC [ RunTime:0.008485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679228 ORDER BY `unit` DESC [ RunTime:0.015737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679228 LIMIT 2 [ RunTime:0.005040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679228 ORDER BY `minOrder` ASC [ RunTime:0.010029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684240 LIMIT 5 [ RunTime:0.013468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684240 ORDER BY `minOrder` ASC [ RunTime:0.010417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684240 ORDER BY `unit` DESC [ RunTime:0.020504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684240 LIMIT 2 [ RunTime:0.020789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684240 ORDER BY `minOrder` ASC [ RunTime:0.006396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661554 LIMIT 5 [ RunTime:0.035823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661554 ORDER BY `minOrder` ASC [ RunTime:0.016133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661554 ORDER BY `unit` DESC [ RunTime:0.021131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661554 LIMIT 2 [ RunTime:0.017067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661554 ORDER BY `minOrder` ASC [ RunTime:0.003763s ]
select * from pdf where partno='SMAJ7.0A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.026056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665025 LIMIT 5 [ RunTime:0.027957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665025 ORDER BY `minOrder` ASC [ RunTime:0.031525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665025 ORDER BY `unit` DESC [ RunTime:0.074056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665025 LIMIT 2 [ RunTime:0.013000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665025 ORDER BY `minOrder` ASC [ RunTime:0.020830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662184 LIMIT 5 [ RunTime:0.024468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662184 ORDER BY `minOrder` ASC [ RunTime:0.054477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662184 ORDER BY `unit` DESC [ RunTime:0.050950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662184 LIMIT 2 [ RunTime:0.089264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662184 ORDER BY `minOrder` ASC [ RunTime:0.010694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918274 LIMIT 5 [ RunTime:0.017408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918274 ORDER BY `minOrder` ASC [ RunTime:0.019738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918274 ORDER BY `unit` DESC [ RunTime:0.021229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918274 LIMIT 2 [ RunTime:0.039815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918274 ORDER BY `minOrder` ASC [ RunTime:0.017172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825199 LIMIT 5 [ RunTime:0.037869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825199 ORDER BY `minOrder` ASC [ RunTime:0.023690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825199 ORDER BY `unit` DESC [ RunTime:0.009372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825199 LIMIT 2 [ RunTime:0.056193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825199 ORDER BY `minOrder` ASC [ RunTime:0.007971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690746 LIMIT 5 [ RunTime:0.036420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690746 ORDER BY `minOrder` ASC [ RunTime:0.045450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690746 ORDER BY `unit` DESC [ RunTime:0.101125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690746 LIMIT 2 [ RunTime:0.028294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690746 ORDER BY `minOrder` ASC [ RunTime:0.005769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661530 LIMIT 5 [ RunTime:0.009744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661530 ORDER BY `minOrder` ASC [ RunTime:0.084157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661530 ORDER BY `unit` DESC [ RunTime:0.043247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661530 LIMIT 2 [ RunTime:0.022205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661530 ORDER BY `minOrder` ASC [ RunTime:0.025614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905691 LIMIT 5 [ RunTime:0.014890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905691 ORDER BY `minOrder` ASC [ RunTime:0.026146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905691 ORDER BY `unit` DESC [ RunTime:0.057513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905691 LIMIT 2 [ RunTime:0.042666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905691 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662366 LIMIT 5 [ RunTime:0.033174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662366 ORDER BY `minOrder` ASC [ RunTime:0.030765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662366 ORDER BY `unit` DESC [ RunTime:0.008726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662366 LIMIT 2 [ RunTime:0.013016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662366 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907443 LIMIT 5 [ RunTime:0.012314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907443 ORDER BY `minOrder` ASC [ RunTime:0.042857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907443 ORDER BY `unit` DESC [ RunTime:0.035780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907443 LIMIT 2 [ RunTime:0.024579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907443 ORDER BY `minOrder` ASC [ RunTime:0.023996s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021305s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160982 LIMIT 5 [ RunTime:0.029206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160982 ORDER BY `minOrder` ASC [ RunTime:0.044254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160982 ORDER BY `unit` DESC [ RunTime:0.024618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160982 LIMIT 2 [ RunTime:0.022808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160982 ORDER BY `minOrder` ASC [ RunTime:0.022391s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='MDD' limit 1 [ RunTime:0.061768s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.038527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42095153 LIMIT 5 [ RunTime:0.017766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095153 ORDER BY `minOrder` ASC [ RunTime:0.056223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42095153 ORDER BY `unit` DESC [ RunTime:0.017600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42095153 LIMIT 2 [ RunTime:0.035370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095153 ORDER BY `minOrder` ASC [ RunTime:0.002494s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.026597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099342 LIMIT 5 [ RunTime:0.064560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099342 ORDER BY `minOrder` ASC [ RunTime:0.017544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099342 ORDER BY `unit` DESC [ RunTime:0.007937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099342 LIMIT 2 [ RunTime:0.021070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099342 ORDER BY `minOrder` ASC [ RunTime:0.023370s ]
select * from pdf where partno='SMAJ7.0A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.013004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.043756s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099342 AND `partno` = 'SMAJ7.0A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.059927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802230 [ RunTime:0.030073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099731 LIMIT 5 [ RunTime:0.017181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099731 ORDER BY `minOrder` ASC [ RunTime:0.016795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099731 ORDER BY `unit` DESC [ RunTime:0.030519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099731 LIMIT 2 [ RunTime:0.042029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099731 ORDER BY `minOrder` ASC [ RunTime:0.012562s ]
select * from pdf where partno='SMAJ7.0CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.040206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.014008s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099731 AND `partno` = 'SMAJ7.0CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.022225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802229 [ RunTime:0.016951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147856 LIMIT 5 [ RunTime:0.022464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147856 ORDER BY `minOrder` ASC [ RunTime:0.034081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147856 ORDER BY `unit` DESC [ RunTime:0.047185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147856 LIMIT 2 [ RunTime:0.017405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147856 ORDER BY `minOrder` ASC [ RunTime:0.017675s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.040105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.021814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42100153 LIMIT 5 [ RunTime:0.020044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100153 ORDER BY `minOrder` ASC [ RunTime:0.022799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42100153 ORDER BY `unit` DESC [ RunTime:0.054541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42100153 LIMIT 2 [ RunTime:0.069431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100153 ORDER BY `minOrder` ASC [ RunTime:0.013880s ]
select * from pdf where partno='SMAJ7.0A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.040552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099374 LIMIT 5 [ RunTime:0.022963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099374 ORDER BY `minOrder` ASC [ RunTime:0.036867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099374 ORDER BY `unit` DESC [ RunTime:0.039827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099374 LIMIT 2 [ RunTime:0.031783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099374 ORDER BY `minOrder` ASC [ RunTime:0.011970s ]
select * from pdf where partno='SMAJ7.0A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.009577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42110658 LIMIT 5 [ RunTime:0.031859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110658 ORDER BY `minOrder` ASC [ RunTime:0.006388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42110658 ORDER BY `unit` DESC [ RunTime:0.010594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42110658 LIMIT 2 [ RunTime:0.012130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110658 ORDER BY `minOrder` ASC [ RunTime:0.017133s ]
select * from pdf where partno='SMAJ7.0CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.025772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.020693s ]
SELECT `id` FROM `stock` WHERE `id` <> 42110658 AND `partno` = 'SMAJ7.0CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.010184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661530 [ RunTime:0.015226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149133 LIMIT 5 [ RunTime:0.008576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149133 ORDER BY `minOrder` ASC [ RunTime:0.023109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149133 ORDER BY `unit` DESC [ RunTime:0.008960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149133 LIMIT 2 [ RunTime:0.016639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149133 ORDER BY `minOrder` ASC [ RunTime:0.011034s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.015677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.018503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112930 LIMIT 5 [ RunTime:0.008151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112930 ORDER BY `minOrder` ASC [ RunTime:0.012276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112930 ORDER BY `unit` DESC [ RunTime:0.026712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112930 LIMIT 2 [ RunTime:0.000992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112930 ORDER BY `minOrder` ASC [ RunTime:0.002637s ]
select * from pdf where partno='SMAJ7.0CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.025828s ]
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.009133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825935 [ RunTime:0.000925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146477 LIMIT 5 [ RunTime:0.030218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146477 ORDER BY `minOrder` ASC [ RunTime:0.011565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146477 ORDER BY `unit` DESC [ RunTime:0.004145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146477 LIMIT 2 [ RunTime:0.013402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146477 ORDER BY `minOrder` ASC [ RunTime:0.008038s ]
select * from pdf where partno='SMAJ7.0A' and brandshort='MDD' limit 1 [ RunTime:0.008335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0A' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.008851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122926 LIMIT 5 [ RunTime:0.004935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122926 ORDER BY `minOrder` ASC [ RunTime:0.031216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122926 ORDER BY `unit` DESC [ RunTime:0.020423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122926 LIMIT 2 [ RunTime:0.007603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122926 ORDER BY `minOrder` ASC [ RunTime:0.011570s ]
select * from pdf where partno='SMAJ7.0A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.012520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123946 LIMIT 5 [ RunTime:0.001082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123946 ORDER BY `minOrder` ASC [ RunTime:0.011909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123946 ORDER BY `unit` DESC [ RunTime:0.020320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123946 LIMIT 2 [ RunTime:0.013497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123946 ORDER BY `minOrder` ASC [ RunTime:0.013915s ]
select * from pdf where partno='SMAJ7.0CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.011412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.027676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101509 LIMIT 5 [ RunTime:0.094744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101509 ORDER BY `minOrder` ASC [ RunTime:0.038232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101509 ORDER BY `unit` DESC [ RunTime:0.096081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101509 LIMIT 2 [ RunTime:0.020986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101509 ORDER BY `minOrder` ASC [ RunTime:0.009916s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.031422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.037966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114284 LIMIT 5 [ RunTime:0.037682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114284 ORDER BY `minOrder` ASC [ RunTime:0.070659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114284 ORDER BY `unit` DESC [ RunTime:0.030371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114284 LIMIT 2 [ RunTime:0.007906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114284 ORDER BY `minOrder` ASC [ RunTime:0.006509s ]
select * from pdf where partno='SMAJ7.0CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.005131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.015077s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114284 AND `partno` = 'SMAJ7.0CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.024329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679228 [ RunTime:0.025695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124465 LIMIT 5 [ RunTime:0.015992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124465 ORDER BY `minOrder` ASC [ RunTime:0.020948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124465 ORDER BY `unit` DESC [ RunTime:0.021825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124465 LIMIT 2 [ RunTime:0.006380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124465 ORDER BY `minOrder` ASC [ RunTime:0.013222s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.014979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.007384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42129504 LIMIT 5 [ RunTime:0.019481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129504 ORDER BY `minOrder` ASC [ RunTime:0.019424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42129504 ORDER BY `unit` DESC [ RunTime:0.018548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42129504 LIMIT 2 [ RunTime:0.022317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129504 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
select * from pdf where partno='SMAJ7.0AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.010735s ]
SELECT `id` FROM `stock` WHERE `id` <> 42129504 AND `partno` = 'SMAJ7.0AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690746 [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159931 LIMIT 5 [ RunTime:0.015896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159931 ORDER BY `minOrder` ASC [ RunTime:0.024676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159931 ORDER BY `unit` DESC [ RunTime:0.028358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159931 LIMIT 2 [ RunTime:0.012277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159931 ORDER BY `minOrder` ASC [ RunTime:0.016707s ]
select * from pdf where partno='SMAJ7.0A' and brandshort='HY Electronic Cayman Limited' limit 1 [ RunTime:0.008358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0A' OR `brand` LIKE 'HY Electronic (Cayman) Limited%' ) ) LIMIT 1 [ RunTime:0.047526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159930 LIMIT 5 [ RunTime:0.023096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159930 ORDER BY `minOrder` ASC [ RunTime:0.010397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159930 ORDER BY `unit` DESC [ RunTime:0.014916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159930 LIMIT 2 [ RunTime:0.014432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159930 ORDER BY `minOrder` ASC [ RunTime:0.012422s ]
select * from pdf where partno='SMAJ7.0CA' and brandshort='HY Electronic Cayman Limited' limit 1 [ RunTime:0.030867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0CA' OR `brand` LIKE 'HY Electronic (Cayman) Limited%' ) ) LIMIT 1 [ RunTime:0.044046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124431 LIMIT 5 [ RunTime:0.008182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124431 ORDER BY `minOrder` ASC [ RunTime:0.029701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124431 ORDER BY `unit` DESC [ RunTime:0.016258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124431 LIMIT 2 [ RunTime:0.034623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124431 ORDER BY `minOrder` ASC [ RunTime:0.016441s ]
select * from pdf where partno='SMAJ7.0A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.021365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ7.0A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.015586s ]
SELECT `id` FROM `stock` WHERE `id` <> 42124431 AND `partno` = 'SMAJ7.0A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.034680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825199 [ RunTime:0.044979s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012763s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014794s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008700s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035246s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018154s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049856s ]
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.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026350s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ7.0%' OR `brand` LIKE 'SMAJ7.0%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030913s ]