SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002225s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=HLT-02&search=1' [ RunTime:0.027174s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002539s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.015595s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002906s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.014307s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002392s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006371s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001834s ]
SELECT * FROM `stock_search` WHERE `partno` = 'HLT-02' LIMIT 1 [ RunTime:0.039318s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-30 10:29:35' WHERE `partno` = 'HLT-02' [ RunTime:0.026121s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003642s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.174152s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812132 LIMIT 5 [ RunTime:0.062919s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812132 ORDER BY `minOrder` ASC [ RunTime:0.021907s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19812132 ORDER BY `unit` DESC [ RunTime:0.058590s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19812132 LIMIT 2 [ RunTime:0.100075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812132 ORDER BY `minOrder` ASC [ RunTime:0.015795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811051 LIMIT 5 [ RunTime:0.066327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811051 ORDER BY `minOrder` ASC [ RunTime:0.095164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19811051 ORDER BY `unit` DESC [ RunTime:0.042126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19811051 LIMIT 2 [ RunTime:0.034688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811051 ORDER BY `minOrder` ASC [ RunTime:0.075862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810756 LIMIT 5 [ RunTime:0.027376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810756 ORDER BY `minOrder` ASC [ RunTime:0.086923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19810756 ORDER BY `unit` DESC [ RunTime:0.052689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19810756 LIMIT 2 [ RunTime:0.024893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810756 ORDER BY `minOrder` ASC [ RunTime:0.019718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19809841 LIMIT 5 [ RunTime:0.047030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19809841 ORDER BY `minOrder` ASC [ RunTime:0.047097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19809841 ORDER BY `unit` DESC [ RunTime:0.076654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19809841 LIMIT 2 [ RunTime:0.030418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19809841 ORDER BY `minOrder` ASC [ RunTime:0.011454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801431 LIMIT 5 [ RunTime:0.046343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801431 ORDER BY `minOrder` ASC [ RunTime:0.031436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19801431 ORDER BY `unit` DESC [ RunTime:0.044106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19801431 LIMIT 2 [ RunTime:0.058066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801431 ORDER BY `minOrder` ASC [ RunTime:0.024924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796693 LIMIT 5 [ RunTime:0.058443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796693 ORDER BY `minOrder` ASC [ RunTime:0.031659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19796693 ORDER BY `unit` DESC [ RunTime:0.048323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19796693 LIMIT 2 [ RunTime:0.038435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796693 ORDER BY `minOrder` ASC [ RunTime:0.024483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19794570 LIMIT 5 [ RunTime:0.031741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19794570 ORDER BY `minOrder` ASC [ RunTime:0.020881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19794570 ORDER BY `unit` DESC [ RunTime:0.007019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19794570 LIMIT 2 [ RunTime:0.041819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19794570 ORDER BY `minOrder` ASC [ RunTime:0.009138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19788896 LIMIT 5 [ RunTime:0.017807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19788896 ORDER BY `minOrder` ASC [ RunTime:0.023488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19788896 ORDER BY `unit` DESC [ RunTime:0.024434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19788896 LIMIT 2 [ RunTime:0.004434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19788896 ORDER BY `minOrder` ASC [ RunTime:0.008561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786907 LIMIT 5 [ RunTime:0.012130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786907 ORDER BY `minOrder` ASC [ RunTime:0.025663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786907 ORDER BY `unit` DESC [ RunTime:0.057705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786907 LIMIT 2 [ RunTime:0.053675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786907 ORDER BY `minOrder` ASC [ RunTime:0.004984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786163 LIMIT 5 [ RunTime:0.017687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786163 ORDER BY `minOrder` ASC [ RunTime:0.008177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786163 ORDER BY `unit` DESC [ RunTime:0.000979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786163 LIMIT 2 [ RunTime:0.020276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786163 ORDER BY `minOrder` ASC [ RunTime:0.006254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19781330 LIMIT 5 [ RunTime:0.013428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19781330 ORDER BY `minOrder` ASC [ RunTime:0.012841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19781330 ORDER BY `unit` DESC [ RunTime:0.001475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19781330 LIMIT 2 [ RunTime:0.006140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19781330 ORDER BY `minOrder` ASC [ RunTime:0.006070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19777151 LIMIT 5 [ RunTime:0.001335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19777151 ORDER BY `minOrder` ASC [ RunTime:0.002399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19777151 ORDER BY `unit` DESC [ RunTime:0.000711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19777151 LIMIT 2 [ RunTime:0.012666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19777151 ORDER BY `minOrder` ASC [ RunTime:0.011458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212129 LIMIT 5 [ RunTime:0.004082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212129 ORDER BY `minOrder` ASC [ RunTime:0.009285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16212129 ORDER BY `unit` DESC [ RunTime:0.012767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16212129 LIMIT 2 [ RunTime:0.004371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212129 ORDER BY `minOrder` ASC [ RunTime:0.003013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212013 LIMIT 5 [ RunTime:0.004517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212013 ORDER BY `minOrder` ASC [ RunTime:0.008986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16212013 ORDER BY `unit` DESC [ RunTime:0.012983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16212013 LIMIT 2 [ RunTime:0.003312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212013 ORDER BY `minOrder` ASC [ RunTime:0.006295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16211187 LIMIT 5 [ RunTime:0.026015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211187 ORDER BY `minOrder` ASC [ RunTime:0.001709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16211187 ORDER BY `unit` DESC [ RunTime:0.061090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16211187 LIMIT 2 [ RunTime:0.022498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211187 ORDER BY `minOrder` ASC [ RunTime:0.011984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207696 LIMIT 5 [ RunTime:0.031890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207696 ORDER BY `minOrder` ASC [ RunTime:0.011556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16207696 ORDER BY `unit` DESC [ RunTime:0.047478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16207696 LIMIT 2 [ RunTime:0.007785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207696 ORDER BY `minOrder` ASC [ RunTime:0.025652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205599 LIMIT 5 [ RunTime:0.024202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205599 ORDER BY `minOrder` ASC [ RunTime:0.019746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16205599 ORDER BY `unit` DESC [ RunTime:0.007732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16205599 LIMIT 2 [ RunTime:0.011934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205599 ORDER BY `minOrder` ASC [ RunTime:0.008315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14707882 LIMIT 5 [ RunTime:0.039552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14707882 ORDER BY `minOrder` ASC [ RunTime:0.021760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14707882 ORDER BY `unit` DESC [ RunTime:0.020170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14707882 LIMIT 2 [ RunTime:0.014973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14707882 ORDER BY `minOrder` ASC [ RunTime:0.024518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764537 LIMIT 5 [ RunTime:0.030389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764537 ORDER BY `minOrder` ASC [ RunTime:0.019657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12764537 ORDER BY `unit` DESC [ RunTime:0.031280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12764537 LIMIT 2 [ RunTime:0.028665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764537 ORDER BY `minOrder` ASC [ RunTime:0.029459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764329 LIMIT 5 [ RunTime:0.004509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764329 ORDER BY `minOrder` ASC [ RunTime:0.056356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12764329 ORDER BY `unit` DESC [ RunTime:0.053346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12764329 LIMIT 2 [ RunTime:0.023165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764329 ORDER BY `minOrder` ASC [ RunTime:0.035259s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017959s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59739623 LIMIT 5 [ RunTime:0.006178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59739623 ORDER BY `minOrder` ASC [ RunTime:0.012145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59739623 ORDER BY `unit` DESC [ RunTime:0.005389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59739623 LIMIT 2 [ RunTime:0.052180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59739623 ORDER BY `minOrder` ASC [ RunTime:0.012733s ]
select * from pdf where partno='HLT-0220-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002768s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0220-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003486s ]
SELECT `id` FROM `stock` WHERE `id` <> 59739623 AND `partno` = 'HLT-0220-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764537 [ RunTime:0.013228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59738998 LIMIT 5 [ RunTime:0.018288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738998 ORDER BY `minOrder` ASC [ RunTime:0.022804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59738998 ORDER BY `unit` DESC [ RunTime:0.007987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59738998 LIMIT 2 [ RunTime:0.020123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738998 ORDER BY `minOrder` ASC [ RunTime:0.019923s ]
select * from pdf where partno='HLT-0220-G-H' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0220-G-H' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021345s ]
SELECT `id` FROM `stock` WHERE `id` <> 59738998 AND `partno` = 'HLT-0220-G-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764227 [ RunTime:0.028336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59738424 LIMIT 5 [ RunTime:0.006955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738424 ORDER BY `minOrder` ASC [ RunTime:0.032178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59738424 ORDER BY `unit` DESC [ RunTime:0.012606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59738424 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738424 ORDER BY `minOrder` ASC [ RunTime:0.002958s ]
select * from pdf where partno='HLT-0220-G-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0220-G-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014650s ]
SELECT `id` FROM `stock` WHERE `id` <> 59738424 AND `partno` = 'HLT-0220-G-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737837 LIMIT 5 [ RunTime:0.012000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737837 ORDER BY `minOrder` ASC [ RunTime:0.018469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737837 ORDER BY `unit` DESC [ RunTime:0.019911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737837 LIMIT 2 [ RunTime:0.007947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737837 ORDER BY `minOrder` ASC [ RunTime:0.017552s ]
select * from pdf where partno='HLT-0218-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0218-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007285s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737837 AND `partno` = 'HLT-0218-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763642 [ RunTime:0.012266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737592 LIMIT 5 [ RunTime:0.002402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737592 ORDER BY `minOrder` ASC [ RunTime:0.005323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737592 ORDER BY `unit` DESC [ RunTime:0.005099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737592 LIMIT 2 [ RunTime:0.003752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737592 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='HLT-0219-G-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0219-G-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003954s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737592 AND `partno` = 'HLT-0219-G-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763507 [ RunTime:0.021883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737150 LIMIT 5 [ RunTime:0.016501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737150 ORDER BY `minOrder` ASC [ RunTime:0.023283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737150 ORDER BY `unit` DESC [ RunTime:0.000931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737150 LIMIT 2 [ RunTime:0.014914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737150 ORDER BY `minOrder` ASC [ RunTime:0.020194s ]
select * from pdf where partno='HLT-0218-G-H' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0218-G-H' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022032s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737150 AND `partno` = 'HLT-0218-G-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764329 [ RunTime:0.024044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59736515 LIMIT 5 [ RunTime:0.008604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736515 ORDER BY `minOrder` ASC [ RunTime:0.021908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59736515 ORDER BY `unit` DESC [ RunTime:0.009306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59736515 LIMIT 2 [ RunTime:0.013869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736515 ORDER BY `minOrder` ASC [ RunTime:0.000967s ]
select * from pdf where partno='HLT-0218-G-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.043540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0218-G-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015426s ]
SELECT `id` FROM `stock` WHERE `id` <> 59736515 AND `partno` = 'HLT-0218-G-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.032392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762998 [ RunTime:0.022066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59735979 LIMIT 5 [ RunTime:0.005887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59735979 ORDER BY `minOrder` ASC [ RunTime:0.018552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59735979 ORDER BY `unit` DESC [ RunTime:0.023053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59735979 LIMIT 2 [ RunTime:0.037664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59735979 ORDER BY `minOrder` ASC [ RunTime:0.021466s ]
select * from pdf where partno='HLT-0217-G-H' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0217-G-H' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030393s ]
SELECT `id` FROM `stock` WHERE `id` <> 59735979 AND `partno` = 'HLT-0217-G-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.055836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762729 [ RunTime:0.050504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59735419 LIMIT 5 [ RunTime:0.025294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59735419 ORDER BY `minOrder` ASC [ RunTime:0.054975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59735419 ORDER BY `unit` DESC [ RunTime:0.034590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59735419 LIMIT 2 [ RunTime:0.060300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59735419 ORDER BY `minOrder` ASC [ RunTime:0.021436s ]
select * from pdf where partno='HLT-0216-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.057473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0216-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.065071s ]
SELECT `id` FROM `stock` WHERE `id` <> 59735419 AND `partno` = 'HLT-0216-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.099695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763576 [ RunTime:0.060333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59735240 LIMIT 5 [ RunTime:0.066426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59735240 ORDER BY `minOrder` ASC [ RunTime:0.076102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59735240 ORDER BY `unit` DESC [ RunTime:0.009815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59735240 LIMIT 2 [ RunTime:0.019619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59735240 ORDER BY `minOrder` ASC [ RunTime:0.041149s ]
select * from pdf where partno='HLT-0217-G-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0217-G-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.044807s ]
SELECT `id` FROM `stock` WHERE `id` <> 59735240 AND `partno` = 'HLT-0217-G-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.067244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588297 [ RunTime:0.055867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59734629 LIMIT 5 [ RunTime:0.012853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59734629 ORDER BY `minOrder` ASC [ RunTime:0.038048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59734629 ORDER BY `unit` DESC [ RunTime:0.037078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59734629 LIMIT 2 [ RunTime:0.010026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59734629 ORDER BY `minOrder` ASC [ RunTime:0.023964s ]
select * from pdf where partno='HLT-0216-G-H' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.051131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0216-G-H' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020903s ]
SELECT `id` FROM `stock` WHERE `id` <> 59734629 AND `partno` = 'HLT-0216-G-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11588901 [ RunTime:0.026443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59734012 LIMIT 5 [ RunTime:0.010820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59734012 ORDER BY `minOrder` ASC [ RunTime:0.009923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59734012 ORDER BY `unit` DESC [ RunTime:0.026722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59734012 LIMIT 2 [ RunTime:0.033807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59734012 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
select * from pdf where partno='HLT-0215-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0215-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010487s ]
SELECT `id` FROM `stock` WHERE `id` <> 59734012 AND `partno` = 'HLT-0215-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761157 [ RunTime:0.010062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59733078 LIMIT 5 [ RunTime:0.001357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733078 ORDER BY `minOrder` ASC [ RunTime:0.008435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59733078 ORDER BY `unit` DESC [ RunTime:0.004507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59733078 LIMIT 2 [ RunTime:0.003094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733078 ORDER BY `minOrder` ASC [ RunTime:0.002547s ]
select * from pdf where partno='HLT-0215-G-H' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0215-G-H' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005640s ]
SELECT `id` FROM `stock` WHERE `id` <> 59733078 AND `partno` = 'HLT-0215-G-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11586932 [ RunTime:0.008773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59732349 LIMIT 5 [ RunTime:0.000988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732349 ORDER BY `minOrder` ASC [ RunTime:0.002138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59732349 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59732349 LIMIT 2 [ RunTime:0.002822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732349 ORDER BY `minOrder` ASC [ RunTime:0.006530s ]
select * from pdf where partno='HLT-0214-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0214-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001125s ]
SELECT `id` FROM `stock` WHERE `id` <> 59732349 AND `partno` = 'HLT-0214-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762234 [ RunTime:0.007713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59732293 LIMIT 5 [ RunTime:0.007945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732293 ORDER BY `minOrder` ASC [ RunTime:0.008702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59732293 ORDER BY `unit` DESC [ RunTime:0.009926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59732293 LIMIT 2 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732293 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='HLT-0215-G-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0215-G-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005409s ]
SELECT `id` FROM `stock` WHERE `id` <> 59732293 AND `partno` = 'HLT-0215-G-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12760302 [ RunTime:0.003772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59731361 LIMIT 5 [ RunTime:0.008041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59731361 ORDER BY `minOrder` ASC [ RunTime:0.001266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59731361 ORDER BY `unit` DESC [ RunTime:0.006511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59731361 LIMIT 2 [ RunTime:0.006758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59731361 ORDER BY `minOrder` ASC [ RunTime:0.002873s ]
select * from pdf where partno='HLT-0214-G-H' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0214-G-H' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010890s ]
SELECT `id` FROM `stock` WHERE `id` <> 59731361 AND `partno` = 'HLT-0214-G-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59730423 LIMIT 5 [ RunTime:0.005001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730423 ORDER BY `minOrder` ASC [ RunTime:0.009656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59730423 ORDER BY `unit` DESC [ RunTime:0.002507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59730423 LIMIT 2 [ RunTime:0.027182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730423 ORDER BY `minOrder` ASC [ RunTime:0.011411s ]
select * from pdf where partno='HLT-0213-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0213-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009759s ]
SELECT `id` FROM `stock` WHERE `id` <> 59730423 AND `partno` = 'HLT-0213-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759419 [ RunTime:0.010415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59729398 LIMIT 5 [ RunTime:0.007587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59729398 ORDER BY `minOrder` ASC [ RunTime:0.014000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59729398 ORDER BY `unit` DESC [ RunTime:0.015055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59729398 LIMIT 2 [ RunTime:0.023965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59729398 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
select * from pdf where partno='HLT-0213-G-H' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0213-G-H' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011873s ]
SELECT `id` FROM `stock` WHERE `id` <> 59729398 AND `partno` = 'HLT-0213-G-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758978 [ RunTime:0.043246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59728471 LIMIT 5 [ RunTime:0.011270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728471 ORDER BY `minOrder` ASC [ RunTime:0.029740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59728471 ORDER BY `unit` DESC [ RunTime:0.012663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59728471 LIMIT 2 [ RunTime:0.006235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728471 ORDER BY `minOrder` ASC [ RunTime:0.012179s ]
select * from pdf where partno='HLT-0213-G-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0213-G-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.036258s ]
SELECT `id` FROM `stock` WHERE `id` <> 59728471 AND `partno` = 'HLT-0213-G-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11585124 [ RunTime:0.020919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59728235 LIMIT 5 [ RunTime:0.008431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728235 ORDER BY `minOrder` ASC [ RunTime:0.007718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59728235 ORDER BY `unit` DESC [ RunTime:0.000709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59728235 LIMIT 2 [ RunTime:0.001376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59728235 ORDER BY `minOrder` ASC [ RunTime:0.004680s ]
select * from pdf where partno='HLT-0212-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HLT-0212-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005743s ]
SELECT `id` FROM `stock` WHERE `id` <> 59728235 AND `partno` = 'HLT-0212-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11585601 [ RunTime:0.001207s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003567s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008122s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003095s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009473s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005192s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001203s ]
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 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007655s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'HLT-02%' OR `brand` LIKE 'HLT-02%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005946s ]