SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001989s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000712s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002789s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.000500s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001828s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001657s ]
SELECT * FROM `stock_search` WHERE `partno` = '388' LIMIT 1 [ RunTime:0.004568s ]
UPDATE `stock_search` SET `count` = 14 , `updatetime` = '2026-06-04 15:28:12' WHERE `partno` = '388' [ RunTime:0.002257s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000258s ]
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.000474s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002156s ]
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.019637s ]
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 200,20 [ RunTime:0.005157s ]
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 ('12182731','12182730','12182720','12182719','12182656','12182655','12182645','12182637','12182636','12182623','12182605','12182591','12177251','12174307','12174173','12168000','12062378','12046843','12014626','11998723') ORDER BY FIELD(s.id, 12182731,12182730,12182720,12182719,12182656,12182655,12182645,12182637,12182636,12182623,12182605,12182591,12177251,12174307,12174173,12168000,12062378,12046843,12014626,11998723) [ RunTime:0.003895s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182731 LIMIT 4 [ RunTime:0.007113s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182731 ORDER BY `minOrder` ASC [ RunTime:0.003431s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182731 ORDER BY `unit` DESC [ RunTime:0.000971s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182731 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182731 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182730 LIMIT 4 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182730 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182730 ORDER BY `unit` DESC [ RunTime:0.000792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182730 LIMIT 2 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182730 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182720 LIMIT 4 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182720 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182720 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182720 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182720 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182719 LIMIT 4 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182719 ORDER BY `minOrder` ASC [ RunTime:0.001377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182719 ORDER BY `unit` DESC [ RunTime:0.001859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182719 LIMIT 2 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182719 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182656 LIMIT 4 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182656 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182656 ORDER BY `unit` DESC [ RunTime:0.002280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182656 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182656 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182655 LIMIT 4 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182655 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182655 ORDER BY `unit` DESC [ RunTime:0.002144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182655 LIMIT 2 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182655 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182645 LIMIT 4 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182645 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182645 ORDER BY `unit` DESC [ RunTime:0.003160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182645 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182645 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182637 LIMIT 4 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182637 ORDER BY `minOrder` ASC [ RunTime:0.004544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182637 ORDER BY `unit` DESC [ RunTime:0.000466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182637 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182637 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182636 LIMIT 4 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182636 ORDER BY `minOrder` ASC [ RunTime:0.003237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182636 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182636 LIMIT 2 [ RunTime:0.003750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182636 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182623 LIMIT 4 [ RunTime:0.003211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182623 ORDER BY `minOrder` ASC [ RunTime:0.000824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182623 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182623 LIMIT 2 [ RunTime:0.002150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182623 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182605 LIMIT 4 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182605 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182605 ORDER BY `unit` DESC [ RunTime:0.004613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182605 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182605 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182591 LIMIT 4 [ RunTime:0.006134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182591 ORDER BY `minOrder` ASC [ RunTime:0.001798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182591 ORDER BY `unit` DESC [ RunTime:0.002892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182591 LIMIT 2 [ RunTime:0.001401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182591 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177251 LIMIT 4 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177251 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12177251 ORDER BY `unit` DESC [ RunTime:0.002160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12177251 LIMIT 2 [ RunTime:0.006693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177251 ORDER BY `minOrder` ASC [ RunTime:0.001755s ]
select * from pdf where partno='3888D' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.001972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174307 LIMIT 4 [ RunTime:0.001906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174307 ORDER BY `minOrder` ASC [ RunTime:0.002202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12174307 ORDER BY `unit` DESC [ RunTime:0.001501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12174307 LIMIT 2 [ RunTime:0.002890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174307 ORDER BY `minOrder` ASC [ RunTime:0.001581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174173 LIMIT 4 [ RunTime:0.001831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174173 ORDER BY `minOrder` ASC [ RunTime:0.003079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12174173 ORDER BY `unit` DESC [ RunTime:0.002076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12174173 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174173 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12168000 LIMIT 4 [ RunTime:0.000811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168000 ORDER BY `minOrder` ASC [ RunTime:0.000965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12168000 ORDER BY `unit` DESC [ RunTime:0.002888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12168000 LIMIT 2 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168000 ORDER BY `minOrder` ASC [ RunTime:0.002011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12062378 LIMIT 4 [ RunTime:0.006553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12062378 ORDER BY `minOrder` ASC [ RunTime:0.001572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12062378 ORDER BY `unit` DESC [ RunTime:0.003286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12062378 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12062378 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046843 LIMIT 4 [ RunTime:0.000921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046843 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046843 ORDER BY `unit` DESC [ RunTime:0.001608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046843 LIMIT 2 [ RunTime:0.003183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046843 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014626 LIMIT 4 [ RunTime:0.000868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014626 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12014626 ORDER BY `unit` DESC [ RunTime:0.001196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12014626 LIMIT 2 [ RunTime:0.003903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014626 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11998723 LIMIT 4 [ RunTime:0.002843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11998723 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11998723 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11998723 LIMIT 2 [ RunTime:0.001836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11998723 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
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.003993s ]