SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002224s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=226&srecordnum=7529' [ RunTime:0.014284s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001380s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003000s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001921s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.001350s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001378s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000291s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001442s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000708s ]
UPDATE `stock_search` SET `count` = 5626 , `updatetime` = '2026-06-08 22:55:39' WHERE `partno` = '210' [ RunTime:0.009273s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004972s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000874s ]
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.012677s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001953s ]
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.007044s ]
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 4500,20 [ RunTime:0.112858s ]
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 ('34282229','34282077','34282052','34281986','34281975','34281953','34281938','34281915','34281124','34281113','34281081','34281053','34281032','34281020','34280997','34280150','34280128','34279453','34278895','34278610') ORDER BY FIELD(s.id, 34282229,34282077,34282052,34281986,34281975,34281953,34281938,34281915,34281124,34281113,34281081,34281053,34281032,34281020,34280997,34280150,34280128,34279453,34278895,34278610) [ RunTime:0.030143s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34282229 LIMIT 4 [ RunTime:0.025188s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282229 ORDER BY `minOrder` ASC [ RunTime:0.014534s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34282229 ORDER BY `unit` DESC [ RunTime:0.012576s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34282229 LIMIT 2 [ RunTime:0.014370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282229 ORDER BY `minOrder` ASC [ RunTime:0.004230s ]
select * from pdf where partno='2102446-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005740s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102446-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.011706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34282077 LIMIT 4 [ RunTime:0.013467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282077 ORDER BY `minOrder` ASC [ RunTime:0.003930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34282077 ORDER BY `unit` DESC [ RunTime:0.015655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34282077 LIMIT 2 [ RunTime:0.011706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282077 ORDER BY `minOrder` ASC [ RunTime:0.011930s ]
select * from pdf where partno='2102092-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.012950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102092-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34282052 LIMIT 4 [ RunTime:0.005347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282052 ORDER BY `minOrder` ASC [ RunTime:0.015557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34282052 ORDER BY `unit` DESC [ RunTime:0.046098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34282052 LIMIT 2 [ RunTime:0.009906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282052 ORDER BY `minOrder` ASC [ RunTime:0.002263s ]
select * from pdf where partno='2102737-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.009660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102737-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.023043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281986 LIMIT 4 [ RunTime:0.034732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281986 ORDER BY `minOrder` ASC [ RunTime:0.002173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281986 ORDER BY `unit` DESC [ RunTime:0.008948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281986 LIMIT 2 [ RunTime:0.038443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281986 ORDER BY `minOrder` ASC [ RunTime:0.027197s ]
select * from pdf where partno='2102247-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102247-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.018101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281975 LIMIT 4 [ RunTime:0.021770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281975 ORDER BY `minOrder` ASC [ RunTime:0.027083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281975 ORDER BY `unit` DESC [ RunTime:0.028075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281975 LIMIT 2 [ RunTime:0.010587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281975 ORDER BY `minOrder` ASC [ RunTime:0.003466s ]
select * from pdf where partno='2102096-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.021542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102096-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.021078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281953 LIMIT 4 [ RunTime:0.012626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281953 ORDER BY `minOrder` ASC [ RunTime:0.021907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281953 ORDER BY `unit` DESC [ RunTime:0.032261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281953 LIMIT 2 [ RunTime:0.030639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281953 ORDER BY `minOrder` ASC [ RunTime:0.005494s ]
select * from pdf where partno='2102774-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.014413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102774-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.020724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281938 LIMIT 4 [ RunTime:0.022231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281938 ORDER BY `minOrder` ASC [ RunTime:0.032456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281938 ORDER BY `unit` DESC [ RunTime:0.013749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281938 LIMIT 2 [ RunTime:0.025677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281938 ORDER BY `minOrder` ASC [ RunTime:0.017308s ]
select * from pdf where partno='2102098-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.048561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102098-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281915 LIMIT 4 [ RunTime:0.029002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281915 ORDER BY `minOrder` ASC [ RunTime:0.016167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281915 ORDER BY `unit` DESC [ RunTime:0.037317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281915 LIMIT 2 [ RunTime:0.056990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281915 ORDER BY `minOrder` ASC [ RunTime:0.014505s ]
select * from pdf where partno='2102768-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.040976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102768-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.039454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281124 LIMIT 4 [ RunTime:0.024757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281124 ORDER BY `minOrder` ASC [ RunTime:0.019835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281124 ORDER BY `unit` DESC [ RunTime:0.088575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281124 LIMIT 2 [ RunTime:0.031421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281124 ORDER BY `minOrder` ASC [ RunTime:0.004394s ]
select * from pdf where partno='2102247-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.043677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102247-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.003826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281113 LIMIT 4 [ RunTime:0.010801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281113 ORDER BY `minOrder` ASC [ RunTime:0.011153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281113 ORDER BY `unit` DESC [ RunTime:0.015765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281113 LIMIT 2 [ RunTime:0.012254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281113 ORDER BY `minOrder` ASC [ RunTime:0.003014s ]
select * from pdf where partno='2102316-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.024330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102316-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.028297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281081 LIMIT 4 [ RunTime:0.026674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281081 ORDER BY `minOrder` ASC [ RunTime:0.026406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281081 ORDER BY `unit` DESC [ RunTime:0.043254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281081 LIMIT 2 [ RunTime:0.026157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281081 ORDER BY `minOrder` ASC [ RunTime:0.006141s ]
select * from pdf where partno='2102155-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.034505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102155-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.026335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281053 LIMIT 4 [ RunTime:0.020256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281053 ORDER BY `minOrder` ASC [ RunTime:0.015422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281053 ORDER BY `unit` DESC [ RunTime:0.028101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281053 LIMIT 2 [ RunTime:0.019047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281053 ORDER BY `minOrder` ASC [ RunTime:0.025791s ]
select * from pdf where partno='2102775-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.006758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102775-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.008997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281032 LIMIT 4 [ RunTime:0.012326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281032 ORDER BY `minOrder` ASC [ RunTime:0.031397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281032 ORDER BY `unit` DESC [ RunTime:0.031015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281032 LIMIT 2 [ RunTime:0.018918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281032 ORDER BY `minOrder` ASC [ RunTime:0.012615s ]
select * from pdf where partno='2102157-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102157-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281020 LIMIT 4 [ RunTime:0.039324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281020 ORDER BY `minOrder` ASC [ RunTime:0.034693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281020 ORDER BY `unit` DESC [ RunTime:0.034571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281020 LIMIT 2 [ RunTime:0.025675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281020 ORDER BY `minOrder` ASC [ RunTime:0.011040s ]
select * from pdf where partno='2102317-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102317-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.021582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280997 LIMIT 4 [ RunTime:0.006616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280997 ORDER BY `minOrder` ASC [ RunTime:0.022266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280997 ORDER BY `unit` DESC [ RunTime:0.030922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280997 LIMIT 2 [ RunTime:0.019150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280997 ORDER BY `minOrder` ASC [ RunTime:0.006500s ]
select * from pdf where partno='2102851-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102851-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.011016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280150 LIMIT 4 [ RunTime:0.015416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280150 ORDER BY `minOrder` ASC [ RunTime:0.027318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280150 ORDER BY `unit` DESC [ RunTime:0.030518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280150 LIMIT 2 [ RunTime:0.018661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280150 ORDER BY `minOrder` ASC [ RunTime:0.020495s ]
select * from pdf where partno='2102159-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.015538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102159-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.039717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280128 LIMIT 4 [ RunTime:0.029704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280128 ORDER BY `minOrder` ASC [ RunTime:0.022097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280128 ORDER BY `unit` DESC [ RunTime:0.010883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280128 LIMIT 2 [ RunTime:0.019085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280128 ORDER BY `minOrder` ASC [ RunTime:0.000934s ]
select * from pdf where partno='2102318-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102318-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.018253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34279453 LIMIT 4 [ RunTime:0.010414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279453 ORDER BY `minOrder` ASC [ RunTime:0.021687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34279453 ORDER BY `unit` DESC [ RunTime:0.024774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34279453 LIMIT 2 [ RunTime:0.044821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279453 ORDER BY `minOrder` ASC [ RunTime:0.017360s ]
select * from pdf where partno='2102771-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.009793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102771-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278895 LIMIT 4 [ RunTime:0.062332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278895 ORDER BY `minOrder` ASC [ RunTime:0.054242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278895 ORDER BY `unit` DESC [ RunTime:0.027677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278895 LIMIT 2 [ RunTime:0.029313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278895 ORDER BY `minOrder` ASC [ RunTime:0.063483s ]
select * from pdf where partno='2102272-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.025969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102272-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278610 LIMIT 4 [ RunTime:0.035300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278610 ORDER BY `minOrder` ASC [ RunTime:0.066920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278610 ORDER BY `unit` DESC [ RunTime:0.037408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278610 LIMIT 2 [ RunTime:0.019099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278610 ORDER BY `minOrder` ASC [ RunTime:0.005491s ]
select * from pdf where partno='2102737-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.041265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102737-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017939s ]
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.017374s ]