SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002274s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=11221&search=1' [ RunTime:0.025953s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001913s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002376s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001371s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.016423s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001438s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002808s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001359s ]
SELECT * FROM `stock_search` WHERE `partno` = '11221' LIMIT 1 [ RunTime:0.090350s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 09:23:00' WHERE `partno` = '11221' [ RunTime:0.016352s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003283s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040125s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448852 LIMIT 5 [ RunTime:0.053434s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448852 ORDER BY `minOrder` ASC [ RunTime:0.012207s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15448852 ORDER BY `unit` DESC [ RunTime:0.028910s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15448852 LIMIT 2 [ RunTime:0.010418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448852 ORDER BY `minOrder` ASC [ RunTime:0.001749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19640532 LIMIT 5 [ RunTime:0.012082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640532 ORDER BY `minOrder` ASC [ RunTime:0.029766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19640532 ORDER BY `unit` DESC [ RunTime:0.008495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19640532 LIMIT 2 [ RunTime:0.010985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640532 ORDER BY `minOrder` ASC [ RunTime:0.009840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11849844 LIMIT 5 [ RunTime:0.015654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11849844 ORDER BY `minOrder` ASC [ RunTime:0.008884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11849844 ORDER BY `unit` DESC [ RunTime:0.024344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11849844 LIMIT 2 [ RunTime:0.028332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11849844 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605997 LIMIT 5 [ RunTime:0.005594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605997 ORDER BY `minOrder` ASC [ RunTime:0.009611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605997 ORDER BY `unit` DESC [ RunTime:0.006512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605997 LIMIT 2 [ RunTime:0.008131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605997 ORDER BY `minOrder` ASC [ RunTime:0.003400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681714 LIMIT 5 [ RunTime:0.007792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681714 ORDER BY `minOrder` ASC [ RunTime:0.014135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681714 ORDER BY `unit` DESC [ RunTime:0.012283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681714 LIMIT 2 [ RunTime:0.004374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681714 ORDER BY `minOrder` ASC [ RunTime:0.009917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419439 LIMIT 5 [ RunTime:0.008221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419439 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419439 ORDER BY `unit` DESC [ RunTime:0.010716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419439 LIMIT 2 [ RunTime:0.009763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419439 ORDER BY `minOrder` ASC [ RunTime:0.007159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10905285 LIMIT 5 [ RunTime:0.001224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10905285 ORDER BY `minOrder` ASC [ RunTime:0.010053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10905285 ORDER BY `unit` DESC [ RunTime:0.010392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10905285 LIMIT 2 [ RunTime:0.006162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10905285 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196051 LIMIT 5 [ RunTime:0.019386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14196051 ORDER BY `minOrder` ASC [ RunTime:0.028880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14196051 ORDER BY `unit` DESC [ RunTime:0.009646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14196051 LIMIT 2 [ RunTime:0.020094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14196051 ORDER BY `minOrder` ASC [ RunTime:0.001492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20096559 LIMIT 5 [ RunTime:0.015838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20096559 ORDER BY `minOrder` ASC [ RunTime:0.017096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20096559 ORDER BY `unit` DESC [ RunTime:0.018345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20096559 LIMIT 2 [ RunTime:0.033074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20096559 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20093605 LIMIT 5 [ RunTime:0.007148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20093605 ORDER BY `minOrder` ASC [ RunTime:0.016610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20093605 ORDER BY `unit` DESC [ RunTime:0.012775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20093605 LIMIT 2 [ RunTime:0.010990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20093605 ORDER BY `minOrder` ASC [ RunTime:0.011616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20085626 LIMIT 5 [ RunTime:0.038373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20085626 ORDER BY `minOrder` ASC [ RunTime:0.005569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20085626 ORDER BY `unit` DESC [ RunTime:0.037787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20085626 LIMIT 2 [ RunTime:0.031375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20085626 ORDER BY `minOrder` ASC [ RunTime:0.006453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646070 LIMIT 5 [ RunTime:0.035220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646070 ORDER BY `minOrder` ASC [ RunTime:0.009227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646070 ORDER BY `unit` DESC [ RunTime:0.026277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646070 LIMIT 2 [ RunTime:0.003866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646070 ORDER BY `minOrder` ASC [ RunTime:0.009009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18783096 LIMIT 5 [ RunTime:0.063880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783096 ORDER BY `minOrder` ASC [ RunTime:0.033077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18783096 ORDER BY `unit` DESC [ RunTime:0.024743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18783096 LIMIT 2 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783096 ORDER BY `minOrder` ASC [ RunTime:0.007677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778559 LIMIT 5 [ RunTime:0.040990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778559 ORDER BY `minOrder` ASC [ RunTime:0.053722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778559 ORDER BY `unit` DESC [ RunTime:0.051798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778559 LIMIT 2 [ RunTime:0.021137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778559 ORDER BY `minOrder` ASC [ RunTime:0.011492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774460 LIMIT 5 [ RunTime:0.018486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774460 ORDER BY `minOrder` ASC [ RunTime:0.037246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774460 ORDER BY `unit` DESC [ RunTime:0.028118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774460 LIMIT 2 [ RunTime:0.026250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774460 ORDER BY `minOrder` ASC [ RunTime:0.007848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011166 LIMIT 5 [ RunTime:0.009381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011166 ORDER BY `minOrder` ASC [ RunTime:0.021421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17011166 ORDER BY `unit` DESC [ RunTime:0.012312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17011166 LIMIT 2 [ RunTime:0.065469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011166 ORDER BY `minOrder` ASC [ RunTime:0.011502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16364853 LIMIT 5 [ RunTime:0.016426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16364853 ORDER BY `minOrder` ASC [ RunTime:0.019760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16364853 ORDER BY `unit` DESC [ RunTime:0.037216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16364853 LIMIT 2 [ RunTime:0.081711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16364853 ORDER BY `minOrder` ASC [ RunTime:0.021586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212390 LIMIT 5 [ RunTime:0.020021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212390 ORDER BY `minOrder` ASC [ RunTime:0.074590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212390 ORDER BY `unit` DESC [ RunTime:0.057084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212390 LIMIT 2 [ RunTime:0.050336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212390 ORDER BY `minOrder` ASC [ RunTime:0.068940s ]
select * from pdf where partno='11221' and brandshort='Astro Tool Corp' limit 1 [ RunTime:0.047704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13284165 LIMIT 5 [ RunTime:0.044986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284165 ORDER BY `minOrder` ASC [ RunTime:0.047856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13284165 ORDER BY `unit` DESC [ RunTime:0.052819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13284165 LIMIT 2 [ RunTime:0.044452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13284165 ORDER BY `minOrder` ASC [ RunTime:0.007178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12889946 LIMIT 5 [ RunTime:0.053340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12889946 ORDER BY `minOrder` ASC [ RunTime:0.029041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12889946 ORDER BY `unit` DESC [ RunTime:0.055675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12889946 LIMIT 2 [ RunTime:0.037885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12889946 ORDER BY `minOrder` ASC [ RunTime:0.019413s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017590s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60357502 LIMIT 5 [ RunTime:0.029486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60357502 ORDER BY `minOrder` ASC [ RunTime:0.023360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60357502 ORDER BY `unit` DESC [ RunTime:0.029186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60357502 LIMIT 2 [ RunTime:0.011864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60357502 ORDER BY `minOrder` ASC [ RunTime:0.008296s ]
select * from pdf where partno='11221000' and brandshort='LAPP' limit 1 [ RunTime:0.027958s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11221000' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.045976s ]
SELECT `id` FROM `stock` WHERE `id` <> 60357502 AND `partno` = '11221000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.032062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11849769 [ RunTime:0.037141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409605 LIMIT 5 [ RunTime:0.082045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409605 ORDER BY `minOrder` ASC [ RunTime:0.066999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409605 ORDER BY `unit` DESC [ RunTime:0.056157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409605 LIMIT 2 [ RunTime:0.027884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409605 ORDER BY `minOrder` ASC [ RunTime:0.023743s ]
select * from pdf where partno='11221250' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.095535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11221250' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.041803s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409605 AND `partno` = '11221250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.062769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60358134 LIMIT 5 [ RunTime:0.050888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60358134 ORDER BY `minOrder` ASC [ RunTime:0.052464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60358134 ORDER BY `unit` DESC [ RunTime:0.050911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60358134 LIMIT 2 [ RunTime:0.050986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60358134 ORDER BY `minOrder` ASC [ RunTime:0.051105s ]
select * from pdf where partno='11221300' and brandshort='LAPP' limit 1 [ RunTime:0.051516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11221300' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.051121s ]
SELECT `id` FROM `stock` WHERE `id` <> 60358134 AND `partno` = '11221300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.051185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11849844 [ RunTime:0.050978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484034 LIMIT 5 [ RunTime:0.050918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484034 ORDER BY `minOrder` ASC [ RunTime:0.051487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484034 ORDER BY `unit` DESC [ RunTime:0.139200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484034 LIMIT 2 [ RunTime:0.129747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484034 ORDER BY `minOrder` ASC [ RunTime:0.118473s ]
select * from pdf where partno='1122100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.138765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.047003s ]
SELECT `id` FROM `stock` WHERE `id` <> 60484034 AND `partno` = '1122100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.032400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448852 [ RunTime:0.075806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915089 LIMIT 5 [ RunTime:0.108166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915089 ORDER BY `minOrder` ASC [ RunTime:0.021711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915089 ORDER BY `unit` DESC [ RunTime:0.061495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915089 LIMIT 2 [ RunTime:0.049637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915089 ORDER BY `minOrder` ASC [ RunTime:0.075809s ]
select * from pdf where partno='1122117C031' and brandshort='Ease Electronics' limit 1 [ RunTime:0.039698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122117C031' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.065646s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915089 AND `partno` = '1122117C031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.017359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681714 [ RunTime:0.074967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63192022 LIMIT 5 [ RunTime:0.070584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63192022 ORDER BY `minOrder` ASC [ RunTime:0.043654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63192022 ORDER BY `unit` DESC [ RunTime:0.181945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63192022 LIMIT 2 [ RunTime:0.026280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63192022 ORDER BY `minOrder` ASC [ RunTime:0.042552s ]
select * from pdf where partno='1122108' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.041010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122108' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004329s ]
SELECT `id` FROM `stock` WHERE `id` <> 63192022 AND `partno` = '1122108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.064824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196051 [ RunTime:0.045663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61161051 LIMIT 5 [ RunTime:0.049602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61161051 ORDER BY `minOrder` ASC [ RunTime:0.021987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61161051 ORDER BY `unit` DESC [ RunTime:0.047686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61161051 LIMIT 2 [ RunTime:0.076880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61161051 ORDER BY `minOrder` ASC [ RunTime:0.055759s ]
select * from pdf where partno='1122171024' and brandshort='Molex' limit 1 [ RunTime:0.016371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122171024' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.042901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63349702 LIMIT 5 [ RunTime:0.019980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63349702 ORDER BY `minOrder` ASC [ RunTime:0.005756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63349702 ORDER BY `unit` DESC [ RunTime:0.012033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63349702 LIMIT 2 [ RunTime:0.026459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63349702 ORDER BY `minOrder` ASC [ RunTime:0.009770s ]
select * from pdf where partno='1122155' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122155' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033012s ]
SELECT `id` FROM `stock` WHERE `id` <> 63349702 AND `partno` = '1122155' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18783096 [ RunTime:0.030226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63342957 LIMIT 5 [ RunTime:0.021034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342957 ORDER BY `minOrder` ASC [ RunTime:0.020059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63342957 ORDER BY `unit` DESC [ RunTime:0.024077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63342957 LIMIT 2 [ RunTime:0.027199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342957 ORDER BY `minOrder` ASC [ RunTime:0.012430s ]
select * from pdf where partno='1122172' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122172' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013556s ]
SELECT `id` FROM `stock` WHERE `id` <> 63342957 AND `partno` = '1122172' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778559 [ RunTime:0.020128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63298953 LIMIT 5 [ RunTime:0.014876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63298953 ORDER BY `minOrder` ASC [ RunTime:0.009614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63298953 ORDER BY `unit` DESC [ RunTime:0.005952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63298953 LIMIT 2 [ RunTime:0.015700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63298953 ORDER BY `minOrder` ASC [ RunTime:0.012552s ]
select * from pdf where partno='1122104' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122104' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018007s ]
SELECT `id` FROM `stock` WHERE `id` <> 63298953 AND `partno` = '1122104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520833 [ RunTime:0.017116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63298727 LIMIT 5 [ RunTime:0.013012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63298727 ORDER BY `minOrder` ASC [ RunTime:0.017366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63298727 ORDER BY `unit` DESC [ RunTime:0.005034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63298727 LIMIT 2 [ RunTime:0.003815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63298727 ORDER BY `minOrder` ASC [ RunTime:0.010370s ]
select * from pdf where partno='1122103' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122103' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012544s ]
SELECT `id` FROM `stock` WHERE `id` <> 63298727 AND `partno` = '1122103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419439 [ RunTime:0.005234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61605708 LIMIT 5 [ RunTime:0.011506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61605708 ORDER BY `minOrder` ASC [ RunTime:0.014958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61605708 ORDER BY `unit` DESC [ RunTime:0.008846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61605708 LIMIT 2 [ RunTime:0.025801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61605708 ORDER BY `minOrder` ASC [ RunTime:0.011263s ]
select * from pdf where partno='1122190018' and brandshort='Molex' limit 1 [ RunTime:0.016657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122190018' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.022439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61596197 LIMIT 5 [ RunTime:0.012079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61596197 ORDER BY `minOrder` ASC [ RunTime:0.009568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61596197 ORDER BY `unit` DESC [ RunTime:0.009918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61596197 LIMIT 2 [ RunTime:0.004130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61596197 ORDER BY `minOrder` ASC [ RunTime:0.005053s ]
select * from pdf where partno='1122190032' and brandshort='Molex' limit 1 [ RunTime:0.017817s ]
select foldpath,foldpath2,filename from pdf_file where id=1349985 limit 1 [ RunTime:0.019789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122190032' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.022173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61535990 LIMIT 5 [ RunTime:0.017098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61535990 ORDER BY `minOrder` ASC [ RunTime:0.013969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61535990 ORDER BY `unit` DESC [ RunTime:0.001136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61535990 LIMIT 2 [ RunTime:0.012410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61535990 ORDER BY `minOrder` ASC [ RunTime:0.016768s ]
select * from pdf where partno='1122190052' and brandshort='Molex' limit 1 [ RunTime:0.010329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122190052' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.037467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61517151 LIMIT 5 [ RunTime:0.014050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61517151 ORDER BY `minOrder` ASC [ RunTime:0.009970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61517151 ORDER BY `unit` DESC [ RunTime:0.018503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61517151 LIMIT 2 [ RunTime:0.011438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61517151 ORDER BY `minOrder` ASC [ RunTime:0.004591s ]
select * from pdf where partno='1122190001' and brandshort='Molex' limit 1 [ RunTime:0.012094s ]
select foldpath,foldpath2,filename from pdf_file where id=1620821 limit 1 [ RunTime:0.016201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122190001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61465667 LIMIT 5 [ RunTime:0.006920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61465667 ORDER BY `minOrder` ASC [ RunTime:0.002478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61465667 ORDER BY `unit` DESC [ RunTime:0.001042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61465667 LIMIT 2 [ RunTime:0.000979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61465667 ORDER BY `minOrder` ASC [ RunTime:0.002288s ]
select * from pdf where partno='1122191032' and brandshort='Molex' limit 1 [ RunTime:0.001745s ]
select foldpath,foldpath2,filename from pdf_file where id=1665599 limit 1 [ RunTime:0.000991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122191032' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.112538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61465666 LIMIT 5 [ RunTime:0.010200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61465666 ORDER BY `minOrder` ASC [ RunTime:0.027492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61465666 ORDER BY `unit` DESC [ RunTime:0.050799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61465666 LIMIT 2 [ RunTime:0.055247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61465666 ORDER BY `minOrder` ASC [ RunTime:0.032569s ]
select * from pdf where partno='1122191031' and brandshort='Molex' limit 1 [ RunTime:0.015939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122191031' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.101821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61447680 LIMIT 5 [ RunTime:0.032918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61447680 ORDER BY `minOrder` ASC [ RunTime:0.056324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61447680 ORDER BY `unit` DESC [ RunTime:0.011505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61447680 LIMIT 2 [ RunTime:0.033090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61447680 ORDER BY `minOrder` ASC [ RunTime:0.020875s ]
select * from pdf where partno='1122191016' and brandshort='Molex' limit 1 [ RunTime:0.021832s ]
select foldpath,foldpath2,filename from pdf_file where id=1849747 limit 1 [ RunTime:0.011424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122191016' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61433682 LIMIT 5 [ RunTime:0.003539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61433682 ORDER BY `minOrder` ASC [ RunTime:0.001233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61433682 ORDER BY `unit` DESC [ RunTime:0.003170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61433682 LIMIT 2 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61433682 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
select * from pdf where partno='1122191044' and brandshort='Molex' limit 1 [ RunTime:0.001032s ]
select foldpath,foldpath2,filename from pdf_file where id=1639440 limit 1 [ RunTime:0.001452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122191044' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61167518 LIMIT 5 [ RunTime:0.001045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61167518 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61167518 ORDER BY `unit` DESC [ RunTime:0.001448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61167518 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61167518 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
select * from pdf where partno='1122170052' and brandshort='Molex' limit 1 [ RunTime:0.004167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1122170052' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.025815s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030915s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021611s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006533s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001600s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003484s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003117s ]
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 '11221%' OR `brand` LIKE '11221%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003835s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '11221%' OR `brand` LIKE '11221%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001476s ]