SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001988s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=H-4&search=1' [ RunTime:0.002813s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001883s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002026s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001818s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002348s ]
SELECT * FROM `stock_search` WHERE `partno` = 'H-4' LIMIT 1 [ RunTime:0.000929s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-25 21:48:41' WHERE `partno` = 'H-4' [ RunTime:0.001733s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002208s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004877s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13345959 LIMIT 5 [ RunTime:0.009015s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345959 ORDER BY `minOrder` ASC [ RunTime:0.009562s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13345959 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13345959 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345959 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349686 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349686 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349686 ORDER BY `unit` DESC [ RunTime:0.000252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349686 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349686 ORDER BY `minOrder` ASC [ RunTime:0.000167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066350 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066350 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066350 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066350 LIMIT 2 [ RunTime:0.015248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066350 ORDER BY `minOrder` ASC [ RunTime:0.001999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348870 LIMIT 5 [ RunTime:0.000874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348870 ORDER BY `minOrder` ASC [ RunTime:0.006929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348870 ORDER BY `unit` DESC [ RunTime:0.004932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348870 LIMIT 2 [ RunTime:0.003100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348870 ORDER BY `minOrder` ASC [ RunTime:0.002217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348212 LIMIT 5 [ RunTime:0.005065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348212 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348212 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348212 LIMIT 2 [ RunTime:0.004649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348212 ORDER BY `minOrder` ASC [ RunTime:0.012386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065377 LIMIT 5 [ RunTime:0.001047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065377 ORDER BY `minOrder` ASC [ RunTime:0.016423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065377 ORDER BY `unit` DESC [ RunTime:0.026792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065377 LIMIT 2 [ RunTime:0.028437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065377 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346675 LIMIT 5 [ RunTime:0.001450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346675 ORDER BY `minOrder` ASC [ RunTime:0.006052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346675 ORDER BY `unit` DESC [ RunTime:0.009643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346675 LIMIT 2 [ RunTime:0.021437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346675 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11421271 LIMIT 5 [ RunTime:0.008922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11421271 ORDER BY `minOrder` ASC [ RunTime:0.007781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11421271 ORDER BY `unit` DESC [ RunTime:0.009906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11421271 LIMIT 2 [ RunTime:0.008875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11421271 ORDER BY `minOrder` ASC [ RunTime:0.009712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16777448 LIMIT 5 [ RunTime:0.018987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16777448 ORDER BY `minOrder` ASC [ RunTime:0.032075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16777448 ORDER BY `unit` DESC [ RunTime:0.003839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16777448 LIMIT 2 [ RunTime:0.010372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16777448 ORDER BY `minOrder` ASC [ RunTime:0.007278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065659 LIMIT 5 [ RunTime:0.026688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065659 ORDER BY `minOrder` ASC [ RunTime:0.022054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065659 ORDER BY `unit` DESC [ RunTime:0.008670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065659 LIMIT 2 [ RunTime:0.007180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065659 ORDER BY `minOrder` ASC [ RunTime:0.004447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17762863 LIMIT 5 [ RunTime:0.008457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17762863 ORDER BY `minOrder` ASC [ RunTime:0.020740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17762863 ORDER BY `unit` DESC [ RunTime:0.004352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17762863 LIMIT 2 [ RunTime:0.004067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17762863 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18911701 LIMIT 5 [ RunTime:0.012407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18911701 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18911701 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18911701 LIMIT 2 [ RunTime:0.002774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18911701 ORDER BY `minOrder` ASC [ RunTime:0.003228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160218 LIMIT 5 [ RunTime:0.006704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160218 ORDER BY `minOrder` ASC [ RunTime:0.003780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160218 ORDER BY `unit` DESC [ RunTime:0.001261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160218 LIMIT 2 [ RunTime:0.000927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160218 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160301 LIMIT 5 [ RunTime:0.002182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160301 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160301 ORDER BY `unit` DESC [ RunTime:0.000571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160301 LIMIT 2 [ RunTime:0.002728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160301 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11185985 LIMIT 5 [ RunTime:0.001053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185985 ORDER BY `minOrder` ASC [ RunTime:0.007158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11185985 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11185985 LIMIT 2 [ RunTime:0.006614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185985 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19171170 LIMIT 5 [ RunTime:0.001298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19171170 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19171170 ORDER BY `unit` DESC [ RunTime:0.009136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19171170 LIMIT 2 [ RunTime:0.006954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19171170 ORDER BY `minOrder` ASC [ RunTime:0.001363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037652 LIMIT 5 [ RunTime:0.015662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037652 ORDER BY `minOrder` ASC [ RunTime:0.015334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037652 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037652 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037652 ORDER BY `minOrder` ASC [ RunTime:0.003662s ]
select * from pdf where partno='H-45AAA,BK' and brandshort='Serpac' limit 1 [ RunTime:0.001899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18912838 LIMIT 5 [ RunTime:0.007991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912838 ORDER BY `minOrder` ASC [ RunTime:0.001293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18912838 ORDER BY `unit` DESC [ RunTime:0.003393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18912838 LIMIT 2 [ RunTime:0.003760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18912838 ORDER BY `minOrder` ASC [ RunTime:0.003199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18911332 LIMIT 5 [ RunTime:0.001247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18911332 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18911332 ORDER BY `unit` DESC [ RunTime:0.000659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18911332 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18911332 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18911331 LIMIT 5 [ RunTime:0.001986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18911331 ORDER BY `minOrder` ASC [ RunTime:0.007886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18911331 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18911331 LIMIT 2 [ RunTime:0.003660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18911331 ORDER BY `minOrder` ASC [ RunTime:0.004117s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212498 LIMIT 5 [ RunTime:0.003829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212498 ORDER BY `minOrder` ASC [ RunTime:0.001218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212498 ORDER BY `unit` DESC [ RunTime:0.005594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212498 LIMIT 2 [ RunTime:0.011161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212498 ORDER BY `minOrder` ASC [ RunTime:0.008032s ]
select * from pdf where partno='h-46-6a' and brandshort='bourns' limit 1 [ RunTime:0.004618s ]
select foldpath,foldpath2,filename from pdf_file where id=531973 limit 1 [ RunTime:0.002181s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h-46-6a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.011816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212635 LIMIT 5 [ RunTime:0.001317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212635 ORDER BY `minOrder` ASC [ RunTime:0.011147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212635 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212635 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212635 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='h-46-6a-1' and brandshort='bourns' limit 1 [ RunTime:0.029619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h-46-6a-1' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.004247s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558043 LIMIT 5 [ RunTime:0.002772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558043 ORDER BY `minOrder` ASC [ RunTime:0.010226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558043 ORDER BY `unit` DESC [ RunTime:0.010657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558043 LIMIT 2 [ RunTime:0.017138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558043 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
select * from pdf where partno='H-42CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-42CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001869s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558043 AND `partno` = 'H-42CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.013833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348212 [ RunTime:0.002548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64564360 LIMIT 5 [ RunTime:0.012385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64564360 ORDER BY `minOrder` ASC [ RunTime:0.004600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64564360 ORDER BY `unit` DESC [ RunTime:0.007188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64564360 LIMIT 2 [ RunTime:0.008619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64564360 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='H-45CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-45CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010688s ]
SELECT `id` FROM `stock` WHERE `id` <> 64564360 AND `partno` = 'H-45CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.015234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13345959 [ RunTime:0.001070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64557986 LIMIT 5 [ RunTime:0.014984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64557986 ORDER BY `minOrder` ASC [ RunTime:0.015234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64557986 ORDER BY `unit` DESC [ RunTime:0.000884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64557986 LIMIT 2 [ RunTime:0.005001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64557986 ORDER BY `minOrder` ASC [ RunTime:0.009297s ]
select * from pdf where partno='H-44CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-44CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000985s ]
SELECT `id` FROM `stock` WHERE `id` <> 64557986 AND `partno` = 'H-44CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066350 [ RunTime:0.000658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559139 LIMIT 5 [ RunTime:0.015101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559139 ORDER BY `minOrder` ASC [ RunTime:0.002834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559139 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559139 LIMIT 2 [ RunTime:0.002465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559139 ORDER BY `minOrder` ASC [ RunTime:0.006402s ]
select * from pdf where partno='H-49CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-49CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010927s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559139 AND `partno` = 'H-49CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346675 [ RunTime:0.001960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64556275 LIMIT 5 [ RunTime:0.010651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556275 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64556275 ORDER BY `unit` DESC [ RunTime:0.006799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64556275 LIMIT 2 [ RunTime:0.003389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556275 ORDER BY `minOrder` ASC [ RunTime:0.001191s ]
select * from pdf where partno='H-48CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.019985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-48CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007857s ]
SELECT `id` FROM `stock` WHERE `id` <> 64556275 AND `partno` = 'H-48CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.003545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065377 [ RunTime:0.016476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559088 LIMIT 5 [ RunTime:0.009029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559088 ORDER BY `minOrder` ASC [ RunTime:0.016251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559088 ORDER BY `unit` DESC [ RunTime:0.005686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559088 LIMIT 2 [ RunTime:0.004018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559088 ORDER BY `minOrder` ASC [ RunTime:0.004192s ]
select * from pdf where partno='H-41CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-41CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.007095s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559088 AND `partno` = 'H-41CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.014400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065659 [ RunTime:0.013287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559093 LIMIT 5 [ RunTime:0.025915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559093 ORDER BY `minOrder` ASC [ RunTime:0.016747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559093 ORDER BY `unit` DESC [ RunTime:0.008558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559093 LIMIT 2 [ RunTime:0.042232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559093 ORDER BY `minOrder` ASC [ RunTime:0.019208s ]
select * from pdf where partno='H-4CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.010701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-4CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.011604s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559093 AND `partno` = 'H-4CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.036906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348870 [ RunTime:0.039108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58085257 LIMIT 5 [ RunTime:0.003916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58085257 ORDER BY `minOrder` ASC [ RunTime:0.017953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58085257 ORDER BY `unit` DESC [ RunTime:0.006148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58085257 LIMIT 2 [ RunTime:0.015153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58085257 ORDER BY `minOrder` ASC [ RunTime:0.007163s ]
select * from pdf where partno='H-46-6A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-46-6A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004195s ]
SELECT `id` FROM `stock` WHERE `id` <> 58085257 AND `partno` = 'H-46-6A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.023125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16777448 [ RunTime:0.020300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58085285 LIMIT 5 [ RunTime:0.008605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58085285 ORDER BY `minOrder` ASC [ RunTime:0.003602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58085285 ORDER BY `unit` DESC [ RunTime:0.004622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58085285 LIMIT 2 [ RunTime:0.009495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58085285 ORDER BY `minOrder` ASC [ RunTime:0.018117s ]
select * from pdf where partno='H-46-6A-1' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.013384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-46-6A-1' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.023968s ]
SELECT `id` FROM `stock` WHERE `id` <> 58085285 AND `partno` = 'H-46-6A-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17762863 [ RunTime:0.002949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60429474 LIMIT 5 [ RunTime:0.002476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429474 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60429474 ORDER BY `unit` DESC [ RunTime:0.003126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60429474 LIMIT 2 [ RunTime:0.003122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429474 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='H-4' and brandshort='Curtis Industries' limit 1 [ RunTime:0.000927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-4' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.003395s ]
SELECT `id` FROM `stock` WHERE `id` <> 60429474 AND `partno` = 'H-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.003169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11421271 [ RunTime:0.010986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64566772 LIMIT 5 [ RunTime:0.004528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566772 ORDER BY `minOrder` ASC [ RunTime:0.001447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64566772 ORDER BY `unit` DESC [ RunTime:0.006824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64566772 LIMIT 2 [ RunTime:0.009348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566772 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
select * from pdf where partno='H-46CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-46CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001233s ]
SELECT `id` FROM `stock` WHERE `id` <> 64566772 AND `partno` = 'H-46CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.012510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349686 [ RunTime:0.014479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58123461 LIMIT 5 [ RunTime:0.014948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58123461 ORDER BY `minOrder` ASC [ RunTime:0.002883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58123461 ORDER BY `unit` DESC [ RunTime:0.000796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58123461 LIMIT 2 [ RunTime:0.006990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58123461 ORDER BY `minOrder` ASC [ RunTime:0.003299s ]
select * from pdf where partno='H-480C' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.007751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-480C' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.010232s ]
SELECT `id` FROM `stock` WHERE `id` <> 58123461 AND `partno` = 'H-480C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.001327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18911701 [ RunTime:0.001640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58587352 LIMIT 5 [ RunTime:0.002518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58587352 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58587352 ORDER BY `unit` DESC [ RunTime:0.011587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58587352 LIMIT 2 [ RunTime:0.002709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58587352 ORDER BY `minOrder` ASC [ RunTime:0.004478s ]
select * from pdf where partno='H-422' and brandshort='3M' limit 1 [ RunTime:0.014521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-422' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.034517s ]
SELECT `id` FROM `stock` WHERE `id` <> 58587352 AND `partno` = 'H-422' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.006351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160301 [ RunTime:0.006317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58514057 LIMIT 5 [ RunTime:0.008855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58514057 ORDER BY `minOrder` ASC [ RunTime:0.008596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58514057 ORDER BY `unit` DESC [ RunTime:0.002847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58514057 LIMIT 2 [ RunTime:0.006277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58514057 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='H-40' and brandshort='Jonard Tools' limit 1 [ RunTime:0.007997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-40' OR `brand` LIKE 'Jonard Tools%' ) ) LIMIT 1 [ RunTime:0.001639s ]
SELECT `id` FROM `stock` WHERE `id` <> 58514057 AND `partno` = 'H-40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jonard tools%' ) [ RunTime:0.005306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11185985 [ RunTime:0.003023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64810553 LIMIT 5 [ RunTime:0.011780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810553 ORDER BY `minOrder` ASC [ RunTime:0.016256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64810553 ORDER BY `unit` DESC [ RunTime:0.001717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64810553 LIMIT 2 [ RunTime:0.015710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64810553 ORDER BY `minOrder` ASC [ RunTime:0.001422s ]
select * from pdf where partno='H-45' and brandshort='Jonard Tools' limit 1 [ RunTime:0.001377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-45' OR `brand` LIKE 'Jonard Tools%' ) ) LIMIT 1 [ RunTime:0.008425s ]
SELECT `id` FROM `stock` WHERE `id` <> 64810553 AND `partno` = 'H-45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jonard tools%' ) [ RunTime:0.023557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12161074 [ RunTime:0.028960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64096551 LIMIT 5 [ RunTime:0.028279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64096551 ORDER BY `minOrder` ASC [ RunTime:0.022749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64096551 ORDER BY `unit` DESC [ RunTime:0.000984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64096551 LIMIT 2 [ RunTime:0.007483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64096551 ORDER BY `minOrder` ASC [ RunTime:0.016433s ]
select * from pdf where partno='H-4/3-M5' and brandshort='Festo Corporation' limit 1 [ RunTime:0.007777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-4/3-M5' OR `brand` LIKE 'Festo Corporation%' ) ) LIMIT 1 [ RunTime:0.019172s ]
SELECT `id` FROM `stock` WHERE `id` <> 64096551 AND `partno` = 'H-4/3-M5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%festo corporation%' ) [ RunTime:0.031234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505058 LIMIT 5 [ RunTime:0.010275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505058 ORDER BY `minOrder` ASC [ RunTime:0.029731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505058 ORDER BY `unit` DESC [ RunTime:0.019595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505058 LIMIT 2 [ RunTime:0.012973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505058 ORDER BY `minOrder` ASC [ RunTime:0.003230s ]
select * from pdf where partno='H-40-160F-9' and brandshort='Omega' limit 1 [ RunTime:0.007980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-40-160F-9' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.008601s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505058 AND `partno` = 'H-40-160F-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.003192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63504958 LIMIT 5 [ RunTime:0.016333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63504958 ORDER BY `minOrder` ASC [ RunTime:0.019991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63504958 ORDER BY `unit` DESC [ RunTime:0.021837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63504958 LIMIT 2 [ RunTime:0.003459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63504958 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='H-40-100F-12-PB' and brandshort='Omega' limit 1 [ RunTime:0.001845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-40-100F-12-PB' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.008896s ]
SELECT `id` FROM `stock` WHERE `id` <> 63504958 AND `partno` = 'H-40-100F-12-PB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.008177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63433923 LIMIT 5 [ RunTime:0.016753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433923 ORDER BY `minOrder` ASC [ RunTime:0.006313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63433923 ORDER BY `unit` DESC [ RunTime:0.002879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63433923 LIMIT 2 [ RunTime:0.003205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63433923 ORDER BY `minOrder` ASC [ RunTime:0.001238s ]
select * from pdf where partno='H-45AAA,BK' and brandshort='Serpac' limit 1 [ RunTime:0.002950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-45AAA,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.011444s ]
SELECT `id` FROM `stock` WHERE `id` <> 63433923 AND `partno` = 'H-45AAA,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.013470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037652 [ RunTime:0.008166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63415614 LIMIT 5 [ RunTime:0.026712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415614 ORDER BY `minOrder` ASC [ RunTime:0.002475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63415614 ORDER BY `unit` DESC [ RunTime:0.013432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63415614 LIMIT 2 [ RunTime:0.004882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415614 ORDER BY `minOrder` ASC [ RunTime:0.003394s ]
select * from pdf where partno='H-4NP-BOX' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H-4NP-BOX' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000498s ]
SELECT `id` FROM `stock` WHERE `id` <> 63415614 AND `partno` = 'H-4NP-BOX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.002610s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008693s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009077s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008368s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002679s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010418s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025930s ]
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 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019947s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'H-4%' OR `brand` LIKE 'H-4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010323s ]