SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001204s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003244s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001626s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.219' ) [ RunTime:0.001569s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001111s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000800s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001908s ]
SELECT * FROM `stock_search` WHERE `partno` = 'G501' LIMIT 1 [ RunTime:0.003169s ]
UPDATE `stock_search` SET `count` = 13303 , `updatetime` = '2026-05-31 19:33:48' WHERE `partno` = 'G501' [ RunTime:0.002745s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004223s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000321s ]
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.001249s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001225s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'G501%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.003980s ]
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 'G501%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.008285s ]
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 ('21079872','21079860','21079217','21079216','21079215','21079214','21079213','21073127','18866987','18590292','18589154','18589147','18588692','18588691','17027159','16966609','16004771','16004770','16004769','13371259') ORDER BY FIELD(s.id, 21079872,21079860,21079217,21079216,21079215,21079214,21079213,21073127,18866987,18590292,18589154,18589147,18588692,18588691,17027159,16966609,16004771,16004770,16004769,13371259) [ RunTime:0.027140s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079872 LIMIT 4 [ RunTime:0.012126s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079872 ORDER BY `minOrder` ASC [ RunTime:0.019866s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079872 ORDER BY `unit` DESC [ RunTime:0.012430s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079872 LIMIT 2 [ RunTime:0.012594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079872 ORDER BY `minOrder` ASC [ RunTime:0.004651s ]
select * from pdf where partno='G5015E12B1-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.001904s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015E12B1-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.010877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079860 LIMIT 4 [ RunTime:0.025634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079860 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079860 ORDER BY `unit` DESC [ RunTime:0.009583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079860 LIMIT 2 [ RunTime:0.001008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079860 ORDER BY `minOrder` ASC [ RunTime:0.007191s ]
select * from pdf where partno='G5015H12B1-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.005269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015H12B1-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.001057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079217 LIMIT 4 [ RunTime:0.005623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079217 ORDER BY `minOrder` ASC [ RunTime:0.008106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079217 ORDER BY `unit` DESC [ RunTime:0.012656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079217 LIMIT 2 [ RunTime:0.002844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079217 ORDER BY `minOrder` ASC [ RunTime:0.006238s ]
select * from pdf where partno='G5015S24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015S24B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079216 LIMIT 4 [ RunTime:0.001584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079216 ORDER BY `minOrder` ASC [ RunTime:0.002788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079216 ORDER BY `unit` DESC [ RunTime:0.026834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079216 LIMIT 2 [ RunTime:0.007241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079216 ORDER BY `minOrder` ASC [ RunTime:0.008536s ]
select * from pdf where partno='G5015M24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.031914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015M24B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.017097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079215 LIMIT 4 [ RunTime:0.007485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079215 ORDER BY `minOrder` ASC [ RunTime:0.013544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079215 ORDER BY `unit` DESC [ RunTime:0.033086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079215 LIMIT 2 [ RunTime:0.028637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079215 ORDER BY `minOrder` ASC [ RunTime:0.021722s ]
select * from pdf where partno='G5015M12B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.033784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015M12B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.019487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079214 LIMIT 4 [ RunTime:0.018034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079214 ORDER BY `minOrder` ASC [ RunTime:0.037904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079214 ORDER BY `unit` DESC [ RunTime:0.005461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079214 LIMIT 2 [ RunTime:0.027037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079214 ORDER BY `minOrder` ASC [ RunTime:0.006989s ]
select * from pdf where partno='G5015H05B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.007479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015H05B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.005836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21079213 LIMIT 4 [ RunTime:0.001006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079213 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21079213 ORDER BY `unit` DESC [ RunTime:0.003868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21079213 LIMIT 2 [ RunTime:0.023133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21079213 ORDER BY `minOrder` ASC [ RunTime:0.001701s ]
select * from pdf where partno='G5015E24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.005566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015E24B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.002505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21073127 LIMIT 4 [ RunTime:0.005722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21073127 ORDER BY `minOrder` ASC [ RunTime:0.002507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21073127 ORDER BY `unit` DESC [ RunTime:0.004620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21073127 LIMIT 2 [ RunTime:0.007228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21073127 ORDER BY `minOrder` ASC [ RunTime:0.013775s ]
select * from pdf where partno='G5015H24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.009684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5015H24B-RSR' OR `brand` LIKE 'Mechatronics Fan Group%' ) ) LIMIT 1 [ RunTime:0.007956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866987 LIMIT 4 [ RunTime:0.012215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866987 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18866987 ORDER BY `unit` DESC [ RunTime:0.002071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18866987 LIMIT 2 [ RunTime:0.018230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866987 ORDER BY `minOrder` ASC [ RunTime:0.009998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18590292 LIMIT 4 [ RunTime:0.002409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18590292 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18590292 ORDER BY `unit` DESC [ RunTime:0.006525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18590292 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18590292 ORDER BY `minOrder` ASC [ RunTime:0.007063s ]
select * from pdf where partno='G5015L12B1+6-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.009415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18589154 LIMIT 4 [ RunTime:0.003890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18589154 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18589154 ORDER BY `unit` DESC [ RunTime:0.009793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18589154 LIMIT 2 [ RunTime:0.008081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18589154 ORDER BY `minOrder` ASC [ RunTime:0.001929s ]
select * from pdf where partno='G5015E12B1-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.002580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18589147 LIMIT 4 [ RunTime:0.006363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18589147 ORDER BY `minOrder` ASC [ RunTime:0.008597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18589147 ORDER BY `unit` DESC [ RunTime:0.009267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18589147 LIMIT 2 [ RunTime:0.002331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18589147 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
select * from pdf where partno='G5015H12B1-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588692 LIMIT 4 [ RunTime:0.001486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588692 ORDER BY `minOrder` ASC [ RunTime:0.002087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18588692 ORDER BY `unit` DESC [ RunTime:0.012533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18588692 LIMIT 2 [ RunTime:0.006316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588692 ORDER BY `minOrder` ASC [ RunTime:0.001964s ]
select * from pdf where partno='G5015S24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.002763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588691 LIMIT 4 [ RunTime:0.013517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588691 ORDER BY `minOrder` ASC [ RunTime:0.013511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18588691 ORDER BY `unit` DESC [ RunTime:0.019224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18588691 LIMIT 2 [ RunTime:0.000977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588691 ORDER BY `minOrder` ASC [ RunTime:0.003407s ]
select * from pdf where partno='G5015H05B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.000614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17027159 LIMIT 4 [ RunTime:0.006241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027159 ORDER BY `minOrder` ASC [ RunTime:0.005545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17027159 ORDER BY `unit` DESC [ RunTime:0.013359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17027159 LIMIT 2 [ RunTime:0.004887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17027159 ORDER BY `minOrder` ASC [ RunTime:0.007914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16966609 LIMIT 4 [ RunTime:0.002156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16966609 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16966609 ORDER BY `unit` DESC [ RunTime:0.002721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16966609 LIMIT 2 [ RunTime:0.001427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16966609 ORDER BY `minOrder` ASC [ RunTime:0.004969s ]
select * from pdf where partno='G5015E12B-RSR-CC' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.019198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004771 LIMIT 4 [ RunTime:0.001788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004771 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004771 ORDER BY `unit` DESC [ RunTime:0.007731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004771 LIMIT 2 [ RunTime:0.007233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004771 ORDER BY `minOrder` ASC [ RunTime:0.007192s ]
select * from pdf where partno='G5015M24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.002383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004770 LIMIT 4 [ RunTime:0.006963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004770 ORDER BY `minOrder` ASC [ RunTime:0.000718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004770 ORDER BY `unit` DESC [ RunTime:0.010285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004770 LIMIT 2 [ RunTime:0.004534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004770 ORDER BY `minOrder` ASC [ RunTime:0.007324s ]
select * from pdf where partno='G5015M12B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.006774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004769 LIMIT 4 [ RunTime:0.005264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004769 ORDER BY `minOrder` ASC [ RunTime:0.006659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004769 ORDER BY `unit` DESC [ RunTime:0.012320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004769 LIMIT 2 [ RunTime:0.016823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004769 ORDER BY `minOrder` ASC [ RunTime:0.003887s ]
select * from pdf where partno='G5015E24B-RSR' and brandshort='Mechatronics Fan Group' limit 1 [ RunTime:0.001368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13371259 LIMIT 4 [ RunTime:0.023558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371259 ORDER BY `minOrder` ASC [ RunTime:0.007655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13371259 ORDER BY `unit` DESC [ RunTime:0.004303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13371259 LIMIT 2 [ RunTime:0.001236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13371259 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'G501%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.012910s ]