SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002338s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=6915&search=1' [ RunTime:0.006923s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001408s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004042s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002176s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.003331s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001932s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002236s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002539s ]
SELECT * FROM `stock_search` WHERE `partno` = '6915' LIMIT 1 [ RunTime:0.034657s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 07:37:42' WHERE `partno` = '6915' [ RunTime:0.024318s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002380s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043004s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19816388 LIMIT 5 [ RunTime:0.005105s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816388 ORDER BY `minOrder` ASC [ RunTime:0.005107s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19816388 ORDER BY `unit` DESC [ RunTime:0.008978s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19816388 LIMIT 2 [ RunTime:0.007345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816388 ORDER BY `minOrder` ASC [ RunTime:0.019393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556519 LIMIT 5 [ RunTime:0.023821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556519 ORDER BY `minOrder` ASC [ RunTime:0.002714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556519 ORDER BY `unit` DESC [ RunTime:0.013475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556519 LIMIT 2 [ RunTime:0.017698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556519 ORDER BY `minOrder` ASC [ RunTime:0.008600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12554288 LIMIT 5 [ RunTime:0.034027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12554288 ORDER BY `minOrder` ASC [ RunTime:0.025637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12554288 ORDER BY `unit` DESC [ RunTime:0.017667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12554288 LIMIT 2 [ RunTime:0.019195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12554288 ORDER BY `minOrder` ASC [ RunTime:0.002483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496113 LIMIT 5 [ RunTime:0.043292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496113 ORDER BY `minOrder` ASC [ RunTime:0.057010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496113 ORDER BY `unit` DESC [ RunTime:0.028655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496113 LIMIT 2 [ RunTime:0.013497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496113 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435538 LIMIT 5 [ RunTime:0.002816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435538 ORDER BY `minOrder` ASC [ RunTime:0.040540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11435538 ORDER BY `unit` DESC [ RunTime:0.024680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11435538 LIMIT 2 [ RunTime:0.016678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435538 ORDER BY `minOrder` ASC [ RunTime:0.007246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11443946 LIMIT 5 [ RunTime:0.012041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11443946 ORDER BY `minOrder` ASC [ RunTime:0.012691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11443946 ORDER BY `unit` DESC [ RunTime:0.005446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11443946 LIMIT 2 [ RunTime:0.034584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11443946 ORDER BY `minOrder` ASC [ RunTime:0.017285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12547604 LIMIT 5 [ RunTime:0.026707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12547604 ORDER BY `minOrder` ASC [ RunTime:0.037823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12547604 ORDER BY `unit` DESC [ RunTime:0.038288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12547604 LIMIT 2 [ RunTime:0.022410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12547604 ORDER BY `minOrder` ASC [ RunTime:0.006669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12548177 LIMIT 5 [ RunTime:0.012394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12548177 ORDER BY `minOrder` ASC [ RunTime:0.015804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12548177 ORDER BY `unit` DESC [ RunTime:0.026929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12548177 LIMIT 2 [ RunTime:0.044741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12548177 ORDER BY `minOrder` ASC [ RunTime:0.002847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544381 LIMIT 5 [ RunTime:0.025055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544381 ORDER BY `minOrder` ASC [ RunTime:0.017736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544381 ORDER BY `unit` DESC [ RunTime:0.030690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544381 LIMIT 2 [ RunTime:0.012890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544381 ORDER BY `minOrder` ASC [ RunTime:0.007563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556047 LIMIT 5 [ RunTime:0.003196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556047 ORDER BY `minOrder` ASC [ RunTime:0.008321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556047 ORDER BY `unit` DESC [ RunTime:0.020463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556047 LIMIT 2 [ RunTime:0.004683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556047 ORDER BY `minOrder` ASC [ RunTime:0.003169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618310 LIMIT 5 [ RunTime:0.012890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618310 ORDER BY `minOrder` ASC [ RunTime:0.012645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618310 ORDER BY `unit` DESC [ RunTime:0.012869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618310 LIMIT 2 [ RunTime:0.014289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618310 ORDER BY `minOrder` ASC [ RunTime:0.016193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210519 LIMIT 5 [ RunTime:0.006946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210519 ORDER BY `minOrder` ASC [ RunTime:0.009105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210519 ORDER BY `unit` DESC [ RunTime:0.014295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210519 LIMIT 2 [ RunTime:0.022488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210519 ORDER BY `minOrder` ASC [ RunTime:0.003462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829596 LIMIT 5 [ RunTime:0.021294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829596 ORDER BY `minOrder` ASC [ RunTime:0.008025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19829596 ORDER BY `unit` DESC [ RunTime:0.032321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19829596 LIMIT 2 [ RunTime:0.021222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829596 ORDER BY `minOrder` ASC [ RunTime:0.006273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812034 LIMIT 5 [ RunTime:0.022926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812034 ORDER BY `minOrder` ASC [ RunTime:0.028262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19812034 ORDER BY `unit` DESC [ RunTime:0.008262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19812034 LIMIT 2 [ RunTime:0.017757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812034 ORDER BY `minOrder` ASC [ RunTime:0.005485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810880 LIMIT 5 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810880 ORDER BY `minOrder` ASC [ RunTime:0.015379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19810880 ORDER BY `unit` DESC [ RunTime:0.011229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19810880 LIMIT 2 [ RunTime:0.007871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810880 ORDER BY `minOrder` ASC [ RunTime:0.002359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810295 LIMIT 5 [ RunTime:0.006548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810295 ORDER BY `minOrder` ASC [ RunTime:0.013511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19810295 ORDER BY `unit` DESC [ RunTime:0.022870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19810295 LIMIT 2 [ RunTime:0.024709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810295 ORDER BY `minOrder` ASC [ RunTime:0.017658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19808750 LIMIT 5 [ RunTime:0.002640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808750 ORDER BY `minOrder` ASC [ RunTime:0.014132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19808750 ORDER BY `unit` DESC [ RunTime:0.014314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19808750 LIMIT 2 [ RunTime:0.012561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808750 ORDER BY `minOrder` ASC [ RunTime:0.016446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19806625 LIMIT 5 [ RunTime:0.017681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806625 ORDER BY `minOrder` ASC [ RunTime:0.028216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19806625 ORDER BY `unit` DESC [ RunTime:0.019300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19806625 LIMIT 2 [ RunTime:0.028287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806625 ORDER BY `minOrder` ASC [ RunTime:0.004006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19806295 LIMIT 5 [ RunTime:0.016157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806295 ORDER BY `minOrder` ASC [ RunTime:0.010928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19806295 ORDER BY `unit` DESC [ RunTime:0.010988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19806295 LIMIT 2 [ RunTime:0.009266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806295 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19806290 LIMIT 5 [ RunTime:0.010487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806290 ORDER BY `minOrder` ASC [ RunTime:0.035773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19806290 ORDER BY `unit` DESC [ RunTime:0.025411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19806290 LIMIT 2 [ RunTime:0.026085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806290 ORDER BY `minOrder` ASC [ RunTime:0.031495s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014932s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52575156 LIMIT 5 [ RunTime:0.016414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52575156 ORDER BY `minOrder` ASC [ RunTime:0.038072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52575156 ORDER BY `unit` DESC [ RunTime:0.036313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52575156 LIMIT 2 [ RunTime:0.020333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52575156 ORDER BY `minOrder` ASC [ RunTime:0.003602s ]
select * from pdf where partno='69157-102HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.028214s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69157-102HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.019613s ]
SELECT `id` FROM `stock` WHERE `id` <> 52575156 AND `partno` = '69157-102HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.021088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19816388 [ RunTime:0.012363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53737748 LIMIT 5 [ RunTime:0.002508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737748 ORDER BY `minOrder` ASC [ RunTime:0.008016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53737748 ORDER BY `unit` DESC [ RunTime:0.013847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53737748 LIMIT 2 [ RunTime:0.036743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737748 ORDER BY `minOrder` ASC [ RunTime:0.000947s ]
select * from pdf where partno='691502710003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691502710003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025391s ]
SELECT `id` FROM `stock` WHERE `id` <> 53737748 AND `partno` = '691502710003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.016303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556519 [ RunTime:0.026741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53737677 LIMIT 5 [ RunTime:0.012247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737677 ORDER BY `minOrder` ASC [ RunTime:0.024107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53737677 ORDER BY `unit` DESC [ RunTime:0.008952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53737677 LIMIT 2 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737677 ORDER BY `minOrder` ASC [ RunTime:0.013628s ]
select * from pdf where partno='691502710002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691502710002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.032143s ]
SELECT `id` FROM `stock` WHERE `id` <> 53737677 AND `partno` = '691502710002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12554288 [ RunTime:0.007916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53086331 LIMIT 5 [ RunTime:0.005307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53086331 ORDER BY `minOrder` ASC [ RunTime:0.023053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53086331 ORDER BY `unit` DESC [ RunTime:0.008470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53086331 LIMIT 2 [ RunTime:0.007036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53086331 ORDER BY `minOrder` ASC [ RunTime:0.010569s ]
select * from pdf where partno='69153-032LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.005204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69153-032LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004427s ]
SELECT `id` FROM `stock` WHERE `id` <> 53086331 AND `partno` = '69153-032LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486584 [ RunTime:0.009433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53737552 LIMIT 5 [ RunTime:0.005646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737552 ORDER BY `minOrder` ASC [ RunTime:0.016883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53737552 ORDER BY `unit` DESC [ RunTime:0.028895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53737552 LIMIT 2 [ RunTime:0.009342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737552 ORDER BY `minOrder` ASC [ RunTime:0.003112s ]
select * from pdf where partno='691508110302' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691508110302' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.036561s ]
SELECT `id` FROM `stock` WHERE `id` <> 53737552 AND `partno` = '691508110302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.053415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11443946 [ RunTime:0.005953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53082834 LIMIT 5 [ RunTime:0.023934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082834 ORDER BY `minOrder` ASC [ RunTime:0.023341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53082834 ORDER BY `unit` DESC [ RunTime:0.002755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53082834 LIMIT 2 [ RunTime:0.002457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082834 ORDER BY `minOrder` ASC [ RunTime:0.001598s ]
select * from pdf where partno='69153-027LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.011588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69153-027LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004201s ]
SELECT `id` FROM `stock` WHERE `id` <> 53082834 AND `partno` = '69153-027LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.022104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496113 [ RunTime:0.018763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53739193 LIMIT 5 [ RunTime:0.007656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739193 ORDER BY `minOrder` ASC [ RunTime:0.012289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53739193 ORDER BY `unit` DESC [ RunTime:0.017461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53739193 LIMIT 2 [ RunTime:0.004334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739193 ORDER BY `minOrder` ASC [ RunTime:0.012850s ]
select * from pdf where partno='691508110304' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691508110304' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007665s ]
SELECT `id` FROM `stock` WHERE `id` <> 53739193 AND `partno` = '691508110304' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435538 [ RunTime:0.007634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53739104 LIMIT 5 [ RunTime:0.010215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739104 ORDER BY `minOrder` ASC [ RunTime:0.048117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53739104 ORDER BY `unit` DESC [ RunTime:0.020377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53739104 LIMIT 2 [ RunTime:0.027687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739104 ORDER BY `minOrder` ASC [ RunTime:0.007218s ]
select * from pdf where partno='691508110303' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691508110303' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.037066s ]
SELECT `id` FROM `stock` WHERE `id` <> 53739104 AND `partno` = '691508110303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544381 [ RunTime:0.033231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53739277 LIMIT 5 [ RunTime:0.013115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739277 ORDER BY `minOrder` ASC [ RunTime:0.015423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53739277 ORDER BY `unit` DESC [ RunTime:0.013111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53739277 LIMIT 2 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739277 ORDER BY `minOrder` ASC [ RunTime:0.016864s ]
select * from pdf where partno='691508110306' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691508110306' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.012032s ]
SELECT `id` FROM `stock` WHERE `id` <> 53739277 AND `partno` = '691508110306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.008169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556047 [ RunTime:0.004490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53739983 LIMIT 5 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739983 ORDER BY `minOrder` ASC [ RunTime:0.004375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53739983 ORDER BY `unit` DESC [ RunTime:0.004723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53739983 LIMIT 2 [ RunTime:0.003929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739983 ORDER BY `minOrder` ASC [ RunTime:0.014957s ]
select * from pdf where partno='691508110305' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691508110305' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004418s ]
SELECT `id` FROM `stock` WHERE `id` <> 53739983 AND `partno` = '691508110305' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.008689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12547604 [ RunTime:0.003772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53742217 LIMIT 5 [ RunTime:0.016113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53742217 ORDER BY `minOrder` ASC [ RunTime:0.009964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53742217 ORDER BY `unit` DESC [ RunTime:0.004592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53742217 LIMIT 2 [ RunTime:0.002851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53742217 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
select * from pdf where partno='691508110308' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691508110308' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002036s ]
SELECT `id` FROM `stock` WHERE `id` <> 53742217 AND `partno` = '691508110308' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12548177 [ RunTime:0.003303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53090922 LIMIT 5 [ RunTime:0.007197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53090922 ORDER BY `minOrder` ASC [ RunTime:0.005179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53090922 ORDER BY `unit` DESC [ RunTime:0.001881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53090922 LIMIT 2 [ RunTime:0.013355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53090922 ORDER BY `minOrder` ASC [ RunTime:0.004039s ]
select * from pdf where partno='69153-034LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.024756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69153-034LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.010134s ]
SELECT `id` FROM `stock` WHERE `id` <> 53090922 AND `partno` = '69153-034LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618310 [ RunTime:0.002437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44626815 LIMIT 5 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626815 ORDER BY `minOrder` ASC [ RunTime:0.005883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44626815 ORDER BY `unit` DESC [ RunTime:0.015618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44626815 LIMIT 2 [ RunTime:0.002228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626815 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='69151-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.003947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69151-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000776s ]
SELECT `id` FROM `stock` WHERE `id` <> 44626815 AND `partno` = '69151-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.006781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210519 [ RunTime:0.011681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33108312 LIMIT 5 [ RunTime:0.002375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33108312 ORDER BY `minOrder` ASC [ RunTime:0.012432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33108312 ORDER BY `unit` DESC [ RunTime:0.009432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33108312 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33108312 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='69151-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69151-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.004779s ]
SELECT `id` FROM `stock` WHERE `id` <> 33108312 AND `partno` = '69151-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.017087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210519 [ RunTime:0.004931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51661849 LIMIT 5 [ RunTime:0.013024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51661849 ORDER BY `minOrder` ASC [ RunTime:0.002265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51661849 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51661849 LIMIT 2 [ RunTime:0.012329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51661849 ORDER BY `minOrder` ASC [ RunTime:0.006160s ]
select * from pdf where partno='69151-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.014675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69151-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.012493s ]
SELECT `id` FROM `stock` WHERE `id` <> 51661849 AND `partno` = '69151-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.003732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57716886 LIMIT 5 [ RunTime:0.014655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57716886 ORDER BY `minOrder` ASC [ RunTime:0.002054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57716886 ORDER BY `unit` DESC [ RunTime:0.002119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57716886 LIMIT 2 [ RunTime:0.013702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57716886 ORDER BY `minOrder` ASC [ RunTime:0.002609s ]
select * from pdf where partno='69157' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69157' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002374s ]
SELECT `id` FROM `stock` WHERE `id` <> 57716886 AND `partno` = '69157' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421264 [ RunTime:0.001259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57465551 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57465551 ORDER BY `minOrder` ASC [ RunTime:0.001200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57465551 ORDER BY `unit` DESC [ RunTime:0.000708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57465551 LIMIT 2 [ RunTime:0.013894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57465551 ORDER BY `minOrder` ASC [ RunTime:0.011052s ]
select * from pdf where partno='6915' and brandshort='3M' limit 1 [ RunTime:0.016039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6915' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.005770s ]
SELECT `id` FROM `stock` WHERE `id` <> 57465551 AND `partno` = '6915' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12275894 [ RunTime:0.010317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56501284 LIMIT 5 [ RunTime:0.002998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56501284 ORDER BY `minOrder` ASC [ RunTime:0.007575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56501284 ORDER BY `unit` DESC [ RunTime:0.012102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56501284 LIMIT 2 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56501284 ORDER BY `minOrder` ASC [ RunTime:0.002592s ]
select * from pdf where partno='6915-1002-030' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6915-1002-030' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.002042s ]
SELECT `id` FROM `stock` WHERE `id` <> 56501284 AND `partno` = '6915-1002-030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.001013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56501262 LIMIT 5 [ RunTime:0.001925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56501262 ORDER BY `minOrder` ASC [ RunTime:0.000972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56501262 ORDER BY `unit` DESC [ RunTime:0.008283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56501262 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56501262 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='6915-1003-030' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.003778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6915-1003-030' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.003673s ]
SELECT `id` FROM `stock` WHERE `id` <> 56501262 AND `partno` = '6915-1003-030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.027920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13226527 [ RunTime:0.014665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53105526 LIMIT 5 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53105526 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53105526 ORDER BY `unit` DESC [ RunTime:0.002530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53105526 LIMIT 2 [ RunTime:0.010461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53105526 ORDER BY `minOrder` ASC [ RunTime:0.003036s ]
select * from pdf where partno='69150-024LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69150-024LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004191s ]
SELECT `id` FROM `stock` WHERE `id` <> 53105526 AND `partno` = '69150-024LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12625266 [ RunTime:0.001231s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006089s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009890s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001360s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004286s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005448s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001839s ]
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 '6915%' OR `brand` LIKE '6915%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001372s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6915%' OR `brand` LIKE '6915%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011397s ]