SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001473s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001872s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002180s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.9' ) [ RunTime:0.005000s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001800s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003424s ]
SELECT * FROM `stock_search` WHERE `partno` = 'RAC05-12SK' LIMIT 1 [ RunTime:0.006816s ]
UPDATE `stock_search` SET `count` = 16658 , `updatetime` = '2026-06-03 07:03:01' WHERE `partno` = 'RAC05-12SK' [ RunTime:0.010384s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000277s ]
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.000417s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002290s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'RAC05-12SK%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.002896s ]
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 'RAC05-12SK%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006315s ]
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 ('25820137','29578339','25820176','12081311','25820142','29591862','11144343','25822077','9705','11179856') ORDER BY FIELD(s.id, 25820137,29578339,25820176,12081311,25820142,29591862,11144343,25822077,9705,11179856) [ RunTime:0.005775s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25820137 LIMIT 4 [ RunTime:0.009063s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25820137 ORDER BY `minOrder` ASC [ RunTime:0.002231s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25820137 ORDER BY `unit` DESC [ RunTime:0.002581s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25820137 LIMIT 2 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25820137 ORDER BY `minOrder` ASC [ RunTime:0.000841s ]
select * from pdf where partno='RAC05-12SK' and brandshort='Recom Power' limit 1 [ RunTime:0.001325s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAC05-12SK' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.012335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 29578339 LIMIT 4 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 29578339 ORDER BY `minOrder` ASC [ RunTime:0.001480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 29578339 ORDER BY `unit` DESC [ RunTime:0.000869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 29578339 LIMIT 2 [ RunTime:0.001799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 29578339 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
select * from pdf where partno='RAC05-12SK/277/W' and brandshort='Recom Power' limit 1 [ RunTime:0.005653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAC05-12SK/277/W' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25820176 LIMIT 4 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25820176 ORDER BY `minOrder` ASC [ RunTime:0.001127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25820176 ORDER BY `unit` DESC [ RunTime:0.000941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25820176 LIMIT 2 [ RunTime:0.001300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25820176 ORDER BY `minOrder` ASC [ RunTime:0.003584s ]
select * from pdf where partno='RAC05-12SK/480' and brandshort='Recom Power' limit 1 [ RunTime:0.003161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAC05-12SK/480' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.000786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12081311 LIMIT 4 [ RunTime:0.005275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12081311 ORDER BY `minOrder` ASC [ RunTime:0.003027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12081311 ORDER BY `unit` DESC [ RunTime:0.004846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12081311 LIMIT 2 [ RunTime:0.007413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12081311 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25820142 LIMIT 4 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25820142 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25820142 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25820142 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25820142 ORDER BY `minOrder` ASC [ RunTime:0.001799s ]
select * from pdf where partno='RAC05-12SK/277' and brandshort='Recom Power' limit 1 [ RunTime:0.009082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAC05-12SK/277' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.002154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 29591862 LIMIT 4 [ RunTime:0.003044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 29591862 ORDER BY `minOrder` ASC [ RunTime:0.003703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 29591862 ORDER BY `unit` DESC [ RunTime:0.003797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 29591862 LIMIT 2 [ RunTime:0.001233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 29591862 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
select * from pdf where partno='RAC05-12SK/C14' and brandshort='Recom Power' limit 1 [ RunTime:0.001742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAC05-12SK/C14' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.001860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11144343 LIMIT 4 [ RunTime:0.004964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11144343 ORDER BY `minOrder` ASC [ RunTime:0.005035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11144343 ORDER BY `unit` DESC [ RunTime:0.005172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11144343 LIMIT 2 [ RunTime:0.001055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11144343 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25822077 LIMIT 4 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25822077 ORDER BY `minOrder` ASC [ RunTime:0.005059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25822077 ORDER BY `unit` DESC [ RunTime:0.009941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25822077 LIMIT 2 [ RunTime:0.010320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25822077 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
select * from pdf where partno='RAC05-12SK/PD3/H' and brandshort='Recom Power' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAC05-12SK/PD3/H' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.000999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9705 LIMIT 4 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9705 ORDER BY `minOrder` ASC [ RunTime:0.007842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9705 ORDER BY `unit` DESC [ RunTime:0.006085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9705 LIMIT 2 [ RunTime:0.005925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9705 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RAC05-12SK' OR `brand` LIKE 'RECOM POWER%' ) ) LIMIT 1 [ RunTime:0.001744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11179856 LIMIT 4 [ RunTime:0.001162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179856 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11179856 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11179856 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11179856 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'RAC05-12SK%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002419s ]