SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001490s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000711s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001777s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002672s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001805s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001658s ]
SELECT * FROM `stock_search` WHERE `partno` = '388' LIMIT 1 [ RunTime:0.002242s ]
UPDATE `stock_search` SET `count` = 20 , `updatetime` = '2026-06-04 16:53:49' WHERE `partno` = '388' [ RunTime:0.004419s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000263s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001146s ]
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.000632s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001553s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.001418s ]
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 '388%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 80,20 [ RunTime:0.011344s ]
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 ('18899782','18762039','18757489','18753605','18752677','18752653','18750833','18750598','18750269','18749006','18742059','18734593','18732101','18725598','18706523','18706494','18706493','18706434','18703848','17871727') ORDER BY FIELD(s.id, 18899782,18762039,18757489,18753605,18752677,18752653,18750833,18750598,18750269,18749006,18742059,18734593,18732101,18725598,18706523,18706494,18706493,18706434,18703848,17871727) [ RunTime:0.025943s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18899782 LIMIT 4 [ RunTime:0.017247s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18899782 ORDER BY `minOrder` ASC [ RunTime:0.012206s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18899782 ORDER BY `unit` DESC [ RunTime:0.005427s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18899782 LIMIT 2 [ RunTime:0.008041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18899782 ORDER BY `minOrder` ASC [ RunTime:0.008527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18762039 LIMIT 4 [ RunTime:0.009672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18762039 ORDER BY `minOrder` ASC [ RunTime:0.021377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18762039 ORDER BY `unit` DESC [ RunTime:0.018871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18762039 LIMIT 2 [ RunTime:0.012569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18762039 ORDER BY `minOrder` ASC [ RunTime:0.028724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18757489 LIMIT 4 [ RunTime:0.030371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757489 ORDER BY `minOrder` ASC [ RunTime:0.018436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18757489 ORDER BY `unit` DESC [ RunTime:0.025354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18757489 LIMIT 2 [ RunTime:0.027789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757489 ORDER BY `minOrder` ASC [ RunTime:0.006562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753605 LIMIT 4 [ RunTime:0.017958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753605 ORDER BY `minOrder` ASC [ RunTime:0.008096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753605 ORDER BY `unit` DESC [ RunTime:0.007928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753605 LIMIT 2 [ RunTime:0.016949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753605 ORDER BY `minOrder` ASC [ RunTime:0.008503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752677 LIMIT 4 [ RunTime:0.015187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752677 ORDER BY `minOrder` ASC [ RunTime:0.013906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752677 ORDER BY `unit` DESC [ RunTime:0.011786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752677 LIMIT 2 [ RunTime:0.014946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752677 ORDER BY `minOrder` ASC [ RunTime:0.016134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752653 LIMIT 4 [ RunTime:0.011227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752653 ORDER BY `minOrder` ASC [ RunTime:0.023768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752653 ORDER BY `unit` DESC [ RunTime:0.025678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752653 LIMIT 2 [ RunTime:0.019103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752653 ORDER BY `minOrder` ASC [ RunTime:0.002441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750833 LIMIT 4 [ RunTime:0.008495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750833 ORDER BY `minOrder` ASC [ RunTime:0.006528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750833 ORDER BY `unit` DESC [ RunTime:0.006529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750833 LIMIT 2 [ RunTime:0.011612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750833 ORDER BY `minOrder` ASC [ RunTime:0.006922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750598 LIMIT 4 [ RunTime:0.017809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750598 ORDER BY `minOrder` ASC [ RunTime:0.021803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750598 ORDER BY `unit` DESC [ RunTime:0.018680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750598 LIMIT 2 [ RunTime:0.017529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750598 ORDER BY `minOrder` ASC [ RunTime:0.024501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750269 LIMIT 4 [ RunTime:0.016513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750269 ORDER BY `minOrder` ASC [ RunTime:0.008639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750269 ORDER BY `unit` DESC [ RunTime:0.015228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750269 LIMIT 2 [ RunTime:0.016721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750269 ORDER BY `minOrder` ASC [ RunTime:0.008111s ]
select * from pdf where partno='388632-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.016671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18749006 LIMIT 4 [ RunTime:0.008986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749006 ORDER BY `minOrder` ASC [ RunTime:0.007993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18749006 ORDER BY `unit` DESC [ RunTime:0.006401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18749006 LIMIT 2 [ RunTime:0.010766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749006 ORDER BY `minOrder` ASC [ RunTime:0.013951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18742059 LIMIT 4 [ RunTime:0.009481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18742059 ORDER BY `minOrder` ASC [ RunTime:0.008648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18742059 ORDER BY `unit` DESC [ RunTime:0.010275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18742059 LIMIT 2 [ RunTime:0.004824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18742059 ORDER BY `minOrder` ASC [ RunTime:0.010213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18734593 LIMIT 4 [ RunTime:0.009831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734593 ORDER BY `minOrder` ASC [ RunTime:0.012369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18734593 ORDER BY `unit` DESC [ RunTime:0.003373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18734593 LIMIT 2 [ RunTime:0.015071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18734593 ORDER BY `minOrder` ASC [ RunTime:0.008043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18732101 LIMIT 4 [ RunTime:0.010100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18732101 ORDER BY `minOrder` ASC [ RunTime:0.009128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18732101 ORDER BY `unit` DESC [ RunTime:0.009441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18732101 LIMIT 2 [ RunTime:0.009998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18732101 ORDER BY `minOrder` ASC [ RunTime:0.011090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18725598 LIMIT 4 [ RunTime:0.009815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18725598 ORDER BY `minOrder` ASC [ RunTime:0.013011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18725598 ORDER BY `unit` DESC [ RunTime:0.009895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18725598 LIMIT 2 [ RunTime:0.009260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18725598 ORDER BY `minOrder` ASC [ RunTime:0.004803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18706523 LIMIT 4 [ RunTime:0.013123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706523 ORDER BY `minOrder` ASC [ RunTime:0.010841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18706523 ORDER BY `unit` DESC [ RunTime:0.013236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18706523 LIMIT 2 [ RunTime:0.011403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706523 ORDER BY `minOrder` ASC [ RunTime:0.002405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18706494 LIMIT 4 [ RunTime:0.005932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706494 ORDER BY `minOrder` ASC [ RunTime:0.013796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18706494 ORDER BY `unit` DESC [ RunTime:0.005455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18706494 LIMIT 2 [ RunTime:0.007277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706494 ORDER BY `minOrder` ASC [ RunTime:0.003937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18706493 LIMIT 4 [ RunTime:0.005351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706493 ORDER BY `minOrder` ASC [ RunTime:0.005309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18706493 ORDER BY `unit` DESC [ RunTime:0.004136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18706493 LIMIT 2 [ RunTime:0.011081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706493 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18706434 LIMIT 4 [ RunTime:0.013317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706434 ORDER BY `minOrder` ASC [ RunTime:0.004772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18706434 ORDER BY `unit` DESC [ RunTime:0.004236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18706434 LIMIT 2 [ RunTime:0.003190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18706434 ORDER BY `minOrder` ASC [ RunTime:0.004121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18703848 LIMIT 4 [ RunTime:0.006394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703848 ORDER BY `minOrder` ASC [ RunTime:0.006996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18703848 ORDER BY `unit` DESC [ RunTime:0.005961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18703848 LIMIT 2 [ RunTime:0.003376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703848 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17871727 LIMIT 4 [ RunTime:0.003110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17871727 ORDER BY `minOrder` ASC [ RunTime:0.004948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17871727 ORDER BY `unit` DESC [ RunTime:0.005072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17871727 LIMIT 2 [ RunTime:0.008316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17871727 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000570s ]