SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003250s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007582s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002699s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.131' ) [ RunTime:0.000635s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001263s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000233s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000999s ]
SELECT * FROM `stock_search` WHERE `partno` = '130014' LIMIT 1 [ RunTime:0.000344s ]
UPDATE `stock_search` SET `count` = 18711 , `updatetime` = '2026-06-05 09:53:09' WHERE `partno` = '130014' [ RunTime:0.008889s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000227s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000195s ]
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.000298s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003066s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '130014%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.015739s ]
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 '130014%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.013564s ]
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 ('16616423','16616321','16615877','16615857','14696324','14695875','14695455','14694244','14693814','14693478','14693355','14692115','14692018','14690765','14672025','14671990','13807406','13807150','13805269','13804944') ORDER BY FIELD(s.id, 16616423,16616321,16615877,16615857,14696324,14695875,14695455,14694244,14693814,14693478,14693355,14692115,14692018,14690765,14672025,14671990,13807406,13807150,13805269,13804944) [ RunTime:0.022052s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16616423 LIMIT 4 [ RunTime:0.013278s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.022252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16616423 ORDER BY `minOrder` ASC [ RunTime:0.025466s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.022988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16616423 ORDER BY `unit` DESC [ RunTime:0.024593s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16616423 LIMIT 2 [ RunTime:0.021427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16616423 ORDER BY `minOrder` ASC [ RunTime:0.024639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16616321 LIMIT 4 [ RunTime:0.008205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16616321 ORDER BY `minOrder` ASC [ RunTime:0.016667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16616321 ORDER BY `unit` DESC [ RunTime:0.015944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16616321 LIMIT 2 [ RunTime:0.013378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16616321 ORDER BY `minOrder` ASC [ RunTime:0.008202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16615877 LIMIT 4 [ RunTime:0.010968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615877 ORDER BY `minOrder` ASC [ RunTime:0.029933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16615877 ORDER BY `unit` DESC [ RunTime:0.035503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16615877 LIMIT 2 [ RunTime:0.033596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615877 ORDER BY `minOrder` ASC [ RunTime:0.050760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16615857 LIMIT 4 [ RunTime:0.030745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615857 ORDER BY `minOrder` ASC [ RunTime:0.058720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16615857 ORDER BY `unit` DESC [ RunTime:0.053780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16615857 LIMIT 2 [ RunTime:0.024313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615857 ORDER BY `minOrder` ASC [ RunTime:0.010663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696324 LIMIT 4 [ RunTime:0.020043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696324 ORDER BY `minOrder` ASC [ RunTime:0.010336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696324 ORDER BY `unit` DESC [ RunTime:0.006090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696324 LIMIT 2 [ RunTime:0.032469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696324 ORDER BY `minOrder` ASC [ RunTime:0.024396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695875 LIMIT 4 [ RunTime:0.029809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695875 ORDER BY `minOrder` ASC [ RunTime:0.011498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695875 ORDER BY `unit` DESC [ RunTime:0.022845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695875 LIMIT 2 [ RunTime:0.016630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695875 ORDER BY `minOrder` ASC [ RunTime:0.003534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695455 LIMIT 4 [ RunTime:0.006702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695455 ORDER BY `minOrder` ASC [ RunTime:0.022129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695455 ORDER BY `unit` DESC [ RunTime:0.021921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695455 LIMIT 2 [ RunTime:0.014204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695455 ORDER BY `minOrder` ASC [ RunTime:0.012891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14694244 LIMIT 4 [ RunTime:0.012207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694244 ORDER BY `minOrder` ASC [ RunTime:0.015668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14694244 ORDER BY `unit` DESC [ RunTime:0.031613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14694244 LIMIT 2 [ RunTime:0.048005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694244 ORDER BY `minOrder` ASC [ RunTime:0.023643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693814 LIMIT 4 [ RunTime:0.014618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693814 ORDER BY `minOrder` ASC [ RunTime:0.027853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14693814 ORDER BY `unit` DESC [ RunTime:0.019155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14693814 LIMIT 2 [ RunTime:0.076423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693814 ORDER BY `minOrder` ASC [ RunTime:0.023615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693478 LIMIT 4 [ RunTime:0.029190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693478 ORDER BY `minOrder` ASC [ RunTime:0.127875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14693478 ORDER BY `unit` DESC [ RunTime:0.040864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14693478 LIMIT 2 [ RunTime:0.040123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693478 ORDER BY `minOrder` ASC [ RunTime:0.010627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693355 LIMIT 4 [ RunTime:0.012949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693355 ORDER BY `minOrder` ASC [ RunTime:0.011239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14693355 ORDER BY `unit` DESC [ RunTime:0.011946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14693355 LIMIT 2 [ RunTime:0.038497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693355 ORDER BY `minOrder` ASC [ RunTime:0.012736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692115 LIMIT 4 [ RunTime:0.010433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692115 ORDER BY `minOrder` ASC [ RunTime:0.013762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14692115 ORDER BY `unit` DESC [ RunTime:0.038239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14692115 LIMIT 2 [ RunTime:0.025976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692115 ORDER BY `minOrder` ASC [ RunTime:0.029311s ]
select * from pdf where partno='1300140033' and brandshort='Molex' limit 1 [ RunTime:0.035661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692018 LIMIT 4 [ RunTime:0.016579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692018 ORDER BY `minOrder` ASC [ RunTime:0.011211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14692018 ORDER BY `unit` DESC [ RunTime:0.005703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14692018 LIMIT 2 [ RunTime:0.002211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692018 ORDER BY `minOrder` ASC [ RunTime:0.002995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14690765 LIMIT 4 [ RunTime:0.021984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690765 ORDER BY `minOrder` ASC [ RunTime:0.022597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14690765 ORDER BY `unit` DESC [ RunTime:0.020162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14690765 LIMIT 2 [ RunTime:0.010754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690765 ORDER BY `minOrder` ASC [ RunTime:0.006566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14672025 LIMIT 4 [ RunTime:0.010298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14672025 ORDER BY `minOrder` ASC [ RunTime:0.020595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14672025 ORDER BY `unit` DESC [ RunTime:0.003817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14672025 LIMIT 2 [ RunTime:0.026651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14672025 ORDER BY `minOrder` ASC [ RunTime:0.001874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14671990 LIMIT 4 [ RunTime:0.011805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671990 ORDER BY `minOrder` ASC [ RunTime:0.015514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14671990 ORDER BY `unit` DESC [ RunTime:0.034039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14671990 LIMIT 2 [ RunTime:0.023323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14671990 ORDER BY `minOrder` ASC [ RunTime:0.016916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807406 LIMIT 4 [ RunTime:0.026620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807406 ORDER BY `minOrder` ASC [ RunTime:0.017091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807406 ORDER BY `unit` DESC [ RunTime:0.010554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807406 LIMIT 2 [ RunTime:0.017565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807406 ORDER BY `minOrder` ASC [ RunTime:0.016705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807150 LIMIT 4 [ RunTime:0.013609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807150 ORDER BY `minOrder` ASC [ RunTime:0.010965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807150 ORDER BY `unit` DESC [ RunTime:0.009132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807150 LIMIT 2 [ RunTime:0.012150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807150 ORDER BY `minOrder` ASC [ RunTime:0.007034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13805269 LIMIT 4 [ RunTime:0.025075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13805269 ORDER BY `minOrder` ASC [ RunTime:0.021033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13805269 ORDER BY `unit` DESC [ RunTime:0.029242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13805269 LIMIT 2 [ RunTime:0.018061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13805269 ORDER BY `minOrder` ASC [ RunTime:0.015156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13804944 LIMIT 4 [ RunTime:0.020771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804944 ORDER BY `minOrder` ASC [ RunTime:0.012509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13804944 ORDER BY `unit` DESC [ RunTime:0.016868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13804944 LIMIT 2 [ RunTime:0.007402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13804944 ORDER BY `minOrder` ASC [ RunTime:0.007744s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '130014%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.005425s ]