SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003898s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.180' , `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=60431&search=1' [ RunTime:0.008682s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002457s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011310s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001358s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.180' ) [ RunTime:0.005095s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001288s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001904s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001248s ]
SELECT * FROM `stock_search` WHERE `partno` = '60431' LIMIT 1 [ RunTime:0.021400s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 23:02:01' WHERE `partno` = '60431' [ RunTime:0.013637s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002975s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036454s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776713 LIMIT 5 [ RunTime:0.022208s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776713 ORDER BY `minOrder` ASC [ RunTime:0.014678s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18776713 ORDER BY `unit` DESC [ RunTime:0.012404s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18776713 LIMIT 2 [ RunTime:0.006243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776713 ORDER BY `minOrder` ASC [ RunTime:0.007265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232987 LIMIT 5 [ RunTime:0.022884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232987 ORDER BY `minOrder` ASC [ RunTime:0.051096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232987 ORDER BY `unit` DESC [ RunTime:0.055366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232987 LIMIT 2 [ RunTime:0.011536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232987 ORDER BY `minOrder` ASC [ RunTime:0.021472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182840 LIMIT 5 [ RunTime:0.024478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182840 ORDER BY `minOrder` ASC [ RunTime:0.052696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14182840 ORDER BY `unit` DESC [ RunTime:0.022199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14182840 LIMIT 2 [ RunTime:0.025647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182840 ORDER BY `minOrder` ASC [ RunTime:0.046876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553074 LIMIT 5 [ RunTime:0.027712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553074 ORDER BY `minOrder` ASC [ RunTime:0.016290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13553074 ORDER BY `unit` DESC [ RunTime:0.009726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13553074 LIMIT 2 [ RunTime:0.026522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553074 ORDER BY `minOrder` ASC [ RunTime:0.020600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265939 LIMIT 5 [ RunTime:0.018569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265939 ORDER BY `minOrder` ASC [ RunTime:0.032533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265939 ORDER BY `unit` DESC [ RunTime:0.005024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265939 LIMIT 2 [ RunTime:0.016060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265939 ORDER BY `minOrder` ASC [ RunTime:0.034469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265938 LIMIT 5 [ RunTime:0.023438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265938 ORDER BY `minOrder` ASC [ RunTime:0.031687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265938 ORDER BY `unit` DESC [ RunTime:0.038680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265938 LIMIT 2 [ RunTime:0.009047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265938 ORDER BY `minOrder` ASC [ RunTime:0.009232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265937 LIMIT 5 [ RunTime:0.009015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265937 ORDER BY `minOrder` ASC [ RunTime:0.024762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265937 ORDER BY `unit` DESC [ RunTime:0.022668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265937 LIMIT 2 [ RunTime:0.002685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265937 ORDER BY `minOrder` ASC [ RunTime:0.004214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265936 LIMIT 5 [ RunTime:0.010944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265936 ORDER BY `minOrder` ASC [ RunTime:0.005565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265936 ORDER BY `unit` DESC [ RunTime:0.011845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265936 LIMIT 2 [ RunTime:0.008368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265936 ORDER BY `minOrder` ASC [ RunTime:0.016460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265935 LIMIT 5 [ RunTime:0.037251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265935 ORDER BY `minOrder` ASC [ RunTime:0.011979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265935 ORDER BY `unit` DESC [ RunTime:0.017369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265935 LIMIT 2 [ RunTime:0.021209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265935 ORDER BY `minOrder` ASC [ RunTime:0.018522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265934 LIMIT 5 [ RunTime:0.017659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265934 ORDER BY `minOrder` ASC [ RunTime:0.072454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265934 ORDER BY `unit` DESC [ RunTime:0.051199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265934 LIMIT 2 [ RunTime:0.021138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265934 ORDER BY `minOrder` ASC [ RunTime:0.016254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265933 LIMIT 5 [ RunTime:0.022146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265933 ORDER BY `minOrder` ASC [ RunTime:0.062130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265933 ORDER BY `unit` DESC [ RunTime:0.079188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265933 LIMIT 2 [ RunTime:0.049923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265933 ORDER BY `minOrder` ASC [ RunTime:0.010055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265923 LIMIT 5 [ RunTime:0.047126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265923 ORDER BY `minOrder` ASC [ RunTime:0.086400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265923 ORDER BY `unit` DESC [ RunTime:0.073957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265923 LIMIT 2 [ RunTime:0.051158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265923 ORDER BY `minOrder` ASC [ RunTime:0.016493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265890 LIMIT 5 [ RunTime:0.017261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265890 ORDER BY `minOrder` ASC [ RunTime:0.061883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265890 ORDER BY `unit` DESC [ RunTime:0.003969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265890 LIMIT 2 [ RunTime:0.021381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265890 ORDER BY `minOrder` ASC [ RunTime:0.030657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265871 LIMIT 5 [ RunTime:0.037390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265871 ORDER BY `minOrder` ASC [ RunTime:0.021165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265871 ORDER BY `unit` DESC [ RunTime:0.072462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265871 LIMIT 2 [ RunTime:0.046159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265871 ORDER BY `minOrder` ASC [ RunTime:0.036326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265870 LIMIT 5 [ RunTime:0.036319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265870 ORDER BY `minOrder` ASC [ RunTime:0.030601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265870 ORDER BY `unit` DESC [ RunTime:0.032304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265870 LIMIT 2 [ RunTime:0.036051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265870 ORDER BY `minOrder` ASC [ RunTime:0.002070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265869 LIMIT 5 [ RunTime:0.013441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265869 ORDER BY `minOrder` ASC [ RunTime:0.023908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265869 ORDER BY `unit` DESC [ RunTime:0.041326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265869 LIMIT 2 [ RunTime:0.031519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265869 ORDER BY `minOrder` ASC [ RunTime:0.027372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265868 LIMIT 5 [ RunTime:0.022389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265868 ORDER BY `minOrder` ASC [ RunTime:0.016056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265868 ORDER BY `unit` DESC [ RunTime:0.052356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265868 LIMIT 2 [ RunTime:0.038768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265868 ORDER BY `minOrder` ASC [ RunTime:0.025833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265866 LIMIT 5 [ RunTime:0.023319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265866 ORDER BY `minOrder` ASC [ RunTime:0.043778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265866 ORDER BY `unit` DESC [ RunTime:0.011447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265866 LIMIT 2 [ RunTime:0.046851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265866 ORDER BY `minOrder` ASC [ RunTime:0.026856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265864 LIMIT 5 [ RunTime:0.050987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265864 ORDER BY `minOrder` ASC [ RunTime:0.029169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265864 ORDER BY `unit` DESC [ RunTime:0.093765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265864 LIMIT 2 [ RunTime:0.027803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265864 ORDER BY `minOrder` ASC [ RunTime:0.052703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265858 LIMIT 5 [ RunTime:0.057666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265858 ORDER BY `minOrder` ASC [ RunTime:0.070077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265858 ORDER BY `unit` DESC [ RunTime:0.043944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265858 LIMIT 2 [ RunTime:0.024471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265858 ORDER BY `minOrder` ASC [ RunTime:0.005022s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024771s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64714436 LIMIT 5 [ RunTime:0.022445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714436 ORDER BY `minOrder` ASC [ RunTime:0.019535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64714436 ORDER BY `unit` DESC [ RunTime:0.026024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64714436 LIMIT 2 [ RunTime:0.017646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714436 ORDER BY `minOrder` ASC [ RunTime:0.012091s ]
select * from pdf where partno='6043157' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.044228s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043157' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016149s ]
SELECT `id` FROM `stock` WHERE `id` <> 64714436 AND `partno` = '6043157' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.074271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182840 [ RunTime:0.040221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64639108 LIMIT 5 [ RunTime:0.045860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64639108 ORDER BY `minOrder` ASC [ RunTime:0.074278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64639108 ORDER BY `unit` DESC [ RunTime:0.023471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64639108 LIMIT 2 [ RunTime:0.032651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64639108 ORDER BY `minOrder` ASC [ RunTime:0.018061s ]
select * from pdf where partno='6043182' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043182' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011442s ]
SELECT `id` FROM `stock` WHERE `id` <> 64639108 AND `partno` = '6043182' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.039809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776713 [ RunTime:0.030784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64522799 LIMIT 5 [ RunTime:0.024340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64522799 ORDER BY `minOrder` ASC [ RunTime:0.025920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64522799 ORDER BY `unit` DESC [ RunTime:0.018539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64522799 LIMIT 2 [ RunTime:0.016231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64522799 ORDER BY `minOrder` ASC [ RunTime:0.001898s ]
select * from pdf where partno='60431' and brandshort='Brady Corporation' limit 1 [ RunTime:0.036072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60431' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.036073s ]
SELECT `id` FROM `stock` WHERE `id` <> 64522799 AND `partno` = '60431' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.034039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553074 [ RunTime:0.042079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194731 LIMIT 5 [ RunTime:0.014726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194731 ORDER BY `minOrder` ASC [ RunTime:0.022781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194731 ORDER BY `unit` DESC [ RunTime:0.043264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194731 LIMIT 2 [ RunTime:0.038230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194731 ORDER BY `minOrder` ASC [ RunTime:0.015990s ]
select * from pdf where partno='60431' and brandshort='Lantronix, Inc.' limit 1 [ RunTime:0.013694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60431' OR `brand` LIKE 'Lantronix, Inc.%' ) ) LIMIT 1 [ RunTime:0.040944s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194731 AND `partno` = '60431' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lantronix, inc.%' ) [ RunTime:0.053233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252589 [ RunTime:0.044217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266762 LIMIT 5 [ RunTime:0.073876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266762 ORDER BY `minOrder` ASC [ RunTime:0.099764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266762 ORDER BY `unit` DESC [ RunTime:0.047397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266762 LIMIT 2 [ RunTime:0.020938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266762 ORDER BY `minOrder` ASC [ RunTime:0.009656s ]
select * from pdf where partno='6043154' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043154' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019821s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266762 AND `partno` = '6043154' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265939 [ RunTime:0.019535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266761 LIMIT 5 [ RunTime:0.041733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266761 ORDER BY `minOrder` ASC [ RunTime:0.009885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266761 ORDER BY `unit` DESC [ RunTime:0.049302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266761 LIMIT 2 [ RunTime:0.051234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266761 ORDER BY `minOrder` ASC [ RunTime:0.004943s ]
select * from pdf where partno='6043153' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043153' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.040501s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266761 AND `partno` = '6043153' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265938 [ RunTime:0.065581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266760 LIMIT 5 [ RunTime:0.031835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266760 ORDER BY `minOrder` ASC [ RunTime:0.019050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266760 ORDER BY `unit` DESC [ RunTime:0.054904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266760 LIMIT 2 [ RunTime:0.017482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266760 ORDER BY `minOrder` ASC [ RunTime:0.040872s ]
select * from pdf where partno='6043114' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043114' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.051855s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266760 AND `partno` = '6043114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265936 [ RunTime:0.033074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266759 LIMIT 5 [ RunTime:0.021204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266759 ORDER BY `minOrder` ASC [ RunTime:0.012605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266759 ORDER BY `unit` DESC [ RunTime:0.024030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266759 LIMIT 2 [ RunTime:0.020725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266759 ORDER BY `minOrder` ASC [ RunTime:0.030246s ]
select * from pdf where partno='6043152' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043152' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031547s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266759 AND `partno` = '6043152' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.042534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265934 [ RunTime:0.044331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266758 LIMIT 5 [ RunTime:0.043052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266758 ORDER BY `minOrder` ASC [ RunTime:0.016281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266758 ORDER BY `unit` DESC [ RunTime:0.009987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266758 LIMIT 2 [ RunTime:0.028002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266758 ORDER BY `minOrder` ASC [ RunTime:0.006606s ]
select * from pdf where partno='6043151' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043151' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031269s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266758 AND `partno` = '6043151' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265933 [ RunTime:0.007033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266739 LIMIT 5 [ RunTime:0.025168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266739 ORDER BY `minOrder` ASC [ RunTime:0.026725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266739 ORDER BY `unit` DESC [ RunTime:0.010496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266739 LIMIT 2 [ RunTime:0.022327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266739 ORDER BY `minOrder` ASC [ RunTime:0.009036s ]
select * from pdf where partno='6043135' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043135' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031017s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266739 AND `partno` = '6043135' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.063838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992206 [ RunTime:0.063518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266738 LIMIT 5 [ RunTime:0.039207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266738 ORDER BY `minOrder` ASC [ RunTime:0.019257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266738 ORDER BY `unit` DESC [ RunTime:0.032912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266738 LIMIT 2 [ RunTime:0.051300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266738 ORDER BY `minOrder` ASC [ RunTime:0.011996s ]
select * from pdf where partno='6043137' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043137' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.029486s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266738 AND `partno` = '6043137' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992205 [ RunTime:0.039207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266737 LIMIT 5 [ RunTime:0.006256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266737 ORDER BY `minOrder` ASC [ RunTime:0.039076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266737 ORDER BY `unit` DESC [ RunTime:0.017193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266737 LIMIT 2 [ RunTime:0.014271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266737 ORDER BY `minOrder` ASC [ RunTime:0.007233s ]
select * from pdf where partno='6043134' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043134' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016225s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266737 AND `partno` = '6043134' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992204 [ RunTime:0.022863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266736 LIMIT 5 [ RunTime:0.022844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266736 ORDER BY `minOrder` ASC [ RunTime:0.026957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266736 ORDER BY `unit` DESC [ RunTime:0.034557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266736 LIMIT 2 [ RunTime:0.014871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266736 ORDER BY `minOrder` ASC [ RunTime:0.002246s ]
select * from pdf where partno='6043136' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043136' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019209s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266736 AND `partno` = '6043136' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.043289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992200 [ RunTime:0.018804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266734 LIMIT 5 [ RunTime:0.026332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266734 ORDER BY `minOrder` ASC [ RunTime:0.017152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266734 ORDER BY `unit` DESC [ RunTime:0.030707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266734 LIMIT 2 [ RunTime:0.028479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266734 ORDER BY `minOrder` ASC [ RunTime:0.027868s ]
select * from pdf where partno='6043113' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043113' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031283s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266734 AND `partno` = '6043113' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265937 [ RunTime:0.018557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266733 LIMIT 5 [ RunTime:0.027260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266733 ORDER BY `minOrder` ASC [ RunTime:0.013931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266733 ORDER BY `unit` DESC [ RunTime:0.012583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266733 LIMIT 2 [ RunTime:0.011372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266733 ORDER BY `minOrder` ASC [ RunTime:0.006594s ]
select * from pdf where partno='6043112' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043112' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024397s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266733 AND `partno` = '6043112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265935 [ RunTime:0.039148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266732 LIMIT 5 [ RunTime:0.002286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266732 ORDER BY `minOrder` ASC [ RunTime:0.011149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266732 ORDER BY `unit` DESC [ RunTime:0.039846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266732 LIMIT 2 [ RunTime:0.046242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266732 ORDER BY `minOrder` ASC [ RunTime:0.033966s ]
select * from pdf where partno='6043111' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.039467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043111' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018334s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266732 AND `partno` = '6043111' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992208 [ RunTime:0.006937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266697 LIMIT 5 [ RunTime:0.016646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266697 ORDER BY `minOrder` ASC [ RunTime:0.025384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266697 ORDER BY `unit` DESC [ RunTime:0.024213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266697 LIMIT 2 [ RunTime:0.007801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266697 ORDER BY `minOrder` ASC [ RunTime:0.005892s ]
select * from pdf where partno='6043115' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043115' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013226s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266697 AND `partno` = '6043115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992199 [ RunTime:0.040815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266696 LIMIT 5 [ RunTime:0.010686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266696 ORDER BY `minOrder` ASC [ RunTime:0.016772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266696 ORDER BY `unit` DESC [ RunTime:0.021587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266696 LIMIT 2 [ RunTime:0.015158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266696 ORDER BY `minOrder` ASC [ RunTime:0.017461s ]
select * from pdf where partno='6043116' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.058031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043116' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037303s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266696 AND `partno` = '6043116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.140473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992198 [ RunTime:0.036556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266695 LIMIT 5 [ RunTime:0.044423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266695 ORDER BY `minOrder` ASC [ RunTime:0.065714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266695 ORDER BY `unit` DESC [ RunTime:0.027141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266695 LIMIT 2 [ RunTime:0.033449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266695 ORDER BY `minOrder` ASC [ RunTime:0.009027s ]
select * from pdf where partno='6043118' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043118' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.040902s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266695 AND `partno` = '6043118' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992197 [ RunTime:0.013757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266694 LIMIT 5 [ RunTime:0.013087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266694 ORDER BY `minOrder` ASC [ RunTime:0.004726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266694 ORDER BY `unit` DESC [ RunTime:0.032992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266694 LIMIT 2 [ RunTime:0.017496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266694 ORDER BY `minOrder` ASC [ RunTime:0.031336s ]
select * from pdf where partno='6043117' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6043117' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.036861s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266694 AND `partno` = '6043117' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.028557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265923 [ RunTime:0.018183s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029968s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034714s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009177s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023492s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018385s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014288s ]
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 '60431%' OR `brand` LIKE '60431%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042731s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60431%' OR `brand` LIKE '60431%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025717s ]