SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001292s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001193s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002713s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001378s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001154s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000769s ]
UPDATE `stock_search` SET `count` = 523 , `updatetime` = '2026-06-05 01:51:11' WHERE `partno` = '210' [ RunTime:0.003656s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000191s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000161s ]
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.000345s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001249s ]
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.175758s ]
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 3000,20 [ RunTime:0.054361s ]
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 ('13175356','13169396','13168127','13168090','13165442','13164982','13145900','13136369','13133117','13130466','13130447','13130437','13130432','13130414','13130407','13130395','13130152','13122873','13117952','13105241') ORDER BY FIELD(s.id, 13175356,13169396,13168127,13168090,13165442,13164982,13145900,13136369,13133117,13130466,13130447,13130437,13130432,13130414,13130407,13130395,13130152,13122873,13117952,13105241) [ RunTime:0.008564s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175356 LIMIT 4 [ RunTime:0.001023s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.005107s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13175356 ORDER BY `unit` DESC [ RunTime:0.000575s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13175356 LIMIT 2 [ RunTime:0.003339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175356 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13169396 LIMIT 4 [ RunTime:0.034092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169396 ORDER BY `minOrder` ASC [ RunTime:0.019422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13169396 ORDER BY `unit` DESC [ RunTime:0.019505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13169396 LIMIT 2 [ RunTime:0.051612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169396 ORDER BY `minOrder` ASC [ RunTime:0.031787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13168127 LIMIT 4 [ RunTime:0.046287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13168127 ORDER BY `minOrder` ASC [ RunTime:0.064343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13168127 ORDER BY `unit` DESC [ RunTime:0.040420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13168127 LIMIT 2 [ RunTime:0.014892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13168127 ORDER BY `minOrder` ASC [ RunTime:0.007671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13168090 LIMIT 4 [ RunTime:0.039389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13168090 ORDER BY `minOrder` ASC [ RunTime:0.026381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13168090 ORDER BY `unit` DESC [ RunTime:0.036701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13168090 LIMIT 2 [ RunTime:0.027483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13168090 ORDER BY `minOrder` ASC [ RunTime:0.032261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13165442 LIMIT 4 [ RunTime:0.015657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13165442 ORDER BY `minOrder` ASC [ RunTime:0.021683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13165442 ORDER BY `unit` DESC [ RunTime:0.025019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13165442 LIMIT 2 [ RunTime:0.055295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13165442 ORDER BY `minOrder` ASC [ RunTime:0.028073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13164982 LIMIT 4 [ RunTime:0.006128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13164982 ORDER BY `minOrder` ASC [ RunTime:0.001306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13164982 ORDER BY `unit` DESC [ RunTime:0.006243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13164982 LIMIT 2 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13164982 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13145900 LIMIT 4 [ RunTime:0.007002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145900 ORDER BY `minOrder` ASC [ RunTime:0.004608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13145900 ORDER BY `unit` DESC [ RunTime:0.008869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13145900 LIMIT 2 [ RunTime:0.001821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145900 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13136369 LIMIT 4 [ RunTime:0.004551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13136369 ORDER BY `minOrder` ASC [ RunTime:0.004162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13136369 ORDER BY `unit` DESC [ RunTime:0.013615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13136369 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13136369 ORDER BY `minOrder` ASC [ RunTime:0.001970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13133117 LIMIT 4 [ RunTime:0.001321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13133117 ORDER BY `minOrder` ASC [ RunTime:0.006668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13133117 ORDER BY `unit` DESC [ RunTime:0.006566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13133117 LIMIT 2 [ RunTime:0.001369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13133117 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130466 LIMIT 4 [ RunTime:0.004464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130466 ORDER BY `minOrder` ASC [ RunTime:0.011024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130466 ORDER BY `unit` DESC [ RunTime:0.007520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130466 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130466 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130447 LIMIT 4 [ RunTime:0.001602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130447 ORDER BY `minOrder` ASC [ RunTime:0.008170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130447 ORDER BY `unit` DESC [ RunTime:0.014730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130447 LIMIT 2 [ RunTime:0.008877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130447 ORDER BY `minOrder` ASC [ RunTime:0.003282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130437 LIMIT 4 [ RunTime:0.003895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130437 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130437 ORDER BY `unit` DESC [ RunTime:0.007923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130437 LIMIT 2 [ RunTime:0.003439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130437 ORDER BY `minOrder` ASC [ RunTime:0.001024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130432 LIMIT 4 [ RunTime:0.001034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130432 ORDER BY `minOrder` ASC [ RunTime:0.009560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130432 ORDER BY `unit` DESC [ RunTime:0.009659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130432 LIMIT 2 [ RunTime:0.003494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130432 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130414 LIMIT 4 [ RunTime:0.005424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130414 ORDER BY `minOrder` ASC [ RunTime:0.001686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130414 ORDER BY `unit` DESC [ RunTime:0.013915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130414 LIMIT 2 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130414 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130407 LIMIT 4 [ RunTime:0.005388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130407 ORDER BY `minOrder` ASC [ RunTime:0.008548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130407 ORDER BY `unit` DESC [ RunTime:0.007707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130407 LIMIT 2 [ RunTime:0.010312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130407 ORDER BY `minOrder` ASC [ RunTime:0.003040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130395 LIMIT 4 [ RunTime:0.004221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130395 ORDER BY `minOrder` ASC [ RunTime:0.001686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130395 ORDER BY `unit` DESC [ RunTime:0.007240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130395 LIMIT 2 [ RunTime:0.015276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130395 ORDER BY `minOrder` ASC [ RunTime:0.003166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130152 LIMIT 4 [ RunTime:0.006796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130152 ORDER BY `minOrder` ASC [ RunTime:0.009824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130152 ORDER BY `unit` DESC [ RunTime:0.012935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130152 LIMIT 2 [ RunTime:0.025188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130152 ORDER BY `minOrder` ASC [ RunTime:0.005212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122873 LIMIT 4 [ RunTime:0.005410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122873 ORDER BY `minOrder` ASC [ RunTime:0.009308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13122873 ORDER BY `unit` DESC [ RunTime:0.019036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13122873 LIMIT 2 [ RunTime:0.019830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122873 ORDER BY `minOrder` ASC [ RunTime:0.014500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13117952 LIMIT 4 [ RunTime:0.009980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13117952 ORDER BY `minOrder` ASC [ RunTime:0.013239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13117952 ORDER BY `unit` DESC [ RunTime:0.014688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13117952 LIMIT 2 [ RunTime:0.011166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13117952 ORDER BY `minOrder` ASC [ RunTime:0.009488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13105241 LIMIT 4 [ RunTime:0.011053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13105241 ORDER BY `minOrder` ASC [ RunTime:0.010306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13105241 ORDER BY `unit` DESC [ RunTime:0.015383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13105241 LIMIT 2 [ RunTime:0.020123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13105241 ORDER BY `minOrder` ASC [ RunTime:0.003502s ]
select * from pdf where partno='21000100007' and brandshort='HARTING' limit 1 [ RunTime:0.017776s ]
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.051762s ]