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

请登录

免费注册

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

联系客服

823711899

点击QQ咨询

400-618-9990

拨打电话咨询

购物车 0

上传BOM

产品分类

找货询价

QQ咨询

会员中心

购物车

技术支持

售后咨询

类目：

全部二极管

展开

收起

品牌：

全部 Aker Technology Corp (38) Comchip Technology (2) DIODES INC. (1) Diodes Incorporated (16) Diotec Semiconductor (2) EVVO (1) Fairchild Semiconductor (1) FSC (1) Hoffman Enclosures, Inc. (86) LGE Diodes (1) Lumimax Optoelectronic Technology (2) MCC (Micro Commercial Components) (1) ONSEMI (6) Panjit International Inc. (2) Shenzhen Slkormicro Semicon Co., Ltd. (1) SMC Diode Solutions (14) StarTech.com (1) TAIWAN SEMICONDUCTOR (1) Taiwan Semiconductor Corporation (26) Thomas Research Products (1) VIITOR SEMICONDUCTOR CO., LTD (2) Vishay General Semiconductor - Diodes Division (11) Xsens a Movella brand (4) YAGEO (1)

展开

收起

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

没有符合条件的记录。

购物指南

支付方式

配送服务

售后服务

发票须知

优惠券使用规则

代理产品

代理品牌

代理器件

