SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002483s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=SE630&search=1' [ RunTime:0.003849s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002338s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004003s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002622s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.003045s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002476s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001971s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002629s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SE630' LIMIT 1 [ RunTime:0.001837s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 15:38:11' WHERE `partno` = 'SE630' [ RunTime:0.009771s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002715s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074622s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060655 LIMIT 5 [ RunTime:0.023202s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.038807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060655 ORDER BY `minOrder` ASC [ RunTime:0.037190s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17060655 ORDER BY `unit` DESC [ RunTime:0.041486s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17060655 LIMIT 2 [ RunTime:0.059009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060655 ORDER BY `minOrder` ASC [ RunTime:0.040721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033850 LIMIT 5 [ RunTime:0.029796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033850 ORDER BY `minOrder` ASC [ RunTime:0.043800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19033850 ORDER BY `unit` DESC [ RunTime:0.046599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19033850 LIMIT 2 [ RunTime:0.013105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033850 ORDER BY `minOrder` ASC [ RunTime:0.046777s ]
select * from pdf where partno='SE630,BK' and brandshort='Serpac' limit 1 [ RunTime:0.068447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036340 LIMIT 5 [ RunTime:0.058463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036340 ORDER BY `minOrder` ASC [ RunTime:0.019666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036340 ORDER BY `unit` DESC [ RunTime:0.012065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036340 LIMIT 2 [ RunTime:0.039487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036340 ORDER BY `minOrder` ASC [ RunTime:0.009532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032792 LIMIT 5 [ RunTime:0.059256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032792 ORDER BY `minOrder` ASC [ RunTime:0.020388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19032792 ORDER BY `unit` DESC [ RunTime:0.018953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19032792 LIMIT 2 [ RunTime:0.119168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032792 ORDER BY `minOrder` ASC [ RunTime:0.023236s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094827 LIMIT 5 [ RunTime:0.031581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094827 ORDER BY `minOrder` ASC [ RunTime:0.025364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094827 ORDER BY `unit` DESC [ RunTime:0.019478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094827 LIMIT 2 [ RunTime:0.029039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094827 ORDER BY `minOrder` ASC [ RunTime:0.009781s ]
select * from pdf where partno='se630f,bk' and brandshort='serpac' limit 1 [ RunTime:0.033346s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se630f,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.081261s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094827 AND `partno` = 'se630f,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.118474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060655 [ RunTime:0.011429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51094783 LIMIT 5 [ RunTime:0.024765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094783 ORDER BY `minOrder` ASC [ RunTime:0.019849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51094783 ORDER BY `unit` DESC [ RunTime:0.009909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51094783 LIMIT 2 [ RunTime:0.009500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51094783 ORDER BY `minOrder` ASC [ RunTime:0.011352s ]
select * from pdf where partno='se630,bk' and brandshort='serpac' limit 1 [ RunTime:0.020673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'se630,bk' OR `brand` LIKE 'serpac%' ) ) LIMIT 1 [ RunTime:0.006482s ]
SELECT `id` FROM `stock` WHERE `id` <> 51094783 AND `partno` = 'se630,bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.004574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033850 [ RunTime:0.010463s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56609942 LIMIT 5 [ RunTime:0.011663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56609942 ORDER BY `minOrder` ASC [ RunTime:0.002399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56609942 ORDER BY `unit` DESC [ RunTime:0.024333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56609942 LIMIT 2 [ RunTime:0.018758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56609942 ORDER BY `minOrder` ASC [ RunTime:0.002947s ]
select * from pdf where partno='SE630F,BK' and brandshort='Serpac' limit 1 [ RunTime:0.034101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630F,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.030986s ]
SELECT `id` FROM `stock` WHERE `id` <> 56609942 AND `partno` = 'SE630F,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.012774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060655 [ RunTime:0.012879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56613772 LIMIT 5 [ RunTime:0.020395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56613772 ORDER BY `minOrder` ASC [ RunTime:0.017823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56613772 ORDER BY `unit` DESC [ RunTime:0.006652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56613772 LIMIT 2 [ RunTime:0.008534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56613772 ORDER BY `minOrder` ASC [ RunTime:0.014603s ]
select * from pdf where partno='SE630,BK' and brandshort='Serpac' limit 1 [ RunTime:0.005215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630,BK' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.036892s ]
SELECT `id` FROM `stock` WHERE `id` <> 56613772 AND `partno` = 'SE630,BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.004567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033850 [ RunTime:0.001617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56620458 LIMIT 5 [ RunTime:0.013984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56620458 ORDER BY `minOrder` ASC [ RunTime:0.016562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56620458 ORDER BY `unit` DESC [ RunTime:0.013546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56620458 LIMIT 2 [ RunTime:0.015155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56620458 ORDER BY `minOrder` ASC [ RunTime:0.012734s ]
select * from pdf where partno='SE630F,DT' and brandshort='Serpac' limit 1 [ RunTime:0.005523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630F,DT' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.014222s ]
SELECT `id` FROM `stock` WHERE `id` <> 56620458 AND `partno` = 'SE630F,DT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.006366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036340 [ RunTime:0.005626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56629147 LIMIT 5 [ RunTime:0.007026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56629147 ORDER BY `minOrder` ASC [ RunTime:0.006828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56629147 ORDER BY `unit` DESC [ RunTime:0.006926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56629147 LIMIT 2 [ RunTime:0.006126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56629147 ORDER BY `minOrder` ASC [ RunTime:0.005773s ]
select * from pdf where partno='SE630FP6A' and brandshort='Serpac' limit 1 [ RunTime:0.006387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630FP6A' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.011111s ]
SELECT `id` FROM `stock` WHERE `id` <> 56629147 AND `partno` = 'SE630FP6A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.005908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627950 LIMIT 5 [ RunTime:0.004623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627950 ORDER BY `minOrder` ASC [ RunTime:0.005020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627950 ORDER BY `unit` DESC [ RunTime:0.018403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627950 LIMIT 2 [ RunTime:0.005440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627950 ORDER BY `minOrder` ASC [ RunTime:0.008118s ]
select * from pdf where partno='SE630DML' and brandshort='Serpac' limit 1 [ RunTime:0.003239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630DML' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.019324s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627950 AND `partno` = 'SE630DML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.012007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627883 LIMIT 5 [ RunTime:0.006605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627883 ORDER BY `minOrder` ASC [ RunTime:0.003971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627883 ORDER BY `unit` DESC [ RunTime:0.012089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627883 LIMIT 2 [ RunTime:0.031684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627883 ORDER BY `minOrder` ASC [ RunTime:0.008729s ]
select * from pdf where partno='SE630HPSML' and brandshort='Serpac' limit 1 [ RunTime:0.043140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630HPSML' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.016116s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627883 AND `partno` = 'SE630HPSML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.020762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627762 LIMIT 5 [ RunTime:0.002623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627762 ORDER BY `minOrder` ASC [ RunTime:0.008919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627762 ORDER BY `unit` DESC [ RunTime:0.018708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627762 LIMIT 2 [ RunTime:0.005399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627762 ORDER BY `minOrder` ASC [ RunTime:0.004691s ]
select * from pdf where partno='SE630D' and brandshort='Serpac' limit 1 [ RunTime:0.026890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630D' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.028910s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627762 AND `partno` = 'SE630D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.002699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627692 LIMIT 5 [ RunTime:0.017876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627692 ORDER BY `minOrder` ASC [ RunTime:0.042723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627692 ORDER BY `unit` DESC [ RunTime:0.020696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627692 LIMIT 2 [ RunTime:0.053707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627692 ORDER BY `minOrder` ASC [ RunTime:0.020275s ]
select * from pdf where partno='SE630FP4ML' and brandshort='Serpac' limit 1 [ RunTime:0.022112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630FP4ML' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.007565s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627692 AND `partno` = 'SE630FP4ML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.040682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627626 LIMIT 5 [ RunTime:0.013430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627626 ORDER BY `minOrder` ASC [ RunTime:0.016306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627626 ORDER BY `unit` DESC [ RunTime:0.019441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627626 LIMIT 2 [ RunTime:0.024726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627626 ORDER BY `minOrder` ASC [ RunTime:0.019317s ]
select * from pdf where partno='SE630DPL' and brandshort='Serpac' limit 1 [ RunTime:0.054876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630DPL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.046097s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627626 AND `partno` = 'SE630DPL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.069042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627593 LIMIT 5 [ RunTime:0.076271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627593 ORDER BY `minOrder` ASC [ RunTime:0.014156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627593 ORDER BY `unit` DESC [ RunTime:0.044425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627593 LIMIT 2 [ RunTime:0.039676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627593 ORDER BY `minOrder` ASC [ RunTime:0.028712s ]
select * from pdf where partno='SE630FP4PL' and brandshort='Serpac' limit 1 [ RunTime:0.054235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630FP4PL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.010945s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627593 AND `partno` = 'SE630FP4PL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.009631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627480 LIMIT 5 [ RunTime:0.010428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627480 ORDER BY `minOrder` ASC [ RunTime:0.033434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627480 ORDER BY `unit` DESC [ RunTime:0.035641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627480 LIMIT 2 [ RunTime:0.048049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627480 ORDER BY `minOrder` ASC [ RunTime:0.006122s ]
select * from pdf where partno='SE630FP4' and brandshort='Serpac' limit 1 [ RunTime:0.014098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630FP4' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.041742s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627480 AND `partno` = 'SE630FP4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.034344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627453 LIMIT 5 [ RunTime:0.011454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627453 ORDER BY `minOrder` ASC [ RunTime:0.095716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627453 ORDER BY `unit` DESC [ RunTime:0.159444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627453 LIMIT 2 [ RunTime:0.029016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627453 ORDER BY `minOrder` ASC [ RunTime:0.145924s ]
select * from pdf where partno='SE630HPS' and brandshort='Serpac' limit 1 [ RunTime:0.028981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630HPS' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.065976s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627453 AND `partno` = 'SE630HPS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.034509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627196 LIMIT 5 [ RunTime:0.043445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627196 ORDER BY `minOrder` ASC [ RunTime:0.047601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627196 ORDER BY `unit` DESC [ RunTime:0.068473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627196 LIMIT 2 [ RunTime:0.035804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627196 ORDER BY `minOrder` ASC [ RunTime:0.098562s ]
select * from pdf where partno='SE630FPL' and brandshort='Serpac' limit 1 [ RunTime:0.017755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630FPL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.026173s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627196 AND `partno` = 'SE630FPL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.021360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627063 LIMIT 5 [ RunTime:0.019871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627063 ORDER BY `minOrder` ASC [ RunTime:0.048471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627063 ORDER BY `unit` DESC [ RunTime:0.012378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627063 LIMIT 2 [ RunTime:0.003974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627063 ORDER BY `minOrder` ASC [ RunTime:0.013268s ]
select * from pdf where partno='SE630FML' and brandshort='Serpac' limit 1 [ RunTime:0.028425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630FML' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.031300s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627063 AND `partno` = 'SE630FML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.012037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56627037 LIMIT 5 [ RunTime:0.024162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627037 ORDER BY `minOrder` ASC [ RunTime:0.025708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56627037 ORDER BY `unit` DESC [ RunTime:0.042696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56627037 LIMIT 2 [ RunTime:0.032767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56627037 ORDER BY `minOrder` ASC [ RunTime:0.041933s ]
select * from pdf where partno='SE630F' and brandshort='Serpac' limit 1 [ RunTime:0.023962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630F' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.024712s ]
SELECT `id` FROM `stock` WHERE `id` <> 56627037 AND `partno` = 'SE630F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.007398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56626901 LIMIT 5 [ RunTime:0.018461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56626901 ORDER BY `minOrder` ASC [ RunTime:0.042818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56626901 ORDER BY `unit` DESC [ RunTime:0.075182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56626901 LIMIT 2 [ RunTime:0.049327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56626901 ORDER BY `minOrder` ASC [ RunTime:0.028691s ]
select * from pdf where partno='SE630ML' and brandshort='Serpac' limit 1 [ RunTime:0.012892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630ML' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.042019s ]
SELECT `id` FROM `stock` WHERE `id` <> 56626901 AND `partno` = 'SE630ML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.008321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56626750 LIMIT 5 [ RunTime:0.031216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56626750 ORDER BY `minOrder` ASC [ RunTime:0.027958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56626750 ORDER BY `unit` DESC [ RunTime:0.018845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56626750 LIMIT 2 [ RunTime:0.039080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56626750 ORDER BY `minOrder` ASC [ RunTime:0.004397s ]
select * from pdf where partno='SE630PL' and brandshort='Serpac' limit 1 [ RunTime:0.086368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630PL' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.015178s ]
SELECT `id` FROM `stock` WHERE `id` <> 56626750 AND `partno` = 'SE630PL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.023998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56626587 LIMIT 5 [ RunTime:0.026489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56626587 ORDER BY `minOrder` ASC [ RunTime:0.027114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56626587 ORDER BY `unit` DESC [ RunTime:0.020750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56626587 LIMIT 2 [ RunTime:0.028247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56626587 ORDER BY `minOrder` ASC [ RunTime:0.004698s ]
select * from pdf where partno='SE630' and brandshort='Serpac' limit 1 [ RunTime:0.028017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SE630' OR `brand` LIKE 'Serpac%' ) ) LIMIT 1 [ RunTime:0.057237s ]
SELECT `id` FROM `stock` WHERE `id` <> 56626587 AND `partno` = 'SE630' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%serpac%' ) [ RunTime:0.230602s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057892s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026338s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045089s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017146s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037670s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041432s ]
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 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013557s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SE630%' OR `brand` LIKE 'SE630%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020519s ]