1N4735A，型号信息 PDF中文资料市场行情现货热卖优势库存

请登录

免费注册

首页购物车我的订单会员中心

联系客服

823711899

点击QQ咨询

400-618-9990

拨打电话咨询

购物车 0

上传BOM

产品分类

找货询价

QQ咨询

会员中心

购物车

技术支持

售后咨询

类目：

全部二极管

展开

收起

品牌：

全部 Central Semiconductor Corp (3) Diodes Incorporated (1) Fairchild Semiconductor (1) Lumimax Optoelectronic Technology (1) MCC (Micro Commercial Components) (1) Microchip Technology (3) Microsemi Corporation (1) Nexperia USA Inc. (2) ONSEMI (7) Renesas Electronics Corporation (1) SMC Diode Solutions (1) Vishay General Semiconductor - Diodes Division (2)

展开

收起

型号/品牌/封装参数价格阶梯(含税) 库存交期数量操作

Total:2412 下页

总24条记录，每页20条，共2页。

购物指南

支付方式

配送服务

售后服务

发票须知

优惠券使用规则

代理产品

代理品牌

代理器件

特色服务

PCBA制造

国产品牌推荐

国产料号替代

质量保证

技术资料

行业资讯

关于我们

关于壹壹捌

联系我们

服务热线：400-618-9990

企业邮箱：sales@ic118.com

服务时间：周一至周六 8:30-17:30

壹壹捌官方微信号

PDF索引：

IC型号索引：

深圳网络警察报警平台

公共信息安全网络监察

经营性网站备案信息

不良信息举报中心

工商网监电子标识

全国公安机关备案

基本文件流程错误 SQL 调试用户

