SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001598s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.222' , `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=9687&search=1' [ RunTime:0.002169s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001367s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003152s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001480s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.222' ) [ RunTime:0.006841s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001113s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001817s ]
SELECT * FROM `stock_search` WHERE `partno` = '9687' LIMIT 1 [ RunTime:0.019484s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-31 01:20:27' WHERE `partno` = '9687' [ RunTime:0.008502s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001213s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016572s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428292 LIMIT 5 [ RunTime:0.012254s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16428292 ORDER BY `minOrder` ASC [ RunTime:0.009473s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16428292 ORDER BY `unit` DESC [ RunTime:0.017734s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16428292 LIMIT 2 [ RunTime:0.006785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16428292 ORDER BY `minOrder` ASC [ RunTime:0.001632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427978 LIMIT 5 [ RunTime:0.006450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427978 ORDER BY `minOrder` ASC [ RunTime:0.004303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427978 ORDER BY `unit` DESC [ RunTime:0.006814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427978 LIMIT 2 [ RunTime:0.011888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427978 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427925 LIMIT 5 [ RunTime:0.009993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427925 ORDER BY `minOrder` ASC [ RunTime:0.005845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427925 ORDER BY `unit` DESC [ RunTime:0.013138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427925 LIMIT 2 [ RunTime:0.019590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427925 ORDER BY `minOrder` ASC [ RunTime:0.010929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427924 LIMIT 5 [ RunTime:0.006806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427924 ORDER BY `minOrder` ASC [ RunTime:0.014037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427924 ORDER BY `unit` DESC [ RunTime:0.011234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427924 LIMIT 2 [ RunTime:0.011677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427924 ORDER BY `minOrder` ASC [ RunTime:0.018545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427923 LIMIT 5 [ RunTime:0.015099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427923 ORDER BY `minOrder` ASC [ RunTime:0.017058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427923 ORDER BY `unit` DESC [ RunTime:0.023198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427923 LIMIT 2 [ RunTime:0.057863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427923 ORDER BY `minOrder` ASC [ RunTime:0.031526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427843 LIMIT 5 [ RunTime:0.018450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427843 ORDER BY `minOrder` ASC [ RunTime:0.011488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427843 ORDER BY `unit` DESC [ RunTime:0.009734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427843 LIMIT 2 [ RunTime:0.019910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427843 ORDER BY `minOrder` ASC [ RunTime:0.031164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427373 LIMIT 5 [ RunTime:0.016348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427373 ORDER BY `minOrder` ASC [ RunTime:0.003893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427373 ORDER BY `unit` DESC [ RunTime:0.005079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427373 LIMIT 2 [ RunTime:0.010175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427373 ORDER BY `minOrder` ASC [ RunTime:0.009725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417874 LIMIT 5 [ RunTime:0.003797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417874 ORDER BY `minOrder` ASC [ RunTime:0.014747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417874 ORDER BY `unit` DESC [ RunTime:0.008504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417874 LIMIT 2 [ RunTime:0.004420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417874 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417873 LIMIT 5 [ RunTime:0.003335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417873 ORDER BY `minOrder` ASC [ RunTime:0.004530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417873 ORDER BY `unit` DESC [ RunTime:0.016708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417873 LIMIT 2 [ RunTime:0.006081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417873 ORDER BY `minOrder` ASC [ RunTime:0.004382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417725 LIMIT 5 [ RunTime:0.001976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417725 ORDER BY `minOrder` ASC [ RunTime:0.004125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417725 ORDER BY `unit` DESC [ RunTime:0.000942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417725 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417725 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417662 LIMIT 5 [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417662 ORDER BY `minOrder` ASC [ RunTime:0.001869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417662 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417662 LIMIT 2 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417662 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414239 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414239 ORDER BY `minOrder` ASC [ RunTime:0.005628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414239 ORDER BY `unit` DESC [ RunTime:0.005296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414239 LIMIT 2 [ RunTime:0.003487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414239 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414116 LIMIT 5 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414116 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414116 ORDER BY `unit` DESC [ RunTime:0.002684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414116 LIMIT 2 [ RunTime:0.001722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414116 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14413720 LIMIT 5 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14413720 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14413720 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14413720 LIMIT 2 [ RunTime:0.002099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14413720 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14413645 LIMIT 5 [ RunTime:0.003848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14413645 ORDER BY `minOrder` ASC [ RunTime:0.003876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14413645 ORDER BY `unit` DESC [ RunTime:0.004121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14413645 LIMIT 2 [ RunTime:0.005369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14413645 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547335 LIMIT 5 [ RunTime:0.001010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547335 ORDER BY `minOrder` ASC [ RunTime:0.000946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13547335 ORDER BY `unit` DESC [ RunTime:0.001570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13547335 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547335 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547280 LIMIT 5 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547280 ORDER BY `minOrder` ASC [ RunTime:0.001395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13547280 ORDER BY `unit` DESC [ RunTime:0.011473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13547280 LIMIT 2 [ RunTime:0.001709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547280 ORDER BY `minOrder` ASC [ RunTime:0.005601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544734 LIMIT 5 [ RunTime:0.004569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544734 ORDER BY `minOrder` ASC [ RunTime:0.009964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13544734 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13544734 LIMIT 2 [ RunTime:0.007512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544734 ORDER BY `minOrder` ASC [ RunTime:0.005812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544460 LIMIT 5 [ RunTime:0.003358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544460 ORDER BY `minOrder` ASC [ RunTime:0.014051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13544460 ORDER BY `unit` DESC [ RunTime:0.011992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13544460 LIMIT 2 [ RunTime:0.001770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544460 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544048 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544048 ORDER BY `minOrder` ASC [ RunTime:0.016710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13544048 ORDER BY `unit` DESC [ RunTime:0.000993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13544048 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544048 ORDER BY `minOrder` ASC [ RunTime:0.002252s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004215s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63388355 LIMIT 5 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63388355 ORDER BY `minOrder` ASC [ RunTime:0.008341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63388355 ORDER BY `unit` DESC [ RunTime:0.017128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63388355 LIMIT 2 [ RunTime:0.006468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63388355 ORDER BY `minOrder` ASC [ RunTime:0.007274s ]
select * from pdf where partno='9687T' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.007166s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9687T' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002474s ]
SELECT `id` FROM `stock` WHERE `id` <> 63388355 AND `partno` = '9687T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.013612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63388247 LIMIT 5 [ RunTime:0.011395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63388247 ORDER BY `minOrder` ASC [ RunTime:0.014734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63388247 ORDER BY `unit` DESC [ RunTime:0.026213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63388247 LIMIT 2 [ RunTime:0.016186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63388247 ORDER BY `minOrder` ASC [ RunTime:0.007954s ]
select * from pdf where partno='9687' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.012246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9687' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.032934s ]
SELECT `id` FROM `stock` WHERE `id` <> 63388247 AND `partno` = '9687' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.025900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63152856 LIMIT 5 [ RunTime:0.013603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152856 ORDER BY `minOrder` ASC [ RunTime:0.009716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63152856 ORDER BY `unit` DESC [ RunTime:0.010197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63152856 LIMIT 2 [ RunTime:0.013105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152856 ORDER BY `minOrder` ASC [ RunTime:0.002601s ]
select * from pdf where partno='96879.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.022262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96879.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.005135s ]
SELECT `id` FROM `stock` WHERE `id` <> 63152856 AND `partno` = '96879.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.003985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544734 [ RunTime:0.021911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63152295 LIMIT 5 [ RunTime:0.024267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152295 ORDER BY `minOrder` ASC [ RunTime:0.009617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63152295 ORDER BY `unit` DESC [ RunTime:0.003348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63152295 LIMIT 2 [ RunTime:0.023728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152295 ORDER BY `minOrder` ASC [ RunTime:0.002107s ]
select * from pdf where partno='96878.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.004222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96878.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.014846s ]
SELECT `id` FROM `stock` WHERE `id` <> 63152295 AND `partno` = '96878.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.034296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428292 [ RunTime:0.015681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63152294 LIMIT 5 [ RunTime:0.005684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152294 ORDER BY `minOrder` ASC [ RunTime:0.015237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63152294 ORDER BY `unit` DESC [ RunTime:0.005675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63152294 LIMIT 2 [ RunTime:0.017217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152294 ORDER BY `minOrder` ASC [ RunTime:0.005245s ]
select * from pdf where partno='96877.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.013198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96877.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.009702s ]
SELECT `id` FROM `stock` WHERE `id` <> 63152294 AND `partno` = '96877.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.012220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544460 [ RunTime:0.011021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150898 LIMIT 5 [ RunTime:0.006215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150898 ORDER BY `minOrder` ASC [ RunTime:0.005998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150898 ORDER BY `unit` DESC [ RunTime:0.006846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150898 LIMIT 2 [ RunTime:0.009939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150898 ORDER BY `minOrder` ASC [ RunTime:0.000750s ]
select * from pdf where partno='96876.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.012512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96876.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.007673s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150898 AND `partno` = '96876.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.014500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414239 [ RunTime:0.023029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150897 LIMIT 5 [ RunTime:0.003079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150897 ORDER BY `minOrder` ASC [ RunTime:0.007402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150897 ORDER BY `unit` DESC [ RunTime:0.006759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150897 LIMIT 2 [ RunTime:0.007527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150897 ORDER BY `minOrder` ASC [ RunTime:0.003886s ]
select * from pdf where partno='96875.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.001560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96875.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.002750s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150897 AND `partno` = '96875.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.005995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427978 [ RunTime:0.001960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150896 LIMIT 5 [ RunTime:0.001702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150896 ORDER BY `minOrder` ASC [ RunTime:0.005790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150896 ORDER BY `unit` DESC [ RunTime:0.018424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150896 LIMIT 2 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150896 ORDER BY `minOrder` ASC [ RunTime:0.009694s ]
select * from pdf where partno='96874.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.003132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96874.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.005561s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150896 AND `partno` = '96874.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544048 [ RunTime:0.002034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150754 LIMIT 5 [ RunTime:0.003075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150754 ORDER BY `minOrder` ASC [ RunTime:0.005116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150754 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150754 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150754 ORDER BY `minOrder` ASC [ RunTime:0.007997s ]
select * from pdf where partno='96876.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.010617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96876.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.001721s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150754 AND `partno` = '96876.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427925 [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150753 LIMIT 5 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150753 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150753 ORDER BY `unit` DESC [ RunTime:0.006254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150753 LIMIT 2 [ RunTime:0.002909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150753 ORDER BY `minOrder` ASC [ RunTime:0.003380s ]
select * from pdf where partno='96875.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.003815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96875.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.010099s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150753 AND `partno` = '96875.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.017344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427924 [ RunTime:0.003134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150752 LIMIT 5 [ RunTime:0.017830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150752 ORDER BY `minOrder` ASC [ RunTime:0.025114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150752 ORDER BY `unit` DESC [ RunTime:0.004198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150752 LIMIT 2 [ RunTime:0.005391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150752 ORDER BY `minOrder` ASC [ RunTime:0.002137s ]
select * from pdf where partno='96874.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.007587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96874.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.014625s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150752 AND `partno` = '96874.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.014645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427923 [ RunTime:0.002790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150712 LIMIT 5 [ RunTime:0.012706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150712 ORDER BY `minOrder` ASC [ RunTime:0.019142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150712 ORDER BY `unit` DESC [ RunTime:0.008859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150712 LIMIT 2 [ RunTime:0.002045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150712 ORDER BY `minOrder` ASC [ RunTime:0.005093s ]
select * from pdf where partno='96874.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.016467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96874.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.010622s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150712 AND `partno` = '96874.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.009249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543980 [ RunTime:0.012831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150621 LIMIT 5 [ RunTime:0.005145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150621 ORDER BY `minOrder` ASC [ RunTime:0.021062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150621 ORDER BY `unit` DESC [ RunTime:0.016650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150621 LIMIT 2 [ RunTime:0.008521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150621 ORDER BY `minOrder` ASC [ RunTime:0.006592s ]
select * from pdf where partno='96876.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.013129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96876.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.004974s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150621 AND `partno` = '96876.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.013431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414116 [ RunTime:0.023502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63150620 LIMIT 5 [ RunTime:0.026374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150620 ORDER BY `minOrder` ASC [ RunTime:0.019092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63150620 ORDER BY `unit` DESC [ RunTime:0.017629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63150620 LIMIT 2 [ RunTime:0.015263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63150620 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
select * from pdf where partno='96875.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.004979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96875.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.017749s ]
SELECT `id` FROM `stock` WHERE `id` <> 63150620 AND `partno` = '96875.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.012966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427843 [ RunTime:0.017630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149402 LIMIT 5 [ RunTime:0.009512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149402 ORDER BY `minOrder` ASC [ RunTime:0.001250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149402 ORDER BY `unit` DESC [ RunTime:0.005132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149402 LIMIT 2 [ RunTime:0.019150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149402 ORDER BY `minOrder` ASC [ RunTime:0.010329s ]
select * from pdf where partno='96873.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.016930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96873.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.027985s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149402 AND `partno` = '96873.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.009723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14413720 [ RunTime:0.003186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149401 LIMIT 5 [ RunTime:0.000897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149401 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149401 ORDER BY `unit` DESC [ RunTime:0.012863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149401 LIMIT 2 [ RunTime:0.016824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149401 ORDER BY `minOrder` ASC [ RunTime:0.011617s ]
select * from pdf where partno='96872.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.012716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96872.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.019122s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149401 AND `partno` = '96872.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.029729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543528 [ RunTime:0.013060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149168 LIMIT 5 [ RunTime:0.014055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149168 ORDER BY `minOrder` ASC [ RunTime:0.019174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149168 ORDER BY `unit` DESC [ RunTime:0.007135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149168 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149168 ORDER BY `minOrder` ASC [ RunTime:0.012619s ]
select * from pdf where partno='96873.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.014575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96873.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.009125s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149168 AND `partno` = '96873.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.029818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543461 [ RunTime:0.013106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149167 LIMIT 5 [ RunTime:0.027366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149167 ORDER BY `minOrder` ASC [ RunTime:0.033164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149167 ORDER BY `unit` DESC [ RunTime:0.017501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149167 LIMIT 2 [ RunTime:0.038784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149167 ORDER BY `minOrder` ASC [ RunTime:0.006344s ]
select * from pdf where partno='96872.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.040116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96872.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.006014s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149167 AND `partno` = '96872.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.030398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427373 [ RunTime:0.013744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149154 LIMIT 5 [ RunTime:0.019730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149154 ORDER BY `minOrder` ASC [ RunTime:0.063967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149154 ORDER BY `unit` DESC [ RunTime:0.008721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149154 LIMIT 2 [ RunTime:0.002062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149154 ORDER BY `minOrder` ASC [ RunTime:0.008405s ]
select * from pdf where partno='96873.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.019255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96873.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.011467s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149154 AND `partno` = '96873.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.008017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14413645 [ RunTime:0.011074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149153 LIMIT 5 [ RunTime:0.006823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149153 ORDER BY `minOrder` ASC [ RunTime:0.014539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149153 ORDER BY `unit` DESC [ RunTime:0.032540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149153 LIMIT 2 [ RunTime:0.036233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149153 ORDER BY `minOrder` ASC [ RunTime:0.003229s ]
select * from pdf where partno='96872.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.004229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96872.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.034713s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149153 AND `partno` = '96872.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.016262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543456 [ RunTime:0.039225s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022628s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044964s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015384s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037051s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022333s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025674s ]
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 '9687%' OR `brand` LIKE '9687%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004813s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9687%' OR `brand` LIKE '9687%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013539s ]