SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002101s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.158' , `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=6797&search=1' [ RunTime:0.002000s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002169s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003845s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002706s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.158' ) [ RunTime:0.000609s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001844s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000505s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001835s ]
SELECT * FROM `stock_search` WHERE `partno` = '6797' LIMIT 1 [ RunTime:0.000867s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-09-18 03:39:37' WHERE `partno` = '6797' [ RunTime:0.001739s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001997s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004773s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16419179 LIMIT 5 [ RunTime:0.000953s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16419179 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16419179 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16419179 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16419179 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990885 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990885 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18990885 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18990885 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990885 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990884 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990884 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18990884 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18990884 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990884 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990883 LIMIT 5 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990883 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18990883 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18990883 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990883 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753056 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753056 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753056 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753056 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753056 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752737 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752737 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752737 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752737 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752737 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750097 LIMIT 5 [ RunTime:0.001047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750097 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750097 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750097 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750097 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18749153 LIMIT 5 [ RunTime:0.000915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749153 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18749153 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18749153 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749153 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18741407 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18741407 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18741407 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18741407 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18741407 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18736450 LIMIT 5 [ RunTime:0.001953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18736450 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18736450 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18736450 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18736450 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17006118 LIMIT 5 [ RunTime:0.000778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006118 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17006118 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17006118 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006118 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17000623 LIMIT 5 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17000623 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17000623 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17000623 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17000623 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218715 LIMIT 5 [ RunTime:0.001011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218715 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218715 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218715 LIMIT 2 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218715 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15215836 LIMIT 5 [ RunTime:0.000999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215836 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15215836 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15215836 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15215836 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171444 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171444 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12171444 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12171444 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171444 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001235s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69903307 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69903307 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69903307 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69903307 LIMIT 2 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69903307 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='6797570001' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000564s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6797570001' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000574s ]
SELECT `id` FROM `stock` WHERE `id` <> 69903307 AND `partno` = '6797570001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16419179 [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71568263 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71568263 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71568263 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71568263 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71568263 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='6797YB' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.000743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6797YB' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.000523s ]
SELECT `id` FROM `stock` WHERE `id` <> 71568263 AND `partno` = '6797YB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990885 [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71568262 LIMIT 5 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71568262 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71568262 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71568262 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71568262 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='6797BB' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.000552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6797BB' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.000478s ]
SELECT `id` FROM `stock` WHERE `id` <> 71568262 AND `partno` = '6797BB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990884 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71568261 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71568261 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71568261 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71568261 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71568261 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
select * from pdf where partno='6797RB' and brandshort='Flambeau Inc.' limit 1 [ RunTime:0.000628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6797RB' OR `brand` LIKE 'Flambeau Inc.%' ) ) LIMIT 1 [ RunTime:0.000791s ]
SELECT `id` FROM `stock` WHERE `id` <> 71568261 AND `partno` = '6797RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flambeau inc.%' ) [ RunTime:0.000696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990883 [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70192710 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70192710 ORDER BY `minOrder` ASC [ RunTime:0.001974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70192710 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70192710 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70192710 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
select * from pdf where partno='6797-1' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6797-1' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000740s ]
SELECT `id` FROM `stock` WHERE `id` <> 70192710 AND `partno` = '6797-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.000655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70192681 LIMIT 5 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70192681 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70192681 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70192681 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70192681 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
select * from pdf where partno='6797' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6797' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT `id` FROM `stock` WHERE `id` <> 70192681 AND `partno` = '6797' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65330900 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65330900 ORDER BY `minOrder` ASC [ RunTime:0.001019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65330900 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65330900 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65330900 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
select * from pdf where partno='679754-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679754-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000758s ]
SELECT `id` FROM `stock` WHERE `id` <> 65330900 AND `partno` = '679754-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44624423 LIMIT 5 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44624423 ORDER BY `minOrder` ASC [ RunTime:0.001052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44624423 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44624423 LIMIT 2 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44624423 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='679754-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679754-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000643s ]
SELECT `id` FROM `stock` WHERE `id` <> 44624423 AND `partno` = '679754-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171444 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44039863 LIMIT 5 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44039863 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44039863 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44039863 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44039863 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='679768-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679768-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000623s ]
SELECT `id` FROM `stock` WHERE `id` <> 44039863 AND `partno` = '679768-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18749153 [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44030381 LIMIT 5 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44030381 ORDER BY `minOrder` ASC [ RunTime:0.000904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44030381 ORDER BY `unit` DESC [ RunTime:0.000475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44030381 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44030381 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='679747-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679747-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000532s ]
SELECT `id` FROM `stock` WHERE `id` <> 44030381 AND `partno` = '679747-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752737 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44029805 LIMIT 5 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44029805 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44029805 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44029805 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44029805 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='679793-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679793-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000545s ]
SELECT `id` FROM `stock` WHERE `id` <> 44029805 AND `partno` = '679793-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15215836 [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44028009 LIMIT 5 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44028009 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44028009 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44028009 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44028009 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='679792-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679792-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000534s ]
SELECT `id` FROM `stock` WHERE `id` <> 44028009 AND `partno` = '679792-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18741407 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44024678 LIMIT 5 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44024678 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44024678 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44024678 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44024678 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='679792-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679792-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000527s ]
SELECT `id` FROM `stock` WHERE `id` <> 44024678 AND `partno` = '679792-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18736450 [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44007778 LIMIT 5 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44007778 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44007778 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44007778 LIMIT 2 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44007778 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='679746-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679746-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000731s ]
SELECT `id` FROM `stock` WHERE `id` <> 44007778 AND `partno` = '679746-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17000623 [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33105498 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33105498 ORDER BY `minOrder` ASC [ RunTime:0.001077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33105498 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33105498 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33105498 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
select * from pdf where partno='679754-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '679754-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000738s ]
SELECT `id` FROM `stock` WHERE `id` <> 33105498 AND `partno` = '679754-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171444 [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32561353 LIMIT 5 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32561353 ORDER BY `minOrder` ASC [ RunTime:0.001083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32561353 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32561353 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32561353 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
select * from pdf where partno='67974' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.000837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67974' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.000748s ]
SELECT `id` FROM `stock` WHERE `id` <> 32561353 AND `partno` = '67974' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32555779 LIMIT 5 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32555779 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32555779 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32555779 LIMIT 2 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32555779 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
select * from pdf where partno='67972' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.000822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '67972' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.000768s ]
SELECT `id` FROM `stock` WHERE `id` <> 32555779 AND `partno` = '67972' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.000759s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001277s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001161s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001154s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001160s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001274s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001166s ]
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 '6797%' OR `brand` LIKE '6797%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001156s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6797%' OR `brand` LIKE '6797%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001190s ]