SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001470s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.003417s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001342s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002290s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002702s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002504s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003283s ]
UPDATE `stock_search` SET `count` = 2248 , `updatetime` = '2026-06-07 00:04:28' WHERE `partno` = '210' [ RunTime:0.008127s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001468s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000334s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002612s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.000358s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 2440,20 [ RunTime:0.082489s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('34281020','34280997','34280150','34280128','34279453','34278895','34278610','34278378','33886954','33886951','33886950','33886948','33886939','33884453','33860820','33860806','33860785','33860757','33860755','33860743') ORDER BY FIELD(s.id, 34281020,34280997,34280150,34280128,34279453,34278895,34278610,34278378,33886954,33886951,33886950,33886948,33886939,33884453,33860820,33860806,33860785,33860757,33860755,33860743) [ RunTime:0.022892s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281020 LIMIT 4 [ RunTime:0.018790s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281020 ORDER BY `minOrder` ASC [ RunTime:0.007556s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281020 ORDER BY `unit` DESC [ RunTime:0.018608s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281020 LIMIT 2 [ RunTime:0.027765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281020 ORDER BY `minOrder` ASC [ RunTime:0.015660s ]
select * from pdf where partno='2102317-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.023935s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102317-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.028766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280997 LIMIT 4 [ RunTime:0.020335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280997 ORDER BY `minOrder` ASC [ RunTime:0.059540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280997 ORDER BY `unit` DESC [ RunTime:0.067781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280997 LIMIT 2 [ RunTime:0.049663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280997 ORDER BY `minOrder` ASC [ RunTime:0.006478s ]
select * from pdf where partno='2102851-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.088247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102851-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280150 LIMIT 4 [ RunTime:0.012776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280150 ORDER BY `minOrder` ASC [ RunTime:0.038164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280150 ORDER BY `unit` DESC [ RunTime:0.014863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280150 LIMIT 2 [ RunTime:0.025592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280150 ORDER BY `minOrder` ASC [ RunTime:0.007298s ]
select * from pdf where partno='2102159-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.012194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102159-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280128 LIMIT 4 [ RunTime:0.008838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280128 ORDER BY `minOrder` ASC [ RunTime:0.032506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280128 ORDER BY `unit` DESC [ RunTime:0.056251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280128 LIMIT 2 [ RunTime:0.046540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280128 ORDER BY `minOrder` ASC [ RunTime:0.043510s ]
select * from pdf where partno='2102318-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102318-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.059194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34279453 LIMIT 4 [ RunTime:0.064866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279453 ORDER BY `minOrder` ASC [ RunTime:0.021157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34279453 ORDER BY `unit` DESC [ RunTime:0.103982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34279453 LIMIT 2 [ RunTime:0.015121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279453 ORDER BY `minOrder` ASC [ RunTime:0.082684s ]
select * from pdf where partno='2102771-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.043458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102771-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.055262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278895 LIMIT 4 [ RunTime:0.071374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278895 ORDER BY `minOrder` ASC [ RunTime:0.109814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278895 ORDER BY `unit` DESC [ RunTime:0.041512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278895 LIMIT 2 [ RunTime:0.009265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278895 ORDER BY `minOrder` ASC [ RunTime:0.018064s ]
select * from pdf where partno='2102272-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.015950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102272-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.018941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278610 LIMIT 4 [ RunTime:0.045358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278610 ORDER BY `minOrder` ASC [ RunTime:0.042134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278610 ORDER BY `unit` DESC [ RunTime:0.084548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278610 LIMIT 2 [ RunTime:0.062793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278610 ORDER BY `minOrder` ASC [ RunTime:0.029473s ]
select * from pdf where partno='2102737-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.024080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102737-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.054761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278378 LIMIT 4 [ RunTime:0.088192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278378 ORDER BY `minOrder` ASC [ RunTime:0.075982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278378 ORDER BY `unit` DESC [ RunTime:0.111443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278378 LIMIT 2 [ RunTime:0.050807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278378 ORDER BY `minOrder` ASC [ RunTime:0.015495s ]
select * from pdf where partno='2102735-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.069448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102735-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.044838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886954 LIMIT 4 [ RunTime:0.070884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886954 ORDER BY `minOrder` ASC [ RunTime:0.134492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886954 ORDER BY `unit` DESC [ RunTime:0.058467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886954 LIMIT 2 [ RunTime:0.063947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886954 ORDER BY `minOrder` ASC [ RunTime:0.016633s ]
select * from pdf where partno='2102573-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.021593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102573-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.021312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886951 LIMIT 4 [ RunTime:0.045781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.049758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886951 ORDER BY `unit` DESC [ RunTime:0.007075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886951 LIMIT 2 [ RunTime:0.022146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886951 ORDER BY `minOrder` ASC [ RunTime:0.035298s ]
select * from pdf where partno='2102582-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.022572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102582-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.033913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886950 LIMIT 4 [ RunTime:0.029474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.038346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886950 ORDER BY `unit` DESC [ RunTime:0.022323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886950 LIMIT 2 [ RunTime:0.011713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886950 ORDER BY `minOrder` ASC [ RunTime:0.004290s ]
select * from pdf where partno='2102575-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102575-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.003652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886948 LIMIT 4 [ RunTime:0.031727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.035875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886948 ORDER BY `unit` DESC [ RunTime:0.052228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886948 LIMIT 2 [ RunTime:0.058221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886948 ORDER BY `minOrder` ASC [ RunTime:0.047856s ]
select * from pdf where partno='2102579-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.017361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102579-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.013430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886939 LIMIT 4 [ RunTime:0.106861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.090430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886939 ORDER BY `unit` DESC [ RunTime:0.047541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886939 LIMIT 2 [ RunTime:0.040809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886939 ORDER BY `minOrder` ASC [ RunTime:0.075798s ]
select * from pdf where partno='2102571-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.099076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102571-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.082292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33884453 LIMIT 4 [ RunTime:0.088702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.025715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33884453 ORDER BY `unit` DESC [ RunTime:0.055007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33884453 LIMIT 2 [ RunTime:0.097273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884453 ORDER BY `minOrder` ASC [ RunTime:0.027370s ]
select * from pdf where partno='2102572-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.034931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102572-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.033679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860820 LIMIT 4 [ RunTime:0.164157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.066923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860820 ORDER BY `unit` DESC [ RunTime:0.039178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860820 LIMIT 2 [ RunTime:0.062333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860820 ORDER BY `minOrder` ASC [ RunTime:0.058868s ]
select * from pdf where partno='2101253-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101253-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.089181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860806 LIMIT 4 [ RunTime:0.077465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.171933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860806 ORDER BY `unit` DESC [ RunTime:0.044975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860806 LIMIT 2 [ RunTime:0.023629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860806 ORDER BY `minOrder` ASC [ RunTime:0.007947s ]
select * from pdf where partno='2101927-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.021511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101927-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860785 LIMIT 4 [ RunTime:0.025344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.084079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860785 ORDER BY `unit` DESC [ RunTime:0.039134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860785 LIMIT 2 [ RunTime:0.039424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860785 ORDER BY `minOrder` ASC [ RunTime:0.021316s ]
select * from pdf where partno='2101423-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.075056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101423-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.066683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860757 LIMIT 4 [ RunTime:0.021153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.050389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860757 ORDER BY `unit` DESC [ RunTime:0.039402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860757 LIMIT 2 [ RunTime:0.099204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860757 ORDER BY `minOrder` ASC [ RunTime:0.038965s ]
select * from pdf where partno='2101650-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.084595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101650-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.043566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860755 LIMIT 4 [ RunTime:0.049219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.062789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860755 ORDER BY `unit` DESC [ RunTime:0.029943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860755 LIMIT 2 [ RunTime:0.043379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860755 ORDER BY `minOrder` ASC [ RunTime:0.050124s ]
select * from pdf where partno='2101598-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.021664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101598-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.035068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33860743 LIMIT 4 [ RunTime:0.021114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.039046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33860743 ORDER BY `unit` DESC [ RunTime:0.058144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33860743 LIMIT 2 [ RunTime:0.040525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33860743 ORDER BY `minOrder` ASC [ RunTime:0.025366s ]
select * from pdf where partno='2101252-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101252-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.055961s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.017783s ]