/www/wwwroot/www.ic72.com/public/index.php ( 0.79 KB )
/www/wwwroot/www.ic72.com/vendor/autoload.php ( 0.73 KB )
/www/wwwroot/www.ic72.com/vendor/composer/autoload_real.php ( 1.63 KB )
/www/wwwroot/www.ic72.com/vendor/composer/platform_check.php ( 1.01 KB )
/www/wwwroot/www.ic72.com/vendor/composer/ClassLoader.php ( 15.99 KB )
/www/wwwroot/www.ic72.com/vendor/composer/autoload_static.php ( 12.68 KB )
/www/wwwroot/www.ic72.com/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/wwwroot/www.ic72.com/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
/www/wwwroot/www.ic72.com/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/wwwroot/www.ic72.com/vendor/guzzlehttp/guzzle/src/functions.php ( 5.55 KB )
/www/wwwroot/www.ic72.com/vendor/adbario/php-dot-notation/src/helpers.php ( 0.57 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/www/wwwroot/www.ic72.com/vendor/yansongda/supports/src/Functions.php ( 1.53 KB )
/www/wwwroot/www.ic72.com/vendor/hyperf/engine/src/Functions.php ( 0.83 KB )
/www/wwwroot/www.ic72.com/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
/www/wwwroot/www.ic72.com/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.77 KB )
/www/wwwroot/www.ic72.com/vendor/yansongda/artful/src/Functions.php ( 2.38 KB )
/www/wwwroot/www.ic72.com/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php ( 0.72 KB )
/www/wwwroot/www.ic72.com/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.49 KB )
/www/wwwroot/www.ic72.com/vendor/yansongda/pay/src/Functions.php ( 19.32 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/App.php ( 14.29 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Container.php ( 15.39 KB )
/www/wwwroot/www.ic72.com/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
/www/wwwroot/www.ic72.com/app/provider.php ( 0.19 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Http.php ( 6.04 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Env.php ( 4.52 KB )
/www/wwwroot/www.ic72.com/app/common.php ( 107.36 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/helper.php ( 18.47 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Config.php ( 4.62 KB )
/www/wwwroot/www.ic72.com/config/api.php ( 0.59 KB )
/www/wwwroot/www.ic72.com/config/app.php ( 2.86 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/www/wwwroot/www.ic72.com/config/cache.php ( 1.07 KB )
/www/wwwroot/www.ic72.com/config/console.php ( 0.37 KB )
/www/wwwroot/www.ic72.com/config/cookie.php ( 2.06 KB )
/www/wwwroot/www.ic72.com/config/database.php ( 5.02 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
/www/wwwroot/www.ic72.com/config/email.php ( 2.34 KB )
/www/wwwroot/www.ic72.com/config/filesystem.php ( 0.68 KB )
/www/wwwroot/www.ic72.com/config/lang.php ( 0.82 KB )
/www/wwwroot/www.ic72.com/config/log.php ( 1.35 KB )
/www/wwwroot/www.ic72.com/config/middleware.php ( 0.19 KB )
/www/wwwroot/www.ic72.com/config/payment.php ( 0.00 KB )
/www/wwwroot/www.ic72.com/config/route.php ( 1.54 KB )
/www/wwwroot/www.ic72.com/config/session.php ( 0.70 KB )
/www/wwwroot/www.ic72.com/config/trace.php ( 0.58 KB )
/www/wwwroot/www.ic72.com/config/view.php ( 0.96 KB )
/www/wwwroot/www.ic72.com/app/event.php ( 0.26 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Event.php ( 6.97 KB )
/www/wwwroot/www.ic72.com/app/service.php ( 0.13 KB )
/www/wwwroot/www.ic72.com/app/AppService.php ( 0.44 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Lang.php ( 7.22 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/lang/zh-cn.php ( 13.27 KB )
/www/wwwroot/www.ic72.com/app/lang/zh-cn.php ( 0.08 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/initializer/Error.php ( 3.27 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/www/wwwroot/www.ic72.com/vendor/services.php ( 0.17 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/service/ModelService.php ( 1.75 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-multi-app/src/Service.php ( 1.08 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Middleware.php ( 6.65 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/Paginator.php ( 11.71 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Validate.php ( 46.61 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/Model.php ( 26.86 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 19.12 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.44 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.58 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.69 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/model/concern/AutoWriteId.php ( 1.44 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.85 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/DbManager.php ( 8.33 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Log.php ( 6.27 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
/www/wwwroot/www.ic72.com/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
/www/wwwroot/www.ic72.com/vendor/psr/log/src/LoggerInterface.php ( 2.68 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Cache.php ( 4.91 KB )
/www/wwwroot/www.ic72.com/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-helper/src/helper/Arr.php ( 16.08 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.60 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/cache/Driver.php ( 8.17 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Console.php ( 22.64 KB )
/www/wwwroot/www.ic72.com/app/Request.php ( 0.09 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Request.php ( 54.27 KB )
/www/wwwroot/www.ic72.com/app/middleware.php ( 0.32 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/www/wwwroot/www.ic72.com/app/middleware/AccessLog.php ( 2.59 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.06 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Route.php ( 23.25 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/RuleName.php ( 5.31 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/Domain.php ( 5.53 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.56 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/Rule.php ( 23.18 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.19 KB )
/www/wwwroot/www.ic72.com/route/app.php ( 0.77 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/facade/Route.php ( 4.68 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/dispatch/Url.php ( 3.42 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 6.61 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.07 KB )
/www/wwwroot/www.ic72.com/app/controller/Stock.php ( 67.97 KB )
/www/wwwroot/www.ic72.com/app/controller/Api.php ( 13.19 KB )
/www/wwwroot/www.ic72.com/app/BaseController.php ( 2.04 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.33 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/PDOConnection.php ( 51.60 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/Connection.php ( 8.79 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.86 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.56 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/Builder.php ( 22.26 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.29 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/Query.php ( 15.19 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/BaseQuery.php ( 41.48 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 19.29 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.98 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 18.79 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.96 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.46 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/log/Channel.php ( 3.88 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/facade/Cookie.php ( 1.48 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Cookie.php ( 5.97 KB )
/www/wwwroot/www.ic72.com/app/model/Type.php ( 0.45 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/model/Collection.php ( 6.96 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-helper/src/Collection.php ( 16.48 KB )
/www/wwwroot/www.ic72.com/app/model/Cart.php ( 15.85 KB )
/www/wwwroot/www.ic72.com/app/model/Api.php ( 11.18 KB )
/www/wwwroot/www.ic72.com/app/controller/Index.php ( 24.67 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/facade/View.php ( 1.70 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/View.php ( 4.33 KB )
/www/wwwroot/www.ic72.com/app/model/Stock.php ( 64.65 KB )
/www/wwwroot/www.ic72.com/app/model/StockPra.php ( 0.78 KB )
/www/wwwroot/www.ic72.com/app/model/StockPrice.php ( 1.52 KB )
/www/wwwroot/www.ic72.com/app/model/StockUnit.php ( 0.78 KB )
/www/wwwroot/www.ic72.com/app/model/StockWarehouse.php ( 0.91 KB )
/www/wwwroot/www.ic72.com/app/model/Pdf.php ( 3.09 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/Raw.php ( 1.22 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/Fetch.php ( 13.25 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-view/src/Think.php ( 8.00 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
/www/wwwroot/www.ic72.com/runtime/temp/3c590b8e614ad0fff63aef5fa8c8410e.php ( 77.09 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/Response.php ( 8.65 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/framework/src/think/response/Html.php ( 0.97 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-trace/src/Html.php ( 4.49 KB )

CONNECT:[ UseTime:0.000783s ] mysql:host=127.0.0.1;port=3306;dbname=ic72com;charset=utf8
SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002444s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=1N4735A' [ RunTime:0.001930s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001909s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000506s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002414s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002334s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000366s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003569s ]
SELECT * FROM `stock_search` WHERE `partno` = '1N4735A' LIMIT 1 [ RunTime:0.000589s ]
UPDATE `stock_search` SET `count` = 17715 , `updatetime` = '2026-06-13 06:00:29' WHERE `partno` = '1N4735A' [ RunTime:0.002690s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002046s ]
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 '1N4735A%' OR `brand` LIKE '1N4735A%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003380s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39996052 LIMIT 4 [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39996052 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39996052 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39996052 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39996052 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
CONNECT:[ UseTime:0.000647s ] mysql:host=127.0.0.1;port=3306;dbname=ic72com_pdf;charset=utf8
select * from pdf where partno='1N4735A-TR' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A-TR' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000446s ]
SELECT `id` FROM `stock` WHERE `id` <> 39996052 AND `partno` = '1N4735A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40013037 LIMIT 4 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40013037 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40013037 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40013037 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40013037 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='1N4735A-T50A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.000499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A-T50A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000359s ]
SELECT `id` FROM `stock` WHERE `id` <> 40013037 AND `partno` = '1N4735A-T50A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39999572 LIMIT 4 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39999572 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39999572 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39999572 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39999572 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='1N4735A-TAP' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A-TAP' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000309s ]
SELECT `id` FROM `stock` WHERE `id` <> 39999572 AND `partno` = '1N4735A-TAP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39199978 LIMIT 4 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39199978 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39199978 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39199978 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39199978 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='1N4735A' and brandshort='onsemi' limit 1 [ RunTime:0.000477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.000343s ]
SELECT `id` FROM `stock` WHERE `id` <> 39199978 AND `partno` = '1N4735A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7402 [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40011662 LIMIT 4 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40011662 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40011662 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40011662 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40011662 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
select * from pdf where partno='1N4735AT9-E' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.000481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735AT9-E' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.000297s ]
SELECT `id` FROM `stock` WHERE `id` <> 40011662 AND `partno` = '1N4735AT9-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39997534 LIMIT 4 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39997534 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39997534 ORDER BY `unit` DESC [ RunTime:0.000246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39997534 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39997534 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='1N4735A-T50A' and brandshort='onsemi' limit 1 [ RunTime:0.000436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A-T50A' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.000252s ]
SELECT `id` FROM `stock` WHERE `id` <> 39997534 AND `partno` = '1N4735A-T50A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40004046 LIMIT 4 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40004046 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40004046 ORDER BY `unit` DESC [ RunTime:0.000184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40004046 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40004046 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
select * from pdf where partno='1N4735A,133' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.000663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A,133' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000240s ]
SELECT `id` FROM `stock` WHERE `id` <> 40004046 AND `partno` = '1N4735A,133' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.000236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40010750 LIMIT 4 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40010750 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40010750 ORDER BY `unit` DESC [ RunTime:0.000248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40010750 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40010750 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
select * from pdf where partno='1N4735A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000228s ]
SELECT `id` FROM `stock` WHERE `id` <> 40010750 AND `partno` = '1N4735A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40006667 LIMIT 4 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40006667 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40006667 ORDER BY `unit` DESC [ RunTime:0.000207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40006667 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40006667 ORDER BY `minOrder` ASC [ RunTime:0.000206s ]
select * from pdf where partno='1N4735A' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.000451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.000226s ]
SELECT `id` FROM `stock` WHERE `id` <> 40006667 AND `partno` = '1N4735A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumimax optoelectronic technology%' ) [ RunTime:0.000231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39999139 LIMIT 4 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39999139 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39999139 ORDER BY `unit` DESC [ RunTime:0.000199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39999139 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39999139 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
select * from pdf where partno='1N4735A TR PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A TR PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.000303s ]
SELECT `id` FROM `stock` WHERE `id` <> 39999139 AND `partno` = '1N4735A TR PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.000265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7402 LIMIT 4 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7402 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7402 ORDER BY `unit` DESC [ RunTime:0.000335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7402 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7402 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.007682s ]
SELECT `id` FROM `stock` WHERE `id` <> 7402 AND `partno` = '1N4735A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39199978 [ RunTime:0.000187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40004098 LIMIT 4 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40004098 ORDER BY `minOrder` ASC [ RunTime:0.000175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40004098 ORDER BY `unit` DESC [ RunTime:0.000179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40004098 LIMIT 2 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40004098 ORDER BY `minOrder` ASC [ RunTime:0.000167s ]
select * from pdf where partno='1N4735A,113' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.000449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A,113' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000222s ]
SELECT `id` FROM `stock` WHERE `id` <> 40004098 AND `partno` = '1N4735A,113' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40014876 LIMIT 4 [ RunTime:0.000256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40014876 ORDER BY `minOrder` ASC [ RunTime:0.000174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40014876 ORDER BY `unit` DESC [ RunTime:0.000156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40014876 LIMIT 2 [ RunTime:0.000228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40014876 ORDER BY `minOrder` ASC [ RunTime:0.000164s ]
select * from pdf where partno='1N4735ATR' and brandshort='onsemi' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735ATR' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.000203s ]
SELECT `id` FROM `stock` WHERE `id` <> 40014876 AND `partno` = '1N4735ATR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41295048 LIMIT 4 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41295048 ORDER BY `minOrder` ASC [ RunTime:0.000188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41295048 ORDER BY `unit` DESC [ RunTime:0.000158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41295048 LIMIT 2 [ RunTime:0.000232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41295048 ORDER BY `minOrder` ASC [ RunTime:0.000165s ]
select * from pdf where partno='1N4735AG/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.000370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735AG/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000177s ]
SELECT `id` FROM `stock` WHERE `id` <> 41295048 AND `partno` = '1N4735AG/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41294800 LIMIT 4 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41294800 ORDER BY `minOrder` ASC [ RunTime:0.000200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41294800 ORDER BY `unit` DESC [ RunTime:0.000155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41294800 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41294800 ORDER BY `minOrder` ASC [ RunTime:0.000163s ]
select * from pdf where partno='1N4735AUR/TR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.000363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735AUR/TR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000166s ]
SELECT `id` FROM `stock` WHERE `id` <> 41294800 AND `partno` = '1N4735AUR/TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41294243 LIMIT 4 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41294243 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41294243 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41294243 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41294243 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='1N4735AG' and brandshort='Microsemi Corporation' limit 1 [ RunTime:0.000552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735AG' OR `brand` LIKE 'Microsemi Corporation%' ) ) LIMIT 1 [ RunTime:0.000315s ]
SELECT `id` FROM `stock` WHERE `id` <> 41294243 AND `partno` = '1N4735AG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microsemi corporation%' ) [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41294040 LIMIT 4 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41294040 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41294040 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41294040 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41294040 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='1N4735AUR' and brandshort='Microchip Technology' limit 1 [ RunTime:0.000496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735AUR' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.000281s ]
SELECT `id` FROM `stock` WHERE `id` <> 41294040 AND `partno` = '1N4735AUR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41212033 LIMIT 4 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41212033 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41212033 ORDER BY `unit` DESC [ RunTime:0.000219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41212033 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41212033 ORDER BY `minOrder` ASC [ RunTime:0.000201s ]
select * from pdf where partno='1N4735A_S00Z' and brandshort='onsemi' limit 1 [ RunTime:0.000379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A_S00Z' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.000233s ]
SELECT `id` FROM `stock` WHERE `id` <> 41212033 AND `partno` = '1N4735A_S00Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40484360 LIMIT 4 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40484360 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40484360 ORDER BY `unit` DESC [ RunTime:0.000198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40484360 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40484360 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
select * from pdf where partno='1N4735A-T' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A-T' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000224s ]
SELECT `id` FROM `stock` WHERE `id` <> 40484360 AND `partno` = '1N4735A-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40484344 LIMIT 4 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40484344 ORDER BY `minOrder` ASC [ RunTime:0.000185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40484344 ORDER BY `unit` DESC [ RunTime:0.000159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40484344 LIMIT 2 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40484344 ORDER BY `minOrder` ASC [ RunTime:0.000166s ]
select * from pdf where partno='1N4735A BK PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.000265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4735A BK PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.000204s ]
SELECT `id` FROM `stock` WHERE `id` <> 40484344 AND `partno` = '1N4735A BK PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.000218s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1N4735A%' OR `brand` LIKE '1N4735A%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000998s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1N4735A%' OR `brand` LIKE '1N4735A%' ) AND `s`.`status` <> '2' ) LIMIT 24 ) tmp GROUP BY `brand` [ RunTime:0.000912s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1N4735A%' OR `brand` LIKE '1N4735A%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 LIMIT 24 [ RunTime:0.000740s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 21 [ RunTime:0.000165s ]

0.360868s