SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001201s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.115' , `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=SMBJ8.5&search=1' [ RunTime:0.001700s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001744s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000467s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001335s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.001225s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000941s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000646s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000945s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ8.5' LIMIT 1 [ RunTime:0.010501s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-15 01:40:30' WHERE `partno` = 'SMBJ8.5' [ RunTime:0.004894s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001369s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016033s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675145 LIMIT 5 [ RunTime:0.012136s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675145 ORDER BY `minOrder` ASC [ RunTime:0.004488s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675145 ORDER BY `unit` DESC [ RunTime:0.003126s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675145 LIMIT 2 [ RunTime:0.001374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675145 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801020 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801020 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801020 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801020 LIMIT 2 [ RunTime:0.002649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801020 ORDER BY `minOrder` ASC [ RunTime:0.000214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918953 LIMIT 5 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918953 ORDER BY `minOrder` ASC [ RunTime:0.006907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918953 ORDER BY `unit` DESC [ RunTime:0.004664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918953 LIMIT 2 [ RunTime:0.001375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918953 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687340 LIMIT 5 [ RunTime:0.004911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687340 ORDER BY `minOrder` ASC [ RunTime:0.004439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687340 ORDER BY `unit` DESC [ RunTime:0.006283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687340 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687340 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930855 LIMIT 5 [ RunTime:0.001524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930855 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13930855 ORDER BY `unit` DESC [ RunTime:0.006289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13930855 LIMIT 2 [ RunTime:0.002560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930855 ORDER BY `minOrder` ASC [ RunTime:0.003430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829051 LIMIT 5 [ RunTime:0.004214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829051 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829051 ORDER BY `unit` DESC [ RunTime:0.002216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829051 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829051 ORDER BY `minOrder` ASC [ RunTime:0.003185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685027 LIMIT 5 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685027 ORDER BY `minOrder` ASC [ RunTime:0.002927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685027 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685027 LIMIT 2 [ RunTime:0.008318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685027 ORDER BY `minOrder` ASC [ RunTime:0.006907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818861 LIMIT 5 [ RunTime:0.007511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818861 ORDER BY `minOrder` ASC [ RunTime:0.015400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818861 ORDER BY `unit` DESC [ RunTime:0.019580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818861 LIMIT 2 [ RunTime:0.011709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818861 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='SMBJ8.5D-M3/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904798 LIMIT 5 [ RunTime:0.003910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904798 ORDER BY `minOrder` ASC [ RunTime:0.006062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904798 ORDER BY `unit` DESC [ RunTime:0.005263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904798 LIMIT 2 [ RunTime:0.007004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904798 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662674 LIMIT 5 [ RunTime:0.005368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662674 ORDER BY `minOrder` ASC [ RunTime:0.010924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662674 ORDER BY `unit` DESC [ RunTime:0.017113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662674 LIMIT 2 [ RunTime:0.008320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662674 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928887 LIMIT 5 [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928887 ORDER BY `minOrder` ASC [ RunTime:0.011982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928887 ORDER BY `unit` DESC [ RunTime:0.010541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928887 LIMIT 2 [ RunTime:0.010741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928887 ORDER BY `minOrder` ASC [ RunTime:0.005412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661072 LIMIT 5 [ RunTime:0.014004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661072 ORDER BY `minOrder` ASC [ RunTime:0.009396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661072 ORDER BY `unit` DESC [ RunTime:0.012446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661072 LIMIT 2 [ RunTime:0.005827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661072 ORDER BY `minOrder` ASC [ RunTime:0.009593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687357 LIMIT 5 [ RunTime:0.012665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687357 ORDER BY `minOrder` ASC [ RunTime:0.007963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687357 ORDER BY `unit` DESC [ RunTime:0.000725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687357 LIMIT 2 [ RunTime:0.007660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687357 ORDER BY `minOrder` ASC [ RunTime:0.002067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662446 LIMIT 5 [ RunTime:0.001161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662446 ORDER BY `minOrder` ASC [ RunTime:0.024033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662446 ORDER BY `unit` DESC [ RunTime:0.015885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662446 LIMIT 2 [ RunTime:0.006681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662446 ORDER BY `minOrder` ASC [ RunTime:0.002679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685807 LIMIT 5 [ RunTime:0.003125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685807 ORDER BY `minOrder` ASC [ RunTime:0.008219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685807 ORDER BY `unit` DESC [ RunTime:0.003272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685807 LIMIT 2 [ RunTime:0.016479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685807 ORDER BY `minOrder` ASC [ RunTime:0.003111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911918 LIMIT 5 [ RunTime:0.015747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911918 ORDER BY `minOrder` ASC [ RunTime:0.004497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911918 ORDER BY `unit` DESC [ RunTime:0.004397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911918 LIMIT 2 [ RunTime:0.014008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911918 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
select * from pdf where partno='SMBJ8.5CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684232 LIMIT 5 [ RunTime:0.007042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684232 ORDER BY `minOrder` ASC [ RunTime:0.002026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684232 ORDER BY `unit` DESC [ RunTime:0.003526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684232 LIMIT 2 [ RunTime:0.008865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684232 ORDER BY `minOrder` ASC [ RunTime:0.001786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806572 LIMIT 5 [ RunTime:0.001680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806572 ORDER BY `minOrder` ASC [ RunTime:0.016434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806572 ORDER BY `unit` DESC [ RunTime:0.003567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806572 LIMIT 2 [ RunTime:0.002140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806572 ORDER BY `minOrder` ASC [ RunTime:0.005956s ]
select * from pdf where partno='SMBJ8.5A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803450 LIMIT 5 [ RunTime:0.015319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803450 ORDER BY `minOrder` ASC [ RunTime:0.002667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803450 ORDER BY `unit` DESC [ RunTime:0.009045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803450 LIMIT 2 [ RunTime:0.004348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803450 ORDER BY `minOrder` ASC [ RunTime:0.002776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803868 LIMIT 5 [ RunTime:0.006004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803868 ORDER BY `minOrder` ASC [ RunTime:0.012154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803868 ORDER BY `unit` DESC [ RunTime:0.012519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803868 LIMIT 2 [ RunTime:0.006334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803868 ORDER BY `minOrder` ASC [ RunTime:0.005774s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141444 LIMIT 5 [ RunTime:0.003615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141444 ORDER BY `minOrder` ASC [ RunTime:0.003494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141444 ORDER BY `unit` DESC [ RunTime:0.014071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141444 LIMIT 2 [ RunTime:0.002407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141444 ORDER BY `minOrder` ASC [ RunTime:0.002476s ]
select * from pdf where partno='smbj8.5ca-q' and brandshort='bourns' limit 1 [ RunTime:0.004744s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbj8.5ca-q' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.018403s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113421 LIMIT 5 [ RunTime:0.004142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113421 ORDER BY `minOrder` ASC [ RunTime:0.010148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113421 ORDER BY `unit` DESC [ RunTime:0.001840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113421 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113421 ORDER BY `minOrder` ASC [ RunTime:0.004394s ]
select * from pdf where partno='SMBJ8.5CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.004259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002045s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113421 AND `partno` = 'SMBJ8.5CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.002193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675145 [ RunTime:0.017787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42151427 LIMIT 5 [ RunTime:0.003027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151427 ORDER BY `minOrder` ASC [ RunTime:0.009940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42151427 ORDER BY `unit` DESC [ RunTime:0.002793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42151427 LIMIT 2 [ RunTime:0.015248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151427 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
select * from pdf where partno='SMBJ8.5A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.010541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.009218s ]
SELECT `id` FROM `stock` WHERE `id` <> 42151427 AND `partno` = 'SMBJ8.5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.005282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801020 [ RunTime:0.016383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099791 LIMIT 5 [ RunTime:0.004156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099791 ORDER BY `minOrder` ASC [ RunTime:0.006930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099791 ORDER BY `unit` DESC [ RunTime:0.002556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099791 LIMIT 2 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099791 ORDER BY `minOrder` ASC [ RunTime:0.003313s ]
select * from pdf where partno='SMBJ8.5A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.012183s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099791 AND `partno` = 'SMBJ8.5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806572 [ RunTime:0.001810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128995 LIMIT 5 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128995 ORDER BY `minOrder` ASC [ RunTime:0.010100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128995 ORDER BY `unit` DESC [ RunTime:0.003746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128995 LIMIT 2 [ RunTime:0.005669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128995 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
select * from pdf where partno='SMBJ8.5CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004991s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128995 AND `partno` = 'SMBJ8.5CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.012538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687340 [ RunTime:0.032504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127121 LIMIT 5 [ RunTime:0.003557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127121 ORDER BY `minOrder` ASC [ RunTime:0.005440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127121 ORDER BY `unit` DESC [ RunTime:0.016094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127121 LIMIT 2 [ RunTime:0.007770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127121 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='SMBJ8.5A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000915s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127121 AND `partno` = 'SMBJ8.5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930855 [ RunTime:0.002755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113733 LIMIT 5 [ RunTime:0.011787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113733 ORDER BY `minOrder` ASC [ RunTime:0.025141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113733 ORDER BY `unit` DESC [ RunTime:0.010402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113733 LIMIT 2 [ RunTime:0.001245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113733 ORDER BY `minOrder` ASC [ RunTime:0.002535s ]
select * from pdf where partno='SMBJ8.5CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114702 LIMIT 5 [ RunTime:0.014505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114702 ORDER BY `minOrder` ASC [ RunTime:0.007817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114702 ORDER BY `unit` DESC [ RunTime:0.006126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114702 LIMIT 2 [ RunTime:0.008281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114702 ORDER BY `minOrder` ASC [ RunTime:0.006948s ]
select * from pdf where partno='SMBJ8.5CA-TR' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.012669s ]
select foldpath,foldpath2,filename from pdf_file where id=422121 limit 1 [ RunTime:0.007243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA-TR' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.005546s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114702 AND `partno` = 'SMBJ8.5CA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.009084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802800 [ RunTime:0.005552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42126359 LIMIT 5 [ RunTime:0.012362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126359 ORDER BY `minOrder` ASC [ RunTime:0.003765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42126359 ORDER BY `unit` DESC [ RunTime:0.003988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42126359 LIMIT 2 [ RunTime:0.021084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126359 ORDER BY `minOrder` ASC [ RunTime:0.005897s ]
select * from pdf where partno='SMBJ8.5CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.006400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.003055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42129951 LIMIT 5 [ RunTime:0.012346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129951 ORDER BY `minOrder` ASC [ RunTime:0.022801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42129951 ORDER BY `unit` DESC [ RunTime:0.059184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42129951 LIMIT 2 [ RunTime:0.015254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129951 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
select * from pdf where partno='SMBJ8.5D-M3/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5D-M3/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001183s ]
SELECT `id` FROM `stock` WHERE `id` <> 42129951 AND `partno` = 'SMBJ8.5D-M3/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818861 [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141522 LIMIT 5 [ RunTime:0.005433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141522 ORDER BY `minOrder` ASC [ RunTime:0.004891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141522 ORDER BY `unit` DESC [ RunTime:0.008746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141522 LIMIT 2 [ RunTime:0.001052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141522 ORDER BY `minOrder` ASC [ RunTime:0.002540s ]
select * from pdf where partno='SMBJ8.5A' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.016477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5A' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.002311s ]
SELECT `id` FROM `stock` WHERE `id` <> 42141522 AND `partno` = 'SMBJ8.5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%semtech corporation%' ) [ RunTime:0.007116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665248 [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122950 LIMIT 5 [ RunTime:0.002213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122950 ORDER BY `minOrder` ASC [ RunTime:0.006300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122950 ORDER BY `unit` DESC [ RunTime:0.020075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122950 LIMIT 2 [ RunTime:0.004438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122950 ORDER BY `minOrder` ASC [ RunTime:0.001760s ]
select * from pdf where partno='SMBJ8.5A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.000541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42126396 LIMIT 5 [ RunTime:0.014191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126396 ORDER BY `minOrder` ASC [ RunTime:0.003517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42126396 ORDER BY `unit` DESC [ RunTime:0.002362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42126396 LIMIT 2 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126396 ORDER BY `minOrder` ASC [ RunTime:0.006349s ]
select * from pdf where partno='SMBJ8.5CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.013558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000757s ]
SELECT `id` FROM `stock` WHERE `id` <> 42126396 AND `partno` = 'SMBJ8.5CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.004978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928887 [ RunTime:0.010043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114314 LIMIT 5 [ RunTime:0.012509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114314 ORDER BY `minOrder` ASC [ RunTime:0.012695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114314 ORDER BY `unit` DESC [ RunTime:0.004999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114314 LIMIT 2 [ RunTime:0.006131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114314 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='SMBJ8.5CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.010172s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114314 AND `partno` = 'SMBJ8.5CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687357 [ RunTime:0.001486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149455 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149455 ORDER BY `minOrder` ASC [ RunTime:0.012033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149455 ORDER BY `unit` DESC [ RunTime:0.023540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149455 LIMIT 2 [ RunTime:0.022120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149455 ORDER BY `minOrder` ASC [ RunTime:0.009478s ]
select * from pdf where partno='SMBJ8.5CA' and brandshort='EVVO' limit 1 [ RunTime:0.006262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA' OR `brand` LIKE 'EVVO%' ) ) LIMIT 1 [ RunTime:0.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122975 LIMIT 5 [ RunTime:0.002193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122975 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122975 ORDER BY `unit` DESC [ RunTime:0.005285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122975 LIMIT 2 [ RunTime:0.010526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122975 ORDER BY `minOrder` ASC [ RunTime:0.003316s ]
select * from pdf where partno='SMBJ8.5CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113332 LIMIT 5 [ RunTime:0.003092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113332 ORDER BY `minOrder` ASC [ RunTime:0.016951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113332 ORDER BY `unit` DESC [ RunTime:0.002096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113332 LIMIT 2 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113332 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='SMBJ8.5A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.014105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.010997s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113332 AND `partno` = 'SMBJ8.5A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.019854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685027 [ RunTime:0.004751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42129022 LIMIT 5 [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129022 ORDER BY `minOrder` ASC [ RunTime:0.018574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42129022 ORDER BY `unit` DESC [ RunTime:0.007161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42129022 LIMIT 2 [ RunTime:0.014557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129022 ORDER BY `minOrder` ASC [ RunTime:0.008059s ]
select * from pdf where partno='SMBJ8.5CA-QH' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.012836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA-QH' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.008442s ]
SELECT `id` FROM `stock` WHERE `id` <> 42129022 AND `partno` = 'SMBJ8.5CA-QH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.015777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684232 [ RunTime:0.020574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168627 LIMIT 5 [ RunTime:0.001992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168627 ORDER BY `minOrder` ASC [ RunTime:0.010624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168627 ORDER BY `unit` DESC [ RunTime:0.009043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168627 LIMIT 2 [ RunTime:0.005245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168627 ORDER BY `minOrder` ASC [ RunTime:0.002637s ]
select * from pdf where partno='SMBJ8.5A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016440s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168627 AND `partno` = 'SMBJ8.5A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685807 [ RunTime:0.005408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42167858 LIMIT 5 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167858 ORDER BY `minOrder` ASC [ RunTime:0.012210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42167858 ORDER BY `unit` DESC [ RunTime:0.001361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42167858 LIMIT 2 [ RunTime:0.007145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167858 ORDER BY `minOrder` ASC [ RunTime:0.004316s ]
select * from pdf where partno='SMBJ8.5CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.002300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42172571 LIMIT 5 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172571 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42172571 ORDER BY `unit` DESC [ RunTime:0.009566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42172571 LIMIT 2 [ RunTime:0.009195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172571 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='SMBJ8.5CA' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.009960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ8.5CA' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.005360s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007774s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003008s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004214s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003950s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002776s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008429s ]
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 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009534s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ8.5%' OR `brand` LIKE 'SMBJ8.5%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003942s ]