SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001763s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008697s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002312s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.001156s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003559s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001022s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002258s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.006077s ]
UPDATE `stock_search` SET `count` = 105 , `updatetime` = '2026-06-04 19:28:50' WHERE `partno` = '210' [ RunTime:0.002591s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002475s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000996s ]
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.000850s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001315s ]
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.001331s ]
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 180,20 [ RunTime:0.027350s ]
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 ('12630618','19668462','17298226','32303982','32295948','32304158','32296035','11985751','32304207','32296083','32303978','32295945','12632755','32304340','32296204','12632757','13258707','32184709','32304853','32296631') ORDER BY FIELD(s.id, 12630618,19668462,17298226,32303982,32295948,32304158,32296035,11985751,32304207,32296083,32303978,32295945,12632755,32304340,32296204,12632757,13258707,32184709,32304853,32296631) [ RunTime:0.008798s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630618 LIMIT 4 [ RunTime:0.009296s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630618 ORDER BY `minOrder` ASC [ RunTime:0.005356s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630618 ORDER BY `unit` DESC [ RunTime:0.007567s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630618 LIMIT 2 [ RunTime:0.007890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630618 ORDER BY `minOrder` ASC [ RunTime:0.002186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668462 LIMIT 4 [ RunTime:0.006585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668462 ORDER BY `minOrder` ASC [ RunTime:0.013917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668462 ORDER BY `unit` DESC [ RunTime:0.008160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668462 LIMIT 2 [ RunTime:0.003203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668462 ORDER BY `minOrder` ASC [ RunTime:0.005222s ]
select * from pdf where partno='2106111-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298226 LIMIT 4 [ RunTime:0.006339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298226 ORDER BY `minOrder` ASC [ RunTime:0.008331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298226 ORDER BY `unit` DESC [ RunTime:0.004178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298226 LIMIT 2 [ RunTime:0.008118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298226 ORDER BY `minOrder` ASC [ RunTime:0.002491s ]
select * from pdf where partno='21011009019' and brandshort='HARTING' limit 1 [ RunTime:0.010530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32303982 LIMIT 4 [ RunTime:0.010573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303982 ORDER BY `minOrder` ASC [ RunTime:0.002202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32303982 ORDER BY `unit` DESC [ RunTime:0.004442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32303982 LIMIT 2 [ RunTime:0.005272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303982 ORDER BY `minOrder` ASC [ RunTime:0.003475s ]
select * from pdf where partno='2108965-6' and brandshort='te connectivity' limit 1 [ RunTime:0.007961s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32295948 LIMIT 4 [ RunTime:0.004452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295948 ORDER BY `minOrder` ASC [ RunTime:0.005473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32295948 ORDER BY `unit` DESC [ RunTime:0.006061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32295948 LIMIT 2 [ RunTime:0.004996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295948 ORDER BY `minOrder` ASC [ RunTime:0.001746s ]
select * from pdf where partno='2108965-6' and brandshort='te connectivity' limit 1 [ RunTime:0.003444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.002859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304158 LIMIT 4 [ RunTime:0.009129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304158 ORDER BY `minOrder` ASC [ RunTime:0.010461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304158 ORDER BY `unit` DESC [ RunTime:0.006711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304158 LIMIT 2 [ RunTime:0.001925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304158 ORDER BY `minOrder` ASC [ RunTime:0.002092s ]
select * from pdf where partno='2108965-2' and brandshort='te connectivity' limit 1 [ RunTime:0.012373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.029136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296035 LIMIT 4 [ RunTime:0.013979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296035 ORDER BY `minOrder` ASC [ RunTime:0.006316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296035 ORDER BY `unit` DESC [ RunTime:0.005571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296035 LIMIT 2 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296035 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='2108965-2' and brandshort='te connectivity' limit 1 [ RunTime:0.002318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.002625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985751 LIMIT 4 [ RunTime:0.004467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985751 ORDER BY `minOrder` ASC [ RunTime:0.007606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985751 ORDER BY `unit` DESC [ RunTime:0.008673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985751 LIMIT 2 [ RunTime:0.003338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985751 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304207 LIMIT 4 [ RunTime:0.002721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304207 ORDER BY `minOrder` ASC [ RunTime:0.005368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304207 ORDER BY `unit` DESC [ RunTime:0.003995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304207 LIMIT 2 [ RunTime:0.006152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304207 ORDER BY `minOrder` ASC [ RunTime:0.002163s ]
select * from pdf where partno='2108971-2' and brandshort='te connectivity' limit 1 [ RunTime:0.003115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296083 LIMIT 4 [ RunTime:0.005591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296083 ORDER BY `minOrder` ASC [ RunTime:0.001276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296083 ORDER BY `unit` DESC [ RunTime:0.004336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296083 LIMIT 2 [ RunTime:0.005635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296083 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
select * from pdf where partno='2108971-2' and brandshort='te connectivity' limit 1 [ RunTime:0.004122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108971-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.001622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32303978 LIMIT 4 [ RunTime:0.003209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303978 ORDER BY `minOrder` ASC [ RunTime:0.003362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32303978 ORDER BY `unit` DESC [ RunTime:0.000853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32303978 LIMIT 2 [ RunTime:0.005059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303978 ORDER BY `minOrder` ASC [ RunTime:0.004267s ]
select * from pdf where partno='2108965-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.026601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32295945 LIMIT 4 [ RunTime:0.002646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295945 ORDER BY `minOrder` ASC [ RunTime:0.004503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32295945 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32295945 LIMIT 2 [ RunTime:0.002000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295945 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='2108965-1' and brandshort='te connectivity' limit 1 [ RunTime:0.000386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108965-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.003945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12632755 LIMIT 4 [ RunTime:0.005423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12632755 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12632755 ORDER BY `unit` DESC [ RunTime:0.005699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12632755 LIMIT 2 [ RunTime:0.002181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12632755 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='2106489-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304340 LIMIT 4 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304340 ORDER BY `minOrder` ASC [ RunTime:0.001145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304340 ORDER BY `unit` DESC [ RunTime:0.003444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304340 LIMIT 2 [ RunTime:0.002542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304340 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='2108857-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108857-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.013122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296204 LIMIT 4 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296204 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296204 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296204 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296204 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='2108857-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108857-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12632757 LIMIT 4 [ RunTime:0.002434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12632757 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12632757 ORDER BY `unit` DESC [ RunTime:0.000955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12632757 LIMIT 2 [ RunTime:0.005173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12632757 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='2106431-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258707 LIMIT 4 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258707 ORDER BY `minOrder` ASC [ RunTime:0.002315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258707 ORDER BY `unit` DESC [ RunTime:0.003954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258707 LIMIT 2 [ RunTime:0.001025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258707 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32184709 LIMIT 4 [ RunTime:0.002299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32184709 ORDER BY `minOrder` ASC [ RunTime:0.002143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32184709 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32184709 LIMIT 2 [ RunTime:0.007338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32184709 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='21045-6' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.002394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21045-6' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304853 LIMIT 4 [ RunTime:0.001700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304853 ORDER BY `minOrder` ASC [ RunTime:0.001379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304853 ORDER BY `unit` DESC [ RunTime:0.001994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304853 LIMIT 2 [ RunTime:0.003370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304853 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='2108832-1' and brandshort='te connectivity' limit 1 [ RunTime:0.002165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108832-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.013357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296631 LIMIT 4 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296631 ORDER BY `minOrder` ASC [ RunTime:0.003089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296631 ORDER BY `unit` DESC [ RunTime:0.005317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296631 LIMIT 2 [ RunTime:0.002567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296631 ORDER BY `minOrder` ASC [ RunTime:0.003576s ]
select * from pdf where partno='2108832-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108832-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000295s ]
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.000315s ]