SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002147s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008682s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001010s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.023267s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001614s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.018430s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001159s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ6.0CA' LIMIT 1 [ RunTime:0.024255s ]
UPDATE `stock_search` SET `count` = 13824 , `updatetime` = '2026-04-27 22:10:24' WHERE `partno` = 'SMAJ6.0CA' [ RunTime:0.027089s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.012472s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004440s ]
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.009741s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002650s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMAJ6.0CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.026051s ]
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 'SMAJ6.0CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.051488s ]
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 ('16675831','16670630','16668864','16668462','16665619','14831791','14829685','14829186','14810497','14810214','14809506','14809494','14808220','14807593','14807162','14805486','14804474','13921056','13912546','13912154') ORDER BY FIELD(s.id, 16675831,16670630,16668864,16668462,16665619,14831791,14829685,14829186,14810497,14810214,14809506,14809494,14808220,14807593,14807162,14805486,14804474,13921056,13912546,13912154) [ RunTime:0.039477s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675831 LIMIT 4 [ RunTime:0.017543s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675831 ORDER BY `minOrder` ASC [ RunTime:0.011880s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675831 ORDER BY `unit` DESC [ RunTime:0.001889s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675831 LIMIT 2 [ RunTime:0.004727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675831 ORDER BY `minOrder` ASC [ RunTime:0.013558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670630 LIMIT 4 [ RunTime:0.032369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670630 ORDER BY `minOrder` ASC [ RunTime:0.011704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670630 ORDER BY `unit` DESC [ RunTime:0.013622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670630 LIMIT 2 [ RunTime:0.016402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670630 ORDER BY `minOrder` ASC [ RunTime:0.015586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668864 LIMIT 4 [ RunTime:0.044407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668864 ORDER BY `minOrder` ASC [ RunTime:0.019039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668864 ORDER BY `unit` DESC [ RunTime:0.026491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668864 LIMIT 2 [ RunTime:0.012495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668864 ORDER BY `minOrder` ASC [ RunTime:0.009412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668462 LIMIT 4 [ RunTime:0.006398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668462 ORDER BY `minOrder` ASC [ RunTime:0.002575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668462 ORDER BY `unit` DESC [ RunTime:0.025903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668462 LIMIT 2 [ RunTime:0.007615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668462 ORDER BY `minOrder` ASC [ RunTime:0.002295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665619 LIMIT 4 [ RunTime:0.002194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665619 ORDER BY `minOrder` ASC [ RunTime:0.003599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665619 ORDER BY `unit` DESC [ RunTime:0.003907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665619 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665619 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831791 LIMIT 4 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831791 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831791 ORDER BY `unit` DESC [ RunTime:0.018729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831791 LIMIT 2 [ RunTime:0.005730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831791 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829685 LIMIT 4 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829685 ORDER BY `minOrder` ASC [ RunTime:0.014458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829685 ORDER BY `unit` DESC [ RunTime:0.014498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829685 LIMIT 2 [ RunTime:0.014956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829685 ORDER BY `minOrder` ASC [ RunTime:0.011252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829186 LIMIT 4 [ RunTime:0.005260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829186 ORDER BY `minOrder` ASC [ RunTime:0.008578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829186 ORDER BY `unit` DESC [ RunTime:0.017910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829186 LIMIT 2 [ RunTime:0.015486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829186 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810497 LIMIT 4 [ RunTime:0.002155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810497 ORDER BY `minOrder` ASC [ RunTime:0.003619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810497 ORDER BY `unit` DESC [ RunTime:0.006715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810497 LIMIT 2 [ RunTime:0.006569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810497 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810214 LIMIT 4 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810214 ORDER BY `minOrder` ASC [ RunTime:0.004996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810214 ORDER BY `unit` DESC [ RunTime:0.002662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810214 LIMIT 2 [ RunTime:0.002499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810214 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809506 LIMIT 4 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809506 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809506 ORDER BY `unit` DESC [ RunTime:0.013239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809506 LIMIT 2 [ RunTime:0.003305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809506 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809494 LIMIT 4 [ RunTime:0.001107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809494 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809494 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809494 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809494 ORDER BY `minOrder` ASC [ RunTime:0.007638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808220 LIMIT 4 [ RunTime:0.015902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808220 ORDER BY `minOrder` ASC [ RunTime:0.005043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808220 ORDER BY `unit` DESC [ RunTime:0.000966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808220 LIMIT 2 [ RunTime:0.001216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808220 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807593 LIMIT 4 [ RunTime:0.008892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807593 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807593 ORDER BY `unit` DESC [ RunTime:0.011488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807593 LIMIT 2 [ RunTime:0.003928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807593 ORDER BY `minOrder` ASC [ RunTime:0.006062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807162 LIMIT 4 [ RunTime:0.000866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807162 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807162 ORDER BY `unit` DESC [ RunTime:0.003605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807162 LIMIT 2 [ RunTime:0.013991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807162 ORDER BY `minOrder` ASC [ RunTime:0.005133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805486 LIMIT 4 [ RunTime:0.003301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805486 ORDER BY `minOrder` ASC [ RunTime:0.010984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805486 ORDER BY `unit` DESC [ RunTime:0.005730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805486 LIMIT 2 [ RunTime:0.005284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805486 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804474 LIMIT 4 [ RunTime:0.003470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804474 ORDER BY `minOrder` ASC [ RunTime:0.010923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14804474 ORDER BY `unit` DESC [ RunTime:0.004262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14804474 LIMIT 2 [ RunTime:0.016729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804474 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921056 LIMIT 4 [ RunTime:0.010622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921056 ORDER BY `minOrder` ASC [ RunTime:0.011971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921056 ORDER BY `unit` DESC [ RunTime:0.007218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921056 LIMIT 2 [ RunTime:0.022317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921056 ORDER BY `minOrder` ASC [ RunTime:0.012318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912546 LIMIT 4 [ RunTime:0.008216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912546 ORDER BY `minOrder` ASC [ RunTime:0.002673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912546 ORDER BY `unit` DESC [ RunTime:0.002774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912546 LIMIT 2 [ RunTime:0.001556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912546 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912154 LIMIT 4 [ RunTime:0.004239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912154 ORDER BY `minOrder` ASC [ RunTime:0.016055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912154 ORDER BY `unit` DESC [ RunTime:0.007444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912154 LIMIT 2 [ RunTime:0.009006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912154 ORDER BY `minOrder` ASC [ RunTime:0.006021s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMAJ6.0CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.003154s ]