特色服务

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.000567s ] mysql:host=127.0.0.1;port=3306;dbname=ic72com;charset=utf8
SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001355s ]
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=S1M&page=6&srecordnum=222' [ RunTime:0.041660s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002311s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.021274s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002880s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.015580s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002055s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.023521s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002489s ]
SELECT * FROM `stock_search` WHERE `partno` = 'S1M' LIMIT 1 [ RunTime:0.044296s ]
UPDATE `stock_search` SET `count` = 1306 , `updatetime` = '2026-06-13 08:26:10' WHERE `partno` = 'S1M' [ RunTime:0.027611s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002568s ]
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 'S1M%' OR `brand` LIKE 'S1M%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 100,20 [ RunTime:0.049502s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44077928 LIMIT 4 [ RunTime:0.028619s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44077928 ORDER BY `minOrder` ASC [ RunTime:0.060168s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.024962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44077928 ORDER BY `unit` DESC [ RunTime:0.036204s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44077928 LIMIT 2 [ RunTime:0.073865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44077928 ORDER BY `minOrder` ASC [ RunTime:0.103237s ]
CONNECT:[ UseTime:0.000795s ] mysql:host=127.0.0.1;port=3306;dbname=ic72com_pdf;charset=utf8
select * from pdf where partno='S1M0060065J' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.044984s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1M0060065J' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.026277s ]
SELECT `id` FROM `stock` WHERE `id` <> 44077928 AND `partno` = 'S1M0060065J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.010589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36494763 LIMIT 4 [ RunTime:0.014241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36494763 ORDER BY `minOrder` ASC [ RunTime:0.054215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36494763 ORDER BY `unit` DESC [ RunTime:0.009003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36494763 LIMIT 2 [ RunTime:0.026427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36494763 ORDER BY `minOrder` ASC [ RunTime:0.008989s ]
select * from pdf where partno='S1MB-DESK-CABLE-TRAY' and brandshort='StarTech.com' limit 1 [ RunTime:0.028547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MB-DESK-CABLE-TRAY' OR `brand` LIKE 'StarTech.com%' ) ) LIMIT 1 [ RunTime:0.035048s ]
SELECT `id` FROM `stock` WHERE `id` <> 36494763 AND `partno` = 'S1MB-DESK-CABLE-TRAY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%startech.com%' ) [ RunTime:0.025306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36730906 LIMIT 4 [ RunTime:0.053166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36730906 ORDER BY `minOrder` ASC [ RunTime:0.037639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36730906 ORDER BY `unit` DESC [ RunTime:0.041183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36730906 LIMIT 2 [ RunTime:0.036311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36730906 ORDER BY `minOrder` ASC [ RunTime:0.021929s ]
select * from pdf where partno='S1M43B' and brandshort='Xsens a Movella brand' limit 1 [ RunTime:0.147341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1M43B' OR `brand` LIKE 'Xsens a Movella brand%' ) ) LIMIT 1 [ RunTime:0.032089s ]
SELECT `id` FROM `stock` WHERE `id` <> 36730906 AND `partno` = 'S1M43B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%xsens a movella brand%' ) [ RunTime:0.028124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140868 [ RunTime:0.100965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140869 LIMIT 4 [ RunTime:0.053643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140869 ORDER BY `minOrder` ASC [ RunTime:0.080762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17140869 ORDER BY `unit` DESC [ RunTime:0.065268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17140869 LIMIT 2 [ RunTime:0.015914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140869 ORDER BY `minOrder` ASC [ RunTime:0.036864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140868 LIMIT 4 [ RunTime:0.023439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140868 ORDER BY `minOrder` ASC [ RunTime:0.033184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17140868 ORDER BY `unit` DESC [ RunTime:0.033276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17140868 LIMIT 2 [ RunTime:0.034117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140868 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44107350 LIMIT 4 [ RunTime:0.003165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107350 ORDER BY `minOrder` ASC [ RunTime:0.018424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44107350 ORDER BY `unit` DESC [ RunTime:0.014141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44107350 LIMIT 2 [ RunTime:0.034630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107350 ORDER BY `minOrder` ASC [ RunTime:0.003918s ]
select * from pdf where partno='S1MLS RVG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.008903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MLS RVG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002211s ]
SELECT `id` FROM `stock` WHERE `id` <> 44107350 AND `partno` = 'S1MLS RVG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.002553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44107051 LIMIT 4 [ RunTime:0.001366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107051 ORDER BY `minOrder` ASC [ RunTime:0.006999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44107051 ORDER BY `unit` DESC [ RunTime:0.016152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44107051 LIMIT 2 [ RunTime:0.037800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107051 ORDER BY `minOrder` ASC [ RunTime:0.010728s ]
select * from pdf where partno='S1M-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.028915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1M-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.003519s ]
SELECT `id` FROM `stock` WHERE `id` <> 44107051 AND `partno` = 'S1M-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.026495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44104521 LIMIT 4 [ RunTime:0.019527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44104521 ORDER BY `minOrder` ASC [ RunTime:0.021292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44104521 ORDER BY `unit` DESC [ RunTime:0.013133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44104521 LIMIT 2 [ RunTime:0.023884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44104521 ORDER BY `minOrder` ASC [ RunTime:0.005430s ]
select * from pdf where partno='S1MBHR5G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.018617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MBHR5G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.018064s ]
SELECT `id` FROM `stock` WHERE `id` <> 44104521 AND `partno` = 'S1MBHR5G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.006455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44103851 LIMIT 4 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44103851 ORDER BY `minOrder` ASC [ RunTime:0.004308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44103851 ORDER BY `unit` DESC [ RunTime:0.007941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44103851 LIMIT 2 [ RunTime:0.011966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44103851 ORDER BY `minOrder` ASC [ RunTime:0.006850s ]
select * from pdf where partno='S1MLHRUG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MLHRUG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.004098s ]
SELECT `id` FROM `stock` WHERE `id` <> 44103851 AND `partno` = 'S1MLHRUG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.007188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44103637 LIMIT 4 [ RunTime:0.014740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44103637 ORDER BY `minOrder` ASC [ RunTime:0.015424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44103637 ORDER BY `unit` DESC [ RunTime:0.012866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44103637 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44103637 ORDER BY `minOrder` ASC [ RunTime:0.002808s ]
select * from pdf where partno='S1ML RUG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.015906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1ML RUG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.020609s ]
SELECT `id` FROM `stock` WHERE `id` <> 44103637 AND `partno` = 'S1ML RUG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.028248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44101581 LIMIT 4 [ RunTime:0.049224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101581 ORDER BY `minOrder` ASC [ RunTime:0.032554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44101581 ORDER BY `unit` DESC [ RunTime:0.004702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44101581 LIMIT 2 [ RunTime:0.027509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44101581 ORDER BY `minOrder` ASC [ RunTime:0.023103s ]
select * from pdf where partno='S1MWF-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.044127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MWF-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.034185s ]
SELECT `id` FROM `stock` WHERE `id` <> 44101581 AND `partno` = 'S1MWF-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.034310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44100836 LIMIT 4 [ RunTime:0.006213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100836 ORDER BY `minOrder` ASC [ RunTime:0.017919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44100836 ORDER BY `unit` DESC [ RunTime:0.026851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44100836 LIMIT 2 [ RunTime:0.022073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100836 ORDER BY `minOrder` ASC [ RunTime:0.022054s ]
select * from pdf where partno='S1MSWF-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.016158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MSWF-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.014158s ]
SELECT `id` FROM `stock` WHERE `id` <> 44100836 AND `partno` = 'S1MSWF-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.030651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44100721 LIMIT 4 [ RunTime:0.047044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100721 ORDER BY `minOrder` ASC [ RunTime:0.044441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44100721 ORDER BY `unit` DESC [ RunTime:0.015608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44100721 LIMIT 2 [ RunTime:0.052235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100721 ORDER BY `minOrder` ASC [ RunTime:0.012385s ]
select * from pdf where partno='S1MB-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.025023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MB-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.084673s ]
SELECT `id` FROM `stock` WHERE `id` <> 44100721 AND `partno` = 'S1MB-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.025328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44100647 LIMIT 4 [ RunTime:0.147087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100647 ORDER BY `minOrder` ASC [ RunTime:0.046107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44100647 ORDER BY `unit` DESC [ RunTime:0.038339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44100647 LIMIT 2 [ RunTime:0.052338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100647 ORDER BY `minOrder` ASC [ RunTime:0.012242s ]
select * from pdf where partno='S1MLSHRVG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.026360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MLSHRVG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.016249s ]
SELECT `id` FROM `stock` WHERE `id` <> 44100647 AND `partno` = 'S1MLSHRVG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.023695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44100341 LIMIT 4 [ RunTime:0.030354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100341 ORDER BY `minOrder` ASC [ RunTime:0.024787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44100341 ORDER BY `unit` DESC [ RunTime:0.005526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44100341 LIMIT 2 [ RunTime:0.034488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44100341 ORDER BY `minOrder` ASC [ RunTime:0.017453s ]
select * from pdf where partno='S1MFS MWG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.036102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MFS MWG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.012986s ]
SELECT `id` FROM `stock` WHERE `id` <> 44100341 AND `partno` = 'S1MFS MWG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.037251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44099619 LIMIT 4 [ RunTime:0.024468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099619 ORDER BY `minOrder` ASC [ RunTime:0.057598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44099619 ORDER BY `unit` DESC [ RunTime:0.016510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44099619 LIMIT 2 [ RunTime:0.017017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099619 ORDER BY `minOrder` ASC [ RunTime:0.010275s ]
select * from pdf where partno='S1M/1' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1M/1' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.018393s ]
SELECT `id` FROM `stock` WHERE `id` <> 44099619 AND `partno` = 'S1M/1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44099378 LIMIT 4 [ RunTime:0.008352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099378 ORDER BY `minOrder` ASC [ RunTime:0.036862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44099378 ORDER BY `unit` DESC [ RunTime:0.005132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44099378 LIMIT 2 [ RunTime:0.002060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099378 ORDER BY `minOrder` ASC [ RunTime:0.005935s ]
select * from pdf where partno='S1MSP1-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.014087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MSP1-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.009372s ]
SELECT `id` FROM `stock` WHERE `id` <> 44099378 AND `partno` = 'S1MSP1-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.005996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44099340 LIMIT 4 [ RunTime:0.004762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099340 ORDER BY `minOrder` ASC [ RunTime:0.010103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44099340 ORDER BY `unit` DESC [ RunTime:0.015718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44099340 LIMIT 2 [ RunTime:0.014025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099340 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
select * from pdf where partno='S1ML RVG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.019297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1ML RVG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.022002s ]
SELECT `id` FROM `stock` WHERE `id` <> 44099340 AND `partno` = 'S1ML RVG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.038586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44099274 LIMIT 4 [ RunTime:0.017604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099274 ORDER BY `minOrder` ASC [ RunTime:0.007527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44099274 ORDER BY `unit` DESC [ RunTime:0.011195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44099274 LIMIT 2 [ RunTime:0.020086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44099274 ORDER BY `minOrder` ASC [ RunTime:0.012155s ]
select * from pdf where partno='S1MHE3/61T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MHE3/61T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021714s ]
SELECT `id` FROM `stock` WHERE `id` <> 44099274 AND `partno` = 'S1MHE3/61T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44098961 LIMIT 4 [ RunTime:0.025175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44098961 ORDER BY `minOrder` ASC [ RunTime:0.015321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44098961 ORDER BY `unit` DESC [ RunTime:0.016842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44098961 LIMIT 2 [ RunTime:0.005368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44098961 ORDER BY `minOrder` ASC [ RunTime:0.012215s ]
select * from pdf where partno='S1MHQ-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.021353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1MHQ-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.024389s ]
SELECT `id` FROM `stock` WHERE `id` <> 44098961 AND `partno` = 'S1MHQ-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.055357s ]
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 'S1M%' OR `brand` LIKE 'S1M%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 100,20 [ RunTime:0.049465s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'S1M%' OR `brand` LIKE 'S1M%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.043548s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'S1M%' OR `brand` LIKE 'S1M%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.010611s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 21 [ RunTime:0.011008s ]

4.676891s