SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001226s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=16074&search=1' [ RunTime:0.005807s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002341s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001411s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002107s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002005s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002482s ]
SELECT * FROM `stock_search` WHERE `partno` = '16074' LIMIT 1 [ RunTime:0.008490s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-21 02:01:34' WHERE `partno` = '16074' [ RunTime:0.003660s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002337s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019897s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519012 LIMIT 5 [ RunTime:0.017091s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519012 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519012 ORDER BY `unit` DESC [ RunTime:0.009951s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519012 LIMIT 2 [ RunTime:0.011012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519012 ORDER BY `minOrder` ASC [ RunTime:0.011290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159070 LIMIT 5 [ RunTime:0.004768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159070 ORDER BY `minOrder` ASC [ RunTime:0.006174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12159070 ORDER BY `unit` DESC [ RunTime:0.033107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12159070 LIMIT 2 [ RunTime:0.012115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159070 ORDER BY `minOrder` ASC [ RunTime:0.016862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13342367 LIMIT 5 [ RunTime:0.009080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13342367 ORDER BY `minOrder` ASC [ RunTime:0.000873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13342367 ORDER BY `unit` DESC [ RunTime:0.050655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13342367 LIMIT 2 [ RunTime:0.023287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13342367 ORDER BY `minOrder` ASC [ RunTime:0.002238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16380328 LIMIT 5 [ RunTime:0.026531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16380328 ORDER BY `minOrder` ASC [ RunTime:0.007328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16380328 ORDER BY `unit` DESC [ RunTime:0.007267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16380328 LIMIT 2 [ RunTime:0.011815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16380328 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20122150 LIMIT 5 [ RunTime:0.003971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20122150 ORDER BY `minOrder` ASC [ RunTime:0.008184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20122150 ORDER BY `unit` DESC [ RunTime:0.018806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20122150 LIMIT 2 [ RunTime:0.008385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20122150 ORDER BY `minOrder` ASC [ RunTime:0.014195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15560887 LIMIT 5 [ RunTime:0.011006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560887 ORDER BY `minOrder` ASC [ RunTime:0.021909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15560887 ORDER BY `unit` DESC [ RunTime:0.018650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15560887 LIMIT 2 [ RunTime:0.014296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560887 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16379695 LIMIT 5 [ RunTime:0.011689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379695 ORDER BY `minOrder` ASC [ RunTime:0.004504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16379695 ORDER BY `unit` DESC [ RunTime:0.009140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16379695 LIMIT 2 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379695 ORDER BY `minOrder` ASC [ RunTime:0.005835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11852577 LIMIT 5 [ RunTime:0.002884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11852577 ORDER BY `minOrder` ASC [ RunTime:0.009157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11852577 ORDER BY `unit` DESC [ RunTime:0.006585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11852577 LIMIT 2 [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11852577 ORDER BY `minOrder` ASC [ RunTime:0.012542s ]
select * from pdf where partno='1607407' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719222 LIMIT 5 [ RunTime:0.022630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719222 ORDER BY `minOrder` ASC [ RunTime:0.011691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719222 ORDER BY `unit` DESC [ RunTime:0.006634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719222 LIMIT 2 [ RunTime:0.005072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719222 ORDER BY `minOrder` ASC [ RunTime:0.007609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196016 LIMIT 5 [ RunTime:0.026526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196016 ORDER BY `minOrder` ASC [ RunTime:0.019312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11196016 ORDER BY `unit` DESC [ RunTime:0.007191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11196016 LIMIT 2 [ RunTime:0.006078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196016 ORDER BY `minOrder` ASC [ RunTime:0.008320s ]
select * from pdf where partno='1607455' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11852625 LIMIT 5 [ RunTime:0.008096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11852625 ORDER BY `minOrder` ASC [ RunTime:0.008927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11852625 ORDER BY `unit` DESC [ RunTime:0.010801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11852625 LIMIT 2 [ RunTime:0.004959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11852625 ORDER BY `minOrder` ASC [ RunTime:0.005609s ]
select * from pdf where partno='1607431' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19629379 LIMIT 5 [ RunTime:0.017826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19629379 ORDER BY `minOrder` ASC [ RunTime:0.011422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19629379 ORDER BY `unit` DESC [ RunTime:0.000884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19629379 LIMIT 2 [ RunTime:0.002713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19629379 ORDER BY `minOrder` ASC [ RunTime:0.009161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765433 LIMIT 5 [ RunTime:0.001466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765433 ORDER BY `minOrder` ASC [ RunTime:0.003007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18765433 ORDER BY `unit` DESC [ RunTime:0.003018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18765433 LIMIT 2 [ RunTime:0.009226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765433 ORDER BY `minOrder` ASC [ RunTime:0.005337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18728514 LIMIT 5 [ RunTime:0.007053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18728514 ORDER BY `minOrder` ASC [ RunTime:0.015040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18728514 ORDER BY `unit` DESC [ RunTime:0.034791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18728514 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18728514 ORDER BY `minOrder` ASC [ RunTime:0.005861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720073 LIMIT 5 [ RunTime:0.013392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720073 ORDER BY `minOrder` ASC [ RunTime:0.007267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720073 ORDER BY `unit` DESC [ RunTime:0.001548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720073 LIMIT 2 [ RunTime:0.022688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720073 ORDER BY `minOrder` ASC [ RunTime:0.017600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16998018 LIMIT 5 [ RunTime:0.010857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16998018 ORDER BY `minOrder` ASC [ RunTime:0.011203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16998018 ORDER BY `unit` DESC [ RunTime:0.003218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16998018 LIMIT 2 [ RunTime:0.011460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16998018 ORDER BY `minOrder` ASC [ RunTime:0.005971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16412367 LIMIT 5 [ RunTime:0.021041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412367 ORDER BY `minOrder` ASC [ RunTime:0.001993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16412367 ORDER BY `unit` DESC [ RunTime:0.013947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16412367 LIMIT 2 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16412367 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16411175 LIMIT 5 [ RunTime:0.015703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16411175 ORDER BY `minOrder` ASC [ RunTime:0.007535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16411175 ORDER BY `unit` DESC [ RunTime:0.010649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16411175 LIMIT 2 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16411175 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16379916 LIMIT 5 [ RunTime:0.012430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379916 ORDER BY `minOrder` ASC [ RunTime:0.004997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16379916 ORDER BY `unit` DESC [ RunTime:0.001396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16379916 LIMIT 2 [ RunTime:0.001761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379916 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15560910 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560910 ORDER BY `minOrder` ASC [ RunTime:0.006707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15560910 ORDER BY `unit` DESC [ RunTime:0.006546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15560910 LIMIT 2 [ RunTime:0.010660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560910 ORDER BY `minOrder` ASC [ RunTime:0.012185s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008696s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53817818 LIMIT 5 [ RunTime:0.009096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817818 ORDER BY `minOrder` ASC [ RunTime:0.006266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53817818 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53817818 LIMIT 2 [ RunTime:0.020206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817818 ORDER BY `minOrder` ASC [ RunTime:0.013308s ]
select * from pdf where partno='160743-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007652s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.005334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160743-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012944s ]
SELECT `id` FROM `stock` WHERE `id` <> 53817818 AND `partno` = '160743-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519012 [ RunTime:0.006353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51704461 LIMIT 5 [ RunTime:0.002850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51704461 ORDER BY `minOrder` ASC [ RunTime:0.003584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51704461 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51704461 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51704461 ORDER BY `minOrder` ASC [ RunTime:0.007990s ]
select * from pdf where partno='16074' and brandshort='Excel Blades' limit 1 [ RunTime:0.011442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16074' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.013454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50657037 LIMIT 5 [ RunTime:0.001948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50657037 ORDER BY `minOrder` ASC [ RunTime:0.001388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50657037 ORDER BY `unit` DESC [ RunTime:0.014139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50657037 LIMIT 2 [ RunTime:0.005281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50657037 ORDER BY `minOrder` ASC [ RunTime:0.004033s ]
select * from pdf where partno='16074' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.004824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16074' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38005094 LIMIT 5 [ RunTime:0.007935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38005094 ORDER BY `minOrder` ASC [ RunTime:0.023673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38005094 ORDER BY `unit` DESC [ RunTime:0.007647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38005094 LIMIT 2 [ RunTime:0.014891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38005094 ORDER BY `minOrder` ASC [ RunTime:0.004153s ]
select * from pdf where partno='16074' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16074' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575202 LIMIT 5 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575202 ORDER BY `minOrder` ASC [ RunTime:0.009789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575202 ORDER BY `unit` DESC [ RunTime:0.007016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575202 LIMIT 2 [ RunTime:0.001121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575202 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
select * from pdf where partno='1607474' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607474' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575199 LIMIT 5 [ RunTime:0.008074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575199 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575199 ORDER BY `unit` DESC [ RunTime:0.001964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575199 LIMIT 2 [ RunTime:0.005538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575199 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
select * from pdf where partno='1607495' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607495' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53576768 LIMIT 5 [ RunTime:0.003570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53576768 ORDER BY `minOrder` ASC [ RunTime:0.007540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53576768 ORDER BY `unit` DESC [ RunTime:0.004975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53576768 LIMIT 2 [ RunTime:0.001524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53576768 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='1607460' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607460' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.017448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53522200 LIMIT 5 [ RunTime:0.001253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53522200 ORDER BY `minOrder` ASC [ RunTime:0.009109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53522200 ORDER BY `unit` DESC [ RunTime:0.007834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53522200 LIMIT 2 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53522200 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='1607406' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607406' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53502628 LIMIT 5 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53502628 ORDER BY `minOrder` ASC [ RunTime:0.001208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53502628 ORDER BY `unit` DESC [ RunTime:0.013146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53502628 LIMIT 2 [ RunTime:0.001802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53502628 ORDER BY `minOrder` ASC [ RunTime:0.004041s ]
select * from pdf where partno='1607407' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607407' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53509542 LIMIT 5 [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53509542 ORDER BY `minOrder` ASC [ RunTime:0.001072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53509542 ORDER BY `unit` DESC [ RunTime:0.002656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53509542 LIMIT 2 [ RunTime:0.015980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53509542 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='1607449' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607449' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53503187 LIMIT 5 [ RunTime:0.011700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53503187 ORDER BY `minOrder` ASC [ RunTime:0.004675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53503187 ORDER BY `unit` DESC [ RunTime:0.002177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53503187 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53503187 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='1607431' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607431' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51683137 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683137 ORDER BY `minOrder` ASC [ RunTime:0.005450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51683137 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51683137 LIMIT 2 [ RunTime:0.001372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683137 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
select * from pdf where partno='1607455' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607455' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33111068 LIMIT 5 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33111068 ORDER BY `minOrder` ASC [ RunTime:0.001426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33111068 ORDER BY `unit` DESC [ RunTime:0.001504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33111068 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33111068 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
select * from pdf where partno='1607452' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607452' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53819129 LIMIT 5 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819129 ORDER BY `minOrder` ASC [ RunTime:0.006663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53819129 ORDER BY `unit` DESC [ RunTime:0.000822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53819129 LIMIT 2 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819129 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='160743-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '160743-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000712s ]
SELECT `id` FROM `stock` WHERE `id` <> 53819129 AND `partno` = '160743-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517084 [ RunTime:0.002458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53697174 LIMIT 5 [ RunTime:0.005169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53697174 ORDER BY `minOrder` ASC [ RunTime:0.006128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53697174 ORDER BY `unit` DESC [ RunTime:0.013593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53697174 LIMIT 2 [ RunTime:0.031163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53697174 ORDER BY `minOrder` ASC [ RunTime:0.004027s ]
select * from pdf where partno='1607410000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607410000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008579s ]
SELECT `id` FROM `stock` WHERE `id` <> 53697174 AND `partno` = '1607410000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19629379 [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53447529 LIMIT 5 [ RunTime:0.000842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53447529 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53447529 ORDER BY `unit` DESC [ RunTime:0.003241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53447529 LIMIT 2 [ RunTime:0.009613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53447529 ORDER BY `minOrder` ASC [ RunTime:0.007064s ]
select * from pdf where partno='1607499' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607499' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53390060 LIMIT 5 [ RunTime:0.002920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53390060 ORDER BY `minOrder` ASC [ RunTime:0.001370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53390060 ORDER BY `unit` DESC [ RunTime:0.007562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53390060 LIMIT 2 [ RunTime:0.002817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53390060 ORDER BY `minOrder` ASC [ RunTime:0.001169s ]
select * from pdf where partno='1607429' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607429' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53383242 LIMIT 5 [ RunTime:0.011656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53383242 ORDER BY `minOrder` ASC [ RunTime:0.003507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53383242 ORDER BY `unit` DESC [ RunTime:0.001207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53383242 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53383242 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
select * from pdf where partno='1607405' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607405' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53244848 LIMIT 5 [ RunTime:0.002706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53244848 ORDER BY `minOrder` ASC [ RunTime:0.006820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53244848 ORDER BY `unit` DESC [ RunTime:0.005379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53244848 LIMIT 2 [ RunTime:0.021348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53244848 ORDER BY `minOrder` ASC [ RunTime:0.005309s ]
select * from pdf where partno='1607415' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607415' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51697799 LIMIT 5 [ RunTime:0.015125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51697799 ORDER BY `minOrder` ASC [ RunTime:0.001983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51697799 ORDER BY `unit` DESC [ RunTime:0.003020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51697799 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51697799 ORDER BY `minOrder` ASC [ RunTime:0.003459s ]
select * from pdf where partno='1607456' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1607456' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018646s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002645s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002977s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012441s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004386s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003386s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006064s ]
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 '16074%' OR `brand` LIKE '16074%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004971s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '16074%' OR `brand` LIKE '16074%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016383s ]