SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002485s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001962s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001814s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001196s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000407s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001076s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000795s ]
UPDATE `stock_search` SET `count` = 794 , `updatetime` = '2026-06-05 06:52:30' WHERE `partno` = '210' [ RunTime:0.004281s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000747s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000371s ]
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.000480s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002914s ]
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.000458s ]
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 3580,20 [ RunTime:0.067512s ]
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 ('12042825','12041976','12039872','12039776','12039759','12039744','12039742','12039596','12039594','12039460','12039457','12039290','12039288','12039216','12039212','12039209','12039094','12039080','12039079','12038904') ORDER BY FIELD(s.id, 12042825,12041976,12039872,12039776,12039759,12039744,12039742,12039596,12039594,12039460,12039457,12039290,12039288,12039216,12039212,12039209,12039094,12039080,12039079,12038904) [ RunTime:0.003234s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042825 LIMIT 4 [ RunTime:0.005498s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042825 ORDER BY `minOrder` ASC [ RunTime:0.004110s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042825 ORDER BY `unit` DESC [ RunTime:0.003665s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042825 LIMIT 2 [ RunTime:0.001043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042825 ORDER BY `minOrder` ASC [ RunTime:0.005188s ]
select * from pdf where partno='2106-440-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.009816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041976 LIMIT 4 [ RunTime:0.012636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041976 ORDER BY `minOrder` ASC [ RunTime:0.002604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041976 ORDER BY `unit` DESC [ RunTime:0.012484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041976 LIMIT 2 [ RunTime:0.010188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041976 ORDER BY `minOrder` ASC [ RunTime:0.002654s ]
select * from pdf where partno='2108-1032-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.005400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039872 LIMIT 4 [ RunTime:0.003936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039872 ORDER BY `minOrder` ASC [ RunTime:0.007944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039872 ORDER BY `unit` DESC [ RunTime:0.006895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039872 LIMIT 2 [ RunTime:0.006710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039872 ORDER BY `minOrder` ASC [ RunTime:0.004424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039776 LIMIT 4 [ RunTime:0.005488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039776 ORDER BY `minOrder` ASC [ RunTime:0.005429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039776 ORDER BY `unit` DESC [ RunTime:0.005732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039776 LIMIT 2 [ RunTime:0.005345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039776 ORDER BY `minOrder` ASC [ RunTime:0.006516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039759 LIMIT 4 [ RunTime:0.020742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039759 ORDER BY `minOrder` ASC [ RunTime:0.014859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039759 ORDER BY `unit` DESC [ RunTime:0.018049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039759 LIMIT 2 [ RunTime:0.009675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039759 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039744 LIMIT 4 [ RunTime:0.015719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039744 ORDER BY `minOrder` ASC [ RunTime:0.013272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039744 ORDER BY `unit` DESC [ RunTime:0.017739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039744 LIMIT 2 [ RunTime:0.013241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039744 ORDER BY `minOrder` ASC [ RunTime:0.005452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039742 LIMIT 4 [ RunTime:0.017673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039742 ORDER BY `minOrder` ASC [ RunTime:0.020888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039742 ORDER BY `unit` DESC [ RunTime:0.014458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039742 LIMIT 2 [ RunTime:0.022650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039742 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039596 LIMIT 4 [ RunTime:0.015706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039596 ORDER BY `minOrder` ASC [ RunTime:0.027047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039596 ORDER BY `unit` DESC [ RunTime:0.021411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039596 LIMIT 2 [ RunTime:0.015141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039596 ORDER BY `minOrder` ASC [ RunTime:0.002327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039594 LIMIT 4 [ RunTime:0.007549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039594 ORDER BY `minOrder` ASC [ RunTime:0.012571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039594 ORDER BY `unit` DESC [ RunTime:0.010836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039594 LIMIT 2 [ RunTime:0.005333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039594 ORDER BY `minOrder` ASC [ RunTime:0.002300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039460 LIMIT 4 [ RunTime:0.018331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039460 ORDER BY `minOrder` ASC [ RunTime:0.021108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039460 ORDER BY `unit` DESC [ RunTime:0.013747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039460 LIMIT 2 [ RunTime:0.006070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039460 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039457 LIMIT 4 [ RunTime:0.014991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039457 ORDER BY `minOrder` ASC [ RunTime:0.006728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039457 ORDER BY `unit` DESC [ RunTime:0.017456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039457 LIMIT 2 [ RunTime:0.011859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039457 ORDER BY `minOrder` ASC [ RunTime:0.004087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039290 LIMIT 4 [ RunTime:0.002264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039290 ORDER BY `minOrder` ASC [ RunTime:0.012939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039290 ORDER BY `unit` DESC [ RunTime:0.004133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039290 LIMIT 2 [ RunTime:0.007123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039290 ORDER BY `minOrder` ASC [ RunTime:0.005430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039288 LIMIT 4 [ RunTime:0.004780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039288 ORDER BY `minOrder` ASC [ RunTime:0.022404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039288 ORDER BY `unit` DESC [ RunTime:0.007472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039288 LIMIT 2 [ RunTime:0.017471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039288 ORDER BY `minOrder` ASC [ RunTime:0.005084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039216 LIMIT 4 [ RunTime:0.018368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039216 ORDER BY `minOrder` ASC [ RunTime:0.007715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039216 ORDER BY `unit` DESC [ RunTime:0.008468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039216 LIMIT 2 [ RunTime:0.003782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039216 ORDER BY `minOrder` ASC [ RunTime:0.005119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039212 LIMIT 4 [ RunTime:0.007571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039212 ORDER BY `minOrder` ASC [ RunTime:0.010309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039212 ORDER BY `unit` DESC [ RunTime:0.011416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039212 LIMIT 2 [ RunTime:0.010317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039212 ORDER BY `minOrder` ASC [ RunTime:0.001730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039209 LIMIT 4 [ RunTime:0.010348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039209 ORDER BY `minOrder` ASC [ RunTime:0.014494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039209 ORDER BY `unit` DESC [ RunTime:0.011537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039209 LIMIT 2 [ RunTime:0.006495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039209 ORDER BY `minOrder` ASC [ RunTime:0.006113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039094 LIMIT 4 [ RunTime:0.010408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039094 ORDER BY `minOrder` ASC [ RunTime:0.022014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039094 ORDER BY `unit` DESC [ RunTime:0.012399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039094 LIMIT 2 [ RunTime:0.034627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039094 ORDER BY `minOrder` ASC [ RunTime:0.002222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039080 LIMIT 4 [ RunTime:0.011345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039080 ORDER BY `minOrder` ASC [ RunTime:0.019708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039080 ORDER BY `unit` DESC [ RunTime:0.017343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039080 LIMIT 2 [ RunTime:0.014649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039080 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039079 LIMIT 4 [ RunTime:0.010212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039079 ORDER BY `minOrder` ASC [ RunTime:0.009421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039079 ORDER BY `unit` DESC [ RunTime:0.006873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039079 LIMIT 2 [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039079 ORDER BY `minOrder` ASC [ RunTime:0.006167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12038904 LIMIT 4 [ RunTime:0.020826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12038904 ORDER BY `minOrder` ASC [ RunTime:0.003368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12038904 ORDER BY `unit` DESC [ RunTime:0.005962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12038904 LIMIT 2 [ RunTime:0.002353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12038904 ORDER BY `minOrder` ASC [ RunTime:0.001752s ]
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.007611s ]