SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001003s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.251' , `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=ADA600F-24&search=1' [ RunTime:0.020251s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002002s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000549s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002488s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.251' ) [ RunTime:0.005302s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002840s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002302s ]
SELECT * FROM `stock_search` WHERE `partno` = 'ADA600F-24' LIMIT 1 [ RunTime:0.037019s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 03:02:57' WHERE `partno` = 'ADA600F-24' [ RunTime:0.008415s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002633s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019317s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008020 LIMIT 5 [ RunTime:0.019231s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008020 ORDER BY `minOrder` ASC [ RunTime:0.034859s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15008020 ORDER BY `unit` DESC [ RunTime:0.043381s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.021569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15008020 LIMIT 2 [ RunTime:0.025763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008020 ORDER BY `minOrder` ASC [ RunTime:0.030397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008015 LIMIT 5 [ RunTime:0.015916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008015 ORDER BY `minOrder` ASC [ RunTime:0.072381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15008015 ORDER BY `unit` DESC [ RunTime:0.019903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15008015 LIMIT 2 [ RunTime:0.044057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008015 ORDER BY `minOrder` ASC [ RunTime:0.026726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008001 LIMIT 5 [ RunTime:0.005624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008001 ORDER BY `minOrder` ASC [ RunTime:0.033907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15008001 ORDER BY `unit` DESC [ RunTime:0.007431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15008001 LIMIT 2 [ RunTime:0.017933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008001 ORDER BY `minOrder` ASC [ RunTime:0.013203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15007997 LIMIT 5 [ RunTime:0.031547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15007997 ORDER BY `minOrder` ASC [ RunTime:0.054085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15007997 ORDER BY `unit` DESC [ RunTime:0.014263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15007997 LIMIT 2 [ RunTime:0.054811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15007997 ORDER BY `minOrder` ASC [ RunTime:0.013823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14068168 LIMIT 5 [ RunTime:0.043033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068168 ORDER BY `minOrder` ASC [ RunTime:0.073078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14068168 ORDER BY `unit` DESC [ RunTime:0.061599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14068168 LIMIT 2 [ RunTime:0.039938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14068168 ORDER BY `minOrder` ASC [ RunTime:0.015529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12090206 LIMIT 5 [ RunTime:0.029081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12090206 ORDER BY `minOrder` ASC [ RunTime:0.055354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12090206 ORDER BY `unit` DESC [ RunTime:0.070820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12090206 LIMIT 2 [ RunTime:0.028773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12090206 ORDER BY `minOrder` ASC [ RunTime:0.017094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089537 LIMIT 5 [ RunTime:0.025183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089537 ORDER BY `minOrder` ASC [ RunTime:0.044240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12089537 ORDER BY `unit` DESC [ RunTime:0.036304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12089537 LIMIT 2 [ RunTime:0.061760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089537 ORDER BY `minOrder` ASC [ RunTime:0.014810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089232 LIMIT 5 [ RunTime:0.106918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089232 ORDER BY `minOrder` ASC [ RunTime:0.080946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12089232 ORDER BY `unit` DESC [ RunTime:0.057441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12089232 LIMIT 2 [ RunTime:0.074405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089232 ORDER BY `minOrder` ASC [ RunTime:0.045248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089221 LIMIT 5 [ RunTime:0.040239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089221 ORDER BY `minOrder` ASC [ RunTime:0.057581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12089221 ORDER BY `unit` DESC [ RunTime:0.110522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12089221 LIMIT 2 [ RunTime:0.089198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089221 ORDER BY `minOrder` ASC [ RunTime:0.028226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089220 LIMIT 5 [ RunTime:0.035786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089220 ORDER BY `minOrder` ASC [ RunTime:0.044042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12089220 ORDER BY `unit` DESC [ RunTime:0.008081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12089220 LIMIT 2 [ RunTime:0.057034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12089220 ORDER BY `minOrder` ASC [ RunTime:0.003733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088729 LIMIT 5 [ RunTime:0.060900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088729 ORDER BY `minOrder` ASC [ RunTime:0.055149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12088729 ORDER BY `unit` DESC [ RunTime:0.107585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12088729 LIMIT 2 [ RunTime:0.078526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088729 ORDER BY `minOrder` ASC [ RunTime:0.016594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088710 LIMIT 5 [ RunTime:0.039890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088710 ORDER BY `minOrder` ASC [ RunTime:0.058825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12088710 ORDER BY `unit` DESC [ RunTime:0.046865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12088710 LIMIT 2 [ RunTime:0.068423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088710 ORDER BY `minOrder` ASC [ RunTime:0.020542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088497 LIMIT 5 [ RunTime:0.039446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088497 ORDER BY `minOrder` ASC [ RunTime:0.034469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12088497 ORDER BY `unit` DESC [ RunTime:0.048767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12088497 LIMIT 2 [ RunTime:0.047003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088497 ORDER BY `minOrder` ASC [ RunTime:0.015111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088496 LIMIT 5 [ RunTime:0.045945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088496 ORDER BY `minOrder` ASC [ RunTime:0.055406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12088496 ORDER BY `unit` DESC [ RunTime:0.050724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12088496 LIMIT 2 [ RunTime:0.028479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088496 ORDER BY `minOrder` ASC [ RunTime:0.033116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088488 LIMIT 5 [ RunTime:0.008668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088488 ORDER BY `minOrder` ASC [ RunTime:0.036881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12088488 ORDER BY `unit` DESC [ RunTime:0.050146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12088488 LIMIT 2 [ RunTime:0.029217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12088488 ORDER BY `minOrder` ASC [ RunTime:0.019177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087995 LIMIT 5 [ RunTime:0.024412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087995 ORDER BY `minOrder` ASC [ RunTime:0.020190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12087995 ORDER BY `unit` DESC [ RunTime:0.040973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12087995 LIMIT 2 [ RunTime:0.047002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087995 ORDER BY `minOrder` ASC [ RunTime:0.020191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087989 LIMIT 5 [ RunTime:0.041285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087989 ORDER BY `minOrder` ASC [ RunTime:0.030135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12087989 ORDER BY `unit` DESC [ RunTime:0.021513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12087989 LIMIT 2 [ RunTime:0.026933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087989 ORDER BY `minOrder` ASC [ RunTime:0.026274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087988 LIMIT 5 [ RunTime:0.022776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087988 ORDER BY `minOrder` ASC [ RunTime:0.023623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12087988 ORDER BY `unit` DESC [ RunTime:0.032762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12087988 LIMIT 2 [ RunTime:0.024666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087988 ORDER BY `minOrder` ASC [ RunTime:0.045310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087934 LIMIT 5 [ RunTime:0.023710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087934 ORDER BY `minOrder` ASC [ RunTime:0.052590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12087934 ORDER BY `unit` DESC [ RunTime:0.024912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12087934 LIMIT 2 [ RunTime:0.010180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087934 ORDER BY `minOrder` ASC [ RunTime:0.009316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12087933 LIMIT 5 [ RunTime:0.019679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087933 ORDER BY `minOrder` ASC [ RunTime:0.007386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12087933 ORDER BY `unit` DESC [ RunTime:0.012757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12087933 LIMIT 2 [ RunTime:0.002350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12087933 ORDER BY `minOrder` ASC [ RunTime:0.010480s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017988s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57806656 LIMIT 5 [ RunTime:0.022569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806656 ORDER BY `minOrder` ASC [ RunTime:0.023520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57806656 ORDER BY `unit` DESC [ RunTime:0.003789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57806656 LIMIT 2 [ RunTime:0.013692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806656 ORDER BY `minOrder` ASC [ RunTime:0.013353s ]
select * from pdf where partno='ADA600F-24-FN1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.030442s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-FN1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.008867s ]
SELECT `id` FROM `stock` WHERE `id` <> 57806656 AND `partno` = 'ADA600F-24-FN1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.024045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008020 [ RunTime:0.026446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57806641 LIMIT 5 [ RunTime:0.022211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806641 ORDER BY `minOrder` ASC [ RunTime:0.023603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57806641 ORDER BY `unit` DESC [ RunTime:0.003385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57806641 LIMIT 2 [ RunTime:0.011928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806641 ORDER BY `minOrder` ASC [ RunTime:0.004121s ]
select * from pdf where partno='ADA600F-24-CN1W' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.010704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-CN1W' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.016937s ]
SELECT `id` FROM `stock` WHERE `id` <> 57806641 AND `partno` = 'ADA600F-24-CN1W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.040423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008015 [ RunTime:0.022666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57806612 LIMIT 5 [ RunTime:0.024543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806612 ORDER BY `minOrder` ASC [ RunTime:0.028480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57806612 ORDER BY `unit` DESC [ RunTime:0.008737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57806612 LIMIT 2 [ RunTime:0.026274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806612 ORDER BY `minOrder` ASC [ RunTime:0.028713s ]
select * from pdf where partno='ADA600F-24-N1W' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.021913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-N1W' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.023511s ]
SELECT `id` FROM `stock` WHERE `id` <> 57806612 AND `partno` = 'ADA600F-24-N1W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.049324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14068168 [ RunTime:0.041699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57806609 LIMIT 5 [ RunTime:0.013220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806609 ORDER BY `minOrder` ASC [ RunTime:0.096339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57806609 ORDER BY `unit` DESC [ RunTime:0.072574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57806609 LIMIT 2 [ RunTime:0.047837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806609 ORDER BY `minOrder` ASC [ RunTime:0.010520s ]
select * from pdf where partno='ADA600F-24-N1U' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.010715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-N1U' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.024226s ]
SELECT `id` FROM `stock` WHERE `id` <> 57806609 AND `partno` = 'ADA600F-24-N1U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.022687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008001 [ RunTime:0.035090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57806605 LIMIT 5 [ RunTime:0.013425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806605 ORDER BY `minOrder` ASC [ RunTime:0.013688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57806605 ORDER BY `unit` DESC [ RunTime:0.055076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57806605 LIMIT 2 [ RunTime:0.014444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57806605 ORDER BY `minOrder` ASC [ RunTime:0.020586s ]
select * from pdf where partno='ADA600F-24-N1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.029652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-N1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.025610s ]
SELECT `id` FROM `stock` WHERE `id` <> 57806605 AND `partno` = 'ADA600F-24-N1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.009632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15007997 [ RunTime:0.013272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41648819 LIMIT 5 [ RunTime:0.026278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41648819 ORDER BY `minOrder` ASC [ RunTime:0.022184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41648819 ORDER BY `unit` DESC [ RunTime:0.047329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41648819 LIMIT 2 [ RunTime:0.051402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41648819 ORDER BY `minOrder` ASC [ RunTime:0.003465s ]
select * from pdf where partno='ADA600F-24-CF' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.043878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-CF' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.035749s ]
SELECT `id` FROM `stock` WHERE `id` <> 41648819 AND `partno` = 'ADA600F-24-CF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.043386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12090206 [ RunTime:0.015883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41645866 LIMIT 5 [ RunTime:0.026112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41645866 ORDER BY `minOrder` ASC [ RunTime:0.041002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41645866 ORDER BY `unit` DESC [ RunTime:0.028822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41645866 LIMIT 2 [ RunTime:0.017800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41645866 ORDER BY `minOrder` ASC [ RunTime:0.016863s ]
select * from pdf where partno='ADA600F-24-F' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.013168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-F' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.019456s ]
SELECT `id` FROM `stock` WHERE `id` <> 41645866 AND `partno` = 'ADA600F-24-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.060897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089537 [ RunTime:0.044813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41645849 LIMIT 5 [ RunTime:0.022805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41645849 ORDER BY `minOrder` ASC [ RunTime:0.011931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41645849 ORDER BY `unit` DESC [ RunTime:0.005331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41645849 LIMIT 2 [ RunTime:0.006207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41645849 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='ADA600F-24-FU' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.038117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-FU' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.009000s ]
SELECT `id` FROM `stock` WHERE `id` <> 41645849 AND `partno` = 'ADA600F-24-FU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.010530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41645848 LIMIT 5 [ RunTime:0.003587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41645848 ORDER BY `minOrder` ASC [ RunTime:0.011052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41645848 ORDER BY `unit` DESC [ RunTime:0.012980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41645848 LIMIT 2 [ RunTime:0.004191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41645848 ORDER BY `minOrder` ASC [ RunTime:0.011351s ]
select * from pdf where partno='ADA600F-24-FT' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.019441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-FT' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.003713s ]
SELECT `id` FROM `stock` WHERE `id` <> 41645848 AND `partno` = 'ADA600F-24-FT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.004766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41644680 LIMIT 5 [ RunTime:0.014325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644680 ORDER BY `minOrder` ASC [ RunTime:0.017481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41644680 ORDER BY `unit` DESC [ RunTime:0.033960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41644680 LIMIT 2 [ RunTime:0.010323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644680 ORDER BY `minOrder` ASC [ RunTime:0.016451s ]
select * from pdf where partno='ADA600F-24-FM' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.019380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-FM' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.023143s ]
SELECT `id` FROM `stock` WHERE `id` <> 41644680 AND `partno` = 'ADA600F-24-FM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.077065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089232 [ RunTime:0.044588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41644676 LIMIT 5 [ RunTime:0.022770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644676 ORDER BY `minOrder` ASC [ RunTime:0.003391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41644676 ORDER BY `unit` DESC [ RunTime:0.008614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41644676 LIMIT 2 [ RunTime:0.014352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644676 ORDER BY `minOrder` ASC [ RunTime:0.007451s ]
select * from pdf where partno='ADA600F-24-EFU' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.026738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-EFU' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.009868s ]
SELECT `id` FROM `stock` WHERE `id` <> 41644676 AND `partno` = 'ADA600F-24-EFU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.019139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41644675 LIMIT 5 [ RunTime:0.061135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644675 ORDER BY `minOrder` ASC [ RunTime:0.027398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41644675 ORDER BY `unit` DESC [ RunTime:0.027480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41644675 LIMIT 2 [ RunTime:0.107158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644675 ORDER BY `minOrder` ASC [ RunTime:0.013342s ]
select * from pdf where partno='ADA600F-24-EFT' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.030399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-EFT' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.028466s ]
SELECT `id` FROM `stock` WHERE `id` <> 41644675 AND `partno` = 'ADA600F-24-EFT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.033231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41644613 LIMIT 5 [ RunTime:0.026853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644613 ORDER BY `minOrder` ASC [ RunTime:0.044750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41644613 ORDER BY `unit` DESC [ RunTime:0.075386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41644613 LIMIT 2 [ RunTime:0.037867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644613 ORDER BY `minOrder` ASC [ RunTime:0.002493s ]
select * from pdf where partno='ADA600F-24-FW' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.050008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-FW' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.016204s ]
SELECT `id` FROM `stock` WHERE `id` <> 41644613 AND `partno` = 'ADA600F-24-FW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.041003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089221 [ RunTime:0.018459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41644612 LIMIT 5 [ RunTime:0.022058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644612 ORDER BY `minOrder` ASC [ RunTime:0.014516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41644612 ORDER BY `unit` DESC [ RunTime:0.028797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41644612 LIMIT 2 [ RunTime:0.001992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644612 ORDER BY `minOrder` ASC [ RunTime:0.007239s ]
select * from pdf where partno='ADA600F-24-FR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.011300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-FR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.012420s ]
SELECT `id` FROM `stock` WHERE `id` <> 41644612 AND `partno` = 'ADA600F-24-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.031549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41644611 LIMIT 5 [ RunTime:0.020311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644611 ORDER BY `minOrder` ASC [ RunTime:0.011009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41644611 ORDER BY `unit` DESC [ RunTime:0.024155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41644611 LIMIT 2 [ RunTime:0.035457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644611 ORDER BY `minOrder` ASC [ RunTime:0.018301s ]
select * from pdf where partno='ADA600F-24-EF' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.027011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-EF' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.044952s ]
SELECT `id` FROM `stock` WHERE `id` <> 41644611 AND `partno` = 'ADA600F-24-EF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.018431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41644610 LIMIT 5 [ RunTime:0.009887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644610 ORDER BY `minOrder` ASC [ RunTime:0.015571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41644610 ORDER BY `unit` DESC [ RunTime:0.026694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41644610 LIMIT 2 [ RunTime:0.039422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41644610 ORDER BY `minOrder` ASC [ RunTime:0.013426s ]
select * from pdf where partno='ADA600F-24-CN1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.026602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-CN1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.017138s ]
SELECT `id` FROM `stock` WHERE `id` <> 41644610 AND `partno` = 'ADA600F-24-CN1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.016809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12089220 [ RunTime:0.007782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41642940 LIMIT 5 [ RunTime:0.026064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642940 ORDER BY `minOrder` ASC [ RunTime:0.010869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41642940 ORDER BY `unit` DESC [ RunTime:0.004924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41642940 LIMIT 2 [ RunTime:0.005444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642940 ORDER BY `minOrder` ASC [ RunTime:0.003799s ]
select * from pdf where partno='ADA600F-24-CM' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.073029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-CM' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.027843s ]
SELECT `id` FROM `stock` WHERE `id` <> 41642940 AND `partno` = 'ADA600F-24-CM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.078628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088729 [ RunTime:0.015984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41642898 LIMIT 5 [ RunTime:0.036652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642898 ORDER BY `minOrder` ASC [ RunTime:0.033057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41642898 ORDER BY `unit` DESC [ RunTime:0.027027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41642898 LIMIT 2 [ RunTime:0.037879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642898 ORDER BY `minOrder` ASC [ RunTime:0.015943s ]
select * from pdf where partno='ADA600F-24-CW' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.011358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-CW' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.039563s ]
SELECT `id` FROM `stock` WHERE `id` <> 41642898 AND `partno` = 'ADA600F-24-CW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.061532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11132008 [ RunTime:0.011615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41642897 LIMIT 5 [ RunTime:0.024780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642897 ORDER BY `minOrder` ASC [ RunTime:0.018935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41642897 ORDER BY `unit` DESC [ RunTime:0.032907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41642897 LIMIT 2 [ RunTime:0.014239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642897 ORDER BY `minOrder` ASC [ RunTime:0.047325s ]
select * from pdf where partno='ADA600F-24-CR' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.052472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-CR' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.040158s ]
SELECT `id` FROM `stock` WHERE `id` <> 41642897 AND `partno` = 'ADA600F-24-CR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.014484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088710 [ RunTime:0.011835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41642476 LIMIT 5 [ RunTime:0.021937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642476 ORDER BY `minOrder` ASC [ RunTime:0.075479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41642476 ORDER BY `unit` DESC [ RunTime:0.033775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41642476 LIMIT 2 [ RunTime:0.037066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41642476 ORDER BY `minOrder` ASC [ RunTime:0.042900s ]
select * from pdf where partno='ADA600F-24-CU' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.033583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADA600F-24-CU' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.007426s ]
SELECT `id` FROM `stock` WHERE `id` <> 41642476 AND `partno` = 'ADA600F-24-CU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.027660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12088497 [ RunTime:0.047120s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015372s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048282s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018417s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012376s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022818s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030150s ]
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 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052232s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ADA600F-24%' OR `brand` LIKE 'ADA600F-24%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023895s ]