SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002036s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009083s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002111s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.147' ) [ RunTime:0.003733s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001906s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008483s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001817s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P1200' LIMIT 1 [ RunTime:0.006066s ]
UPDATE `stock_search` SET `count` = 5186 , `updatetime` = '2026-03-02 07:16:00' WHERE `partno` = 'P1200' [ RunTime:0.003081s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000229s ]
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.000419s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002144s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'P1200%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.011550s ]
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 'P1200%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004323s ]
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 ('14796004','13566938','703','16657542','16657498','16657078','16656986','16656985','16656951','16656947','14795880','14795837','14795407','13901204','13901013','13901012','13900954') ORDER BY FIELD(s.id, 14796004,13566938,703,16657542,16657498,16657078,16656986,16656985,16656951,16656947,14795880,14795837,14795407,13901204,13901013,13901012,13900954) [ RunTime:0.015269s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796004 LIMIT 4 [ RunTime:0.011686s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796004 ORDER BY `minOrder` ASC [ RunTime:0.005405s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14796004 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14796004 LIMIT 2 [ RunTime:0.006086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796004 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13566938 LIMIT 4 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13566938 ORDER BY `minOrder` ASC [ RunTime:0.001635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13566938 ORDER BY `unit` DESC [ RunTime:0.001976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13566938 LIMIT 2 [ RunTime:0.008969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13566938 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 703 LIMIT 4 [ RunTime:0.002206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 703 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 703 ORDER BY `unit` DESC [ RunTime:0.005264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 703 LIMIT 2 [ RunTime:0.012368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 703 ORDER BY `minOrder` ASC [ RunTime:0.004946s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P1200' OR `brand` LIKE 'ETAL%' ) ) LIMIT 1 [ RunTime:0.002732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657542 LIMIT 4 [ RunTime:0.009210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657542 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657542 ORDER BY `unit` DESC [ RunTime:0.021966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657542 LIMIT 2 [ RunTime:0.012338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657542 ORDER BY `minOrder` ASC [ RunTime:0.008641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657498 LIMIT 4 [ RunTime:0.005141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657498 ORDER BY `minOrder` ASC [ RunTime:0.007495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657498 ORDER BY `unit` DESC [ RunTime:0.004248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657498 LIMIT 2 [ RunTime:0.008209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657498 ORDER BY `minOrder` ASC [ RunTime:0.013176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657078 LIMIT 4 [ RunTime:0.003671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657078 ORDER BY `minOrder` ASC [ RunTime:0.014959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657078 ORDER BY `unit` DESC [ RunTime:0.008682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657078 LIMIT 2 [ RunTime:0.002358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657078 ORDER BY `minOrder` ASC [ RunTime:0.001805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656986 LIMIT 4 [ RunTime:0.009570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656986 ORDER BY `minOrder` ASC [ RunTime:0.007525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656986 ORDER BY `unit` DESC [ RunTime:0.012209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656986 LIMIT 2 [ RunTime:0.024287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656986 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656985 LIMIT 4 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656985 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656985 ORDER BY `unit` DESC [ RunTime:0.022541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656985 LIMIT 2 [ RunTime:0.010242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656985 ORDER BY `minOrder` ASC [ RunTime:0.009662s ]
select * from pdf where partno='P1200Q12ALRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.011352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656951 LIMIT 4 [ RunTime:0.007407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656951 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656951 ORDER BY `unit` DESC [ RunTime:0.003286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656951 LIMIT 2 [ RunTime:0.007727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656951 ORDER BY `minOrder` ASC [ RunTime:0.011401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16656947 LIMIT 4 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656947 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16656947 ORDER BY `unit` DESC [ RunTime:0.003144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16656947 LIMIT 2 [ RunTime:0.008090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16656947 ORDER BY `minOrder` ASC [ RunTime:0.004149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14795880 LIMIT 4 [ RunTime:0.001865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795880 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14795880 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14795880 LIMIT 2 [ RunTime:0.003158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795880 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14795837 LIMIT 4 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795837 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14795837 ORDER BY `unit` DESC [ RunTime:0.000510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14795837 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795837 ORDER BY `minOrder` ASC [ RunTime:0.008578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14795407 LIMIT 4 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795407 ORDER BY `minOrder` ASC [ RunTime:0.011350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14795407 ORDER BY `unit` DESC [ RunTime:0.001854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14795407 LIMIT 2 [ RunTime:0.008531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14795407 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901204 LIMIT 4 [ RunTime:0.001327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901204 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901204 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901204 LIMIT 2 [ RunTime:0.002657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901204 ORDER BY `minOrder` ASC [ RunTime:0.006117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901013 LIMIT 4 [ RunTime:0.006144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901013 ORDER BY `minOrder` ASC [ RunTime:0.013504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901013 ORDER BY `unit` DESC [ RunTime:0.009859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901013 LIMIT 2 [ RunTime:0.001054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901013 ORDER BY `minOrder` ASC [ RunTime:0.003895s ]
select * from pdf where partno='P1200SCMCLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901012 LIMIT 4 [ RunTime:0.002451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901012 ORDER BY `minOrder` ASC [ RunTime:0.030926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901012 ORDER BY `unit` DESC [ RunTime:0.008334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901012 LIMIT 2 [ RunTime:0.006954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901012 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='P1200Q12BLRP' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900954 LIMIT 4 [ RunTime:0.004703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900954 ORDER BY `minOrder` ASC [ RunTime:0.005491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900954 ORDER BY `unit` DESC [ RunTime:0.001640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900954 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900954 ORDER BY `minOrder` ASC [ RunTime:0.000186s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'P1200%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000931s ]