SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002342s ]
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.003357s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003350s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002691s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000382s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002429s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002981s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002124s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000694s ]
UPDATE `stock_search` SET `count` = 1974 , `updatetime` = '2026-06-06 21:06:40' WHERE `partno` = '210' [ RunTime:0.005031s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.009356s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005768s ]
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.002007s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002844s ]
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.120052s ]
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 2420,20 [ RunTime:0.066628s ]
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 ('34282052','34281986','34281975','34281953','34281938','34281915','34281124','34281113','34281081','34281053','34281032','34281020','34280997','34280150','34280128','34279453','34278895','34278610','34278378','33886954') ORDER BY FIELD(s.id, 34282052,34281986,34281975,34281953,34281938,34281915,34281124,34281113,34281081,34281053,34281032,34281020,34280997,34280150,34280128,34279453,34278895,34278610,34278378,33886954) [ RunTime:0.012606s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34282052 LIMIT 4 [ RunTime:0.002512s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282052 ORDER BY `minOrder` ASC [ RunTime:0.017966s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34282052 ORDER BY `unit` DESC [ RunTime:0.002048s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34282052 LIMIT 2 [ RunTime:0.011757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34282052 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
select * from pdf where partno='2102737-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020041s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102737-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.020557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281986 LIMIT 4 [ RunTime:0.004167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281986 ORDER BY `minOrder` ASC [ RunTime:0.015010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281986 ORDER BY `unit` DESC [ RunTime:0.005779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281986 LIMIT 2 [ RunTime:0.026610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281986 ORDER BY `minOrder` ASC [ RunTime:0.006202s ]
select * from pdf where partno='2102247-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.009630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102247-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.015541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281975 LIMIT 4 [ RunTime:0.025170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281975 ORDER BY `minOrder` ASC [ RunTime:0.013988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281975 ORDER BY `unit` DESC [ RunTime:0.024371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281975 LIMIT 2 [ RunTime:0.011472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281975 ORDER BY `minOrder` ASC [ RunTime:0.010572s ]
select * from pdf where partno='2102096-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.043231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102096-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.043901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281953 LIMIT 4 [ RunTime:0.027514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281953 ORDER BY `minOrder` ASC [ RunTime:0.037062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281953 ORDER BY `unit` DESC [ RunTime:0.088192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281953 LIMIT 2 [ RunTime:0.013903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281953 ORDER BY `minOrder` ASC [ RunTime:0.008105s ]
select * from pdf where partno='2102774-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.034847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102774-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.045428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281938 LIMIT 4 [ RunTime:0.050531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281938 ORDER BY `minOrder` ASC [ RunTime:0.041531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281938 ORDER BY `unit` DESC [ RunTime:0.011099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281938 LIMIT 2 [ RunTime:0.022493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281938 ORDER BY `minOrder` ASC [ RunTime:0.036022s ]
select * from pdf where partno='2102098-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.024309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102098-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.054625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281915 LIMIT 4 [ RunTime:0.046821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281915 ORDER BY `minOrder` ASC [ RunTime:0.025918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281915 ORDER BY `unit` DESC [ RunTime:0.019108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281915 LIMIT 2 [ RunTime:0.034734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281915 ORDER BY `minOrder` ASC [ RunTime:0.020830s ]
select * from pdf where partno='2102768-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.072480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102768-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.028104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281124 LIMIT 4 [ RunTime:0.031106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281124 ORDER BY `minOrder` ASC [ RunTime:0.022627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281124 ORDER BY `unit` DESC [ RunTime:0.062620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281124 LIMIT 2 [ RunTime:0.030091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281124 ORDER BY `minOrder` ASC [ RunTime:0.012121s ]
select * from pdf where partno='2102247-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.039866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102247-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281113 LIMIT 4 [ RunTime:0.014271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281113 ORDER BY `minOrder` ASC [ RunTime:0.018241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281113 ORDER BY `unit` DESC [ RunTime:0.027690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281113 LIMIT 2 [ RunTime:0.008437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281113 ORDER BY `minOrder` ASC [ RunTime:0.020278s ]
select * from pdf where partno='2102316-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.021271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102316-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.015605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281081 LIMIT 4 [ RunTime:0.030450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281081 ORDER BY `minOrder` ASC [ RunTime:0.014805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281081 ORDER BY `unit` DESC [ RunTime:0.009912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281081 LIMIT 2 [ RunTime:0.006571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281081 ORDER BY `minOrder` ASC [ RunTime:0.006142s ]
select * from pdf where partno='2102155-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.033200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102155-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281053 LIMIT 4 [ RunTime:0.024452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281053 ORDER BY `minOrder` ASC [ RunTime:0.017449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281053 ORDER BY `unit` DESC [ RunTime:0.020360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281053 LIMIT 2 [ RunTime:0.015149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281053 ORDER BY `minOrder` ASC [ RunTime:0.002805s ]
select * from pdf where partno='2102775-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102775-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.018051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281032 LIMIT 4 [ RunTime:0.042403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281032 ORDER BY `minOrder` ASC [ RunTime:0.017534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281032 ORDER BY `unit` DESC [ RunTime:0.021341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281032 LIMIT 2 [ RunTime:0.014877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281032 ORDER BY `minOrder` ASC [ RunTime:0.006857s ]
select * from pdf where partno='2102157-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.024112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102157-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.021981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34281020 LIMIT 4 [ RunTime:0.025712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281020 ORDER BY `minOrder` ASC [ RunTime:0.019047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34281020 ORDER BY `unit` DESC [ RunTime:0.020509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34281020 LIMIT 2 [ RunTime:0.007582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34281020 ORDER BY `minOrder` ASC [ RunTime:0.000987s ]
select * from pdf where partno='2102317-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.019435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102317-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.030165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280997 LIMIT 4 [ RunTime:0.061010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280997 ORDER BY `minOrder` ASC [ RunTime:0.028783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280997 ORDER BY `unit` DESC [ RunTime:0.008656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280997 LIMIT 2 [ RunTime:0.016582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280997 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='2102851-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.020952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102851-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.041397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280150 LIMIT 4 [ RunTime:0.005166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280150 ORDER BY `minOrder` ASC [ RunTime:0.011681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280150 ORDER BY `unit` DESC [ RunTime:0.016671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280150 LIMIT 2 [ RunTime:0.016013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280150 ORDER BY `minOrder` ASC [ RunTime:0.018593s ]
select * from pdf where partno='2102159-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.009955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102159-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.010708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34280128 LIMIT 4 [ RunTime:0.019656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280128 ORDER BY `minOrder` ASC [ RunTime:0.019786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34280128 ORDER BY `unit` DESC [ RunTime:0.010953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34280128 LIMIT 2 [ RunTime:0.023630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34280128 ORDER BY `minOrder` ASC [ RunTime:0.008970s ]
select * from pdf where partno='2102318-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.021475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102318-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.013475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34279453 LIMIT 4 [ RunTime:0.014185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279453 ORDER BY `minOrder` ASC [ RunTime:0.006083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34279453 ORDER BY `unit` DESC [ RunTime:0.002983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34279453 LIMIT 2 [ RunTime:0.006282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279453 ORDER BY `minOrder` ASC [ RunTime:0.008667s ]
select * from pdf where partno='2102771-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102771-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.001931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278895 LIMIT 4 [ RunTime:0.004110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278895 ORDER BY `minOrder` ASC [ RunTime:0.001498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278895 ORDER BY `unit` DESC [ RunTime:0.006174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278895 LIMIT 2 [ RunTime:0.004964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278895 ORDER BY `minOrder` ASC [ RunTime:0.007666s ]
select * from pdf where partno='2102272-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102272-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.004617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278610 LIMIT 4 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278610 ORDER BY `minOrder` ASC [ RunTime:0.001239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278610 ORDER BY `unit` DESC [ RunTime:0.000735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278610 LIMIT 2 [ RunTime:0.003479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278610 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
select * from pdf where partno='2102737-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.003739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102737-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.007019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34278378 LIMIT 4 [ RunTime:0.013936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278378 ORDER BY `minOrder` ASC [ RunTime:0.001488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34278378 ORDER BY `unit` DESC [ RunTime:0.008700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34278378 LIMIT 2 [ RunTime:0.012776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34278378 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='2102735-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102735-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33886954 LIMIT 4 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886954 ORDER BY `minOrder` ASC [ RunTime:0.001716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33886954 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33886954 LIMIT 2 [ RunTime:0.003223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33886954 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='2102573-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.003837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102573-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000563s ]
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.000430s ]