SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002132s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.114' , `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=371+&search=1' [ RunTime:0.003949s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003148s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001213s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003854s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.114' ) [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001205s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001496s ]
SELECT * FROM `stock_search` WHERE `partno` = '371' LIMIT 1 [ RunTime:0.003832s ]
UPDATE `stock_search` SET `count` = 94 , `updatetime` = '2026-10-14 17:08:02' WHERE `partno` = '371' [ RunTime:0.005510s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002033s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065926s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347543 LIMIT 5 [ RunTime:0.000620s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347543 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13347543 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13347543 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347543 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14365414 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14365414 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14365414 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14365414 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14365414 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='37112 010500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348827 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348827 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348827 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348827 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348827 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11618130 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11618130 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11618130 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11618130 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11618130 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489642 LIMIT 5 [ RunTime:0.000773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489642 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489642 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489642 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489642 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='37118 0025000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14364896 LIMIT 5 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364896 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14364896 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14364896 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364896 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='37116 010500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489643 LIMIT 5 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489643 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489643 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489643 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489643 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='37118 0105000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363366 LIMIT 5 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363366 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363366 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363366 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363366 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='37118 0135000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225793 LIMIT 5 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225793 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11225793 ORDER BY `unit` DESC [ RunTime:0.000313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11225793 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11225793 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348031 LIMIT 5 [ RunTime:0.002941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348031 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348031 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348031 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348031 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615521 LIMIT 5 [ RunTime:0.004205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615521 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615521 ORDER BY `unit` DESC [ RunTime:0.000294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615521 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615521 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066339 LIMIT 5 [ RunTime:0.001307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066339 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066339 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066339 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066339 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16418795 LIMIT 5 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16418795 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16418795 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16418795 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16418795 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799385 LIMIT 5 [ RunTime:0.001188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799385 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799385 ORDER BY `unit` DESC [ RunTime:0.000317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799385 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799385 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066401 LIMIT 5 [ RunTime:0.004131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066401 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066401 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066401 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066401 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615512 LIMIT 5 [ RunTime:0.000312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615512 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615512 ORDER BY `unit` DESC [ RunTime:0.000315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615512 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615512 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12800225 LIMIT 5 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800225 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12800225 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12800225 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800225 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802746 LIMIT 5 [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802746 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12802746 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12802746 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802746 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508649 LIMIT 5 [ RunTime:0.004803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508649 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19508649 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19508649 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508649 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
select * from pdf where partno='37102' and brandshort='Protektive Pak' limit 1 [ RunTime:0.000784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347734 LIMIT 5 [ RunTime:0.001430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347734 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13347734 ORDER BY `unit` DESC [ RunTime:0.000386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13347734 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347734 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820901 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820901 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820901 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820901 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820901 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='371824b00032g' and brandshort='aavid' limit 1 [ RunTime:0.003194s ]
select foldpath,foldpath2,filename from pdf_file where id=1076187 limit 1 [ RunTime:0.000658s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '371824b00032g' OR `brand` LIKE 'aavid%' ) ) LIMIT 1 [ RunTime:0.003626s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820901 AND `partno` = '371824b00032g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aavid%' ) [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820871 LIMIT 5 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820871 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820871 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820871 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820871 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='371824b00034g' and brandshort='aavid' limit 1 [ RunTime:0.001054s ]
select foldpath,foldpath2,filename from pdf_file where id=1076187 limit 1 [ RunTime:0.000557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '371824b00034g' OR `brand` LIKE 'aavid%' ) ) LIMIT 1 [ RunTime:0.000408s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820871 AND `partno` = '371824b00034g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aavid%' ) [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71666739 LIMIT 5 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71666739 ORDER BY `minOrder` ASC [ RunTime:0.003790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71666739 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71666739 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71666739 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='371-tan-48mmx50m' and brandshort='3m electronic specialty' limit 1 [ RunTime:0.000952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '371-tan-48mmx50m' OR `brand` LIKE '3m electronic specialty%' ) ) LIMIT 1 [ RunTime:0.000475s ]
SELECT `id` FROM `stock` WHERE `id` <> 71666739 AND `partno` = '371-tan-48mmx50m' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m electronic specialty%' ) [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71663569 LIMIT 5 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663569 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71663569 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71663569 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663569 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='37100' and brandshort='protektive pak' limit 1 [ RunTime:0.000962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37100' OR `brand` LIKE 'protektive pak%' ) ) LIMIT 1 [ RunTime:0.000687s ]
SELECT `id` FROM `stock` WHERE `id` <> 71663569 AND `partno` = '37100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%protektive pak%' ) [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509067 [ RunTime:0.000542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71663572 LIMIT 5 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663572 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71663572 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71663572 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663572 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='37116' and brandshort='protektive pak' limit 1 [ RunTime:0.000935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37116' OR `brand` LIKE 'protektive pak%' ) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT `id` FROM `stock` WHERE `id` <> 71663572 AND `partno` = '37116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%protektive pak%' ) [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508957 [ RunTime:0.003064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71705859 LIMIT 5 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705859 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71705859 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71705859 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705859 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
select * from pdf where partno='37116 010500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37116 010500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000406s ]
SELECT `id` FROM `stock` WHERE `id` <> 71705859 AND `partno` = '37116 010500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096888 LIMIT 5 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096888 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096888 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096888 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096888 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='3718' and brandshort='adafruit' limit 1 [ RunTime:0.001593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3718' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71705537 LIMIT 5 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705537 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71705537 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71705537 LIMIT 2 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705537 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='37112 010500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37112 010500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000386s ]
SELECT `id` FROM `stock` WHERE `id` <> 71705537 AND `partno` = '37112 010500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71706054 LIMIT 5 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71706054 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71706054 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71706054 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71706054 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='37118 010500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37118 010500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000467s ]
SELECT `id` FROM `stock` WHERE `id` <> 71706054 AND `partno` = '37118 010500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71706053 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71706053 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71706053 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71706053 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71706053 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='37118 005500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37118 005500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000516s ]
SELECT `id` FROM `stock` WHERE `id` <> 71706053 AND `partno` = '37118 005500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71705858 LIMIT 5 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705858 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71705858 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71705858 LIMIT 2 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705858 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='37116 002500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37116 002500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000572s ]
SELECT `id` FROM `stock` WHERE `id` <> 71705858 AND `partno` = '37116 002500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71663571 LIMIT 5 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663571 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71663571 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71663571 LIMIT 2 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663571 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='37114' and brandshort='protektive pak' limit 1 [ RunTime:0.000936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37114' OR `brand` LIKE 'protektive pak%' ) ) LIMIT 1 [ RunTime:0.000434s ]
SELECT `id` FROM `stock` WHERE `id` <> 71663571 AND `partno` = '37114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%protektive pak%' ) [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508898 [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32185477 LIMIT 5 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185477 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32185477 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32185477 LIMIT 2 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32185477 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='371007' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '371007' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000544s ]
SELECT `id` FROM `stock` WHERE `id` <> 32185477 AND `partno` = '371007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71663570 LIMIT 5 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663570 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71663570 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71663570 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663570 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='37101' and brandshort='protektive pak' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37101' OR `brand` LIKE 'protektive pak%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT `id` FROM `stock` WHERE `id` <> 71663570 AND `partno` = '37101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%protektive pak%' ) [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508633 [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71663420 LIMIT 5 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663420 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71663420 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71663420 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71663420 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='37140' and brandshort='protektive pak' limit 1 [ RunTime:0.002162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37140' OR `brand` LIKE 'protektive pak%' ) ) LIMIT 1 [ RunTime:0.000487s ]
SELECT `id` FROM `stock` WHERE `id` <> 71663420 AND `partno` = '37140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%protektive pak%' ) [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71706052 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71706052 ORDER BY `minOrder` ASC [ RunTime:0.004416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71706052 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71706052 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71706052 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
select * from pdf where partno='37116 004500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37116 004500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000726s ]
SELECT `id` FROM `stock` WHERE `id` <> 71706052 AND `partno` = '37116 004500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71705621 LIMIT 5 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705621 ORDER BY `minOrder` ASC [ RunTime:0.001263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71705621 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71705621 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71705621 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='37106 010100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37106 010100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000418s ]
SELECT `id` FROM `stock` WHERE `id` <> 71705621 AND `partno` = '37106 010100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138623 LIMIT 5 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138623 ORDER BY `minOrder` ASC [ RunTime:0.002810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138623 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138623 LIMIT 2 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138623 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='37114 010500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.000538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37114 010500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138623 AND `partno` = '37114 010500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.000440s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69844241 LIMIT 5 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69844241 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69844241 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69844241 LIMIT 2 [ RunTime:0.000271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69844241 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='37112 010500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37112 010500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000414s ]
SELECT `id` FROM `stock` WHERE `id` <> 69844241 AND `partno` = '37112 010500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14365414 [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711778 LIMIT 5 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711778 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711778 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711778 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711778 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='37104-A165-00E MB' and brandshort='3M' limit 1 [ RunTime:0.000646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37104-A165-00E MB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.001503s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711778 AND `partno` = '37104-A165-00E MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615521 [ RunTime:0.000283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69848437 LIMIT 5 [ RunTime:0.000255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848437 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69848437 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69848437 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848437 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='37110 0105000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37110 0105000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000377s ]
SELECT `id` FROM `stock` WHERE `id` <> 69848437 AND `partno` = '37110 0105000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14366245 [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69847952 LIMIT 5 [ RunTime:0.000256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69847952 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69847952 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69847952 LIMIT 2 [ RunTime:0.000239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69847952 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='37118 0025000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37118 0025000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000374s ]
SELECT `id` FROM `stock` WHERE `id` <> 69847952 AND `partno` = '37118 0025000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489642 [ RunTime:0.000274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69847953 LIMIT 5 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69847953 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69847953 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69847953 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69847953 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='37118 0105000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37118 0105000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000398s ]
SELECT `id` FROM `stock` WHERE `id` <> 69847953 AND `partno` = '37118 0105000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489643 [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66714069 LIMIT 5 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66714069 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66714069 ORDER BY `unit` DESC [ RunTime:0.000255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66714069 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66714069 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
select * from pdf where partno='37103-A206-00E MB' and brandshort='3M' limit 1 [ RunTime:0.000455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37103-A206-00E MB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.001404s ]
SELECT `id` FROM `stock` WHERE `id` <> 66714069 AND `partno` = '37103-A206-00E MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11618169 [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711779 LIMIT 5 [ RunTime:0.000241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711779 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711779 ORDER BY `unit` DESC [ RunTime:0.000235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711779 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711779 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
select * from pdf where partno='37104-B122-00E MB' and brandshort='3M' limit 1 [ RunTime:0.000377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37104-B122-00E MB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.001186s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711779 AND `partno` = '37104-B122-00E MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66712489 LIMIT 5 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66712489 ORDER BY `minOrder` ASC [ RunTime:0.001303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66712489 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66712489 LIMIT 2 [ RunTime:0.000227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66712489 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
select * from pdf where partno='37104-A206-00E MB' and brandshort='3M' limit 1 [ RunTime:0.000386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37104-A206-00E MB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.001372s ]
SELECT `id` FROM `stock` WHERE `id` <> 66712489 AND `partno` = '37104-A206-00E MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64967651 LIMIT 5 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64967651 ORDER BY `minOrder` ASC [ RunTime:0.001540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64967651 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64967651 LIMIT 2 [ RunTime:0.000233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64967651 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
select * from pdf where partno='371-1399-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.000787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '371-1399-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.001122s ]
SELECT `id` FROM `stock` WHERE `id` <> 64967651 AND `partno` = '371-1399-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11225793 [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711765 LIMIT 5 [ RunTime:0.000233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711765 ORDER BY `minOrder` ASC [ RunTime:0.001283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711765 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711765 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711765 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='37104-2165-000 FL 100' and brandshort='3M' limit 1 [ RunTime:0.000732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37104-2165-000 FL 100' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.001480s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711765 AND `partno` = '37104-2165-000 FL 100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69848213 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848213 ORDER BY `minOrder` ASC [ RunTime:0.001183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69848213 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69848213 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848213 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='37114 0024000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37114 0024000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000366s ]
SELECT `id` FROM `stock` WHERE `id` <> 69848213 AND `partno` = '37114 0024000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16402375 [ RunTime:0.002870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66712455 LIMIT 5 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66712455 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66712455 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66712455 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66712455 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
select * from pdf where partno='37103-A165-00E MB' and brandshort='3M' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37103-A165-00E MB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002784s ]
SELECT `id` FROM `stock` WHERE `id` <> 66712455 AND `partno` = '37103-A165-00E MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11618130 [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711756 LIMIT 5 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711756 ORDER BY `minOrder` ASC [ RunTime:0.000619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711756 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711756 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711756 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
select * from pdf where partno='37103-3101-000 FL 100' and brandshort='3M' limit 1 [ RunTime:0.000449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37103-3101-000 FL 100' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002548s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711756 AND `partno` = '37103-3101-000 FL 100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617778 [ RunTime:0.001625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66711766 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711766 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66711766 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66711766 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66711766 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='37104-3101-000 FL100' and brandshort='3M' limit 1 [ RunTime:0.000653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37104-3101-000 FL100' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002523s ]
SELECT `id` FROM `stock` WHERE `id` <> 66711766 AND `partno` = '37104-3101-000 FL100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799375 [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69903269 LIMIT 5 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69903269 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69903269 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69903269 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69903269 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='371901-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '371901-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000568s ]
SELECT `id` FROM `stock` WHERE `id` <> 69903269 AND `partno` = '371901-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16418795 [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69848461 LIMIT 5 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848461 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69848461 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69848461 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848461 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='37108 0102500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37108 0102500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000550s ]
SELECT `id` FROM `stock` WHERE `id` <> 69848461 AND `partno` = '37108 0102500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14366507 [ RunTime:0.002273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66712490 LIMIT 5 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66712490 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66712490 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66712490 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66712490 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='37104-B101-00E MB' and brandshort='3M' limit 1 [ RunTime:0.000611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37104-B101-00E MB' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002472s ]
SELECT `id` FROM `stock` WHERE `id` <> 66712490 AND `partno` = '37104-B101-00E MB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799385 [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69848196 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848196 ORDER BY `minOrder` ASC [ RunTime:0.000750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69848196 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69848196 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69848196 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='37116 002500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '37116 002500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000548s ]
SELECT `id` FROM `stock` WHERE `id` <> 69848196 AND `partno` = '37116 002500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16404225 [ RunTime:0.002176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71317176 LIMIT 5 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71317176 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71317176 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71317176 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71317176 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='3713CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3713CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000529s ]
SELECT `id` FROM `stock` WHERE `id` <> 71317176 AND `partno` = '3713CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347734 [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71317135 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71317135 ORDER BY `minOrder` ASC [ RunTime:0.000880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71317135 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71317135 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71317135 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='3710CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3710CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000684s ]
SELECT `id` FROM `stock` WHERE `id` <> 71317135 AND `partno` = '3710CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347725 [ RunTime:0.000748s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001179s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001031s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001119s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001005s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001023s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000998s ]
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 '371%' OR `brand` LIKE '371%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002149s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '371%' OR `brand` LIKE '371%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003275s ]