SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001829s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=SMCJ180&search=1' [ RunTime:0.001919s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003041s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000710s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001986s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003057s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007354s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001793s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ180' LIMIT 1 [ RunTime:0.000988s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-19 02:36:27' WHERE `partno` = 'SMCJ180' [ RunTime:0.004955s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002002s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014171s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921533 LIMIT 5 [ RunTime:0.024485s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921533 ORDER BY `minOrder` ASC [ RunTime:0.000871s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921533 ORDER BY `unit` DESC [ RunTime:0.027684s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921533 LIMIT 2 [ RunTime:0.026398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921533 ORDER BY `minOrder` ASC [ RunTime:0.015111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917905 LIMIT 5 [ RunTime:0.019433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917905 ORDER BY `minOrder` ASC [ RunTime:0.068932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917905 ORDER BY `unit` DESC [ RunTime:0.025746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917905 LIMIT 2 [ RunTime:0.040171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917905 ORDER BY `minOrder` ASC [ RunTime:0.022211s ]
select * from pdf where partno='SMCJ180CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.040840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802141 LIMIT 5 [ RunTime:0.038178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802141 ORDER BY `minOrder` ASC [ RunTime:0.034157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802141 ORDER BY `unit` DESC [ RunTime:0.030440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802141 LIMIT 2 [ RunTime:0.046672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802141 ORDER BY `minOrder` ASC [ RunTime:0.044378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679670 LIMIT 5 [ RunTime:0.030174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679670 ORDER BY `minOrder` ASC [ RunTime:0.037800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679670 ORDER BY `unit` DESC [ RunTime:0.049822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679670 LIMIT 2 [ RunTime:0.049338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679670 ORDER BY `minOrder` ASC [ RunTime:0.021905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802100 LIMIT 5 [ RunTime:0.031754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802100 ORDER BY `minOrder` ASC [ RunTime:0.075230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802100 ORDER BY `unit` DESC [ RunTime:0.039163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802100 LIMIT 2 [ RunTime:0.026844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802100 ORDER BY `minOrder` ASC [ RunTime:0.014083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907602 LIMIT 5 [ RunTime:0.025137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907602 ORDER BY `minOrder` ASC [ RunTime:0.032279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907602 ORDER BY `unit` DESC [ RunTime:0.006921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907602 LIMIT 2 [ RunTime:0.033615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907602 ORDER BY `minOrder` ASC [ RunTime:0.019941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679024 LIMIT 5 [ RunTime:0.031274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679024 ORDER BY `minOrder` ASC [ RunTime:0.014366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679024 ORDER BY `unit` DESC [ RunTime:0.029575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679024 LIMIT 2 [ RunTime:0.034548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679024 ORDER BY `minOrder` ASC [ RunTime:0.020037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677291 LIMIT 5 [ RunTime:0.040363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677291 ORDER BY `minOrder` ASC [ RunTime:0.012637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677291 ORDER BY `unit` DESC [ RunTime:0.009929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677291 LIMIT 2 [ RunTime:0.013651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677291 ORDER BY `minOrder` ASC [ RunTime:0.001722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674812 LIMIT 5 [ RunTime:0.009634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674812 ORDER BY `minOrder` ASC [ RunTime:0.008947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674812 ORDER BY `unit` DESC [ RunTime:0.010451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674812 LIMIT 2 [ RunTime:0.003304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674812 ORDER BY `minOrder` ASC [ RunTime:0.005993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674607 LIMIT 5 [ RunTime:0.011604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674607 ORDER BY `minOrder` ASC [ RunTime:0.010852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674607 ORDER BY `unit` DESC [ RunTime:0.007550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674607 LIMIT 2 [ RunTime:0.002052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674607 ORDER BY `minOrder` ASC [ RunTime:0.004427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674606 LIMIT 5 [ RunTime:0.012268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674606 ORDER BY `minOrder` ASC [ RunTime:0.010576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674606 ORDER BY `unit` DESC [ RunTime:0.003713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674606 LIMIT 2 [ RunTime:0.002135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674606 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674246 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674246 ORDER BY `minOrder` ASC [ RunTime:0.004069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674246 ORDER BY `unit` DESC [ RunTime:0.016901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674246 LIMIT 2 [ RunTime:0.003921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674246 ORDER BY `minOrder` ASC [ RunTime:0.005387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673450 LIMIT 5 [ RunTime:0.017583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673450 ORDER BY `minOrder` ASC [ RunTime:0.005996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673450 ORDER BY `unit` DESC [ RunTime:0.012722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673450 LIMIT 2 [ RunTime:0.006876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673450 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671407 LIMIT 5 [ RunTime:0.001010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671407 ORDER BY `minOrder` ASC [ RunTime:0.001892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671407 ORDER BY `unit` DESC [ RunTime:0.000778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671407 LIMIT 2 [ RunTime:0.005955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671407 ORDER BY `minOrder` ASC [ RunTime:0.007667s ]
select * from pdf where partno='SMCJ180A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671132 LIMIT 5 [ RunTime:0.005493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671132 ORDER BY `minOrder` ASC [ RunTime:0.006953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671132 ORDER BY `unit` DESC [ RunTime:0.005311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671132 LIMIT 2 [ RunTime:0.011262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671132 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671126 LIMIT 5 [ RunTime:0.002891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671126 ORDER BY `minOrder` ASC [ RunTime:0.010874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671126 ORDER BY `unit` DESC [ RunTime:0.013869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671126 LIMIT 2 [ RunTime:0.014137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671126 ORDER BY `minOrder` ASC [ RunTime:0.004230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670240 LIMIT 5 [ RunTime:0.007655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670240 ORDER BY `minOrder` ASC [ RunTime:0.002647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670240 ORDER BY `unit` DESC [ RunTime:0.003194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670240 LIMIT 2 [ RunTime:0.006788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670240 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831072 LIMIT 5 [ RunTime:0.014511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831072 ORDER BY `minOrder` ASC [ RunTime:0.002222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831072 ORDER BY `unit` DESC [ RunTime:0.003984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831072 LIMIT 2 [ RunTime:0.009071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831072 ORDER BY `minOrder` ASC [ RunTime:0.002422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827646 LIMIT 5 [ RunTime:0.011925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827646 ORDER BY `minOrder` ASC [ RunTime:0.001512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827646 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827646 LIMIT 2 [ RunTime:0.006615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827646 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='SMCJ180C' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817964 LIMIT 5 [ RunTime:0.002040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817964 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817964 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817964 LIMIT 2 [ RunTime:0.003375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817964 ORDER BY `minOrder` ASC [ RunTime:0.009678s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141558 LIMIT 5 [ RunTime:0.016084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141558 ORDER BY `minOrder` ASC [ RunTime:0.003334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141558 ORDER BY `unit` DESC [ RunTime:0.003433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141558 LIMIT 2 [ RunTime:0.004821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141558 ORDER BY `minOrder` ASC [ RunTime:0.001249s ]
select * from pdf where partno='smcj180ca' and brandshort='bourns' limit 1 [ RunTime:0.003012s ]
select foldpath,foldpath2,filename from pdf_file where id=1553899 limit 1 [ RunTime:0.001256s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj180ca' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.003924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141447 LIMIT 5 [ RunTime:0.002592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141447 ORDER BY `minOrder` ASC [ RunTime:0.006978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141447 ORDER BY `unit` DESC [ RunTime:0.000262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141447 LIMIT 2 [ RunTime:0.013681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141447 ORDER BY `minOrder` ASC [ RunTime:0.003060s ]
select * from pdf where partno='smcj180a' and brandshort='bourns' limit 1 [ RunTime:0.010570s ]
select foldpath,foldpath2,filename from pdf_file where id=1553899 limit 1 [ RunTime:0.000656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj180a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.000406s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42133835 LIMIT 5 [ RunTime:0.012499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133835 ORDER BY `minOrder` ASC [ RunTime:0.050762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42133835 ORDER BY `unit` DESC [ RunTime:0.002900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42133835 LIMIT 2 [ RunTime:0.004649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133835 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
select * from pdf where partno='SMCJ180CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.009643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.022089s ]
SELECT `id` FROM `stock` WHERE `id` <> 42133835 AND `partno` = 'SMCJ180CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.020712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921533 [ RunTime:0.002845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42096044 LIMIT 5 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096044 ORDER BY `minOrder` ASC [ RunTime:0.008808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42096044 ORDER BY `unit` DESC [ RunTime:0.006285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42096044 LIMIT 2 [ RunTime:0.023199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096044 ORDER BY `minOrder` ASC [ RunTime:0.000918s ]
select * from pdf where partno='SMCJ180A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105594 LIMIT 5 [ RunTime:0.012626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105594 ORDER BY `minOrder` ASC [ RunTime:0.008833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105594 ORDER BY `unit` DESC [ RunTime:0.004749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105594 LIMIT 2 [ RunTime:0.010934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105594 ORDER BY `minOrder` ASC [ RunTime:0.001776s ]
select * from pdf where partno='SMCJ180CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000642s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105594 AND `partno` = 'SMCJ180CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.013765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917905 [ RunTime:0.003457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143023 LIMIT 5 [ RunTime:0.008394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143023 ORDER BY `minOrder` ASC [ RunTime:0.009254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143023 ORDER BY `unit` DESC [ RunTime:0.008624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143023 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143023 ORDER BY `minOrder` ASC [ RunTime:0.005562s ]
select * from pdf where partno='SMCJ180CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004229s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143023 AND `partno` = 'SMCJ180CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804668 [ RunTime:0.002679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142937 LIMIT 5 [ RunTime:0.014675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142937 ORDER BY `minOrder` ASC [ RunTime:0.003870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142937 ORDER BY `unit` DESC [ RunTime:0.002846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142937 LIMIT 2 [ RunTime:0.004803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142937 ORDER BY `minOrder` ASC [ RunTime:0.002207s ]
select * from pdf where partno='SMCJ180A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.010460s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142937 AND `partno` = 'SMCJ180A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.013404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909132 [ RunTime:0.008890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170311 LIMIT 5 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170311 ORDER BY `minOrder` ASC [ RunTime:0.016656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170311 ORDER BY `unit` DESC [ RunTime:0.002995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170311 LIMIT 2 [ RunTime:0.007968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170311 ORDER BY `minOrder` ASC [ RunTime:0.003351s ]
select * from pdf where partno='SMCJ180CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.001243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42290574 LIMIT 5 [ RunTime:0.008699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290574 ORDER BY `minOrder` ASC [ RunTime:0.002350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42290574 ORDER BY `unit` DESC [ RunTime:0.001468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42290574 LIMIT 2 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290574 ORDER BY `minOrder` ASC [ RunTime:0.007522s ]
select * from pdf where partno='SMCJ180CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.001478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.001308s ]
SELECT `id` FROM `stock` WHERE `id` <> 42290574 AND `partno` = 'SMCJ180CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.001353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920046 [ RunTime:0.005408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42290573 LIMIT 5 [ RunTime:0.002758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290573 ORDER BY `minOrder` ASC [ RunTime:0.001734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42290573 ORDER BY `unit` DESC [ RunTime:0.003402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42290573 LIMIT 2 [ RunTime:0.006102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290573 ORDER BY `minOrder` ASC [ RunTime:0.010081s ]
select * from pdf where partno='SMCJ180CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.016703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.005749s ]
SELECT `id` FROM `stock` WHERE `id` <> 42290573 AND `partno` = 'SMCJ180CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.002632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920045 [ RunTime:0.026565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42289224 LIMIT 5 [ RunTime:0.011154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289224 ORDER BY `minOrder` ASC [ RunTime:0.020462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42289224 ORDER BY `unit` DESC [ RunTime:0.007411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42289224 LIMIT 2 [ RunTime:0.014802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289224 ORDER BY `minOrder` ASC [ RunTime:0.007668s ]
select * from pdf where partno='SMCJ180E3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.004090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180E3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.028619s ]
SELECT `id` FROM `stock` WHERE `id` <> 42289224 AND `partno` = 'SMCJ180E3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.009031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817964 [ RunTime:0.008183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42289223 LIMIT 5 [ RunTime:0.010118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289223 ORDER BY `minOrder` ASC [ RunTime:0.004722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42289223 ORDER BY `unit` DESC [ RunTime:0.020618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42289223 LIMIT 2 [ RunTime:0.026088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289223 ORDER BY `minOrder` ASC [ RunTime:0.011167s ]
select * from pdf where partno='SMCJ180AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.016713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.022673s ]
SELECT `id` FROM `stock` WHERE `id` <> 42289223 AND `partno` = 'SMCJ180AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.018343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677291 [ RunTime:0.026159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42278982 LIMIT 5 [ RunTime:0.008935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278982 ORDER BY `minOrder` ASC [ RunTime:0.030883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42278982 ORDER BY `unit` DESC [ RunTime:0.020042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42278982 LIMIT 2 [ RunTime:0.024679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42278982 ORDER BY `minOrder` ASC [ RunTime:0.007363s ]
select * from pdf where partno='SMCJ180CAQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CAQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.015576s ]
SELECT `id` FROM `stock` WHERE `id` <> 42278982 AND `partno` = 'SMCJ180CAQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.013281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918371 [ RunTime:0.042870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42277290 LIMIT 5 [ RunTime:0.031586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277290 ORDER BY `minOrder` ASC [ RunTime:0.007007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42277290 ORDER BY `unit` DESC [ RunTime:0.022869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42277290 LIMIT 2 [ RunTime:0.070136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277290 ORDER BY `minOrder` ASC [ RunTime:0.012862s ]
select * from pdf where partno='SMCJ180AQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.027350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180AQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002980s ]
SELECT `id` FROM `stock` WHERE `id` <> 42277290 AND `partno` = 'SMCJ180AQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.041171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918222 [ RunTime:0.024124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42270104 LIMIT 5 [ RunTime:0.029111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270104 ORDER BY `minOrder` ASC [ RunTime:0.075931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42270104 ORDER BY `unit` DESC [ RunTime:0.037968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42270104 LIMIT 2 [ RunTime:0.085403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270104 ORDER BY `minOrder` ASC [ RunTime:0.038227s ]
select * from pdf where partno='SMCJ180CAHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.035373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CAHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.036847s ]
SELECT `id` FROM `stock` WHERE `id` <> 42270104 AND `partno` = 'SMCJ180CAHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.061858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917635 [ RunTime:0.067029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42270095 LIMIT 5 [ RunTime:0.032613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270095 ORDER BY `minOrder` ASC [ RunTime:0.067029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42270095 ORDER BY `unit` DESC [ RunTime:0.109041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42270095 LIMIT 2 [ RunTime:0.038915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270095 ORDER BY `minOrder` ASC [ RunTime:0.040782s ]
select * from pdf where partno='SMCJ180AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.077594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.030596s ]
SELECT `id` FROM `stock` WHERE `id` <> 42270095 AND `partno` = 'SMCJ180AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.048263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674812 [ RunTime:0.017082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42270069 LIMIT 5 [ RunTime:0.017112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270069 ORDER BY `minOrder` ASC [ RunTime:0.067831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42270069 ORDER BY `unit` DESC [ RunTime:0.052590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42270069 LIMIT 2 [ RunTime:0.049660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270069 ORDER BY `minOrder` ASC [ RunTime:0.017848s ]
select * from pdf where partno='SMCJ180AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.022743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.032295s ]
SELECT `id` FROM `stock` WHERE `id` <> 42270069 AND `partno` = 'SMCJ180AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.018426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917139 [ RunTime:0.036485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42270067 LIMIT 5 [ RunTime:0.031085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270067 ORDER BY `minOrder` ASC [ RunTime:0.019659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42270067 ORDER BY `unit` DESC [ RunTime:0.021161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42270067 LIMIT 2 [ RunTime:0.013709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270067 ORDER BY `minOrder` ASC [ RunTime:0.027763s ]
select * from pdf where partno='SMCJ180CAH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.016430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CAH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.030178s ]
SELECT `id` FROM `stock` WHERE `id` <> 42270067 AND `partno` = 'SMCJ180CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.021043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674246 [ RunTime:0.016210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267623 LIMIT 5 [ RunTime:0.008112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267623 ORDER BY `minOrder` ASC [ RunTime:0.020382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267623 ORDER BY `unit` DESC [ RunTime:0.016079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267623 LIMIT 2 [ RunTime:0.015700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267623 ORDER BY `minOrder` ASC [ RunTime:0.009684s ]
select * from pdf where partno='SMCJ180A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.012365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.013697s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267623 AND `partno` = 'SMCJ180A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.022823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674607 [ RunTime:0.018250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267622 LIMIT 5 [ RunTime:0.016708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267622 ORDER BY `minOrder` ASC [ RunTime:0.007330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267622 ORDER BY `unit` DESC [ RunTime:0.036374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267622 LIMIT 2 [ RunTime:0.009588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267622 ORDER BY `minOrder` ASC [ RunTime:0.009688s ]
select * from pdf where partno='SMCJ180CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.005487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.001946s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267622 AND `partno` = 'SMCJ180CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.007221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674606 [ RunTime:0.009555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262041 LIMIT 5 [ RunTime:0.005476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262041 ORDER BY `minOrder` ASC [ RunTime:0.006399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262041 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262041 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262041 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
select * from pdf where partno='SMCJ180A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.012255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42261696 LIMIT 5 [ RunTime:0.004047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261696 ORDER BY `minOrder` ASC [ RunTime:0.010253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42261696 ORDER BY `unit` DESC [ RunTime:0.008393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42261696 LIMIT 2 [ RunTime:0.003555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261696 ORDER BY `minOrder` ASC [ RunTime:0.005172s ]
select * from pdf where partno='SMCJ180CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.013824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ180CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.005321s ]
SELECT `id` FROM `stock` WHERE `id` <> 42261696 AND `partno` = 'SMCJ180CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.003729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673450 [ RunTime:0.006406s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006225s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017016s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018463s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012535s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010149s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017103s ]
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 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014418s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ180%' OR `brand` LIKE 'SMCJ180%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017144s ]