SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002550s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=20025&search=1' [ RunTime:0.002876s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002426s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002559s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002873s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003078s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002501s ]
SELECT * FROM `stock_search` WHERE `partno` = '20025' LIMIT 1 [ RunTime:0.007353s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-10 06:56:04' WHERE `partno` = '20025' [ RunTime:0.006431s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002387s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024601s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256542 LIMIT 5 [ RunTime:0.012598s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256542 ORDER BY `minOrder` ASC [ RunTime:0.010215s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14256542 ORDER BY `unit` DESC [ RunTime:0.003677s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14256542 LIMIT 2 [ RunTime:0.003839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256542 ORDER BY `minOrder` ASC [ RunTime:0.007051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256538 LIMIT 5 [ RunTime:0.001679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256538 ORDER BY `minOrder` ASC [ RunTime:0.001749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14256538 ORDER BY `unit` DESC [ RunTime:0.010701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14256538 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256538 ORDER BY `minOrder` ASC [ RunTime:0.008497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373031 LIMIT 5 [ RunTime:0.011802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373031 ORDER BY `minOrder` ASC [ RunTime:0.018336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13373031 ORDER BY `unit` DESC [ RunTime:0.016320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13373031 LIMIT 2 [ RunTime:0.012372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373031 ORDER BY `minOrder` ASC [ RunTime:0.014360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256539 LIMIT 5 [ RunTime:0.022726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256539 ORDER BY `minOrder` ASC [ RunTime:0.005346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14256539 ORDER BY `unit` DESC [ RunTime:0.034232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14256539 LIMIT 2 [ RunTime:0.013360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256539 ORDER BY `minOrder` ASC [ RunTime:0.004462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20081320 LIMIT 5 [ RunTime:0.016716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081320 ORDER BY `minOrder` ASC [ RunTime:0.020986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20081320 ORDER BY `unit` DESC [ RunTime:0.009238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20081320 LIMIT 2 [ RunTime:0.025120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081320 ORDER BY `minOrder` ASC [ RunTime:0.005001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18798306 LIMIT 5 [ RunTime:0.023331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798306 ORDER BY `minOrder` ASC [ RunTime:0.033967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18798306 ORDER BY `unit` DESC [ RunTime:0.019176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18798306 LIMIT 2 [ RunTime:0.009876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798306 ORDER BY `minOrder` ASC [ RunTime:0.015386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17142351 LIMIT 5 [ RunTime:0.010838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17142351 ORDER BY `minOrder` ASC [ RunTime:0.023106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17142351 ORDER BY `unit` DESC [ RunTime:0.012414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17142351 LIMIT 2 [ RunTime:0.029766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17142351 ORDER BY `minOrder` ASC [ RunTime:0.001825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12077590 LIMIT 5 [ RunTime:0.004181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12077590 ORDER BY `minOrder` ASC [ RunTime:0.021750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12077590 ORDER BY `unit` DESC [ RunTime:0.019864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12077590 LIMIT 2 [ RunTime:0.024658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12077590 ORDER BY `minOrder` ASC [ RunTime:0.028508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12056640 LIMIT 5 [ RunTime:0.018792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12056640 ORDER BY `minOrder` ASC [ RunTime:0.026273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12056640 ORDER BY `unit` DESC [ RunTime:0.024342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12056640 LIMIT 2 [ RunTime:0.061921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12056640 ORDER BY `minOrder` ASC [ RunTime:0.015948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014864 LIMIT 5 [ RunTime:0.041096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014864 ORDER BY `minOrder` ASC [ RunTime:0.034840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12014864 ORDER BY `unit` DESC [ RunTime:0.009734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12014864 LIMIT 2 [ RunTime:0.015323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014864 ORDER BY `minOrder` ASC [ RunTime:0.016956s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32245595 LIMIT 5 [ RunTime:0.047285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245595 ORDER BY `minOrder` ASC [ RunTime:0.051094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32245595 ORDER BY `unit` DESC [ RunTime:0.011645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32245595 LIMIT 2 [ RunTime:0.024429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245595 ORDER BY `minOrder` ASC [ RunTime:0.017998s ]
select * from pdf where partno='20025129-80' and brandshort='te connectivity' limit 1 [ RunTime:0.011191s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025129-80' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.037608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32245657 LIMIT 5 [ RunTime:0.014234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245657 ORDER BY `minOrder` ASC [ RunTime:0.019744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32245657 ORDER BY `unit` DESC [ RunTime:0.035811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32245657 LIMIT 2 [ RunTime:0.027302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245657 ORDER BY `minOrder` ASC [ RunTime:0.007793s ]
select * from pdf where partno='20025129-90' and brandshort='te connectivity' limit 1 [ RunTime:0.029382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025129-90' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.043622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32245638 LIMIT 5 [ RunTime:0.003156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245638 ORDER BY `minOrder` ASC [ RunTime:0.030879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32245638 ORDER BY `unit` DESC [ RunTime:0.035439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32245638 LIMIT 2 [ RunTime:0.006935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245638 ORDER BY `minOrder` ASC [ RunTime:0.029330s ]
select * from pdf where partno='20025127-80' and brandshort='te connectivity' limit 1 [ RunTime:0.006568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025127-80' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.021668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32245639 LIMIT 5 [ RunTime:0.027997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245639 ORDER BY `minOrder` ASC [ RunTime:0.015196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32245639 ORDER BY `unit` DESC [ RunTime:0.026970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32245639 LIMIT 2 [ RunTime:0.013284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32245639 ORDER BY `minOrder` ASC [ RunTime:0.035594s ]
select * from pdf where partno='20025127-90' and brandshort='te connectivity' limit 1 [ RunTime:0.031959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025127-90' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.049202s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568193 LIMIT 5 [ RunTime:0.036566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568193 ORDER BY `minOrder` ASC [ RunTime:0.058549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568193 ORDER BY `unit` DESC [ RunTime:0.019950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568193 LIMIT 2 [ RunTime:0.029434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568193 ORDER BY `minOrder` ASC [ RunTime:0.014700s ]
select * from pdf where partno='20025' and brandshort='Excel Blades' limit 1 [ RunTime:0.025057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.026331s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568193 AND `partno` = '20025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.013764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63330581 LIMIT 5 [ RunTime:0.034693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330581 ORDER BY `minOrder` ASC [ RunTime:0.028297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63330581 ORDER BY `unit` DESC [ RunTime:0.030857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63330581 LIMIT 2 [ RunTime:0.021588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330581 ORDER BY `minOrder` ASC [ RunTime:0.023222s ]
select * from pdf where partno='20025129-80' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.030058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025129-80' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.035537s ]
SELECT `id` FROM `stock` WHERE `id` <> 63330581 AND `partno` = '20025129-80' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.050523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256542 [ RunTime:0.054978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63330684 LIMIT 5 [ RunTime:0.024816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330684 ORDER BY `minOrder` ASC [ RunTime:0.025456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63330684 ORDER BY `unit` DESC [ RunTime:0.026418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63330684 LIMIT 2 [ RunTime:0.033119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330684 ORDER BY `minOrder` ASC [ RunTime:0.008598s ]
select * from pdf where partno='20025127-80' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.020476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025127-80' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.019489s ]
SELECT `id` FROM `stock` WHERE `id` <> 63330684 AND `partno` = '20025127-80' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.008643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256538 [ RunTime:0.033694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63330687 LIMIT 5 [ RunTime:0.005682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330687 ORDER BY `minOrder` ASC [ RunTime:0.022327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63330687 ORDER BY `unit` DESC [ RunTime:0.048249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63330687 LIMIT 2 [ RunTime:0.027612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330687 ORDER BY `minOrder` ASC [ RunTime:0.005705s ]
select * from pdf where partno='20025129-90' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.040885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025129-90' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.008146s ]
SELECT `id` FROM `stock` WHERE `id` <> 63330687 AND `partno` = '20025129-90' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.030240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373031 [ RunTime:0.041691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63330685 LIMIT 5 [ RunTime:0.047518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330685 ORDER BY `minOrder` ASC [ RunTime:0.047190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63330685 ORDER BY `unit` DESC [ RunTime:0.032121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63330685 LIMIT 2 [ RunTime:0.041048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63330685 ORDER BY `minOrder` ASC [ RunTime:0.006615s ]
select * from pdf where partno='20025127-90' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.055682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025127-90' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.019405s ]
SELECT `id` FROM `stock` WHERE `id` <> 63330685 AND `partno` = '20025127-90' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.026575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256539 [ RunTime:0.031014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64725999 LIMIT 5 [ RunTime:0.041324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725999 ORDER BY `minOrder` ASC [ RunTime:0.092903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64725999 ORDER BY `unit` DESC [ RunTime:0.023270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64725999 LIMIT 2 [ RunTime:0.038432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725999 ORDER BY `minOrder` ASC [ RunTime:0.044960s ]
select * from pdf where partno='20025154-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.018342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025154-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.013006s ]
SELECT `id` FROM `stock` WHERE `id` <> 64725999 AND `partno` = '20025154-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.034094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64630492 LIMIT 5 [ RunTime:0.006282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630492 ORDER BY `minOrder` ASC [ RunTime:0.056902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64630492 ORDER BY `unit` DESC [ RunTime:0.045788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64630492 LIMIT 2 [ RunTime:0.035415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630492 ORDER BY `minOrder` ASC [ RunTime:0.010597s ]
select * from pdf where partno='20025238-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.021119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025238-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.028517s ]
SELECT `id` FROM `stock` WHERE `id` <> 64630492 AND `partno` = '20025238-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.047544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64630479 LIMIT 5 [ RunTime:0.028476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630479 ORDER BY `minOrder` ASC [ RunTime:0.037891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64630479 ORDER BY `unit` DESC [ RunTime:0.026534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64630479 LIMIT 2 [ RunTime:0.042354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630479 ORDER BY `minOrder` ASC [ RunTime:0.015812s ]
select * from pdf where partno='20025239-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.009131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025239-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.023482s ]
SELECT `id` FROM `stock` WHERE `id` <> 64630479 AND `partno` = '20025239-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.012860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64630402 LIMIT 5 [ RunTime:0.054740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630402 ORDER BY `minOrder` ASC [ RunTime:0.017024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64630402 ORDER BY `unit` DESC [ RunTime:0.041929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64630402 LIMIT 2 [ RunTime:0.021826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630402 ORDER BY `minOrder` ASC [ RunTime:0.012360s ]
select * from pdf where partno='20025240-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.015135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025240-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.017433s ]
SELECT `id` FROM `stock` WHERE `id` <> 64630402 AND `partno` = '20025240-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.030450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64630194 LIMIT 5 [ RunTime:0.018360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630194 ORDER BY `minOrder` ASC [ RunTime:0.015769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64630194 ORDER BY `unit` DESC [ RunTime:0.019549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64630194 LIMIT 2 [ RunTime:0.048723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64630194 ORDER BY `minOrder` ASC [ RunTime:0.013374s ]
select * from pdf where partno='20025173-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.006762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025173-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.028138s ]
SELECT `id` FROM `stock` WHERE `id` <> 64630194 AND `partno` = '20025173-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.030637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63297321 LIMIT 5 [ RunTime:0.006798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63297321 ORDER BY `minOrder` ASC [ RunTime:0.022674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63297321 ORDER BY `unit` DESC [ RunTime:0.063891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63297321 LIMIT 2 [ RunTime:0.031092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63297321 ORDER BY `minOrder` ASC [ RunTime:0.017642s ]
select * from pdf where partno='20025700-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.015076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025700-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.023470s ]
SELECT `id` FROM `stock` WHERE `id` <> 63297321 AND `partno` = '20025700-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.014105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63295672 LIMIT 5 [ RunTime:0.012698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295672 ORDER BY `minOrder` ASC [ RunTime:0.014150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63295672 ORDER BY `unit` DESC [ RunTime:0.033851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63295672 LIMIT 2 [ RunTime:0.041654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63295672 ORDER BY `minOrder` ASC [ RunTime:0.031433s ]
select * from pdf where partno='20025413-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.018041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025413-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.026188s ]
SELECT `id` FROM `stock` WHERE `id` <> 63295672 AND `partno` = '20025413-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.042740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63290928 LIMIT 5 [ RunTime:0.015701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63290928 ORDER BY `minOrder` ASC [ RunTime:0.015733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63290928 ORDER BY `unit` DESC [ RunTime:0.018368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63290928 LIMIT 2 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63290928 ORDER BY `minOrder` ASC [ RunTime:0.026662s ]
select * from pdf where partno='20025823-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.006938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025823-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.029887s ]
SELECT `id` FROM `stock` WHERE `id` <> 63290928 AND `partno` = '20025823-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.023393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63290893 LIMIT 5 [ RunTime:0.005984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63290893 ORDER BY `minOrder` ASC [ RunTime:0.034618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63290893 ORDER BY `unit` DESC [ RunTime:0.029915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63290893 LIMIT 2 [ RunTime:0.011877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63290893 ORDER BY `minOrder` ASC [ RunTime:0.014534s ]
select * from pdf where partno='20025181-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.038877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025181-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.038815s ]
SELECT `id` FROM `stock` WHERE `id` <> 63290893 AND `partno` = '20025181-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.020127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20081320 [ RunTime:0.007475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63290845 LIMIT 5 [ RunTime:0.021113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63290845 ORDER BY `minOrder` ASC [ RunTime:0.043986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63290845 ORDER BY `unit` DESC [ RunTime:0.019744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63290845 LIMIT 2 [ RunTime:0.063197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63290845 ORDER BY `minOrder` ASC [ RunTime:0.055454s ]
select * from pdf where partno='20025166-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.073637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025166-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.068674s ]
SELECT `id` FROM `stock` WHERE `id` <> 63290845 AND `partno` = '20025166-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.039193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63276587 LIMIT 5 [ RunTime:0.055862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63276587 ORDER BY `minOrder` ASC [ RunTime:0.030355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63276587 ORDER BY `unit` DESC [ RunTime:0.054250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63276587 LIMIT 2 [ RunTime:0.007246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63276587 ORDER BY `minOrder` ASC [ RunTime:0.015679s ]
select * from pdf where partno='20025214-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.043313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025214-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.018225s ]
SELECT `id` FROM `stock` WHERE `id` <> 63276587 AND `partno` = '20025214-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.035446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17142351 [ RunTime:0.043216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63269957 LIMIT 5 [ RunTime:0.031558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269957 ORDER BY `minOrder` ASC [ RunTime:0.036332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63269957 ORDER BY `unit` DESC [ RunTime:0.036687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63269957 LIMIT 2 [ RunTime:0.032775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269957 ORDER BY `minOrder` ASC [ RunTime:0.010620s ]
select * from pdf where partno='20025022-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.028789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025022-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.034512s ]
SELECT `id` FROM `stock` WHERE `id` <> 63269957 AND `partno` = '20025022-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.050821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63269726 LIMIT 5 [ RunTime:0.049573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269726 ORDER BY `minOrder` ASC [ RunTime:0.053384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63269726 ORDER BY `unit` DESC [ RunTime:0.020254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63269726 LIMIT 2 [ RunTime:0.002754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269726 ORDER BY `minOrder` ASC [ RunTime:0.019035s ]
select * from pdf where partno='20025069-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.031332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025069-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.024211s ]
SELECT `id` FROM `stock` WHERE `id` <> 63269726 AND `partno` = '20025069-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.016111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63269410 LIMIT 5 [ RunTime:0.083566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269410 ORDER BY `minOrder` ASC [ RunTime:0.042433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63269410 ORDER BY `unit` DESC [ RunTime:0.047633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63269410 LIMIT 2 [ RunTime:0.033656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269410 ORDER BY `minOrder` ASC [ RunTime:0.008601s ]
select * from pdf where partno='20025710-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.033586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025710-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.024886s ]
SELECT `id` FROM `stock` WHERE `id` <> 63269410 AND `partno` = '20025710-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.026739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12077590 [ RunTime:0.019204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63269170 LIMIT 5 [ RunTime:0.022106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269170 ORDER BY `minOrder` ASC [ RunTime:0.048515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63269170 ORDER BY `unit` DESC [ RunTime:0.051493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63269170 LIMIT 2 [ RunTime:0.011060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269170 ORDER BY `minOrder` ASC [ RunTime:0.035756s ]
select * from pdf where partno='20025655-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.008836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20025655-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.038259s ]
SELECT `id` FROM `stock` WHERE `id` <> 63269170 AND `partno` = '20025655-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.024513s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069379s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039045s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020988s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054536s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023394s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098509s ]
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 '20025%' OR `brand` LIKE '20025%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058379s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20025%' OR `brand` LIKE '20025%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041512s ]