SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002129s ]
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=SMCJ170C&search=1' [ RunTime:0.008822s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002129s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000503s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002251s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.008410s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002311s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001976s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ170C' LIMIT 1 [ RunTime:0.009693s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 02:42:04' WHERE `partno` = 'SMCJ170C' [ RunTime:0.017645s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002345s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047471s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906787 LIMIT 5 [ RunTime:0.008983s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906787 ORDER BY `minOrder` ASC [ RunTime:0.008236s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906787 ORDER BY `unit` DESC [ RunTime:0.003194s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906787 LIMIT 2 [ RunTime:0.036289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906787 ORDER BY `minOrder` ASC [ RunTime:0.017098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690397 LIMIT 5 [ RunTime:0.028882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690397 ORDER BY `minOrder` ASC [ RunTime:0.030897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690397 ORDER BY `unit` DESC [ RunTime:0.014764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690397 LIMIT 2 [ RunTime:0.018776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690397 ORDER BY `minOrder` ASC [ RunTime:0.007361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692186 LIMIT 5 [ RunTime:0.033444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692186 ORDER BY `minOrder` ASC [ RunTime:0.016835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692186 ORDER BY `unit` DESC [ RunTime:0.022862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692186 LIMIT 2 [ RunTime:0.011082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692186 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808341 LIMIT 5 [ RunTime:0.008520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808341 ORDER BY `minOrder` ASC [ RunTime:0.009342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808341 ORDER BY `unit` DESC [ RunTime:0.033753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808341 LIMIT 2 [ RunTime:0.010792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808341 ORDER BY `minOrder` ASC [ RunTime:0.014389s ]
select * from pdf where partno='SMCJ170CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.018347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821043 LIMIT 5 [ RunTime:0.007106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821043 ORDER BY `minOrder` ASC [ RunTime:0.003691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821043 ORDER BY `unit` DESC [ RunTime:0.000769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821043 LIMIT 2 [ RunTime:0.004827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821043 ORDER BY `minOrder` ASC [ RunTime:0.002362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669894 LIMIT 5 [ RunTime:0.018791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669894 ORDER BY `minOrder` ASC [ RunTime:0.019096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669894 ORDER BY `unit` DESC [ RunTime:0.025374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669894 LIMIT 2 [ RunTime:0.000810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669894 ORDER BY `minOrder` ASC [ RunTime:0.009689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905144 LIMIT 5 [ RunTime:0.010540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905144 ORDER BY `minOrder` ASC [ RunTime:0.005588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905144 ORDER BY `unit` DESC [ RunTime:0.002435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905144 LIMIT 2 [ RunTime:0.005850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905144 ORDER BY `minOrder` ASC [ RunTime:0.003480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675895 LIMIT 5 [ RunTime:0.004036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675895 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675895 ORDER BY `unit` DESC [ RunTime:0.006054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675895 LIMIT 2 [ RunTime:0.011854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675895 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904367 LIMIT 5 [ RunTime:0.001811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904367 ORDER BY `minOrder` ASC [ RunTime:0.009097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904367 ORDER BY `unit` DESC [ RunTime:0.002923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904367 LIMIT 2 [ RunTime:0.004101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904367 ORDER BY `minOrder` ASC [ RunTime:0.013264s ]
select * from pdf where partno='SMCJ170CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908433 LIMIT 5 [ RunTime:0.003685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908433 ORDER BY `minOrder` ASC [ RunTime:0.015034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908433 ORDER BY `unit` DESC [ RunTime:0.014244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908433 LIMIT 2 [ RunTime:0.004236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908433 ORDER BY `minOrder` ASC [ RunTime:0.007259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692470 LIMIT 5 [ RunTime:0.002198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692470 ORDER BY `minOrder` ASC [ RunTime:0.001632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692470 ORDER BY `unit` DESC [ RunTime:0.008179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692470 LIMIT 2 [ RunTime:0.007981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692470 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692469 LIMIT 5 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692469 ORDER BY `minOrder` ASC [ RunTime:0.002205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692469 ORDER BY `unit` DESC [ RunTime:0.003547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692469 LIMIT 2 [ RunTime:0.018420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692469 ORDER BY `minOrder` ASC [ RunTime:0.008516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691527 LIMIT 5 [ RunTime:0.003727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691527 ORDER BY `minOrder` ASC [ RunTime:0.003191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691527 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691527 LIMIT 2 [ RunTime:0.002716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691527 ORDER BY `minOrder` ASC [ RunTime:0.007111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689660 LIMIT 5 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689660 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689660 ORDER BY `unit` DESC [ RunTime:0.007210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689660 LIMIT 2 [ RunTime:0.001423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689660 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689180 LIMIT 5 [ RunTime:0.000979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689180 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689180 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689180 LIMIT 2 [ RunTime:0.002083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689180 ORDER BY `minOrder` ASC [ RunTime:0.010323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689179 LIMIT 5 [ RunTime:0.007181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689179 ORDER BY `minOrder` ASC [ RunTime:0.024430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689179 ORDER BY `unit` DESC [ RunTime:0.001274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689179 LIMIT 2 [ RunTime:0.003076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689179 ORDER BY `minOrder` ASC [ RunTime:0.007570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689178 LIMIT 5 [ RunTime:0.002901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689178 ORDER BY `minOrder` ASC [ RunTime:0.002581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689178 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689178 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689178 ORDER BY `minOrder` ASC [ RunTime:0.001440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680228 LIMIT 5 [ RunTime:0.017913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680228 ORDER BY `minOrder` ASC [ RunTime:0.004130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680228 ORDER BY `unit` DESC [ RunTime:0.016695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680228 LIMIT 2 [ RunTime:0.029100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680228 ORDER BY `minOrder` ASC [ RunTime:0.009361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676370 LIMIT 5 [ RunTime:0.007223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676370 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676370 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676370 LIMIT 2 [ RunTime:0.002429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676370 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676295 LIMIT 5 [ RunTime:0.016588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676295 ORDER BY `minOrder` ASC [ RunTime:0.003461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676295 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676295 LIMIT 2 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676295 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023407s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161926 LIMIT 5 [ RunTime:0.010420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161926 ORDER BY `minOrder` ASC [ RunTime:0.015097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161926 ORDER BY `unit` DESC [ RunTime:0.007338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161926 LIMIT 2 [ RunTime:0.019723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161926 ORDER BY `minOrder` ASC [ RunTime:0.005640s ]
select * from pdf where partno='SMCJ170CA/TR13' and brandshort='Yageo America' limit 1 [ RunTime:0.026320s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA/TR13' OR `brand` LIKE 'Yageo America%' ) ) LIMIT 1 [ RunTime:0.003535s ]
SELECT `id` FROM `stock` WHERE `id` <> 42161926 AND `partno` = 'SMCJ170CA/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yageo america%' ) [ RunTime:0.004884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162978 LIMIT 5 [ RunTime:0.010973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162978 ORDER BY `minOrder` ASC [ RunTime:0.003853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162978 ORDER BY `unit` DESC [ RunTime:0.003145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162978 LIMIT 2 [ RunTime:0.004240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162978 ORDER BY `minOrder` ASC [ RunTime:0.001034s ]
select * from pdf where partno='SMCJ170CA' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.015278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007659s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162978 AND `partno` = 'SMCJ170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.002985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906787 [ RunTime:0.007807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106185 LIMIT 5 [ RunTime:0.001534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106185 ORDER BY `minOrder` ASC [ RunTime:0.005183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106185 ORDER BY `unit` DESC [ RunTime:0.002108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106185 LIMIT 2 [ RunTime:0.004762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106185 ORDER BY `minOrder` ASC [ RunTime:0.001836s ]
select * from pdf where partno='SMCJ170CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004663s ]
SELECT `id` FROM `stock` WHERE `id` <> 42106185 AND `partno` = 'SMCJ170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.003063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690397 [ RunTime:0.016605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155163 LIMIT 5 [ RunTime:0.001800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155163 ORDER BY `minOrder` ASC [ RunTime:0.012450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155163 ORDER BY `unit` DESC [ RunTime:0.007992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155163 LIMIT 2 [ RunTime:0.001819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155163 ORDER BY `minOrder` ASC [ RunTime:0.004673s ]
select * from pdf where partno='SMCJ170CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.010472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.000874s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155163 AND `partno` = 'SMCJ170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.002810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692186 [ RunTime:0.009952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117342 LIMIT 5 [ RunTime:0.009906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117342 ORDER BY `minOrder` ASC [ RunTime:0.003225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117342 ORDER BY `unit` DESC [ RunTime:0.000890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117342 LIMIT 2 [ RunTime:0.005638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117342 ORDER BY `minOrder` ASC [ RunTime:0.003057s ]
select * from pdf where partno='SMCJ170CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.004997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.006358s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117342 AND `partno` = 'SMCJ170CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.008570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821043 [ RunTime:0.004111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143022 LIMIT 5 [ RunTime:0.004457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143022 ORDER BY `minOrder` ASC [ RunTime:0.010608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143022 ORDER BY `unit` DESC [ RunTime:0.009179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143022 LIMIT 2 [ RunTime:0.008422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143022 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='SMCJ170CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000741s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143022 AND `partno` = 'SMCJ170CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909143 [ RunTime:0.002803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42110277 LIMIT 5 [ RunTime:0.005322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110277 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42110277 ORDER BY `unit` DESC [ RunTime:0.000312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42110277 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42110277 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='SMCJ170CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.000506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132628 LIMIT 5 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132628 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132628 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132628 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132628 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='SMCJ170CA-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000336s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132628 AND `partno` = 'SMCJ170CA-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675895 [ RunTime:0.000318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105555 LIMIT 5 [ RunTime:0.011294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105555 ORDER BY `minOrder` ASC [ RunTime:0.012587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105555 ORDER BY `unit` DESC [ RunTime:0.019205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105555 LIMIT 2 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105555 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='SMCJ170CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003263s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105555 AND `partno` = 'SMCJ170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669894 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42121578 LIMIT 5 [ RunTime:0.002372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42121578 ORDER BY `minOrder` ASC [ RunTime:0.006970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42121578 ORDER BY `unit` DESC [ RunTime:0.000482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42121578 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42121578 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='SMCJ170CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002019s ]
SELECT `id` FROM `stock` WHERE `id` <> 42121578 AND `partno` = 'SMCJ170CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.007024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904367 [ RunTime:0.000921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105557 LIMIT 5 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105557 ORDER BY `minOrder` ASC [ RunTime:0.006690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105557 ORDER BY `unit` DESC [ RunTime:0.005677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105557 LIMIT 2 [ RunTime:0.001874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105557 ORDER BY `minOrder` ASC [ RunTime:0.003894s ]
select * from pdf where partno='SMCJ170CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001429s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105557 AND `partno` = 'SMCJ170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.005650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808341 [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42415201 LIMIT 5 [ RunTime:0.006070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415201 ORDER BY `minOrder` ASC [ RunTime:0.002570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42415201 ORDER BY `unit` DESC [ RunTime:0.002426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42415201 LIMIT 2 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415201 ORDER BY `minOrder` ASC [ RunTime:0.006463s ]
select * from pdf where partno='SMCJ170CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000428s ]
SELECT `id` FROM `stock` WHERE `id` <> 42415201 AND `partno` = 'SMCJ170CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823970 [ RunTime:0.002079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42413406 LIMIT 5 [ RunTime:0.006120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413406 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42413406 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42413406 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413406 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
select * from pdf where partno='SMCJ170CA-HRAT7' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-HRAT7' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000380s ]
SELECT `id` FROM `stock` WHERE `id` <> 42413406 AND `partno` = 'SMCJ170CA-HRAT7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924882 [ RunTime:0.001981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42413405 LIMIT 5 [ RunTime:0.022136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413405 ORDER BY `minOrder` ASC [ RunTime:0.010272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42413405 ORDER BY `unit` DESC [ RunTime:0.002965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42413405 LIMIT 2 [ RunTime:0.005562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413405 ORDER BY `minOrder` ASC [ RunTime:0.008194s ]
select * from pdf where partno='SMCJ170CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008761s ]
SELECT `id` FROM `stock` WHERE `id` <> 42413405 AND `partno` = 'SMCJ170CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823772 [ RunTime:0.002635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42311509 LIMIT 5 [ RunTime:0.011587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42311509 ORDER BY `minOrder` ASC [ RunTime:0.017520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42311509 ORDER BY `unit` DESC [ RunTime:0.024266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42311509 LIMIT 2 [ RunTime:0.014433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42311509 ORDER BY `minOrder` ASC [ RunTime:0.010298s ]
select * from pdf where partno='SMCJ170CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.013828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.015073s ]
SELECT `id` FROM `stock` WHERE `id` <> 42311509 AND `partno` = 'SMCJ170CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.035741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680228 [ RunTime:0.034732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42290570 LIMIT 5 [ RunTime:0.003046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290570 ORDER BY `minOrder` ASC [ RunTime:0.002988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42290570 ORDER BY `unit` DESC [ RunTime:0.001221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42290570 LIMIT 2 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290570 ORDER BY `minOrder` ASC [ RunTime:0.002223s ]
select * from pdf where partno='SMCJ170CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.005537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.005069s ]
SELECT `id` FROM `stock` WHERE `id` <> 42290570 AND `partno` = 'SMCJ170CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.011367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818182 [ RunTime:0.022101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42290569 LIMIT 5 [ RunTime:0.002537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290569 ORDER BY `minOrder` ASC [ RunTime:0.005298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42290569 ORDER BY `unit` DESC [ RunTime:0.002663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42290569 LIMIT 2 [ RunTime:0.001714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290569 ORDER BY `minOrder` ASC [ RunTime:0.001046s ]
select * from pdf where partno='SMCJ170CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.000566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.003411s ]
SELECT `id` FROM `stock` WHERE `id` <> 42290569 AND `partno` = 'SMCJ170CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818181 [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42284733 LIMIT 5 [ RunTime:0.005288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284733 ORDER BY `minOrder` ASC [ RunTime:0.003463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42284733 ORDER BY `unit` DESC [ RunTime:0.011938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42284733 LIMIT 2 [ RunTime:0.017678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284733 ORDER BY `minOrder` ASC [ RunTime:0.003639s ]
select * from pdf where partno='SMCJ170CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000767s ]
SELECT `id` FROM `stock` WHERE `id` <> 42284733 AND `partno` = 'SMCJ170CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918589 [ RunTime:0.002783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42282420 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282420 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42282420 ORDER BY `unit` DESC [ RunTime:0.000245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42282420 LIMIT 2 [ RunTime:0.000271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42282420 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='SMCJ170CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000271s ]
SELECT `id` FROM `stock` WHERE `id` <> 42282420 AND `partno` = 'SMCJ170CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676370 [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42281832 LIMIT 5 [ RunTime:0.003913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281832 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42281832 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42281832 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281832 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='SMCJ170CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ170CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000279s ]
SELECT `id` FROM `stock` WHERE `id` <> 42281832 AND `partno` = 'SMCJ170CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816344 [ RunTime:0.002141s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001389s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009891s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005611s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006665s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007379s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014058s ]
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 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023185s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ170C%' OR `brand` LIKE 'SMCJ170C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020330s ]