SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002209s ]
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=SMBJ51CA&search=1' [ RunTime:0.009862s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002966s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000539s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001422s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.001610s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001417s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001263s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001088s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ51CA' LIMIT 1 [ RunTime:0.018301s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-25 04:40:55' WHERE `partno` = 'SMBJ51CA' [ RunTime:0.012538s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001594s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020716s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663420 LIMIT 5 [ RunTime:0.030203s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663420 ORDER BY `minOrder` ASC [ RunTime:0.023776s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663420 ORDER BY `unit` DESC [ RunTime:0.035108s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663420 LIMIT 2 [ RunTime:0.014105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663420 ORDER BY `minOrder` ASC [ RunTime:0.004653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662284 LIMIT 5 [ RunTime:0.042226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662284 ORDER BY `minOrder` ASC [ RunTime:0.018197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662284 ORDER BY `unit` DESC [ RunTime:0.039809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662284 LIMIT 2 [ RunTime:0.021788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662284 ORDER BY `minOrder` ASC [ RunTime:0.015298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908992 LIMIT 5 [ RunTime:0.015521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908992 ORDER BY `minOrder` ASC [ RunTime:0.071125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908992 ORDER BY `unit` DESC [ RunTime:0.054979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908992 LIMIT 2 [ RunTime:0.040535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908992 ORDER BY `minOrder` ASC [ RunTime:0.009725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674013 LIMIT 5 [ RunTime:0.013979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674013 ORDER BY `minOrder` ASC [ RunTime:0.044060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674013 ORDER BY `unit` DESC [ RunTime:0.043019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674013 LIMIT 2 [ RunTime:0.014743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674013 ORDER BY `minOrder` ASC [ RunTime:0.012407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662498 LIMIT 5 [ RunTime:0.023233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662498 ORDER BY `minOrder` ASC [ RunTime:0.016547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662498 ORDER BY `unit` DESC [ RunTime:0.042431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662498 LIMIT 2 [ RunTime:0.040353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662498 ORDER BY `minOrder` ASC [ RunTime:0.021685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664431 LIMIT 5 [ RunTime:0.024988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664431 ORDER BY `minOrder` ASC [ RunTime:0.023844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664431 ORDER BY `unit` DESC [ RunTime:0.065950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664431 LIMIT 2 [ RunTime:0.022168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664431 ORDER BY `minOrder` ASC [ RunTime:0.012055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928201 LIMIT 5 [ RunTime:0.028076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928201 ORDER BY `minOrder` ASC [ RunTime:0.023400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928201 ORDER BY `unit` DESC [ RunTime:0.003682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928201 LIMIT 2 [ RunTime:0.022984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928201 ORDER BY `minOrder` ASC [ RunTime:0.003489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926482 LIMIT 5 [ RunTime:0.002588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926482 ORDER BY `minOrder` ASC [ RunTime:0.016549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926482 ORDER BY `unit` DESC [ RunTime:0.047931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926482 LIMIT 2 [ RunTime:0.029113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926482 ORDER BY `minOrder` ASC [ RunTime:0.017358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799707 LIMIT 5 [ RunTime:0.035435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799707 ORDER BY `minOrder` ASC [ RunTime:0.001892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799707 ORDER BY `unit` DESC [ RunTime:0.013403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799707 LIMIT 2 [ RunTime:0.041711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799707 ORDER BY `minOrder` ASC [ RunTime:0.004086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919919 LIMIT 5 [ RunTime:0.009951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919919 ORDER BY `minOrder` ASC [ RunTime:0.038779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919919 ORDER BY `unit` DESC [ RunTime:0.019130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919919 LIMIT 2 [ RunTime:0.015029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919919 ORDER BY `minOrder` ASC [ RunTime:0.007684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830612 LIMIT 5 [ RunTime:0.004704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830612 ORDER BY `minOrder` ASC [ RunTime:0.015848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830612 ORDER BY `unit` DESC [ RunTime:0.012522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830612 LIMIT 2 [ RunTime:0.010880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830612 ORDER BY `minOrder` ASC [ RunTime:0.003378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803846 LIMIT 5 [ RunTime:0.015269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803846 ORDER BY `minOrder` ASC [ RunTime:0.011582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803846 ORDER BY `unit` DESC [ RunTime:0.002426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803846 LIMIT 2 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803846 ORDER BY `minOrder` ASC [ RunTime:0.007955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673402 LIMIT 5 [ RunTime:0.018776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673402 ORDER BY `minOrder` ASC [ RunTime:0.036426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673402 ORDER BY `unit` DESC [ RunTime:0.024948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673402 LIMIT 2 [ RunTime:0.004976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673402 ORDER BY `minOrder` ASC [ RunTime:0.005291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908691 LIMIT 5 [ RunTime:0.020378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908691 ORDER BY `minOrder` ASC [ RunTime:0.014519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908691 ORDER BY `unit` DESC [ RunTime:0.019642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908691 LIMIT 2 [ RunTime:0.008040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908691 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908168 LIMIT 5 [ RunTime:0.008821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908168 ORDER BY `minOrder` ASC [ RunTime:0.013997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908168 ORDER BY `unit` DESC [ RunTime:0.031031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908168 LIMIT 2 [ RunTime:0.041452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908168 ORDER BY `minOrder` ASC [ RunTime:0.048210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691727 LIMIT 5 [ RunTime:0.015965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691727 ORDER BY `minOrder` ASC [ RunTime:0.016519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691727 ORDER BY `unit` DESC [ RunTime:0.006096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691727 LIMIT 2 [ RunTime:0.008149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691727 ORDER BY `minOrder` ASC [ RunTime:0.008654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691483 LIMIT 5 [ RunTime:0.029465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691483 ORDER BY `minOrder` ASC [ RunTime:0.023936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691483 ORDER BY `unit` DESC [ RunTime:0.030418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691483 LIMIT 2 [ RunTime:0.034364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691483 ORDER BY `minOrder` ASC [ RunTime:0.029203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691184 LIMIT 5 [ RunTime:0.046986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691184 ORDER BY `minOrder` ASC [ RunTime:0.041101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691184 ORDER BY `unit` DESC [ RunTime:0.062847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691184 LIMIT 2 [ RunTime:0.042307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691184 ORDER BY `minOrder` ASC [ RunTime:0.011458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683182 LIMIT 5 [ RunTime:0.016158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683182 ORDER BY `minOrder` ASC [ RunTime:0.027846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683182 ORDER BY `unit` DESC [ RunTime:0.026019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683182 LIMIT 2 [ RunTime:0.010584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683182 ORDER BY `minOrder` ASC [ RunTime:0.007174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677467 LIMIT 5 [ RunTime:0.019831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677467 ORDER BY `minOrder` ASC [ RunTime:0.022320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677467 ORDER BY `unit` DESC [ RunTime:0.026727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677467 LIMIT 2 [ RunTime:0.048166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677467 ORDER BY `minOrder` ASC [ RunTime:0.005072s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056674s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160187 LIMIT 5 [ RunTime:0.036589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160187 ORDER BY `minOrder` ASC [ RunTime:0.036405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160187 ORDER BY `unit` DESC [ RunTime:0.032041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160187 LIMIT 2 [ RunTime:0.047430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160187 ORDER BY `minOrder` ASC [ RunTime:0.009023s ]
select * from pdf where partno='SMBJ51CAL0S0CZ' and brandshort='NextGen Components' limit 1 [ RunTime:0.024816s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CAL0S0CZ' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.016266s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160187 AND `partno` = 'SMBJ51CAL0S0CZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.087008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663420 [ RunTime:0.016899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147676 LIMIT 5 [ RunTime:0.050357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147676 ORDER BY `minOrder` ASC [ RunTime:0.039217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147676 ORDER BY `unit` DESC [ RunTime:0.003340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147676 LIMIT 2 [ RunTime:0.032123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147676 ORDER BY `minOrder` ASC [ RunTime:0.019718s ]
select * from pdf where partno='SMBJ51CA' and brandshort='MDD' limit 1 [ RunTime:0.040701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.032699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42095481 LIMIT 5 [ RunTime:0.029593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095481 ORDER BY `minOrder` ASC [ RunTime:0.041094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42095481 ORDER BY `unit` DESC [ RunTime:0.054807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42095481 LIMIT 2 [ RunTime:0.015432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095481 ORDER BY `minOrder` ASC [ RunTime:0.014642s ]
select * from pdf where partno='SMBJ51CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.036669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.020513s ]
SELECT `id` FROM `stock` WHERE `id` <> 42095481 AND `partno` = 'SMBJ51CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.029541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908992 [ RunTime:0.030871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101117 LIMIT 5 [ RunTime:0.012470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101117 ORDER BY `minOrder` ASC [ RunTime:0.035317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101117 ORDER BY `unit` DESC [ RunTime:0.029735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101117 LIMIT 2 [ RunTime:0.014179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101117 ORDER BY `minOrder` ASC [ RunTime:0.006387s ]
select * from pdf where partno='SMBJ51CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.019740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.013556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142592 LIMIT 5 [ RunTime:0.019376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142592 ORDER BY `minOrder` ASC [ RunTime:0.010955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142592 ORDER BY `unit` DESC [ RunTime:0.010047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142592 LIMIT 2 [ RunTime:0.007255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142592 ORDER BY `minOrder` ASC [ RunTime:0.002699s ]
select * from pdf where partno='SMBJ51CAHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CAHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009177s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142592 AND `partno` = 'SMBJ51CAHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.016408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812942 [ RunTime:0.017472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149499 LIMIT 5 [ RunTime:0.011214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149499 ORDER BY `minOrder` ASC [ RunTime:0.046551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149499 ORDER BY `unit` DESC [ RunTime:0.014382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149499 LIMIT 2 [ RunTime:0.001810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149499 ORDER BY `minOrder` ASC [ RunTime:0.002904s ]
select * from pdf where partno='SMBJ51CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.019298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.034273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128160 LIMIT 5 [ RunTime:0.016519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128160 ORDER BY `minOrder` ASC [ RunTime:0.010653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128160 ORDER BY `unit` DESC [ RunTime:0.039669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128160 LIMIT 2 [ RunTime:0.020094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128160 ORDER BY `minOrder` ASC [ RunTime:0.001999s ]
select * from pdf where partno='SMBJ51CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009803s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128160 AND `partno` = 'SMBJ51CA-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928201 [ RunTime:0.028028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42103011 LIMIT 5 [ RunTime:0.004649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103011 ORDER BY `minOrder` ASC [ RunTime:0.052736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42103011 ORDER BY `unit` DESC [ RunTime:0.020014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42103011 LIMIT 2 [ RunTime:0.015247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103011 ORDER BY `minOrder` ASC [ RunTime:0.009338s ]
select * from pdf where partno='SMBJ51CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016930s ]
SELECT `id` FROM `stock` WHERE `id` <> 42103011 AND `partno` = 'SMBJ51CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664431 [ RunTime:0.056166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143007 LIMIT 5 [ RunTime:0.025839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143007 ORDER BY `minOrder` ASC [ RunTime:0.052966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143007 ORDER BY `unit` DESC [ RunTime:0.045807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143007 LIMIT 2 [ RunTime:0.021786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143007 ORDER BY `minOrder` ASC [ RunTime:0.005673s ]
select * from pdf where partno='SMBJ51CA' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.022854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.034111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42126378 LIMIT 5 [ RunTime:0.026133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126378 ORDER BY `minOrder` ASC [ RunTime:0.027471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42126378 ORDER BY `unit` DESC [ RunTime:0.027465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42126378 LIMIT 2 [ RunTime:0.003098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126378 ORDER BY `minOrder` ASC [ RunTime:0.007146s ]
select * from pdf where partno='SMBJ51CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.022287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.029161s ]
SELECT `id` FROM `stock` WHERE `id` <> 42126378 AND `partno` = 'SMBJ51CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.031851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926482 [ RunTime:0.014594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141469 LIMIT 5 [ RunTime:0.021083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141469 ORDER BY `minOrder` ASC [ RunTime:0.061255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141469 ORDER BY `unit` DESC [ RunTime:0.025082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141469 LIMIT 2 [ RunTime:0.028901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141469 ORDER BY `minOrder` ASC [ RunTime:0.015865s ]
select * from pdf where partno='SMBJ51CAQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.024011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CAQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.012317s ]
SELECT `id` FROM `stock` WHERE `id` <> 42141469 AND `partno` = 'SMBJ51CAQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.021424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809334 [ RunTime:0.034714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42115564 LIMIT 5 [ RunTime:0.019158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115564 ORDER BY `minOrder` ASC [ RunTime:0.024965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42115564 ORDER BY `unit` DESC [ RunTime:0.017244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42115564 LIMIT 2 [ RunTime:0.020346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115564 ORDER BY `minOrder` ASC [ RunTime:0.002800s ]
select * from pdf where partno='SMBJ51CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.013793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.030672s ]
SELECT `id` FROM `stock` WHERE `id` <> 42115564 AND `partno` = 'SMBJ51CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.048605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674013 [ RunTime:0.033721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160976 LIMIT 5 [ RunTime:0.035396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160976 ORDER BY `minOrder` ASC [ RunTime:0.039772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160976 ORDER BY `unit` DESC [ RunTime:0.031531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160976 LIMIT 2 [ RunTime:0.007580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160976 ORDER BY `minOrder` ASC [ RunTime:0.029185s ]
select * from pdf where partno='SMBJ51CA' and brandshort='HY Electronic Cayman Limited' limit 1 [ RunTime:0.020481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'HY Electronic (Cayman) Limited%' ) ) LIMIT 1 [ RunTime:0.018933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127639 LIMIT 5 [ RunTime:0.014942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127639 ORDER BY `minOrder` ASC [ RunTime:0.025596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127639 ORDER BY `unit` DESC [ RunTime:0.032851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127639 LIMIT 2 [ RunTime:0.016344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127639 ORDER BY `minOrder` ASC [ RunTime:0.008869s ]
select * from pdf where partno='SMBJ51CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.013039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.015026s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127639 AND `partno` = 'SMBJ51CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.031179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830612 [ RunTime:0.017043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42140042 LIMIT 5 [ RunTime:0.009260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140042 ORDER BY `minOrder` ASC [ RunTime:0.040705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42140042 ORDER BY `unit` DESC [ RunTime:0.005143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42140042 LIMIT 2 [ RunTime:0.023887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140042 ORDER BY `minOrder` ASC [ RunTime:0.017847s ]
select * from pdf where partno='SMBJ51CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.010961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.020466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174957 LIMIT 5 [ RunTime:0.020183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174957 ORDER BY `minOrder` ASC [ RunTime:0.031691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174957 ORDER BY `unit` DESC [ RunTime:0.039969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174957 LIMIT 2 [ RunTime:0.039895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174957 ORDER BY `minOrder` ASC [ RunTime:0.009621s ]
select * from pdf where partno='SMBJ51CA' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.044624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.008722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168281 LIMIT 5 [ RunTime:0.050213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168281 ORDER BY `minOrder` ASC [ RunTime:0.024013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168281 ORDER BY `unit` DESC [ RunTime:0.024338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168281 LIMIT 2 [ RunTime:0.015020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168281 ORDER BY `minOrder` ASC [ RunTime:0.011956s ]
select * from pdf where partno='SMBJ51CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.033123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174965 LIMIT 5 [ RunTime:0.013573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174965 ORDER BY `minOrder` ASC [ RunTime:0.029451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174965 ORDER BY `unit` DESC [ RunTime:0.058710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174965 LIMIT 2 [ RunTime:0.028620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174965 ORDER BY `minOrder` ASC [ RunTime:0.021958s ]
select * from pdf where partno='SMBJ51CA' and brandshort='VIITOR SEMICONDUCTOR CO., LTD' limit 1 [ RunTime:0.012659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA' OR `brand` LIKE 'VIITOR SEMICONDUCTOR CO., LTD%' ) ) LIMIT 1 [ RunTime:0.022286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42409830 LIMIT 5 [ RunTime:0.031893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409830 ORDER BY `minOrder` ASC [ RunTime:0.043155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42409830 ORDER BY `unit` DESC [ RunTime:0.021965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42409830 LIMIT 2 [ RunTime:0.001936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42409830 ORDER BY `minOrder` ASC [ RunTime:0.002961s ]
select * from pdf where partno='SMBJ51CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.022654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.017313s ]
SELECT `id` FROM `stock` WHERE `id` <> 42409830 AND `partno` = 'SMBJ51CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.016630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924761 [ RunTime:0.026850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42398497 LIMIT 5 [ RunTime:0.041517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398497 ORDER BY `minOrder` ASC [ RunTime:0.020196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42398497 ORDER BY `unit` DESC [ RunTime:0.013299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42398497 LIMIT 2 [ RunTime:0.008296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42398497 ORDER BY `minOrder` ASC [ RunTime:0.010069s ]
select * from pdf where partno='SMBJ51CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.023662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.024891s ]
SELECT `id` FROM `stock` WHERE `id` <> 42398497 AND `partno` = 'SMBJ51CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.041719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683182 [ RunTime:0.029361s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030287s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028375s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038028s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025273s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016869s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016590s ]
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 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005583s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ51CA%' OR `brand` LIKE 'SMBJ51CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012855s ]