SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003047s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=21021&search=1' [ RunTime:0.005645s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002138s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.018298s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001363s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.007680s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001009s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.028324s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001302s ]
SELECT * FROM `stock_search` WHERE `partno` = '21021' LIMIT 1 [ RunTime:0.038414s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-28 01:22:18' WHERE `partno` = '21021' [ RunTime:0.004881s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002068s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063530s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10755327 LIMIT 5 [ RunTime:0.024462s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755327 ORDER BY `minOrder` ASC [ RunTime:0.029159s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10755327 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10755327 LIMIT 2 [ RunTime:0.024835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755327 ORDER BY `minOrder` ASC [ RunTime:0.033222s ]
select * from pdf where partno='21021511305' and brandshort='HARTING' limit 1 [ RunTime:0.012613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12497867 LIMIT 5 [ RunTime:0.027955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12497867 ORDER BY `minOrder` ASC [ RunTime:0.055243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12497867 ORDER BY `unit` DESC [ RunTime:0.030698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12497867 LIMIT 2 [ RunTime:0.055029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12497867 ORDER BY `minOrder` ASC [ RunTime:0.040793s ]
select * from pdf where partno='2102161-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.019040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10834079 LIMIT 5 [ RunTime:0.037684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10834079 ORDER BY `minOrder` ASC [ RunTime:0.025198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10834079 ORDER BY `unit` DESC [ RunTime:0.023393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10834079 LIMIT 2 [ RunTime:0.013896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10834079 ORDER BY `minOrder` ASC [ RunTime:0.026477s ]
select * from pdf where partno='21021451430' and brandshort='HARTING' limit 1 [ RunTime:0.002996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10834082 LIMIT 5 [ RunTime:0.013830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10834082 ORDER BY `minOrder` ASC [ RunTime:0.018757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10834082 ORDER BY `unit` DESC [ RunTime:0.003507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10834082 LIMIT 2 [ RunTime:0.006688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10834082 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
select * from pdf where partno='21021851430' and brandshort='HARTING' limit 1 [ RunTime:0.003794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11048924 LIMIT 5 [ RunTime:0.018105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11048924 ORDER BY `minOrder` ASC [ RunTime:0.007955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11048924 ORDER BY `unit` DESC [ RunTime:0.007345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11048924 LIMIT 2 [ RunTime:0.005699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11048924 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
select * from pdf where partno='21021511405' and brandshort='HARTING' limit 1 [ RunTime:0.014613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832093 LIMIT 5 [ RunTime:0.021101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832093 ORDER BY `minOrder` ASC [ RunTime:0.006865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10832093 ORDER BY `unit` DESC [ RunTime:0.024861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10832093 LIMIT 2 [ RunTime:0.003784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832093 ORDER BY `minOrder` ASC [ RunTime:0.001701s ]
select * from pdf where partno='21021591305' and brandshort='HARTING' limit 1 [ RunTime:0.008923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712220 LIMIT 5 [ RunTime:0.015816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712220 ORDER BY `minOrder` ASC [ RunTime:0.012102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712220 ORDER BY `unit` DESC [ RunTime:0.035951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712220 LIMIT 2 [ RunTime:0.014108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712220 ORDER BY `minOrder` ASC [ RunTime:0.012923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17494787 LIMIT 5 [ RunTime:0.011601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17494787 ORDER BY `minOrder` ASC [ RunTime:0.036489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17494787 ORDER BY `unit` DESC [ RunTime:0.021041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17494787 LIMIT 2 [ RunTime:0.011600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17494787 ORDER BY `minOrder` ASC [ RunTime:0.016329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325777 LIMIT 5 [ RunTime:0.009125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325777 ORDER BY `minOrder` ASC [ RunTime:0.024364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325777 ORDER BY `unit` DESC [ RunTime:0.007793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325777 LIMIT 2 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325777 ORDER BY `minOrder` ASC [ RunTime:0.012249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325776 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325776 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325776 ORDER BY `unit` DESC [ RunTime:0.008982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325776 LIMIT 2 [ RunTime:0.007341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325776 ORDER BY `minOrder` ASC [ RunTime:0.004460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325769 LIMIT 5 [ RunTime:0.013272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325769 ORDER BY `unit` DESC [ RunTime:0.003131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325769 LIMIT 2 [ RunTime:0.018833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325769 ORDER BY `minOrder` ASC [ RunTime:0.001592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325571 LIMIT 5 [ RunTime:0.029906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.007708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325571 ORDER BY `unit` DESC [ RunTime:0.008031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325571 LIMIT 2 [ RunTime:0.014840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325571 ORDER BY `minOrder` ASC [ RunTime:0.002444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13297059 LIMIT 5 [ RunTime:0.011761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297059 ORDER BY `minOrder` ASC [ RunTime:0.012036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13297059 ORDER BY `unit` DESC [ RunTime:0.007488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13297059 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297059 ORDER BY `minOrder` ASC [ RunTime:0.002306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294492 LIMIT 5 [ RunTime:0.002619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294492 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13294492 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13294492 LIMIT 2 [ RunTime:0.009294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294492 ORDER BY `minOrder` ASC [ RunTime:0.005185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292145 LIMIT 5 [ RunTime:0.010051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292145 ORDER BY `minOrder` ASC [ RunTime:0.012015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292145 ORDER BY `unit` DESC [ RunTime:0.015887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292145 LIMIT 2 [ RunTime:0.030537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292145 ORDER BY `minOrder` ASC [ RunTime:0.004961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289962 LIMIT 5 [ RunTime:0.014272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289962 ORDER BY `minOrder` ASC [ RunTime:0.029662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289962 ORDER BY `unit` DESC [ RunTime:0.013303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289962 LIMIT 2 [ RunTime:0.020136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289962 ORDER BY `minOrder` ASC [ RunTime:0.011371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13190865 LIMIT 5 [ RunTime:0.010780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13190865 ORDER BY `minOrder` ASC [ RunTime:0.019436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13190865 ORDER BY `unit` DESC [ RunTime:0.016486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13190865 LIMIT 2 [ RunTime:0.008514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13190865 ORDER BY `minOrder` ASC [ RunTime:0.015174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12500160 LIMIT 5 [ RunTime:0.009468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500160 ORDER BY `minOrder` ASC [ RunTime:0.007442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12500160 ORDER BY `unit` DESC [ RunTime:0.016386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12500160 LIMIT 2 [ RunTime:0.002744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12500160 ORDER BY `minOrder` ASC [ RunTime:0.001443s ]
select * from pdf where partno='2102159-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.010632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12494806 LIMIT 5 [ RunTime:0.006154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12494806 ORDER BY `minOrder` ASC [ RunTime:0.013854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12494806 ORDER BY `unit` DESC [ RunTime:0.004128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12494806 LIMIT 2 [ RunTime:0.009941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12494806 ORDER BY `minOrder` ASC [ RunTime:0.005920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12490759 LIMIT 5 [ RunTime:0.008853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12490759 ORDER BY `minOrder` ASC [ RunTime:0.005819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12490759 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12490759 LIMIT 2 [ RunTime:0.004463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12490759 ORDER BY `minOrder` ASC [ RunTime:0.006221s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001141s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61010669 LIMIT 5 [ RunTime:0.023167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61010669 ORDER BY `minOrder` ASC [ RunTime:0.017479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61010669 ORDER BY `unit` DESC [ RunTime:0.006072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61010669 LIMIT 2 [ RunTime:0.012798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61010669 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
select * from pdf where partno='21021511305' and brandshort='HARTING' limit 1 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021511305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015792s ]
SELECT `id` FROM `stock` WHERE `id` <> 61010669 AND `partno` = '21021511305' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.010107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10755327 [ RunTime:0.007725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60942688 LIMIT 5 [ RunTime:0.006878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942688 ORDER BY `minOrder` ASC [ RunTime:0.020302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60942688 ORDER BY `unit` DESC [ RunTime:0.009908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60942688 LIMIT 2 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60942688 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
select * from pdf where partno='2102161-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102161-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.007088s ]
SELECT `id` FROM `stock` WHERE `id` <> 60942688 AND `partno` = '2102161-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.019899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12497867 [ RunTime:0.018551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61011895 LIMIT 5 [ RunTime:0.018863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61011895 ORDER BY `minOrder` ASC [ RunTime:0.035369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61011895 ORDER BY `unit` DESC [ RunTime:0.008942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61011895 LIMIT 2 [ RunTime:0.009975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61011895 ORDER BY `minOrder` ASC [ RunTime:0.008432s ]
select * from pdf where partno='21021512305' and brandshort='HARTING' limit 1 [ RunTime:0.026188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021512305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.020357s ]
SELECT `id` FROM `stock` WHERE `id` <> 61011895 AND `partno` = '21021512305' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.006482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11049661 [ RunTime:0.014284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61142189 LIMIT 5 [ RunTime:0.009053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61142189 ORDER BY `minOrder` ASC [ RunTime:0.019459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61142189 ORDER BY `unit` DESC [ RunTime:0.018522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61142189 LIMIT 2 [ RunTime:0.007936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61142189 ORDER BY `minOrder` ASC [ RunTime:0.005005s ]
select * from pdf where partno='21021511405' and brandshort='HARTING' limit 1 [ RunTime:0.002053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021511405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009782s ]
SELECT `id` FROM `stock` WHERE `id` <> 61142189 AND `partno` = '21021511405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11048924 [ RunTime:0.008944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63373017 LIMIT 5 [ RunTime:0.002684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373017 ORDER BY `minOrder` ASC [ RunTime:0.002850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63373017 ORDER BY `unit` DESC [ RunTime:0.018225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63373017 LIMIT 2 [ RunTime:0.006200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373017 ORDER BY `minOrder` ASC [ RunTime:0.025535s ]
select * from pdf where partno='21021-6' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.020391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021-6' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.018643s ]
SELECT `id` FROM `stock` WHERE `id` <> 63373017 AND `partno` = '21021-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.045974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49555526 LIMIT 5 [ RunTime:0.011236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49555526 ORDER BY `minOrder` ASC [ RunTime:0.033203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49555526 ORDER BY `unit` DESC [ RunTime:0.012054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49555526 LIMIT 2 [ RunTime:0.011694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49555526 ORDER BY `minOrder` ASC [ RunTime:0.005049s ]
select * from pdf where partno='21021-6' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.026720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021-6' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.033514s ]
SELECT `id` FROM `stock` WHERE `id` <> 49555526 AND `partno` = '21021-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.006530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325571 [ RunTime:0.001408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36748913 LIMIT 5 [ RunTime:0.004049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36748913 ORDER BY `minOrder` ASC [ RunTime:0.016826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36748913 ORDER BY `unit` DESC [ RunTime:0.029570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36748913 LIMIT 2 [ RunTime:0.026102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36748913 ORDER BY `minOrder` ASC [ RunTime:0.023854s ]
select * from pdf where partno='21021-6' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.008466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021-6' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002971s ]
SELECT `id` FROM `stock` WHERE `id` <> 36748913 AND `partno` = '21021-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.007336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325571 [ RunTime:0.002966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61144777 LIMIT 5 [ RunTime:0.012925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144777 ORDER BY `minOrder` ASC [ RunTime:0.040677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61144777 ORDER BY `unit` DESC [ RunTime:0.021220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61144777 LIMIT 2 [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144777 ORDER BY `minOrder` ASC [ RunTime:0.019490s ]
select * from pdf where partno='21021451430' and brandshort='HARTING' limit 1 [ RunTime:0.007957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021451430' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.022838s ]
SELECT `id` FROM `stock` WHERE `id` <> 61144777 AND `partno` = '21021451430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.027066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10834079 [ RunTime:0.056152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61143938 LIMIT 5 [ RunTime:0.018108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61143938 ORDER BY `minOrder` ASC [ RunTime:0.025198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61143938 ORDER BY `unit` DESC [ RunTime:0.010794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61143938 LIMIT 2 [ RunTime:0.070274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61143938 ORDER BY `minOrder` ASC [ RunTime:0.035177s ]
select * from pdf where partno='21021591305' and brandshort='HARTING' limit 1 [ RunTime:0.002309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021591305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.028853s ]
SELECT `id` FROM `stock` WHERE `id` <> 61143938 AND `partno` = '21021591305' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.021271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832093 [ RunTime:0.039287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61143969 LIMIT 5 [ RunTime:0.035648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61143969 ORDER BY `minOrder` ASC [ RunTime:0.051874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61143969 ORDER BY `unit` DESC [ RunTime:0.040570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61143969 LIMIT 2 [ RunTime:0.049500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61143969 ORDER BY `minOrder` ASC [ RunTime:0.059991s ]
select * from pdf where partno='21021512405' and brandshort='HARTING' limit 1 [ RunTime:0.064051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021512405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.019183s ]
SELECT `id` FROM `stock` WHERE `id` <> 61143969 AND `partno` = '21021512405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.040249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11049667 [ RunTime:0.039979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61144781 LIMIT 5 [ RunTime:0.025047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144781 ORDER BY `minOrder` ASC [ RunTime:0.018939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61144781 ORDER BY `unit` DESC [ RunTime:0.041454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61144781 LIMIT 2 [ RunTime:0.032484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144781 ORDER BY `minOrder` ASC [ RunTime:0.028666s ]
select * from pdf where partno='21021851430' and brandshort='HARTING' limit 1 [ RunTime:0.005655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021851430' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.011306s ]
SELECT `id` FROM `stock` WHERE `id` <> 61144781 AND `partno` = '21021851430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.026564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10834082 [ RunTime:0.005276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61144702 LIMIT 5 [ RunTime:0.015926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144702 ORDER BY `minOrder` ASC [ RunTime:0.010847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61144702 ORDER BY `unit` DESC [ RunTime:0.042117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61144702 LIMIT 2 [ RunTime:0.010838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144702 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='21021451405' and brandshort='HARTING' limit 1 [ RunTime:0.043633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021451405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.013536s ]
SELECT `id` FROM `stock` WHERE `id` <> 61144702 AND `partno` = '21021451405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.010144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10833005 [ RunTime:0.013688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61192106 LIMIT 5 [ RunTime:0.015905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192106 ORDER BY `minOrder` ASC [ RunTime:0.021065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61192106 ORDER BY `unit` DESC [ RunTime:0.029596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61192106 LIMIT 2 [ RunTime:0.032673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192106 ORDER BY `minOrder` ASC [ RunTime:0.004937s ]
select * from pdf where partno='21021851405' and brandshort='HARTING' limit 1 [ RunTime:0.016496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021851405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.025425s ]
SELECT `id` FROM `stock` WHERE `id` <> 61192106 AND `partno` = '21021851405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.016067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61192095 LIMIT 5 [ RunTime:0.007856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192095 ORDER BY `minOrder` ASC [ RunTime:0.043386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61192095 ORDER BY `unit` DESC [ RunTime:0.009713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61192095 LIMIT 2 [ RunTime:0.006172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192095 ORDER BY `minOrder` ASC [ RunTime:0.007266s ]
select * from pdf where partno='21021852405' and brandshort='HARTING' limit 1 [ RunTime:0.006395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021852405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003976s ]
SELECT `id` FROM `stock` WHERE `id` <> 61192095 AND `partno` = '21021852405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61192087 LIMIT 5 [ RunTime:0.017865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192087 ORDER BY `minOrder` ASC [ RunTime:0.019579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61192087 ORDER BY `unit` DESC [ RunTime:0.022985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61192087 LIMIT 2 [ RunTime:0.001085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192087 ORDER BY `minOrder` ASC [ RunTime:0.004950s ]
select * from pdf where partno='21021452405' and brandshort='HARTING' limit 1 [ RunTime:0.012099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021452405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015509s ]
SELECT `id` FROM `stock` WHERE `id` <> 61192087 AND `partno` = '21021452405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.011879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64421925 LIMIT 5 [ RunTime:0.001711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64421925 ORDER BY `minOrder` ASC [ RunTime:0.015945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64421925 ORDER BY `unit` DESC [ RunTime:0.009111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64421925 LIMIT 2 [ RunTime:0.018867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64421925 ORDER BY `minOrder` ASC [ RunTime:0.019912s ]
select * from pdf where partno='21021' and brandshort='3M' limit 1 [ RunTime:0.030696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.036450s ]
SELECT `id` FROM `stock` WHERE `id` <> 64421925 AND `partno` = '21021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.034253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712220 [ RunTime:0.023243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63373385 LIMIT 5 [ RunTime:0.055195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373385 ORDER BY `minOrder` ASC [ RunTime:0.021503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63373385 ORDER BY `unit` DESC [ RunTime:0.023594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63373385 LIMIT 2 [ RunTime:0.006386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373385 ORDER BY `minOrder` ASC [ RunTime:0.003080s ]
select * from pdf where partno='21021-2' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.034813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021-2' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.017383s ]
SELECT `id` FROM `stock` WHERE `id` <> 63373385 AND `partno` = '21021-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.011275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62092680 LIMIT 5 [ RunTime:0.015207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62092680 ORDER BY `minOrder` ASC [ RunTime:0.030688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62092680 ORDER BY `unit` DESC [ RunTime:0.024831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62092680 LIMIT 2 [ RunTime:0.026222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62092680 ORDER BY `minOrder` ASC [ RunTime:0.017354s ]
select * from pdf where partno='2102159-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.032809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102159-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.034956s ]
SELECT `id` FROM `stock` WHERE `id` <> 62092680 AND `partno` = '2102159-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.084445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11863873 [ RunTime:0.065080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60959027 LIMIT 5 [ RunTime:0.032877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60959027 ORDER BY `minOrder` ASC [ RunTime:0.064427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60959027 ORDER BY `unit` DESC [ RunTime:0.020995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60959027 LIMIT 2 [ RunTime:0.040162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60959027 ORDER BY `minOrder` ASC [ RunTime:0.014013s ]
select * from pdf where partno='2102161-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.034995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102161-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.032991s ]
SELECT `id` FROM `stock` WHERE `id` <> 60959027 AND `partno` = '2102161-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.024312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400276 [ RunTime:0.010770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958875 LIMIT 5 [ RunTime:0.028173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958875 ORDER BY `minOrder` ASC [ RunTime:0.026375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958875 ORDER BY `unit` DESC [ RunTime:0.014938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958875 LIMIT 2 [ RunTime:0.032588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958875 ORDER BY `minOrder` ASC [ RunTime:0.007980s ]
select * from pdf where partno='2102183-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102183-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.021617s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958875 AND `partno` = '2102183-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.016012s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022015s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017420s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016091s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016786s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008004s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032522s ]
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 '21021%' OR `brand` LIKE '21021%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049551s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21021%' OR `brand` LIKE '21021%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.038792s ]