SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001857s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000728s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002421s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.000576s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002225s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003883s ]
SELECT * FROM `stock_search` WHERE `partno` = '388' LIMIT 1 [ RunTime:0.001307s ]
UPDATE `stock_search` SET `count` = 199 , `updatetime` = '2026-06-04 19:28:49' WHERE `partno` = '388' [ RunTime:0.001976s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000319s ]
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.001065s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001746s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.002309s ]
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 '388%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 180,20 [ RunTime:0.006067s ]
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 ('12182885','12182881','12182834','12182832','12182818','12182817','12182779','12182778','12182777','12182776','12182775','12182774','12182773','12182772','12182771','12182770','12182758','12182743','12182736','12182735') ORDER BY FIELD(s.id, 12182885,12182881,12182834,12182832,12182818,12182817,12182779,12182778,12182777,12182776,12182775,12182774,12182773,12182772,12182771,12182770,12182758,12182743,12182736,12182735) [ RunTime:0.008039s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182885 LIMIT 4 [ RunTime:0.004256s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182885 ORDER BY `minOrder` ASC [ RunTime:0.001586s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182885 ORDER BY `unit` DESC [ RunTime:0.001564s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182885 LIMIT 2 [ RunTime:0.002130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182885 ORDER BY `minOrder` ASC [ RunTime:0.004891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182881 LIMIT 4 [ RunTime:0.006735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182881 ORDER BY `minOrder` ASC [ RunTime:0.007024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182881 ORDER BY `unit` DESC [ RunTime:0.003857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182881 LIMIT 2 [ RunTime:0.002164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182881 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182834 LIMIT 4 [ RunTime:0.002401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182834 ORDER BY `minOrder` ASC [ RunTime:0.006337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182834 ORDER BY `unit` DESC [ RunTime:0.010956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182834 LIMIT 2 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182834 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182832 LIMIT 4 [ RunTime:0.005954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182832 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182832 ORDER BY `unit` DESC [ RunTime:0.004942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182832 LIMIT 2 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182832 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182818 LIMIT 4 [ RunTime:0.010954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182818 ORDER BY `minOrder` ASC [ RunTime:0.005290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182818 ORDER BY `unit` DESC [ RunTime:0.001971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182818 LIMIT 2 [ RunTime:0.006468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182818 ORDER BY `minOrder` ASC [ RunTime:0.005888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182817 LIMIT 4 [ RunTime:0.001786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182817 ORDER BY `minOrder` ASC [ RunTime:0.001707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182817 ORDER BY `unit` DESC [ RunTime:0.005887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182817 LIMIT 2 [ RunTime:0.006259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182817 ORDER BY `minOrder` ASC [ RunTime:0.001805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182779 LIMIT 4 [ RunTime:0.006298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182779 ORDER BY `minOrder` ASC [ RunTime:0.002713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182779 ORDER BY `unit` DESC [ RunTime:0.007155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182779 LIMIT 2 [ RunTime:0.006278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182779 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182778 LIMIT 4 [ RunTime:0.003602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182778 ORDER BY `minOrder` ASC [ RunTime:0.006480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182778 ORDER BY `unit` DESC [ RunTime:0.006550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182778 LIMIT 2 [ RunTime:0.010287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182778 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182777 LIMIT 4 [ RunTime:0.003622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182777 ORDER BY `minOrder` ASC [ RunTime:0.005414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182777 ORDER BY `unit` DESC [ RunTime:0.003309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182777 LIMIT 2 [ RunTime:0.002446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182777 ORDER BY `minOrder` ASC [ RunTime:0.003206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182776 LIMIT 4 [ RunTime:0.007648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182776 ORDER BY `minOrder` ASC [ RunTime:0.010174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182776 ORDER BY `unit` DESC [ RunTime:0.008176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182776 LIMIT 2 [ RunTime:0.005655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182776 ORDER BY `minOrder` ASC [ RunTime:0.003135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182775 LIMIT 4 [ RunTime:0.004218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182775 ORDER BY `minOrder` ASC [ RunTime:0.003722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182775 ORDER BY `unit` DESC [ RunTime:0.007122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182775 LIMIT 2 [ RunTime:0.011420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182775 ORDER BY `minOrder` ASC [ RunTime:0.002600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182774 LIMIT 4 [ RunTime:0.005184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182774 ORDER BY `minOrder` ASC [ RunTime:0.005003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182774 ORDER BY `unit` DESC [ RunTime:0.010291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182774 LIMIT 2 [ RunTime:0.006185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182774 ORDER BY `minOrder` ASC [ RunTime:0.006371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182773 LIMIT 4 [ RunTime:0.003936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182773 ORDER BY `minOrder` ASC [ RunTime:0.000971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182773 ORDER BY `unit` DESC [ RunTime:0.012693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182773 LIMIT 2 [ RunTime:0.002812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182773 ORDER BY `minOrder` ASC [ RunTime:0.003412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182772 LIMIT 4 [ RunTime:0.009932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182772 ORDER BY `minOrder` ASC [ RunTime:0.005139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182772 ORDER BY `unit` DESC [ RunTime:0.006244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182772 LIMIT 2 [ RunTime:0.003616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182772 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182771 LIMIT 4 [ RunTime:0.015149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182771 ORDER BY `minOrder` ASC [ RunTime:0.001146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182771 ORDER BY `unit` DESC [ RunTime:0.004128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182771 LIMIT 2 [ RunTime:0.003217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182771 ORDER BY `minOrder` ASC [ RunTime:0.005022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182770 LIMIT 4 [ RunTime:0.005795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182770 ORDER BY `minOrder` ASC [ RunTime:0.005874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182770 ORDER BY `unit` DESC [ RunTime:0.003384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182770 LIMIT 2 [ RunTime:0.004329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182770 ORDER BY `minOrder` ASC [ RunTime:0.004396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182758 LIMIT 4 [ RunTime:0.005834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182758 ORDER BY `minOrder` ASC [ RunTime:0.012071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182758 ORDER BY `unit` DESC [ RunTime:0.010708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182758 LIMIT 2 [ RunTime:0.006402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182758 ORDER BY `minOrder` ASC [ RunTime:0.002210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182743 LIMIT 4 [ RunTime:0.001203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182743 ORDER BY `minOrder` ASC [ RunTime:0.011941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182743 ORDER BY `unit` DESC [ RunTime:0.008087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182743 LIMIT 2 [ RunTime:0.003610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182743 ORDER BY `minOrder` ASC [ RunTime:0.002991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182736 LIMIT 4 [ RunTime:0.002566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182736 ORDER BY `minOrder` ASC [ RunTime:0.008935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182736 ORDER BY `unit` DESC [ RunTime:0.008272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182736 LIMIT 2 [ RunTime:0.010739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182736 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182735 LIMIT 4 [ RunTime:0.005809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182735 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182735 ORDER BY `unit` DESC [ RunTime:0.002868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182735 LIMIT 2 [ RunTime:0.005826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182735 ORDER BY `minOrder` ASC [ RunTime:0.002627s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000697s ]