SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001385s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=SMBJ200A&search=1' [ RunTime:0.004316s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001459s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000659s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001228s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001547s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001045s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001812s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ200A' LIMIT 1 [ RunTime:0.013495s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-17 19:39:54' WHERE `partno` = 'SMBJ200A' [ RunTime:0.016764s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001880s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010522s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663727 LIMIT 5 [ RunTime:0.020674s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663727 ORDER BY `minOrder` ASC [ RunTime:0.017689s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663727 ORDER BY `unit` DESC [ RunTime:0.011033s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.016023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663727 LIMIT 2 [ RunTime:0.002106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663727 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906729 LIMIT 5 [ RunTime:0.007722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906729 ORDER BY `minOrder` ASC [ RunTime:0.020222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906729 ORDER BY `unit` DESC [ RunTime:0.008056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906729 LIMIT 2 [ RunTime:0.023294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906729 ORDER BY `minOrder` ASC [ RunTime:0.014221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663781 LIMIT 5 [ RunTime:0.035433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663781 ORDER BY `minOrder` ASC [ RunTime:0.030660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663781 ORDER BY `unit` DESC [ RunTime:0.029662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663781 LIMIT 2 [ RunTime:0.041929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663781 ORDER BY `minOrder` ASC [ RunTime:0.005791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673271 LIMIT 5 [ RunTime:0.031455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673271 ORDER BY `minOrder` ASC [ RunTime:0.024254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673271 ORDER BY `unit` DESC [ RunTime:0.044251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673271 LIMIT 2 [ RunTime:0.044538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673271 ORDER BY `minOrder` ASC [ RunTime:0.020297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816376 LIMIT 5 [ RunTime:0.027640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816376 ORDER BY `minOrder` ASC [ RunTime:0.019470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816376 ORDER BY `unit` DESC [ RunTime:0.030618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816376 LIMIT 2 [ RunTime:0.038378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816376 ORDER BY `minOrder` ASC [ RunTime:0.011721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926152 LIMIT 5 [ RunTime:0.028193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926152 ORDER BY `minOrder` ASC [ RunTime:0.038686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926152 ORDER BY `unit` DESC [ RunTime:0.040809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926152 LIMIT 2 [ RunTime:0.046643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926152 ORDER BY `minOrder` ASC [ RunTime:0.023681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661485 LIMIT 5 [ RunTime:0.028726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661485 ORDER BY `minOrder` ASC [ RunTime:0.014617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661485 ORDER BY `unit` DESC [ RunTime:0.012050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661485 LIMIT 2 [ RunTime:0.041655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661485 ORDER BY `minOrder` ASC [ RunTime:0.024387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664337 LIMIT 5 [ RunTime:0.042754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664337 ORDER BY `minOrder` ASC [ RunTime:0.030505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664337 ORDER BY `unit` DESC [ RunTime:0.023631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664337 LIMIT 2 [ RunTime:0.007492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664337 ORDER BY `minOrder` ASC [ RunTime:0.017910s ]
select * from pdf where partno='SMBJ200A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.058968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671071 LIMIT 5 [ RunTime:0.034266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671071 ORDER BY `minOrder` ASC [ RunTime:0.024783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671071 ORDER BY `unit` DESC [ RunTime:0.027496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671071 LIMIT 2 [ RunTime:0.028213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671071 ORDER BY `minOrder` ASC [ RunTime:0.014511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669252 LIMIT 5 [ RunTime:0.034323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669252 ORDER BY `minOrder` ASC [ RunTime:0.014672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669252 ORDER BY `unit` DESC [ RunTime:0.004772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669252 LIMIT 2 [ RunTime:0.003872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669252 ORDER BY `minOrder` ASC [ RunTime:0.006826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833910 LIMIT 5 [ RunTime:0.026500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833910 ORDER BY `minOrder` ASC [ RunTime:0.028128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833910 ORDER BY `unit` DESC [ RunTime:0.025080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833910 LIMIT 2 [ RunTime:0.009556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833910 ORDER BY `minOrder` ASC [ RunTime:0.013440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813575 LIMIT 5 [ RunTime:0.032376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813575 ORDER BY `minOrder` ASC [ RunTime:0.020186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813575 ORDER BY `unit` DESC [ RunTime:0.001011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813575 LIMIT 2 [ RunTime:0.015314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813575 ORDER BY `minOrder` ASC [ RunTime:0.009631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810061 LIMIT 5 [ RunTime:0.011705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810061 ORDER BY `minOrder` ASC [ RunTime:0.005743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810061 ORDER BY `unit` DESC [ RunTime:0.003098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810061 LIMIT 2 [ RunTime:0.008572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810061 ORDER BY `minOrder` ASC [ RunTime:0.002533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809764 LIMIT 5 [ RunTime:0.009748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809764 ORDER BY `minOrder` ASC [ RunTime:0.013060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809764 ORDER BY `unit` DESC [ RunTime:0.007713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809764 LIMIT 2 [ RunTime:0.004881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809764 ORDER BY `minOrder` ASC [ RunTime:0.001502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807618 LIMIT 5 [ RunTime:0.016623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807618 ORDER BY `minOrder` ASC [ RunTime:0.020292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807618 ORDER BY `unit` DESC [ RunTime:0.041770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807618 LIMIT 2 [ RunTime:0.005455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807618 ORDER BY `minOrder` ASC [ RunTime:0.004762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807179 LIMIT 5 [ RunTime:0.022700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807179 ORDER BY `minOrder` ASC [ RunTime:0.020640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807179 ORDER BY `unit` DESC [ RunTime:0.014346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807179 LIMIT 2 [ RunTime:0.023841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807179 ORDER BY `minOrder` ASC [ RunTime:0.003302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805570 LIMIT 5 [ RunTime:0.014487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805570 ORDER BY `minOrder` ASC [ RunTime:0.008007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805570 ORDER BY `unit` DESC [ RunTime:0.012475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805570 LIMIT 2 [ RunTime:0.030769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805570 ORDER BY `minOrder` ASC [ RunTime:0.027926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919242 LIMIT 5 [ RunTime:0.016318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919242 ORDER BY `minOrder` ASC [ RunTime:0.004800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919242 ORDER BY `unit` DESC [ RunTime:0.010563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919242 LIMIT 2 [ RunTime:0.026153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919242 ORDER BY `minOrder` ASC [ RunTime:0.017245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911125 LIMIT 5 [ RunTime:0.011007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911125 ORDER BY `minOrder` ASC [ RunTime:0.002635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911125 ORDER BY `unit` DESC [ RunTime:0.010276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911125 LIMIT 2 [ RunTime:0.011700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911125 ORDER BY `minOrder` ASC [ RunTime:0.029807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908781 LIMIT 5 [ RunTime:0.015102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908781 ORDER BY `minOrder` ASC [ RunTime:0.013370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908781 ORDER BY `unit` DESC [ RunTime:0.011794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908781 LIMIT 2 [ RunTime:0.001677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908781 ORDER BY `minOrder` ASC [ RunTime:0.014104s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141312 LIMIT 5 [ RunTime:0.036863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141312 ORDER BY `minOrder` ASC [ RunTime:0.018549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141312 ORDER BY `unit` DESC [ RunTime:0.033755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141312 LIMIT 2 [ RunTime:0.020361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141312 ORDER BY `minOrder` ASC [ RunTime:0.027689s ]
select * from pdf where partno='smbj200a/tr13' and brandshort='yageo' limit 1 [ RunTime:0.016644s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbj200a/tr13' OR `brand` LIKE 'yageo%' ) ) LIMIT 1 [ RunTime:0.029573s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162569 LIMIT 5 [ RunTime:0.031792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162569 ORDER BY `minOrder` ASC [ RunTime:0.069076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162569 ORDER BY `unit` DESC [ RunTime:0.067477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162569 LIMIT 2 [ RunTime:0.042659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162569 ORDER BY `minOrder` ASC [ RunTime:0.027322s ]
select * from pdf where partno='SMBJ200A' and brandshort='MDD' limit 1 [ RunTime:0.149098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.054076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161913 LIMIT 5 [ RunTime:0.048322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161913 ORDER BY `minOrder` ASC [ RunTime:0.049122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161913 ORDER BY `unit` DESC [ RunTime:0.015436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161913 LIMIT 2 [ RunTime:0.038881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161913 ORDER BY `minOrder` ASC [ RunTime:0.019020s ]
select * from pdf where partno='SMBJ200AL0S0PW' and brandshort='NextGen Components' limit 1 [ RunTime:0.063405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200AL0S0PW' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.031029s ]
SELECT `id` FROM `stock` WHERE `id` <> 42161913 AND `partno` = 'SMBJ200AL0S0PW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.014807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906729 [ RunTime:0.041839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117024 LIMIT 5 [ RunTime:0.075804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117024 ORDER BY `minOrder` ASC [ RunTime:0.062547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117024 ORDER BY `unit` DESC [ RunTime:0.035029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117024 LIMIT 2 [ RunTime:0.017657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117024 ORDER BY `minOrder` ASC [ RunTime:0.048448s ]
select * from pdf where partno='SMBJ200A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.052938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.052505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42131172 LIMIT 5 [ RunTime:0.101840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131172 ORDER BY `minOrder` ASC [ RunTime:0.012053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42131172 ORDER BY `unit` DESC [ RunTime:0.019645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42131172 LIMIT 2 [ RunTime:0.056488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42131172 ORDER BY `minOrder` ASC [ RunTime:0.011870s ]
select * from pdf where partno='SMBJ200A-QH' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.042186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-QH' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.038710s ]
SELECT `id` FROM `stock` WHERE `id` <> 42131172 AND `partno` = 'SMBJ200A-QH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.043647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926152 [ RunTime:0.032903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168793 LIMIT 5 [ RunTime:0.063425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168793 ORDER BY `minOrder` ASC [ RunTime:0.088073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168793 ORDER BY `unit` DESC [ RunTime:0.044448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168793 LIMIT 2 [ RunTime:0.028273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168793 ORDER BY `minOrder` ASC [ RunTime:0.001490s ]
select * from pdf where partno='SMBJ200A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.035777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.076396s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168793 AND `partno` = 'SMBJ200A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.049272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661485 [ RunTime:0.074572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42167849 LIMIT 5 [ RunTime:0.012004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167849 ORDER BY `minOrder` ASC [ RunTime:0.043344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42167849 ORDER BY `unit` DESC [ RunTime:0.023739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42167849 LIMIT 2 [ RunTime:0.031536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167849 ORDER BY `minOrder` ASC [ RunTime:0.007339s ]
select * from pdf where partno='SMBJ200A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.030500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.039062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168374 LIMIT 5 [ RunTime:0.039673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168374 ORDER BY `minOrder` ASC [ RunTime:0.045135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168374 ORDER BY `unit` DESC [ RunTime:0.046180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168374 LIMIT 2 [ RunTime:0.030014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168374 ORDER BY `minOrder` ASC [ RunTime:0.026682s ]
select * from pdf where partno='SMBJ200A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.026519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.035017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42175083 LIMIT 5 [ RunTime:0.053150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42175083 ORDER BY `minOrder` ASC [ RunTime:0.046628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42175083 ORDER BY `unit` DESC [ RunTime:0.016430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42175083 LIMIT 2 [ RunTime:0.031731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42175083 ORDER BY `minOrder` ASC [ RunTime:0.025772s ]
select * from pdf where partno='SMBJ200A' and brandshort='VIITOR SEMICONDUCTOR CO., LTD' limit 1 [ RunTime:0.033049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A' OR `brand` LIKE 'VIITOR SEMICONDUCTOR CO., LTD%' ) ) LIMIT 1 [ RunTime:0.021228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42285165 LIMIT 5 [ RunTime:0.015499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285165 ORDER BY `minOrder` ASC [ RunTime:0.030904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42285165 ORDER BY `unit` DESC [ RunTime:0.009922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42285165 LIMIT 2 [ RunTime:0.018621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285165 ORDER BY `minOrder` ASC [ RunTime:0.007664s ]
select * from pdf where partno='SMBJ200AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.026706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.021479s ]
SELECT `id` FROM `stock` WHERE `id` <> 42285165 AND `partno` = 'SMBJ200AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.044186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919242 [ RunTime:0.019115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42244188 LIMIT 5 [ RunTime:0.032875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244188 ORDER BY `minOrder` ASC [ RunTime:0.056021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42244188 ORDER BY `unit` DESC [ RunTime:0.020064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42244188 LIMIT 2 [ RunTime:0.041675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244188 ORDER BY `minOrder` ASC [ RunTime:0.017283s ]
select * from pdf where partno='SMBJ200AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.009333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200AQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.026401s ]
SELECT `id` FROM `stock` WHERE `id` <> 42244188 AND `partno` = 'SMBJ200AQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.058477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813575 [ RunTime:0.021917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239385 LIMIT 5 [ RunTime:0.017943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239385 ORDER BY `minOrder` ASC [ RunTime:0.028164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239385 ORDER BY `unit` DESC [ RunTime:0.089817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239385 LIMIT 2 [ RunTime:0.039512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239385 ORDER BY `minOrder` ASC [ RunTime:0.031765s ]
select * from pdf where partno='SMBJ200A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.040409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.094190s ]
SELECT `id` FROM `stock` WHERE `id` <> 42239385 AND `partno` = 'SMBJ200A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.070453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671071 [ RunTime:0.025612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221080 LIMIT 5 [ RunTime:0.032648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221080 ORDER BY `minOrder` ASC [ RunTime:0.009344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221080 ORDER BY `unit` DESC [ RunTime:0.050718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221080 LIMIT 2 [ RunTime:0.044332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221080 ORDER BY `minOrder` ASC [ RunTime:0.019218s ]
select * from pdf where partno='SMBJ200A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.026346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.011266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42216643 LIMIT 5 [ RunTime:0.006017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216643 ORDER BY `minOrder` ASC [ RunTime:0.026808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42216643 ORDER BY `unit` DESC [ RunTime:0.006965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42216643 LIMIT 2 [ RunTime:0.001675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216643 ORDER BY `minOrder` ASC [ RunTime:0.005385s ]
select * from pdf where partno='SMBJ200AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.010700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.008892s ]
SELECT `id` FROM `stock` WHERE `id` <> 42216643 AND `partno` = 'SMBJ200AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.016430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810061 [ RunTime:0.023592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215513 LIMIT 5 [ RunTime:0.010478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215513 ORDER BY `minOrder` ASC [ RunTime:0.029734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215513 ORDER BY `unit` DESC [ RunTime:0.021711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215513 LIMIT 2 [ RunTime:0.024472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215513 ORDER BY `minOrder` ASC [ RunTime:0.015776s ]
select * from pdf where partno='SMBJ200A-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.040216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.028564s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215513 AND `partno` = 'SMBJ200A-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.034489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809764 [ RunTime:0.052830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42199471 LIMIT 5 [ RunTime:0.034763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199471 ORDER BY `minOrder` ASC [ RunTime:0.034095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42199471 ORDER BY `unit` DESC [ RunTime:0.005471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42199471 LIMIT 2 [ RunTime:0.026973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199471 ORDER BY `minOrder` ASC [ RunTime:0.009772s ]
select * from pdf where partno='SMBJ200A-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.010806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196180 LIMIT 5 [ RunTime:0.021225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196180 ORDER BY `minOrder` ASC [ RunTime:0.011727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196180 ORDER BY `unit` DESC [ RunTime:0.025054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196180 LIMIT 2 [ RunTime:0.029539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196180 ORDER BY `minOrder` ASC [ RunTime:0.021504s ]
select * from pdf where partno='SMBJ200A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.016991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.019543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42192360 LIMIT 5 [ RunTime:0.022957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192360 ORDER BY `minOrder` ASC [ RunTime:0.057697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42192360 ORDER BY `unit` DESC [ RunTime:0.005272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42192360 LIMIT 2 [ RunTime:0.026613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192360 ORDER BY `minOrder` ASC [ RunTime:0.020081s ]
select * from pdf where partno='SMBJ200A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.070795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.056614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42192006 LIMIT 5 [ RunTime:0.013171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192006 ORDER BY `minOrder` ASC [ RunTime:0.011800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42192006 ORDER BY `unit` DESC [ RunTime:0.012386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42192006 LIMIT 2 [ RunTime:0.018873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192006 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
select * from pdf where partno='SMBJ200A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.026827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.006166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42181399 LIMIT 5 [ RunTime:0.021794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42181399 ORDER BY `minOrder` ASC [ RunTime:0.015936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42181399 ORDER BY `unit` DESC [ RunTime:0.012713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42181399 LIMIT 2 [ RunTime:0.003251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42181399 ORDER BY `minOrder` ASC [ RunTime:0.008286s ]
select * from pdf where partno='SMBJ200A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.019564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004057s ]
SELECT `id` FROM `stock` WHERE `id` <> 42181399 AND `partno` = 'SMBJ200A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.008217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42178517 LIMIT 5 [ RunTime:0.007918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42178517 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42178517 ORDER BY `unit` DESC [ RunTime:0.006444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42178517 LIMIT 2 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42178517 ORDER BY `minOrder` ASC [ RunTime:0.015019s ]
select * from pdf where partno='SMBJ200A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.002676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ200A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.012255s ]
SELECT `id` FROM `stock` WHERE `id` <> 42178517 AND `partno` = 'SMBJ200A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.013527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908781 [ RunTime:0.006125s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023927s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030839s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045320s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017068s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032488s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017054s ]
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 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019535s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ200A%' OR `brand` LIKE 'SMBJ200A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021710s ]