SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001773s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002228s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002153s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.147' ) [ RunTime:0.001238s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001804s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002271s ]
SELECT * FROM `stock_search` WHERE `partno` = '3013' LIMIT 1 [ RunTime:0.010919s ]
UPDATE `stock_search` SET `count` = 3971 , `updatetime` = '2026-03-02 09:12:53' WHERE `partno` = '3013' [ RunTime:0.007029s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000270s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001213s ]
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.000509s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001095s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '3013%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.008016s ]
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 '3013%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.007301s ]
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 ('13162511','13160142','13157298','13153797','13143319','13142877','13141564','12532895','12178597','12173441','12039950','12038914','11992964','11913389','11901103','11900554','11898285','11895358','11895085','11894829') ORDER BY FIELD(s.id, 13162511,13160142,13157298,13153797,13143319,13142877,13141564,12532895,12178597,12173441,12039950,12038914,11992964,11913389,11901103,11900554,11898285,11895358,11895085,11894829) [ RunTime:0.009748s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13162511 LIMIT 4 [ RunTime:0.001111s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13162511 ORDER BY `minOrder` ASC [ RunTime:0.002601s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13162511 ORDER BY `unit` DESC [ RunTime:0.004500s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13162511 LIMIT 2 [ RunTime:0.002853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13162511 ORDER BY `minOrder` ASC [ RunTime:0.005061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13160142 LIMIT 4 [ RunTime:0.006285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13160142 ORDER BY `minOrder` ASC [ RunTime:0.001384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13160142 ORDER BY `unit` DESC [ RunTime:0.003485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13160142 LIMIT 2 [ RunTime:0.002174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13160142 ORDER BY `minOrder` ASC [ RunTime:0.002012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13157298 LIMIT 4 [ RunTime:0.002943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13157298 ORDER BY `minOrder` ASC [ RunTime:0.002126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13157298 ORDER BY `unit` DESC [ RunTime:0.004653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13157298 LIMIT 2 [ RunTime:0.001880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13157298 ORDER BY `minOrder` ASC [ RunTime:0.002545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13153797 LIMIT 4 [ RunTime:0.001067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13153797 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13153797 ORDER BY `unit` DESC [ RunTime:0.011902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13153797 LIMIT 2 [ RunTime:0.002474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13153797 ORDER BY `minOrder` ASC [ RunTime:0.005439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13143319 LIMIT 4 [ RunTime:0.004277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13143319 ORDER BY `minOrder` ASC [ RunTime:0.003286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13143319 ORDER BY `unit` DESC [ RunTime:0.008316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13143319 LIMIT 2 [ RunTime:0.002111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13143319 ORDER BY `minOrder` ASC [ RunTime:0.006865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13142877 LIMIT 4 [ RunTime:0.006492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13142877 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13142877 ORDER BY `unit` DESC [ RunTime:0.005877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13142877 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13142877 ORDER BY `minOrder` ASC [ RunTime:0.005731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13141564 LIMIT 4 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13141564 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13141564 ORDER BY `unit` DESC [ RunTime:0.006224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13141564 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13141564 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12532895 LIMIT 4 [ RunTime:0.000997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12532895 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12532895 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12532895 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12532895 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12178597 LIMIT 4 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12178597 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12178597 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12178597 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12178597 ORDER BY `minOrder` ASC [ RunTime:0.000215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173441 LIMIT 4 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173441 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12173441 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12173441 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173441 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039950 LIMIT 4 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039950 ORDER BY `minOrder` ASC [ RunTime:0.002106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039950 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039950 LIMIT 2 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039950 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12038914 LIMIT 4 [ RunTime:0.001002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12038914 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12038914 ORDER BY `unit` DESC [ RunTime:0.000828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12038914 LIMIT 2 [ RunTime:0.001499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12038914 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992964 LIMIT 4 [ RunTime:0.001146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992964 ORDER BY `minOrder` ASC [ RunTime:0.002714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11992964 ORDER BY `unit` DESC [ RunTime:0.001496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11992964 LIMIT 2 [ RunTime:0.003715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992964 ORDER BY `minOrder` ASC [ RunTime:0.003877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11913389 LIMIT 4 [ RunTime:0.002002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11913389 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11913389 ORDER BY `unit` DESC [ RunTime:0.002404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11913389 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11913389 ORDER BY `minOrder` ASC [ RunTime:0.001080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11901103 LIMIT 4 [ RunTime:0.006663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11901103 ORDER BY `minOrder` ASC [ RunTime:0.003179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11901103 ORDER BY `unit` DESC [ RunTime:0.000581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11901103 LIMIT 2 [ RunTime:0.001695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11901103 ORDER BY `minOrder` ASC [ RunTime:0.002954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11900554 LIMIT 4 [ RunTime:0.001246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900554 ORDER BY `minOrder` ASC [ RunTime:0.001215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11900554 ORDER BY `unit` DESC [ RunTime:0.004794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11900554 LIMIT 2 [ RunTime:0.003002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900554 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11898285 LIMIT 4 [ RunTime:0.001184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11898285 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11898285 ORDER BY `unit` DESC [ RunTime:0.006637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11898285 LIMIT 2 [ RunTime:0.001617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11898285 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11895358 LIMIT 4 [ RunTime:0.000984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11895358 ORDER BY `minOrder` ASC [ RunTime:0.001518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11895358 ORDER BY `unit` DESC [ RunTime:0.003986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11895358 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11895358 ORDER BY `minOrder` ASC [ RunTime:0.001655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11895085 LIMIT 4 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11895085 ORDER BY `minOrder` ASC [ RunTime:0.005132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11895085 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11895085 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11895085 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11894829 LIMIT 4 [ RunTime:0.001083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11894829 ORDER BY `minOrder` ASC [ RunTime:0.000910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11894829 ORDER BY `unit` DESC [ RunTime:0.000555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11894829 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11894829 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '3013%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000502s ]