SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001315s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=SMBJ7.0CA&search=1' [ RunTime:0.001684s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001369s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000507s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001635s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001362s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000640s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000998s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ7.0CA' LIMIT 1 [ RunTime:0.018220s ]
UPDATE `stock_search` SET `count` = 23199 , `updatetime` = '2026-08-16 20:29:28' WHERE `partno` = 'SMBJ7.0CA' [ RunTime:0.016861s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001856s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026483s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802990 LIMIT 5 [ RunTime:0.016319s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802990 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802990 ORDER BY `unit` DESC [ RunTime:0.001052s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802990 LIMIT 2 [ RunTime:0.024179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802990 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800295 LIMIT 5 [ RunTime:0.009902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800295 ORDER BY `minOrder` ASC [ RunTime:0.014738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800295 ORDER BY `unit` DESC [ RunTime:0.024112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800295 LIMIT 2 [ RunTime:0.011868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800295 ORDER BY `minOrder` ASC [ RunTime:0.009852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800580 LIMIT 5 [ RunTime:0.036204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800580 ORDER BY `minOrder` ASC [ RunTime:0.011752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800580 ORDER BY `unit` DESC [ RunTime:0.011091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800580 LIMIT 2 [ RunTime:0.007108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800580 ORDER BY `minOrder` ASC [ RunTime:0.013676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815981 LIMIT 5 [ RunTime:0.002038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815981 ORDER BY `minOrder` ASC [ RunTime:0.002650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815981 ORDER BY `unit` DESC [ RunTime:0.001315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815981 LIMIT 2 [ RunTime:0.004362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815981 ORDER BY `minOrder` ASC [ RunTime:0.006293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907370 LIMIT 5 [ RunTime:0.018362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907370 ORDER BY `minOrder` ASC [ RunTime:0.016767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907370 ORDER BY `unit` DESC [ RunTime:0.008642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907370 LIMIT 2 [ RunTime:0.020640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907370 ORDER BY `minOrder` ASC [ RunTime:0.005282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663753 LIMIT 5 [ RunTime:0.007105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663753 ORDER BY `minOrder` ASC [ RunTime:0.034684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663753 ORDER BY `unit` DESC [ RunTime:0.019345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663753 LIMIT 2 [ RunTime:0.040068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663753 ORDER BY `minOrder` ASC [ RunTime:0.022926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827518 LIMIT 5 [ RunTime:0.016308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827518 ORDER BY `minOrder` ASC [ RunTime:0.019025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827518 ORDER BY `unit` DESC [ RunTime:0.013467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827518 LIMIT 2 [ RunTime:0.006897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827518 ORDER BY `minOrder` ASC [ RunTime:0.007241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801667 LIMIT 5 [ RunTime:0.023562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801667 ORDER BY `minOrder` ASC [ RunTime:0.059861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801667 ORDER BY `unit` DESC [ RunTime:0.055494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801667 LIMIT 2 [ RunTime:0.012388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801667 ORDER BY `minOrder` ASC [ RunTime:0.018005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907939 LIMIT 5 [ RunTime:0.025320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907939 ORDER BY `minOrder` ASC [ RunTime:0.017150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907939 ORDER BY `unit` DESC [ RunTime:0.024381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907939 LIMIT 2 [ RunTime:0.029707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907939 ORDER BY `minOrder` ASC [ RunTime:0.021230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4508 LIMIT 5 [ RunTime:0.005808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4508 ORDER BY `minOrder` ASC [ RunTime:0.014339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4508 ORDER BY `unit` DESC [ RunTime:0.043893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4508 LIMIT 2 [ RunTime:0.046059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4508 ORDER BY `minOrder` ASC [ RunTime:0.008936s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.040062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664450 LIMIT 5 [ RunTime:0.019486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664450 ORDER BY `minOrder` ASC [ RunTime:0.018803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664450 ORDER BY `unit` DESC [ RunTime:0.027823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664450 LIMIT 2 [ RunTime:0.039494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664450 ORDER BY `minOrder` ASC [ RunTime:0.015311s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.031480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907819 LIMIT 5 [ RunTime:0.037234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907819 ORDER BY `minOrder` ASC [ RunTime:0.046201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907819 ORDER BY `unit` DESC [ RunTime:0.040207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907819 LIMIT 2 [ RunTime:0.048522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907819 ORDER BY `minOrder` ASC [ RunTime:0.007471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692653 LIMIT 5 [ RunTime:0.015375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692653 ORDER BY `minOrder` ASC [ RunTime:0.024915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692653 ORDER BY `unit` DESC [ RunTime:0.013971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692653 LIMIT 2 [ RunTime:0.027772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692653 ORDER BY `minOrder` ASC [ RunTime:0.014130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692435 LIMIT 5 [ RunTime:0.012197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692435 ORDER BY `minOrder` ASC [ RunTime:0.038894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692435 ORDER BY `unit` DESC [ RunTime:0.030021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692435 LIMIT 2 [ RunTime:0.014509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692435 ORDER BY `minOrder` ASC [ RunTime:0.010910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691191 LIMIT 5 [ RunTime:0.028934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691191 ORDER BY `minOrder` ASC [ RunTime:0.026529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691191 ORDER BY `unit` DESC [ RunTime:0.008815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691191 LIMIT 2 [ RunTime:0.011265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691191 ORDER BY `minOrder` ASC [ RunTime:0.020738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689630 LIMIT 5 [ RunTime:0.019971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689630 ORDER BY `minOrder` ASC [ RunTime:0.038004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689630 ORDER BY `unit` DESC [ RunTime:0.012339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689630 LIMIT 2 [ RunTime:0.011258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689630 ORDER BY `minOrder` ASC [ RunTime:0.003969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673377 LIMIT 5 [ RunTime:0.010957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673377 ORDER BY `minOrder` ASC [ RunTime:0.008049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673377 ORDER BY `unit` DESC [ RunTime:0.028434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673377 LIMIT 2 [ RunTime:0.021540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673377 ORDER BY `minOrder` ASC [ RunTime:0.005860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673164 LIMIT 5 [ RunTime:0.014595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673164 ORDER BY `minOrder` ASC [ RunTime:0.027373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673164 ORDER BY `unit` DESC [ RunTime:0.016116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673164 LIMIT 2 [ RunTime:0.019860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673164 ORDER BY `minOrder` ASC [ RunTime:0.015230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672771 LIMIT 5 [ RunTime:0.018319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672771 ORDER BY `minOrder` ASC [ RunTime:0.004121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672771 ORDER BY `unit` DESC [ RunTime:0.009281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672771 LIMIT 2 [ RunTime:0.021072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672771 ORDER BY `minOrder` ASC [ RunTime:0.007021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672765 LIMIT 5 [ RunTime:0.018256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672765 ORDER BY `minOrder` ASC [ RunTime:0.012012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672765 ORDER BY `unit` DESC [ RunTime:0.014857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672765 LIMIT 2 [ RunTime:0.010931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672765 ORDER BY `minOrder` ASC [ RunTime:0.019089s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024008s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101114 LIMIT 5 [ RunTime:0.007937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101114 ORDER BY `minOrder` ASC [ RunTime:0.024544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101114 ORDER BY `unit` DESC [ RunTime:0.007151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101114 LIMIT 2 [ RunTime:0.044799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101114 ORDER BY `minOrder` ASC [ RunTime:0.014502s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146886 LIMIT 5 [ RunTime:0.022166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146886 ORDER BY `minOrder` ASC [ RunTime:0.032609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146886 ORDER BY `unit` DESC [ RunTime:0.006538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146886 LIMIT 2 [ RunTime:0.032603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146886 ORDER BY `minOrder` ASC [ RunTime:0.024929s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='MDD' limit 1 [ RunTime:0.016381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.023462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42102009 LIMIT 5 [ RunTime:0.028762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102009 ORDER BY `minOrder` ASC [ RunTime:0.025727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42102009 ORDER BY `unit` DESC [ RunTime:0.010883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42102009 LIMIT 2 [ RunTime:0.020068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102009 ORDER BY `minOrder` ASC [ RunTime:0.044064s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.031460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.036928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42111979 LIMIT 5 [ RunTime:0.030472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111979 ORDER BY `minOrder` ASC [ RunTime:0.018650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42111979 ORDER BY `unit` DESC [ RunTime:0.021012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42111979 LIMIT 2 [ RunTime:0.025323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111979 ORDER BY `minOrder` ASC [ RunTime:0.035372s ]
select * from pdf where partno='SMBJ7.0CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.024402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.028657s ]
SELECT `id` FROM `stock` WHERE `id` <> 42111979 AND `partno` = 'SMBJ7.0CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.065993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907370 [ RunTime:0.027047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123970 LIMIT 5 [ RunTime:0.012902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123970 ORDER BY `minOrder` ASC [ RunTime:0.013690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123970 ORDER BY `unit` DESC [ RunTime:0.024806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123970 LIMIT 2 [ RunTime:0.029392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123970 ORDER BY `minOrder` ASC [ RunTime:0.017079s ]
select * from pdf where partno='SMBJ7.0CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.023829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114291 LIMIT 5 [ RunTime:0.010435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114291 ORDER BY `minOrder` ASC [ RunTime:0.011781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114291 ORDER BY `unit` DESC [ RunTime:0.020127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114291 LIMIT 2 [ RunTime:0.022971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114291 ORDER BY `minOrder` ASC [ RunTime:0.007286s ]
select * from pdf where partno='SMBJ7.0CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019360s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114291 AND `partno` = 'SMBJ7.0CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.030669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827518 [ RunTime:0.020716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162741 LIMIT 5 [ RunTime:0.015308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162741 ORDER BY `minOrder` ASC [ RunTime:0.024548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162741 ORDER BY `unit` DESC [ RunTime:0.023400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162741 LIMIT 2 [ RunTime:0.032520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162741 ORDER BY `minOrder` ASC [ RunTime:0.008459s ]
select * from pdf where partno='SMBJ7.0CA-A' and brandshort='Yenyo Technology' limit 1 [ RunTime:0.027916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-A' OR `brand` LIKE 'Yenyo Technology%' ) ) LIMIT 1 [ RunTime:0.028805s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162741 AND `partno` = 'SMBJ7.0CA-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yenyo technology%' ) [ RunTime:0.016460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663753 [ RunTime:0.054399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143005 LIMIT 5 [ RunTime:0.013607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143005 ORDER BY `minOrder` ASC [ RunTime:0.047240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143005 ORDER BY `unit` DESC [ RunTime:0.008095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143005 LIMIT 2 [ RunTime:0.024744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143005 ORDER BY `minOrder` ASC [ RunTime:0.029094s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.039967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.019247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159208 LIMIT 5 [ RunTime:0.022436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159208 ORDER BY `minOrder` ASC [ RunTime:0.011183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159208 ORDER BY `unit` DESC [ RunTime:0.007115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159208 LIMIT 2 [ RunTime:0.006990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159208 ORDER BY `minOrder` ASC [ RunTime:0.002035s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.025155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.011532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147831 LIMIT 5 [ RunTime:0.009335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147831 ORDER BY `minOrder` ASC [ RunTime:0.009482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147831 ORDER BY `unit` DESC [ RunTime:0.015152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147831 LIMIT 2 [ RunTime:0.016302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147831 ORDER BY `minOrder` ASC [ RunTime:0.001245s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.002733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.009854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42140093 LIMIT 5 [ RunTime:0.021155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140093 ORDER BY `minOrder` ASC [ RunTime:0.054369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42140093 ORDER BY `unit` DESC [ RunTime:0.014482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42140093 LIMIT 2 [ RunTime:0.025181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140093 ORDER BY `minOrder` ASC [ RunTime:0.006518s ]
select * from pdf where partno='SMBJ7.0CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.007563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.022054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42167454 LIMIT 5 [ RunTime:0.009778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167454 ORDER BY `minOrder` ASC [ RunTime:0.003435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42167454 ORDER BY `unit` DESC [ RunTime:0.005777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42167454 LIMIT 2 [ RunTime:0.009646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167454 ORDER BY `minOrder` ASC [ RunTime:0.017652s ]
select * from pdf where partno='SMBJ7.0CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.005506s ]
SELECT `id` FROM `stock` WHERE `id` <> 42167454 AND `partno` = 'SMBJ7.0CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.008188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802990 [ RunTime:0.003172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42176967 LIMIT 5 [ RunTime:0.008151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42176967 ORDER BY `minOrder` ASC [ RunTime:0.009938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42176967 ORDER BY `unit` DESC [ RunTime:0.012732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42176967 LIMIT 2 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42176967 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
select * from pdf where partno='SMBJ7.0CA-QH' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.006345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-QH' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001692s ]
SELECT `id` FROM `stock` WHERE `id` <> 42176967 AND `partno` = 'SMBJ7.0CA-QH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.006324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907819 [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42409779 LIMIT 5 [ RunTime:0.009143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409779 ORDER BY `minOrder` ASC [ RunTime:0.009046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42409779 ORDER BY `unit` DESC [ RunTime:0.007219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42409779 LIMIT 2 [ RunTime:0.002675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409779 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='SMBJ7.0CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001268s ]
SELECT `id` FROM `stock` WHERE `id` <> 42409779 AND `partno` = 'SMBJ7.0CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924743 [ RunTime:0.004151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42398045 LIMIT 5 [ RunTime:0.020702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398045 ORDER BY `minOrder` ASC [ RunTime:0.021805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42398045 ORDER BY `unit` DESC [ RunTime:0.000831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42398045 LIMIT 2 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398045 ORDER BY `minOrder` ASC [ RunTime:0.003539s ]
select * from pdf where partno='SMBJ7.0CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004393s ]
SELECT `id` FROM `stock` WHERE `id` <> 42398045 AND `partno` = 'SMBJ7.0CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.013077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823384 [ RunTime:0.003837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42298473 LIMIT 5 [ RunTime:0.005423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298473 ORDER BY `minOrder` ASC [ RunTime:0.002005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42298473 ORDER BY `unit` DESC [ RunTime:0.000781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42298473 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298473 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='SMBJ7.0CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002838s ]
SELECT `id` FROM `stock` WHERE `id` <> 42298473 AND `partno` = 'SMBJ7.0CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.002899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820261 [ RunTime:0.007449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42269211 LIMIT 5 [ RunTime:0.003123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269211 ORDER BY `minOrder` ASC [ RunTime:0.013163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42269211 ORDER BY `unit` DESC [ RunTime:0.003037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42269211 LIMIT 2 [ RunTime:0.002007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269211 ORDER BY `minOrder` ASC [ RunTime:0.002057s ]
select * from pdf where partno='SMBJ7.0CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.001529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.005456s ]
SELECT `id` FROM `stock` WHERE `id` <> 42269211 AND `partno` = 'SMBJ7.0CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.002971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814887 [ RunTime:0.013694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257275 LIMIT 5 [ RunTime:0.012446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257275 ORDER BY `minOrder` ASC [ RunTime:0.021994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257275 ORDER BY `unit` DESC [ RunTime:0.002318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257275 LIMIT 2 [ RunTime:0.003528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257275 ORDER BY `minOrder` ASC [ RunTime:0.007693s ]
select * from pdf where partno='SMBJ7.0CAHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CAHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.033292s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257275 AND `partno` = 'SMBJ7.0CAHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.037846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812865 [ RunTime:0.066783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257273 LIMIT 5 [ RunTime:0.010835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257273 ORDER BY `minOrder` ASC [ RunTime:0.005396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257273 ORDER BY `unit` DESC [ RunTime:0.002391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257273 LIMIT 2 [ RunTime:0.026096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257273 ORDER BY `minOrder` ASC [ RunTime:0.007587s ]
select * from pdf where partno='SMBJ7.0CAHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CAHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011793s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257273 AND `partno` = 'SMBJ7.0CAHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672771 [ RunTime:0.016218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245756 LIMIT 5 [ RunTime:0.008748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245756 ORDER BY `minOrder` ASC [ RunTime:0.024410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245756 ORDER BY `unit` DESC [ RunTime:0.011431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245756 LIMIT 2 [ RunTime:0.020458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245756 ORDER BY `minOrder` ASC [ RunTime:0.028053s ]
select * from pdf where partno='SMBJ7.0CAHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ7.0CAHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013620s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245756 AND `partno` = 'SMBJ7.0CAHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672693 [ RunTime:0.034234s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019844s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006648s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022528s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012160s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020515s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022607s ]
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 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017881s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ7.0CA%' OR `brand` LIKE 'SMBJ7.0CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014912s ]