SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001518s ]
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=52103&search=1' [ RunTime:0.003692s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001575s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001505s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004900s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001405s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001718s ]
SELECT * FROM `stock_search` WHERE `partno` = '52103' LIMIT 1 [ RunTime:0.001104s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-26 13:50:11' WHERE `partno` = '52103' [ RunTime:0.007706s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001572s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004059s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867675 LIMIT 5 [ RunTime:0.007375s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867675 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867675 ORDER BY `unit` DESC [ RunTime:0.002096s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867675 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867675 ORDER BY `minOrder` ASC [ RunTime:0.002311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867670 LIMIT 5 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867670 ORDER BY `minOrder` ASC [ RunTime:0.001639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867670 ORDER BY `unit` DESC [ RunTime:0.002949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867670 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867670 ORDER BY `minOrder` ASC [ RunTime:0.004836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867667 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867667 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867667 ORDER BY `unit` DESC [ RunTime:0.003487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867667 LIMIT 2 [ RunTime:0.004790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867667 ORDER BY `minOrder` ASC [ RunTime:0.006323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867665 LIMIT 5 [ RunTime:0.008629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867665 ORDER BY `minOrder` ASC [ RunTime:0.017395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867665 ORDER BY `unit` DESC [ RunTime:0.000587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867665 LIMIT 2 [ RunTime:0.006246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867665 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17027270 LIMIT 5 [ RunTime:0.005098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027270 ORDER BY `minOrder` ASC [ RunTime:0.012407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17027270 ORDER BY `unit` DESC [ RunTime:0.007008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17027270 LIMIT 2 [ RunTime:0.007274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027270 ORDER BY `minOrder` ASC [ RunTime:0.003361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15253067 LIMIT 5 [ RunTime:0.008501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15253067 ORDER BY `minOrder` ASC [ RunTime:0.006103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15253067 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15253067 LIMIT 2 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15253067 ORDER BY `minOrder` ASC [ RunTime:0.004397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15242374 LIMIT 5 [ RunTime:0.012822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15242374 ORDER BY `minOrder` ASC [ RunTime:0.002808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15242374 ORDER BY `unit` DESC [ RunTime:0.003101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15242374 LIMIT 2 [ RunTime:0.003518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15242374 ORDER BY `minOrder` ASC [ RunTime:0.005574s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016476s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63083229 LIMIT 5 [ RunTime:0.008859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083229 ORDER BY `minOrder` ASC [ RunTime:0.006821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63083229 ORDER BY `unit` DESC [ RunTime:0.002442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63083229 LIMIT 2 [ RunTime:0.004635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083229 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
select * from pdf where partno='52103190' and brandshort='LAPP' limit 1 [ RunTime:0.010637s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103190' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.015773s ]
SELECT `id` FROM `stock` WHERE `id` <> 63083229 AND `partno` = '52103190' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.008689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63083146 LIMIT 5 [ RunTime:0.008009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083146 ORDER BY `minOrder` ASC [ RunTime:0.010952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63083146 ORDER BY `unit` DESC [ RunTime:0.006016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63083146 LIMIT 2 [ RunTime:0.014596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083146 ORDER BY `minOrder` ASC [ RunTime:0.015401s ]
select * from pdf where partno='52103073' and brandshort='LAPP' limit 1 [ RunTime:0.021030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103073' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.016543s ]
SELECT `id` FROM `stock` WHERE `id` <> 63083146 AND `partno` = '52103073' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.008670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63083109 LIMIT 5 [ RunTime:0.002983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083109 ORDER BY `minOrder` ASC [ RunTime:0.009902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63083109 ORDER BY `unit` DESC [ RunTime:0.013447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63083109 LIMIT 2 [ RunTime:0.006812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083109 ORDER BY `minOrder` ASC [ RunTime:0.018900s ]
select * from pdf where partno='52103190LF' and brandshort='LAPP' limit 1 [ RunTime:0.011632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103190LF' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.010079s ]
SELECT `id` FROM `stock` WHERE `id` <> 63083109 AND `partno` = '52103190LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.010631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63083060 LIMIT 5 [ RunTime:0.012019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083060 ORDER BY `minOrder` ASC [ RunTime:0.034675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63083060 ORDER BY `unit` DESC [ RunTime:0.007081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63083060 LIMIT 2 [ RunTime:0.017838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083060 ORDER BY `minOrder` ASC [ RunTime:0.005933s ]
select * from pdf where partno='52103372' and brandshort='LAPP' limit 1 [ RunTime:0.037631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103372' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.018002s ]
SELECT `id` FROM `stock` WHERE `id` <> 63083060 AND `partno` = '52103372' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.063638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63083041 LIMIT 5 [ RunTime:0.009765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083041 ORDER BY `minOrder` ASC [ RunTime:0.016040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63083041 ORDER BY `unit` DESC [ RunTime:0.012957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63083041 LIMIT 2 [ RunTime:0.012323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083041 ORDER BY `minOrder` ASC [ RunTime:0.009706s ]
select * from pdf where partno='52103072' and brandshort='LAPP' limit 1 [ RunTime:0.036381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103072' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.015430s ]
SELECT `id` FROM `stock` WHERE `id` <> 63083041 AND `partno` = '52103072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.048558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63083007 LIMIT 5 [ RunTime:0.002742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083007 ORDER BY `minOrder` ASC [ RunTime:0.007733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63083007 ORDER BY `unit` DESC [ RunTime:0.004805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63083007 LIMIT 2 [ RunTime:0.026748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083007 ORDER BY `minOrder` ASC [ RunTime:0.008974s ]
select * from pdf where partno='52103426' and brandshort='LAPP' limit 1 [ RunTime:0.046682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103426' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.023258s ]
SELECT `id` FROM `stock` WHERE `id` <> 63083007 AND `partno` = '52103426' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.040051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082958 LIMIT 5 [ RunTime:0.020339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082958 ORDER BY `minOrder` ASC [ RunTime:0.033967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082958 ORDER BY `unit` DESC [ RunTime:0.025950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082958 LIMIT 2 [ RunTime:0.032475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082958 ORDER BY `minOrder` ASC [ RunTime:0.015919s ]
select * from pdf where partno='52103373' and brandshort='LAPP' limit 1 [ RunTime:0.022607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103373' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.019607s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082958 AND `partno` = '52103373' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.063856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082903 LIMIT 5 [ RunTime:0.034029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082903 ORDER BY `minOrder` ASC [ RunTime:0.057017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082903 ORDER BY `unit` DESC [ RunTime:0.026062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082903 LIMIT 2 [ RunTime:0.089177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082903 ORDER BY `minOrder` ASC [ RunTime:0.040725s ]
select * from pdf where partno='52103170LF' and brandshort='LAPP' limit 1 [ RunTime:0.032348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103170LF' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.075128s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082903 AND `partno` = '52103170LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.043739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082873 LIMIT 5 [ RunTime:0.063062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082873 ORDER BY `minOrder` ASC [ RunTime:0.074185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082873 ORDER BY `unit` DESC [ RunTime:0.059670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082873 LIMIT 2 [ RunTime:0.049103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082873 ORDER BY `minOrder` ASC [ RunTime:0.051190s ]
select * from pdf where partno='52103594' and brandshort='LAPP' limit 1 [ RunTime:0.048670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103594' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.108943s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082873 AND `partno` = '52103594' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.088093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082794 LIMIT 5 [ RunTime:0.035371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082794 ORDER BY `minOrder` ASC [ RunTime:0.098395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082794 ORDER BY `unit` DESC [ RunTime:0.011596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082794 LIMIT 2 [ RunTime:0.026123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082794 ORDER BY `minOrder` ASC [ RunTime:0.018210s ]
select * from pdf where partno='52103593' and brandshort='LAPP' limit 1 [ RunTime:0.101123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103593' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.084356s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082794 AND `partno` = '52103593' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.050080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082721 LIMIT 5 [ RunTime:0.117637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082721 ORDER BY `minOrder` ASC [ RunTime:0.097995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082721 ORDER BY `unit` DESC [ RunTime:0.024227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082721 LIMIT 2 [ RunTime:0.030055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082721 ORDER BY `minOrder` ASC [ RunTime:0.022071s ]
select * from pdf where partno='52103602' and brandshort='LAPP' limit 1 [ RunTime:0.068124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103602' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.035199s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082721 AND `partno` = '52103602' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.068277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082712 LIMIT 5 [ RunTime:0.046228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082712 ORDER BY `minOrder` ASC [ RunTime:0.009659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082712 ORDER BY `unit` DESC [ RunTime:0.035035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082712 LIMIT 2 [ RunTime:0.080921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082712 ORDER BY `minOrder` ASC [ RunTime:0.032127s ]
select * from pdf where partno='52103592' and brandshort='LAPP' limit 1 [ RunTime:0.039905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103592' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.031699s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082712 AND `partno` = '52103592' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.060443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082665 LIMIT 5 [ RunTime:0.066257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082665 ORDER BY `minOrder` ASC [ RunTime:0.081993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082665 ORDER BY `unit` DESC [ RunTime:0.055347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082665 LIMIT 2 [ RunTime:0.049980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082665 ORDER BY `minOrder` ASC [ RunTime:0.011541s ]
select * from pdf where partno='52103175' and brandshort='LAPP' limit 1 [ RunTime:0.050235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103175' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.027818s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082665 AND `partno` = '52103175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.056835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082637 LIMIT 5 [ RunTime:0.062577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082637 ORDER BY `minOrder` ASC [ RunTime:0.071798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082637 ORDER BY `unit` DESC [ RunTime:0.026259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082637 LIMIT 2 [ RunTime:0.045648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082637 ORDER BY `minOrder` ASC [ RunTime:0.036194s ]
select * from pdf where partno='52103591' and brandshort='LAPP' limit 1 [ RunTime:0.029268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103591' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.008024s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082637 AND `partno` = '52103591' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.046834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082627 LIMIT 5 [ RunTime:0.078133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082627 ORDER BY `minOrder` ASC [ RunTime:0.067983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082627 ORDER BY `unit` DESC [ RunTime:0.084508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082627 LIMIT 2 [ RunTime:0.086022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082627 ORDER BY `minOrder` ASC [ RunTime:0.014794s ]
select * from pdf where partno='52103600' and brandshort='LAPP' limit 1 [ RunTime:0.026170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103600' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.067590s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082627 AND `partno` = '52103600' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.028347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082572 LIMIT 5 [ RunTime:0.042141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082572 ORDER BY `minOrder` ASC [ RunTime:0.015836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082572 ORDER BY `unit` DESC [ RunTime:0.030515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082572 LIMIT 2 [ RunTime:0.070026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082572 ORDER BY `minOrder` ASC [ RunTime:0.019747s ]
select * from pdf where partno='52103601' and brandshort='LAPP' limit 1 [ RunTime:0.066538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103601' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.032056s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082572 AND `partno` = '52103601' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.037542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082539 LIMIT 5 [ RunTime:0.091286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082539 ORDER BY `minOrder` ASC [ RunTime:0.049318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082539 ORDER BY `unit` DESC [ RunTime:0.013128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082539 LIMIT 2 [ RunTime:0.049602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082539 ORDER BY `minOrder` ASC [ RunTime:0.014854s ]
select * from pdf where partno='52103599' and brandshort='LAPP' limit 1 [ RunTime:0.086719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103599' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.047989s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082539 AND `partno` = '52103599' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.030444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082496 LIMIT 5 [ RunTime:0.028164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082496 ORDER BY `minOrder` ASC [ RunTime:0.051124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082496 ORDER BY `unit` DESC [ RunTime:0.038230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082496 LIMIT 2 [ RunTime:0.071083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082496 ORDER BY `minOrder` ASC [ RunTime:0.024573s ]
select * from pdf where partno='52103597' and brandshort='LAPP' limit 1 [ RunTime:0.058214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103597' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.053669s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082496 AND `partno` = '52103597' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.058118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082494 LIMIT 5 [ RunTime:0.076791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082494 ORDER BY `minOrder` ASC [ RunTime:0.172172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082494 ORDER BY `unit` DESC [ RunTime:0.059996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082494 LIMIT 2 [ RunTime:0.038245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082494 ORDER BY `minOrder` ASC [ RunTime:0.039993s ]
select * from pdf where partno='52103598' and brandshort='LAPP' limit 1 [ RunTime:0.011106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103598' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.024424s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082494 AND `partno` = '52103598' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.022249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63082447 LIMIT 5 [ RunTime:0.014832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082447 ORDER BY `minOrder` ASC [ RunTime:0.030388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63082447 ORDER BY `unit` DESC [ RunTime:0.043140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63082447 LIMIT 2 [ RunTime:0.076653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63082447 ORDER BY `minOrder` ASC [ RunTime:0.011656s ]
select * from pdf where partno='52103596' and brandshort='LAPP' limit 1 [ RunTime:0.019984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52103596' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.029965s ]
SELECT `id` FROM `stock` WHERE `id` <> 63082447 AND `partno` = '52103596' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.063055s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037668s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031047s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065928s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079315s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036519s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032224s ]
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 '52103%' OR `brand` LIKE '52103%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082222s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '52103%' OR `brand` LIKE '52103%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.043884s ]