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

请登录

免费注册

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

联系客服

823711899

点击QQ咨询

400-618-9990

拨打电话咨询

购物车 0

上传BOM

产品分类

找货询价

QQ咨询

会员中心

购物车

技术支持

售后咨询

类目：

电容电阻电感 / 线圈 / 变压器单片机 / 微控制器逻辑器件二极管三极管 / MOS管 / 晶体管碳化硅(SiC)器件氮化镓(GaN)器件 TVS / 保险丝 / 板级保护电源管理通信接口芯片时钟和定时连接器按键 / 开关 ADC / DAC / 数据转换射频芯片 / 天线光电器件数码管驱动 / LED驱动光耦显示屏磁珠 / 滤波器 / EMI优化振荡器 / 谐振器存储器传感器信号隔离器件继电器音频器件 / 振动马达功能模块物联网 / 通信模块运算放大器 / 比较器开发板 / 开发工具电子工具 / 仪器 / 耗材工控电气仪器仪表工具设备五金紧固办公日用

展开

收起

品牌：

Vishay General Semiconductor - Diodes Division (29) YAGEO (8) Littelfuse Inc. (7) Diodes Incorporated (7) Taiwan Semiconductor Corporation (7) MCC (Micro Commercial Components) (6) Bourns Inc. (5) Eaton - Electronics Division (4) STMICROELECTRONICS (3) KYOCERA AVX (2) Good-Ark Semiconductor (2) Semtech Corporation (2) Yenyo Technology (2) NextGen Components (2) UMW(友台半导体) (2) Shenzhen Slkormicro Semicon Co., Ltd. (2) Lumimax Optoelectronic Technology (2) MDD (2) ANBON SEMICONDUCTOR (INT'L) LIMITED (2) Microchip Technology (2) EVVO (2) SMC Diode Solutions (2) Comchip Technology (2) WeEn Semiconductors (2) HY Electronic (Cayman) Limited (1) LITTELFUSE (1) Meritek (1) DIODES INC. (1)

展开

收起

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

Total:110上页 1 2 345 6 下页

总110条记录，每页20条，共6页。

购物指南

支付方式

配送服务

售后服务

发票须知

优惠券使用规则

代理产品

代理品牌

代理器件

特色服务

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 ( 70.43 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 ( 69.08 KB )
/www/wwwroot/www.ic72.com/vendor/topthink/think-orm/src/db/Raw.php ( 1.22 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-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 ( 76.63 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.000510s ] mysql:host=127.0.0.1;port=3306;dbname=ic72com;charset=utf8
SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001361s ]
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://ic118.com/stock&keyword=SMBJ12CA&page=4&srecordnum=110' [ RunTime:0.003161s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001740s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000540s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002157s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001328s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001279s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ12CA' LIMIT 1 [ RunTime:0.000381s ]
UPDATE `stock_search` SET `count` = 21988 , `updatetime` = '2026-06-12 06:30:22' WHERE `partno` = 'SMBJ12CA' [ RunTime:0.001808s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000295s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000204s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001590s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE 'SMBJ12CA%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.000367s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'SMBJ12CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.001916s ]
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 ( (s.isDisplay = 1) ) AND `s`.`id` IN ('42409793','42398059','42298456','42271398','42257283','42257282','42245758','42245757','42245272','42243625','42242861','42242562','42239416','42239130','42236018','42234217','42234207','42222682','42215491','42199424') ORDER BY FIELD(s.id, 42409793,42398059,42298456,42271398,42257283,42257282,42245758,42245757,42245272,42243625,42242861,42242562,42239416,42239130,42236018,42234217,42234207,42222682,42215491,42199424) [ RunTime:0.002808s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42409793 LIMIT 4 [ RunTime:0.000705s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409793 ORDER BY `minOrder` ASC [ RunTime:0.002679s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42409793 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42409793 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409793 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
CONNECT:[ UseTime:0.000815s ] mysql:host=127.0.0.1;port=3306;dbname=ic72com_pdf;charset=utf8
select * from pdf where partno='SMBJ12CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001145s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000802s ]
SELECT `id` FROM `stock` WHERE `id` <> 42409793 AND `partno` = 'SMBJ12CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683397 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42398059 LIMIT 4 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398059 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42398059 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42398059 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398059 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='SMBJ12CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001099s ]
SELECT `id` FROM `stock` WHERE `id` <> 42398059 AND `partno` = 'SMBJ12CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924547 [ RunTime:0.000846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42298456 LIMIT 4 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298456 ORDER BY `minOrder` ASC [ RunTime:0.001178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42298456 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42298456 LIMIT 2 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298456 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='SMBJ12CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000928s ]
SELECT `id` FROM `stock` WHERE `id` <> 42298456 AND `partno` = 'SMBJ12CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820256 [ RunTime:0.000740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42271398 LIMIT 4 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271398 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42271398 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42271398 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271398 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='SMBJ12CAH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.001283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.000934s ]
SELECT `id` FROM `stock` WHERE `id` <> 42271398 AND `partno` = 'SMBJ12CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.000825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800894 [ RunTime:0.001055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257283 LIMIT 4 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257283 ORDER BY `minOrder` ASC [ RunTime:0.001083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257283 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257283 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257283 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='SMBJ12CAHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000771s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257283 AND `partno` = 'SMBJ12CAHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672167 [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257282 LIMIT 4 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257282 ORDER BY `minOrder` ASC [ RunTime:0.000789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257282 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257282 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257282 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='SMBJ12CAHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000834s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257282 AND `partno` = 'SMBJ12CAHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672697 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245758 LIMIT 4 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245758 ORDER BY `minOrder` ASC [ RunTime:0.001206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245758 ORDER BY `unit` DESC [ RunTime:0.000646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245758 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245758 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='SMBJ12CAHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000794s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245758 AND `partno` = 'SMBJ12CAHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812871 [ RunTime:0.000705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245757 LIMIT 4 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245757 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245757 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245757 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245757 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='SMBJ12CAHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000763s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245757 AND `partno` = 'SMBJ12CAHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915817 [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245272 LIMIT 4 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245272 ORDER BY `minOrder` ASC [ RunTime:0.001138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245272 ORDER BY `unit` DESC [ RunTime:0.000642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245272 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245272 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='SMBJ12CA-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CA-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000793s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245272 AND `partno` = 'SMBJ12CA-M3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673222 [ RunTime:0.000670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42243625 LIMIT 4 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243625 ORDER BY `minOrder` ASC [ RunTime:0.001205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42243625 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42243625 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42243625 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='SMBJ12CA-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CA-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000813s ]
SELECT `id` FROM `stock` WHERE `id` <> 42243625 AND `partno` = 'SMBJ12CA-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672406 [ RunTime:0.000727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242861 LIMIT 4 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242861 ORDER BY `minOrder` ASC [ RunTime:0.001183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242861 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242861 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242861 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='SMBJ12CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000798s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242861 AND `partno` = 'SMBJ12CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916215 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242562 LIMIT 4 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242562 ORDER BY `minOrder` ASC [ RunTime:0.000892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242562 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242562 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242562 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='SMBJ12CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000880s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242562 AND `partno` = 'SMBJ12CAHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813410 [ RunTime:0.000736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239416 LIMIT 4 [ RunTime:0.001067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239416 ORDER BY `minOrder` ASC [ RunTime:0.001410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239416 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239416 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239416 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='SMBJ12CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000788s ]
SELECT `id` FROM `stock` WHERE `id` <> 42239416 AND `partno` = 'SMBJ12CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672627 [ RunTime:0.000701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239130 LIMIT 4 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239130 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239130 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239130 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239130 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='SMBJ12CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000996s ]
SELECT `id` FROM `stock` WHERE `id` <> 42239130 AND `partno` = 'SMBJ12CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915595 [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236018 LIMIT 4 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236018 ORDER BY `minOrder` ASC [ RunTime:0.001392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236018 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236018 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236018 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='SMBJ12CAQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.001371s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236018 AND `partno` = 'SMBJ12CAQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671045 [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234217 LIMIT 4 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234217 ORDER BY `minOrder` ASC [ RunTime:0.001001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234217 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234217 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234217 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='SMBJ12CAQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000578s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234217 AND `partno` = 'SMBJ12CAQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810984 [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234207 LIMIT 4 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234207 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234207 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234207 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234207 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='SMBJ12CAHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000558s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234207 AND `partno` = 'SMBJ12CAHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811126 [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222682 LIMIT 4 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222682 ORDER BY `minOrder` ASC [ RunTime:0.001030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222682 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222682 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222682 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='SMBJ12CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000904s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222682 AND `partno` = 'SMBJ12CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913729 [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215491 LIMIT 4 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215491 ORDER BY `minOrder` ASC [ RunTime:0.001118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215491 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215491 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215491 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='SMBJ12CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.001025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.000867s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215491 AND `partno` = 'SMBJ12CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.000755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669737 [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42199424 LIMIT 4 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199424 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42199424 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42199424 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199424 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='SMBJ12CA-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ12CA-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005344s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ12CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000421s ]

0.489883s