SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002508s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=GFP&search=1' [ RunTime:0.009591s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002282s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000514s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001416s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001091s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002047s ]
SELECT * FROM `stock_search` WHERE `partno` = 'GFP' LIMIT 1 [ RunTime:0.003105s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 15:22:34' WHERE `partno` = 'GFP' [ RunTime:0.003435s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001389s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029767s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19853283 LIMIT 5 [ RunTime:0.023582s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19853283 ORDER BY `minOrder` ASC [ RunTime:0.017686s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19853283 ORDER BY `unit` DESC [ RunTime:0.004931s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19853283 LIMIT 2 [ RunTime:0.002195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19853283 ORDER BY `minOrder` ASC [ RunTime:0.002642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13820947 LIMIT 5 [ RunTime:0.008033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13820947 ORDER BY `minOrder` ASC [ RunTime:0.001340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13820947 ORDER BY `unit` DESC [ RunTime:0.009699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13820947 LIMIT 2 [ RunTime:0.005660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13820947 ORDER BY `minOrder` ASC [ RunTime:0.001926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763388 LIMIT 5 [ RunTime:0.014082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763388 ORDER BY `minOrder` ASC [ RunTime:0.008724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763388 ORDER BY `unit` DESC [ RunTime:0.011954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763388 LIMIT 2 [ RunTime:0.012471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763388 ORDER BY `minOrder` ASC [ RunTime:0.016872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763387 LIMIT 5 [ RunTime:0.003863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763387 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763387 ORDER BY `unit` DESC [ RunTime:0.010233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763387 LIMIT 2 [ RunTime:0.017904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763387 ORDER BY `minOrder` ASC [ RunTime:0.012704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763386 LIMIT 5 [ RunTime:0.014827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763386 ORDER BY `minOrder` ASC [ RunTime:0.041302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763386 ORDER BY `unit` DESC [ RunTime:0.039042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763386 LIMIT 2 [ RunTime:0.031290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763386 ORDER BY `minOrder` ASC [ RunTime:0.006042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763385 LIMIT 5 [ RunTime:0.015858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763385 ORDER BY `minOrder` ASC [ RunTime:0.011017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763385 ORDER BY `unit` DESC [ RunTime:0.020070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763385 LIMIT 2 [ RunTime:0.016909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763385 ORDER BY `minOrder` ASC [ RunTime:0.017688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762707 LIMIT 5 [ RunTime:0.021431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762707 ORDER BY `minOrder` ASC [ RunTime:0.019305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762707 ORDER BY `unit` DESC [ RunTime:0.035876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762707 LIMIT 2 [ RunTime:0.047757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762707 ORDER BY `minOrder` ASC [ RunTime:0.006107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762706 LIMIT 5 [ RunTime:0.026854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762706 ORDER BY `minOrder` ASC [ RunTime:0.013459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762706 ORDER BY `unit` DESC [ RunTime:0.012359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762706 LIMIT 2 [ RunTime:0.017693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762706 ORDER BY `minOrder` ASC [ RunTime:0.008965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762705 LIMIT 5 [ RunTime:0.026375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762705 ORDER BY `minOrder` ASC [ RunTime:0.034112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762705 ORDER BY `unit` DESC [ RunTime:0.028358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762705 LIMIT 2 [ RunTime:0.016120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762705 ORDER BY `minOrder` ASC [ RunTime:0.014036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762441 LIMIT 5 [ RunTime:0.047398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762441 ORDER BY `minOrder` ASC [ RunTime:0.047590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762441 ORDER BY `unit` DESC [ RunTime:0.017710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762441 LIMIT 2 [ RunTime:0.018490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762441 ORDER BY `minOrder` ASC [ RunTime:0.026840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759977 LIMIT 5 [ RunTime:0.028943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759977 ORDER BY `minOrder` ASC [ RunTime:0.047870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759977 ORDER BY `unit` DESC [ RunTime:0.055918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759977 LIMIT 2 [ RunTime:0.024885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759977 ORDER BY `minOrder` ASC [ RunTime:0.020188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759976 LIMIT 5 [ RunTime:0.041764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759976 ORDER BY `minOrder` ASC [ RunTime:0.061055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759976 ORDER BY `unit` DESC [ RunTime:0.006315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759976 LIMIT 2 [ RunTime:0.016536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759976 ORDER BY `minOrder` ASC [ RunTime:0.021624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759938 LIMIT 5 [ RunTime:0.066231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759938 ORDER BY `minOrder` ASC [ RunTime:0.021639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759938 ORDER BY `unit` DESC [ RunTime:0.038371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759938 LIMIT 2 [ RunTime:0.043744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759938 ORDER BY `minOrder` ASC [ RunTime:0.032736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759708 LIMIT 5 [ RunTime:0.006598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759708 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759708 ORDER BY `unit` DESC [ RunTime:0.010599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759708 LIMIT 2 [ RunTime:0.032874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759708 ORDER BY `minOrder` ASC [ RunTime:0.024688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759707 LIMIT 5 [ RunTime:0.007191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759707 ORDER BY `minOrder` ASC [ RunTime:0.022638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759707 ORDER BY `unit` DESC [ RunTime:0.034834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759707 LIMIT 2 [ RunTime:0.028275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759707 ORDER BY `minOrder` ASC [ RunTime:0.038628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759706 LIMIT 5 [ RunTime:0.043604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759706 ORDER BY `minOrder` ASC [ RunTime:0.013344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759706 ORDER BY `unit` DESC [ RunTime:0.030048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759706 LIMIT 2 [ RunTime:0.006216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759706 ORDER BY `minOrder` ASC [ RunTime:0.002603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759705 LIMIT 5 [ RunTime:0.029564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759705 ORDER BY `minOrder` ASC [ RunTime:0.031248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759705 ORDER BY `unit` DESC [ RunTime:0.043450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759705 LIMIT 2 [ RunTime:0.005696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759705 ORDER BY `minOrder` ASC [ RunTime:0.005643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759704 LIMIT 5 [ RunTime:0.001992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759704 ORDER BY `minOrder` ASC [ RunTime:0.021124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759704 ORDER BY `unit` DESC [ RunTime:0.043823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759704 LIMIT 2 [ RunTime:0.042386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759704 ORDER BY `minOrder` ASC [ RunTime:0.012849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759454 LIMIT 5 [ RunTime:0.015514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759454 ORDER BY `minOrder` ASC [ RunTime:0.029915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759454 ORDER BY `unit` DESC [ RunTime:0.040961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759454 LIMIT 2 [ RunTime:0.039597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759454 ORDER BY `minOrder` ASC [ RunTime:0.009265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12758900 LIMIT 5 [ RunTime:0.029822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758900 ORDER BY `minOrder` ASC [ RunTime:0.003132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12758900 ORDER BY `unit` DESC [ RunTime:0.037534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12758900 LIMIT 2 [ RunTime:0.063462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12758900 ORDER BY `minOrder` ASC [ RunTime:0.016012s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010439s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44094593 LIMIT 5 [ RunTime:0.019117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094593 ORDER BY `minOrder` ASC [ RunTime:0.008541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44094593 ORDER BY `unit` DESC [ RunTime:0.012801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44094593 LIMIT 2 [ RunTime:0.011201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094593 ORDER BY `minOrder` ASC [ RunTime:0.003264s ]
select * from pdf where partno='GFP5045TC-S1' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.016703s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP5045TC-S1' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.008236s ]
SELECT `id` FROM `stock` WHERE `id` <> 44094593 AND `partno` = 'GFP5045TC-S1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.016329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44094578 LIMIT 5 [ RunTime:0.004014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094578 ORDER BY `minOrder` ASC [ RunTime:0.020758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44094578 ORDER BY `unit` DESC [ RunTime:0.004893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44094578 LIMIT 2 [ RunTime:0.008019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094578 ORDER BY `minOrder` ASC [ RunTime:0.011395s ]
select * from pdf where partno='GFP4045TS-S1' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.007928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP4045TS-S1' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.006414s ]
SELECT `id` FROM `stock` WHERE `id` <> 44094578 AND `partno` = 'GFP4045TS-S1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.009472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44094569 LIMIT 5 [ RunTime:0.011570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094569 ORDER BY `minOrder` ASC [ RunTime:0.034454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44094569 ORDER BY `unit` DESC [ RunTime:0.017543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44094569 LIMIT 2 [ RunTime:0.023931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44094569 ORDER BY `minOrder` ASC [ RunTime:0.016366s ]
select * from pdf where partno='GFP3045TS-S1' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.009281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP3045TS-S1' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.018205s ]
SELECT `id` FROM `stock` WHERE `id` <> 44094569 AND `partno` = 'GFP3045TS-S1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.028332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59543385 LIMIT 5 [ RunTime:0.035580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59543385 ORDER BY `minOrder` ASC [ RunTime:0.027570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59543385 ORDER BY `unit` DESC [ RunTime:0.033361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59543385 LIMIT 2 [ RunTime:0.025761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59543385 ORDER BY `minOrder` ASC [ RunTime:0.016624s ]
select * from pdf where partno='GFPL3M1FC0H' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.033145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL3M1FC0H' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.026999s ]
SELECT `id` FROM `stock` WHERE `id` <> 59543385 AND `partno` = 'GFPL3M1FC0H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.017372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19853283 [ RunTime:0.007502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58207716 LIMIT 5 [ RunTime:0.047791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207716 ORDER BY `minOrder` ASC [ RunTime:0.011107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58207716 ORDER BY `unit` DESC [ RunTime:0.042436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58207716 LIMIT 2 [ RunTime:0.062809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58207716 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
select * from pdf where partno='GFP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.024929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.023876s ]
SELECT `id` FROM `stock` WHERE `id` <> 58207716 AND `partno` = 'GFP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.030604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13820947 [ RunTime:0.019416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58218763 LIMIT 5 [ RunTime:0.031990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218763 ORDER BY `minOrder` ASC [ RunTime:0.023020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58218763 ORDER BY `unit` DESC [ RunTime:0.036934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58218763 LIMIT 2 [ RunTime:0.033447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218763 ORDER BY `minOrder` ASC [ RunTime:0.006801s ]
select * from pdf where partno='GFP11M4P9' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.048249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP11M4P9' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.041631s ]
SELECT `id` FROM `stock` WHERE `id` <> 58218763 AND `partno` = 'GFP11M4P9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.057442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58218760 LIMIT 5 [ RunTime:0.016999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218760 ORDER BY `minOrder` ASC [ RunTime:0.005582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58218760 ORDER BY `unit` DESC [ RunTime:0.009450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58218760 LIMIT 2 [ RunTime:0.021018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218760 ORDER BY `minOrder` ASC [ RunTime:0.002633s ]
select * from pdf where partno='GFP11A4P9' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.029545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP11A4P9' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.013156s ]
SELECT `id` FROM `stock` WHERE `id` <> 58218760 AND `partno` = 'GFP11A4P9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.050655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58218759 LIMIT 5 [ RunTime:0.017673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218759 ORDER BY `minOrder` ASC [ RunTime:0.010621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58218759 ORDER BY `unit` DESC [ RunTime:0.015817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58218759 LIMIT 2 [ RunTime:0.023640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218759 ORDER BY `minOrder` ASC [ RunTime:0.008140s ]
select * from pdf where partno='GFP11A4P3' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.009137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP11A4P3' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.016757s ]
SELECT `id` FROM `stock` WHERE `id` <> 58218759 AND `partno` = 'GFP11A4P3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.002998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58218753 LIMIT 5 [ RunTime:0.036097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218753 ORDER BY `minOrder` ASC [ RunTime:0.034480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58218753 ORDER BY `unit` DESC [ RunTime:0.028180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58218753 LIMIT 2 [ RunTime:0.027416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218753 ORDER BY `minOrder` ASC [ RunTime:0.012126s ]
select * from pdf where partno='GFP11M1P9' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.024365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP11M1P9' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.005413s ]
SELECT `id` FROM `stock` WHERE `id` <> 58218753 AND `partno` = 'GFP11M1P9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.028124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58218741 LIMIT 5 [ RunTime:0.036126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218741 ORDER BY `minOrder` ASC [ RunTime:0.013661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58218741 ORDER BY `unit` DESC [ RunTime:0.008816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58218741 LIMIT 2 [ RunTime:0.017471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58218741 ORDER BY `minOrder` ASC [ RunTime:0.006856s ]
select * from pdf where partno='GFP11A1P3' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.012131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFP11A1P3' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.008335s ]
SELECT `id` FROM `stock` WHERE `id` <> 58218741 AND `partno` = 'GFP11A1P3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.007779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53027896 LIMIT 5 [ RunTime:0.008192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53027896 ORDER BY `minOrder` ASC [ RunTime:0.025123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53027896 ORDER BY `unit` DESC [ RunTime:0.014622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53027896 LIMIT 2 [ RunTime:0.002946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53027896 ORDER BY `minOrder` ASC [ RunTime:0.007743s ]
select * from pdf where partno='GFPL4F000H-50' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.011165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL4F000H-50' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.002504s ]
SELECT `id` FROM `stock` WHERE `id` <> 53027896 AND `partno` = 'GFPL4F000H-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.011476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11507265 [ RunTime:0.018204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53027895 LIMIT 5 [ RunTime:0.029998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53027895 ORDER BY `minOrder` ASC [ RunTime:0.025143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53027895 ORDER BY `unit` DESC [ RunTime:0.017338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53027895 LIMIT 2 [ RunTime:0.011879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53027895 ORDER BY `minOrder` ASC [ RunTime:0.008427s ]
select * from pdf where partno='GFPL4F000H/AA-50' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.015795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL4F000H/AA-50' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.013086s ]
SELECT `id` FROM `stock` WHERE `id` <> 53027895 AND `partno` = 'GFPL4F000H/AA-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.042524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12648038 [ RunTime:0.004788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53014068 LIMIT 5 [ RunTime:0.013058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53014068 ORDER BY `minOrder` ASC [ RunTime:0.019553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53014068 ORDER BY `unit` DESC [ RunTime:0.004678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53014068 LIMIT 2 [ RunTime:0.010513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53014068 ORDER BY `minOrder` ASC [ RunTime:0.005143s ]
select * from pdf where partno='GFPL2F000H-14' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.003677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL2F000H-14' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.005789s ]
SELECT `id` FROM `stock` WHERE `id` <> 53014068 AND `partno` = 'GFPL2F000H-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.006071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12641401 [ RunTime:0.003249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53013097 LIMIT 5 [ RunTime:0.006354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53013097 ORDER BY `minOrder` ASC [ RunTime:0.030937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53013097 ORDER BY `unit` DESC [ RunTime:0.021663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53013097 LIMIT 2 [ RunTime:0.025145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53013097 ORDER BY `minOrder` ASC [ RunTime:0.020244s ]
select * from pdf where partno='GFPL4F000H/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL4F000H/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.009275s ]
SELECT `id` FROM `stock` WHERE `id` <> 53013097 AND `partno` = 'GFPL4F000H/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.017113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12640987 [ RunTime:0.014910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53012090 LIMIT 5 [ RunTime:0.003009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53012090 ORDER BY `minOrder` ASC [ RunTime:0.016104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53012090 ORDER BY `unit` DESC [ RunTime:0.016472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53012090 LIMIT 2 [ RunTime:0.030675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53012090 ORDER BY `minOrder` ASC [ RunTime:0.016129s ]
select * from pdf where partno='GFPL2F000H/AA-14' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.035999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL2F000H/AA-14' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.012102s ]
SELECT `id` FROM `stock` WHERE `id` <> 53012090 AND `partno` = 'GFPL2F000H/AA-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.042316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12641400 [ RunTime:0.021926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53011120 LIMIT 5 [ RunTime:0.023262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53011120 ORDER BY `minOrder` ASC [ RunTime:0.054555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53011120 ORDER BY `unit` DESC [ RunTime:0.013619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53011120 LIMIT 2 [ RunTime:0.022468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53011120 ORDER BY `minOrder` ASC [ RunTime:0.020833s ]
select * from pdf where partno='GFPL4F000H' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.016512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL4F000H' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.012217s ]
SELECT `id` FROM `stock` WHERE `id` <> 53011120 AND `partno` = 'GFPL4F000H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.020377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12640988 [ RunTime:0.013346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53003743 LIMIT 5 [ RunTime:0.038045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53003743 ORDER BY `minOrder` ASC [ RunTime:0.023432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53003743 ORDER BY `unit` DESC [ RunTime:0.016668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53003743 LIMIT 2 [ RunTime:0.036045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53003743 ORDER BY `minOrder` ASC [ RunTime:0.017068s ]
select * from pdf where partno='GFPL2F000H' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.003633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL2F000H' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.058374s ]
SELECT `id` FROM `stock` WHERE `id` <> 53003743 AND `partno` = 'GFPL2F000H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.023248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12637072 [ RunTime:0.030654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53003742 LIMIT 5 [ RunTime:0.008527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53003742 ORDER BY `minOrder` ASC [ RunTime:0.026278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53003742 ORDER BY `unit` DESC [ RunTime:0.025781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53003742 LIMIT 2 [ RunTime:0.029157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53003742 ORDER BY `minOrder` ASC [ RunTime:0.050938s ]
select * from pdf where partno='GFPL2F000H/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.015054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL2F000H/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.024119s ]
SELECT `id` FROM `stock` WHERE `id` <> 53003742 AND `partno` = 'GFPL2F000H/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.035532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11499998 [ RunTime:0.022858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52879617 LIMIT 5 [ RunTime:0.003640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879617 ORDER BY `minOrder` ASC [ RunTime:0.039435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52879617 ORDER BY `unit` DESC [ RunTime:0.027538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52879617 LIMIT 2 [ RunTime:0.029871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879617 ORDER BY `minOrder` ASC [ RunTime:0.009839s ]
select * from pdf where partno='GFPL2M2FCD0H-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.001486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL2M2FCD0H-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.014007s ]
SELECT `id` FROM `stock` WHERE `id` <> 52879617 AND `partno` = 'GFPL2M2FCD0H-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.017214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763386 [ RunTime:0.016723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52878193 LIMIT 5 [ RunTime:0.006561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52878193 ORDER BY `minOrder` ASC [ RunTime:0.018537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52878193 ORDER BY `unit` DESC [ RunTime:0.013270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52878193 LIMIT 2 [ RunTime:0.029389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52878193 ORDER BY `minOrder` ASC [ RunTime:0.007618s ]
select * from pdf where partno='GFPL2M2FCD0H/AA-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.023869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFPL2M2FCD0H/AA-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.010677s ]
SELECT `id` FROM `stock` WHERE `id` <> 52878193 AND `partno` = 'GFPL2M2FCD0H/AA-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.003003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763388 [ RunTime:0.018787s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008588s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019641s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010806s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011632s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022420s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013756s ]
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 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007447s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'GFP%' OR `brand` LIKE 'GFP%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005645s ]