SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001236s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=70223&search=1' [ RunTime:0.003603s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001246s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003683s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002027s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001115s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001036s ]
SELECT * FROM `stock_search` WHERE `partno` = '70223' LIMIT 1 [ RunTime:0.008285s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-05 02:28:01' WHERE `partno` = '70223' [ RunTime:0.009252s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002621s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020917s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350077 LIMIT 5 [ RunTime:0.002980s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350077 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350077 ORDER BY `unit` DESC [ RunTime:0.002387s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350077 LIMIT 2 [ RunTime:0.000917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350077 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068282 LIMIT 5 [ RunTime:0.002188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068282 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068282 ORDER BY `unit` DESC [ RunTime:0.003159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068282 LIMIT 2 [ RunTime:0.005438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068282 ORDER BY `minOrder` ASC [ RunTime:0.002574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17504109 LIMIT 5 [ RunTime:0.001925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17504109 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17504109 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17504109 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17504109 ORDER BY `minOrder` ASC [ RunTime:0.002652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17501229 LIMIT 5 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501229 ORDER BY `minOrder` ASC [ RunTime:0.003768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17501229 ORDER BY `unit` DESC [ RunTime:0.002655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17501229 LIMIT 2 [ RunTime:0.004013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501229 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14699835 LIMIT 5 [ RunTime:0.002253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14699835 ORDER BY `minOrder` ASC [ RunTime:0.001513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14699835 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14699835 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14699835 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550812 LIMIT 5 [ RunTime:0.000869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550812 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13550812 ORDER BY `unit` DESC [ RunTime:0.016762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13550812 LIMIT 2 [ RunTime:0.002678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13550812 ORDER BY `minOrder` ASC [ RunTime:0.002557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13298332 LIMIT 5 [ RunTime:0.009221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13298332 ORDER BY `minOrder` ASC [ RunTime:0.006444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13298332 ORDER BY `unit` DESC [ RunTime:0.005480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13298332 LIMIT 2 [ RunTime:0.020504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13298332 ORDER BY `minOrder` ASC [ RunTime:0.002817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13297683 LIMIT 5 [ RunTime:0.008421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297683 ORDER BY `minOrder` ASC [ RunTime:0.025103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13297683 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13297683 LIMIT 2 [ RunTime:0.007801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297683 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294007 LIMIT 5 [ RunTime:0.000938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294007 ORDER BY `minOrder` ASC [ RunTime:0.005608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13294007 ORDER BY `unit` DESC [ RunTime:0.006123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13294007 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294007 ORDER BY `minOrder` ASC [ RunTime:0.003337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292977 LIMIT 5 [ RunTime:0.000950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292977 ORDER BY `minOrder` ASC [ RunTime:0.002067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292977 ORDER BY `unit` DESC [ RunTime:0.003573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292977 LIMIT 2 [ RunTime:0.006705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292977 ORDER BY `minOrder` ASC [ RunTime:0.002137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284631 LIMIT 5 [ RunTime:0.001011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284631 ORDER BY `minOrder` ASC [ RunTime:0.007674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13284631 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13284631 LIMIT 2 [ RunTime:0.015443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284631 ORDER BY `minOrder` ASC [ RunTime:0.004072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12168891 LIMIT 5 [ RunTime:0.008558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168891 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12168891 ORDER BY `unit` DESC [ RunTime:0.010943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12168891 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168891 ORDER BY `minOrder` ASC [ RunTime:0.001920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029340 LIMIT 5 [ RunTime:0.007911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029340 ORDER BY `minOrder` ASC [ RunTime:0.001082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12029340 ORDER BY `unit` DESC [ RunTime:0.003537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12029340 LIMIT 2 [ RunTime:0.009625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12029340 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028989 LIMIT 5 [ RunTime:0.009889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028989 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028989 ORDER BY `unit` DESC [ RunTime:0.007201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028989 LIMIT 2 [ RunTime:0.011260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028989 ORDER BY `minOrder` ASC [ RunTime:0.006840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028481 LIMIT 5 [ RunTime:0.015567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028481 ORDER BY `minOrder` ASC [ RunTime:0.019530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028481 ORDER BY `unit` DESC [ RunTime:0.012563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028481 LIMIT 2 [ RunTime:0.006082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028481 ORDER BY `minOrder` ASC [ RunTime:0.029819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028453 LIMIT 5 [ RunTime:0.007078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028453 ORDER BY `minOrder` ASC [ RunTime:0.009031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028453 ORDER BY `unit` DESC [ RunTime:0.025436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028453 LIMIT 2 [ RunTime:0.038290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028453 ORDER BY `minOrder` ASC [ RunTime:0.005166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026582 LIMIT 5 [ RunTime:0.023020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026582 ORDER BY `minOrder` ASC [ RunTime:0.089191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026582 ORDER BY `unit` DESC [ RunTime:0.080150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026582 LIMIT 2 [ RunTime:0.040473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026582 ORDER BY `minOrder` ASC [ RunTime:0.013150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026563 LIMIT 5 [ RunTime:0.013852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026563 ORDER BY `minOrder` ASC [ RunTime:0.112456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12026563 ORDER BY `unit` DESC [ RunTime:0.071372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12026563 LIMIT 2 [ RunTime:0.050958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12026563 ORDER BY `minOrder` ASC [ RunTime:0.050984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12024640 LIMIT 5 [ RunTime:0.051538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12024640 ORDER BY `minOrder` ASC [ RunTime:0.051315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12024640 ORDER BY `unit` DESC [ RunTime:0.051093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12024640 LIMIT 2 [ RunTime:0.049670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12024640 ORDER BY `minOrder` ASC [ RunTime:0.009561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12023477 LIMIT 5 [ RunTime:0.021255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12023477 ORDER BY `minOrder` ASC [ RunTime:0.025597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12023477 ORDER BY `unit` DESC [ RunTime:0.035191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12023477 LIMIT 2 [ RunTime:0.076694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12023477 ORDER BY `minOrder` ASC [ RunTime:0.045459s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054834s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560792 LIMIT 5 [ RunTime:0.007713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560792 ORDER BY `minOrder` ASC [ RunTime:0.047265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560792 ORDER BY `unit` DESC [ RunTime:0.012387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560792 LIMIT 2 [ RunTime:0.029670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560792 ORDER BY `minOrder` ASC [ RunTime:0.042749s ]
select * from pdf where partno='70223CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.034488s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70223CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.012830s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560792 AND `partno` = '70223CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350077 [ RunTime:0.016409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64566140 LIMIT 5 [ RunTime:0.015030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566140 ORDER BY `minOrder` ASC [ RunTime:0.014919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64566140 ORDER BY `unit` DESC [ RunTime:0.002414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64566140 LIMIT 2 [ RunTime:0.017157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64566140 ORDER BY `minOrder` ASC [ RunTime:0.010504s ]
select * from pdf where partno='70223SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70223SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.015072s ]
SELECT `id` FROM `stock` WHERE `id` <> 64566140 AND `partno` = '70223SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068282 [ RunTime:0.009311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58559855 LIMIT 5 [ RunTime:0.005328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58559855 ORDER BY `minOrder` ASC [ RunTime:0.019789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58559855 ORDER BY `unit` DESC [ RunTime:0.035111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58559855 LIMIT 2 [ RunTime:0.003178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58559855 ORDER BY `minOrder` ASC [ RunTime:0.012578s ]
select * from pdf where partno='70223' and brandshort='Wiha' limit 1 [ RunTime:0.021642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70223' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.034945s ]
SELECT `id` FROM `stock` WHERE `id` <> 58559855 AND `partno` = '70223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.005722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12168891 [ RunTime:0.028883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64536378 LIMIT 5 [ RunTime:0.023055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536378 ORDER BY `minOrder` ASC [ RunTime:0.013354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64536378 ORDER BY `unit` DESC [ RunTime:0.051449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64536378 LIMIT 2 [ RunTime:0.003327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64536378 ORDER BY `minOrder` ASC [ RunTime:0.021600s ]
select * from pdf where partno='70223' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70223' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.035529s ]
SELECT `id` FROM `stock` WHERE `id` <> 64536378 AND `partno` = '70223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.028185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550812 [ RunTime:0.024371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62979178 LIMIT 5 [ RunTime:0.012926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62979178 ORDER BY `minOrder` ASC [ RunTime:0.062844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62979178 ORDER BY `unit` DESC [ RunTime:0.009382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62979178 LIMIT 2 [ RunTime:0.064795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62979178 ORDER BY `minOrder` ASC [ RunTime:0.015427s ]
select * from pdf where partno='7022308' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022308' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014186s ]
SELECT `id` FROM `stock` WHERE `id` <> 62979178 AND `partno` = '7022308' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14699835 [ RunTime:0.017145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62202731 LIMIT 5 [ RunTime:0.026339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62202731 ORDER BY `minOrder` ASC [ RunTime:0.017322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62202731 ORDER BY `unit` DESC [ RunTime:0.017198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62202731 LIMIT 2 [ RunTime:0.028133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62202731 ORDER BY `minOrder` ASC [ RunTime:0.009158s ]
select * from pdf where partno='7022335' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022335' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015886s ]
SELECT `id` FROM `stock` WHERE `id` <> 62202731 AND `partno` = '7022335' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.028030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17504109 [ RunTime:0.019949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62198282 LIMIT 5 [ RunTime:0.011787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62198282 ORDER BY `minOrder` ASC [ RunTime:0.020119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62198282 ORDER BY `unit` DESC [ RunTime:0.007480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62198282 LIMIT 2 [ RunTime:0.012792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62198282 ORDER BY `minOrder` ASC [ RunTime:0.033374s ]
select * from pdf where partno='7022334' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022334' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.043029s ]
SELECT `id` FROM `stock` WHERE `id` <> 62198282 AND `partno` = '7022334' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17501229 [ RunTime:0.015347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61297849 LIMIT 5 [ RunTime:0.012285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61297849 ORDER BY `minOrder` ASC [ RunTime:0.028999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61297849 ORDER BY `unit` DESC [ RunTime:0.000743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61297849 LIMIT 2 [ RunTime:0.018670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61297849 ORDER BY `minOrder` ASC [ RunTime:0.008546s ]
select * from pdf where partno='7022310' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022310' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010756s ]
SELECT `id` FROM `stock` WHERE `id` <> 61297849 AND `partno` = '7022310' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10772815 [ RunTime:0.018393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32750017 LIMIT 5 [ RunTime:0.014769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32750017 ORDER BY `minOrder` ASC [ RunTime:0.010236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32750017 ORDER BY `unit` DESC [ RunTime:0.013370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32750017 LIMIT 2 [ RunTime:0.005102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32750017 ORDER BY `minOrder` ASC [ RunTime:0.017409s ]
select * from pdf where partno='7022348' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022348' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007669s ]
SELECT `id` FROM `stock` WHERE `id` <> 32750017 AND `partno` = '7022348' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13298332 [ RunTime:0.006004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32742152 LIMIT 5 [ RunTime:0.012166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32742152 ORDER BY `minOrder` ASC [ RunTime:0.011194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32742152 ORDER BY `unit` DESC [ RunTime:0.004406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32742152 LIMIT 2 [ RunTime:0.003310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32742152 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
select * from pdf where partno='7022338' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022338' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017116s ]
SELECT `id` FROM `stock` WHERE `id` <> 32742152 AND `partno` = '7022338' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12029340 [ RunTime:0.005811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32728969 LIMIT 5 [ RunTime:0.004857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32728969 ORDER BY `minOrder` ASC [ RunTime:0.007560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32728969 ORDER BY `unit` DESC [ RunTime:0.003167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32728969 LIMIT 2 [ RunTime:0.001358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32728969 ORDER BY `minOrder` ASC [ RunTime:0.005179s ]
select * from pdf where partno='7022322' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022322' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003051s ]
SELECT `id` FROM `stock` WHERE `id` <> 32728969 AND `partno` = '7022322' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13297683 [ RunTime:0.003208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32726746 LIMIT 5 [ RunTime:0.020646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32726746 ORDER BY `minOrder` ASC [ RunTime:0.032110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32726746 ORDER BY `unit` DESC [ RunTime:0.022196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32726746 LIMIT 2 [ RunTime:0.055115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32726746 ORDER BY `minOrder` ASC [ RunTime:0.051203s ]
select * from pdf where partno='7022377' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.041755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022377' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.060418s ]
SELECT `id` FROM `stock` WHERE `id` <> 32726746 AND `partno` = '7022377' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.060839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028989 [ RunTime:0.021615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32717395 LIMIT 5 [ RunTime:0.070430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32717395 ORDER BY `minOrder` ASC [ RunTime:0.031053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32717395 ORDER BY `unit` DESC [ RunTime:0.014828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32717395 LIMIT 2 [ RunTime:0.010708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32717395 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
select * from pdf where partno='7022344' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022344' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015236s ]
SELECT `id` FROM `stock` WHERE `id` <> 32717395 AND `partno` = '7022344' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32713039 LIMIT 5 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32713039 ORDER BY `minOrder` ASC [ RunTime:0.001481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32713039 ORDER BY `unit` DESC [ RunTime:0.001595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32713039 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32713039 ORDER BY `minOrder` ASC [ RunTime:0.003054s ]
select * from pdf where partno='7022345' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022345' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010173s ]
SELECT `id` FROM `stock` WHERE `id` <> 32713039 AND `partno` = '7022345' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32711129 LIMIT 5 [ RunTime:0.002465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32711129 ORDER BY `minOrder` ASC [ RunTime:0.001586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32711129 ORDER BY `unit` DESC [ RunTime:0.003186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32711129 LIMIT 2 [ RunTime:0.004144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32711129 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
select * from pdf where partno='7022319' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022319' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012498s ]
SELECT `id` FROM `stock` WHERE `id` <> 32711129 AND `partno` = '7022319' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028481 [ RunTime:0.005014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32710210 LIMIT 5 [ RunTime:0.001608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32710210 ORDER BY `minOrder` ASC [ RunTime:0.002402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32710210 ORDER BY `unit` DESC [ RunTime:0.006662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32710210 LIMIT 2 [ RunTime:0.006552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32710210 ORDER BY `minOrder` ASC [ RunTime:0.001646s ]
select * from pdf where partno='7022318' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022318' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003288s ]
SELECT `id` FROM `stock` WHERE `id` <> 32710210 AND `partno` = '7022318' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028453 [ RunTime:0.005760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32654276 LIMIT 5 [ RunTime:0.001242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654276 ORDER BY `minOrder` ASC [ RunTime:0.004225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32654276 ORDER BY `unit` DESC [ RunTime:0.002038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32654276 LIMIT 2 [ RunTime:0.005887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654276 ORDER BY `minOrder` ASC [ RunTime:0.006746s ]
select * from pdf where partno='7022321' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022321' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008110s ]
SELECT `id` FROM `stock` WHERE `id` <> 32654276 AND `partno` = '7022321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294007 [ RunTime:0.002898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32652571 LIMIT 5 [ RunTime:0.001482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32652571 ORDER BY `minOrder` ASC [ RunTime:0.004977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32652571 ORDER BY `unit` DESC [ RunTime:0.001054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32652571 LIMIT 2 [ RunTime:0.009003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32652571 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
select * from pdf where partno='7022303' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022303' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009082s ]
SELECT `id` FROM `stock` WHERE `id` <> 32652571 AND `partno` = '7022303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026582 [ RunTime:0.010495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32652132 LIMIT 5 [ RunTime:0.008097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32652132 ORDER BY `minOrder` ASC [ RunTime:0.005486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32652132 ORDER BY `unit` DESC [ RunTime:0.004821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32652132 LIMIT 2 [ RunTime:0.009306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32652132 ORDER BY `minOrder` ASC [ RunTime:0.051166s ]
select * from pdf where partno='7022317' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022317' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013556s ]
SELECT `id` FROM `stock` WHERE `id` <> 32652132 AND `partno` = '7022317' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026563 [ RunTime:0.008503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32640826 LIMIT 5 [ RunTime:0.005792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32640826 ORDER BY `minOrder` ASC [ RunTime:0.007405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32640826 ORDER BY `unit` DESC [ RunTime:0.006587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32640826 LIMIT 2 [ RunTime:0.005937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32640826 ORDER BY `minOrder` ASC [ RunTime:0.002610s ]
select * from pdf where partno='7022307' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7022307' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016130s ]
SELECT `id` FROM `stock` WHERE `id` <> 32640826 AND `partno` = '7022307' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292977 [ RunTime:0.003081s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004687s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004626s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003854s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003150s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002843s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003640s ]
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 '70223%' OR `brand` LIKE '70223%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003858s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '70223%' OR `brand` LIKE '70223%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006037s ]