SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001703s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001887s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001942s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002053s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001036s ]
UPDATE `stock_search` SET `count` = 796 , `updatetime` = '2026-06-05 06:52:30' WHERE `partno` = '210' [ RunTime:0.003581s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000290s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000216s ]
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.000420s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002303s ]
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.000545s ]
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 3740,20 [ RunTime:0.085646s ]
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 ('11930576','11930490','11930486','11930445','11930443','11930425','11930419','11928243','11927946','11927484','11927339','11927253','11927228','11927124','11926984','11926929','11926866','11926850','11926820','11926686') ORDER BY FIELD(s.id, 11930576,11930490,11930486,11930445,11930443,11930425,11930419,11928243,11927946,11927484,11927339,11927253,11927228,11927124,11926984,11926929,11926866,11926850,11926820,11926686) [ RunTime:0.008950s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11930576 LIMIT 4 [ RunTime:0.009593s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930576 ORDER BY `minOrder` ASC [ RunTime:0.005827s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11930576 ORDER BY `unit` DESC [ RunTime:0.009676s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11930576 LIMIT 2 [ RunTime:0.006246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930576 ORDER BY `minOrder` ASC [ RunTime:0.002348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11930490 LIMIT 4 [ RunTime:0.008049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930490 ORDER BY `minOrder` ASC [ RunTime:0.007248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11930490 ORDER BY `unit` DESC [ RunTime:0.003224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11930490 LIMIT 2 [ RunTime:0.011192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930490 ORDER BY `minOrder` ASC [ RunTime:0.003461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11930486 LIMIT 4 [ RunTime:0.005390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930486 ORDER BY `minOrder` ASC [ RunTime:0.010986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11930486 ORDER BY `unit` DESC [ RunTime:0.008539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11930486 LIMIT 2 [ RunTime:0.009545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930486 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11930445 LIMIT 4 [ RunTime:0.022483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930445 ORDER BY `minOrder` ASC [ RunTime:0.031158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11930445 ORDER BY `unit` DESC [ RunTime:0.017020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11930445 LIMIT 2 [ RunTime:0.019760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930445 ORDER BY `minOrder` ASC [ RunTime:0.003146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11930443 LIMIT 4 [ RunTime:0.009649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930443 ORDER BY `minOrder` ASC [ RunTime:0.003376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11930443 ORDER BY `unit` DESC [ RunTime:0.005244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11930443 LIMIT 2 [ RunTime:0.003951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930443 ORDER BY `minOrder` ASC [ RunTime:0.002474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11930425 LIMIT 4 [ RunTime:0.026423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930425 ORDER BY `minOrder` ASC [ RunTime:0.019335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11930425 ORDER BY `unit` DESC [ RunTime:0.008588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11930425 LIMIT 2 [ RunTime:0.020437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930425 ORDER BY `minOrder` ASC [ RunTime:0.005888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11930419 LIMIT 4 [ RunTime:0.023609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930419 ORDER BY `minOrder` ASC [ RunTime:0.030302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11930419 ORDER BY `unit` DESC [ RunTime:0.013985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11930419 LIMIT 2 [ RunTime:0.007394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11930419 ORDER BY `minOrder` ASC [ RunTime:0.002588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11928243 LIMIT 4 [ RunTime:0.008023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928243 ORDER BY `minOrder` ASC [ RunTime:0.002995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11928243 ORDER BY `unit` DESC [ RunTime:0.026663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11928243 LIMIT 2 [ RunTime:0.013192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11928243 ORDER BY `minOrder` ASC [ RunTime:0.017828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11927946 LIMIT 4 [ RunTime:0.014011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927946 ORDER BY `minOrder` ASC [ RunTime:0.008521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11927946 ORDER BY `unit` DESC [ RunTime:0.007377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11927946 LIMIT 2 [ RunTime:0.027730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927946 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11927484 LIMIT 4 [ RunTime:0.022931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927484 ORDER BY `minOrder` ASC [ RunTime:0.006857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11927484 ORDER BY `unit` DESC [ RunTime:0.022781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11927484 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927484 ORDER BY `minOrder` ASC [ RunTime:0.005636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11927339 LIMIT 4 [ RunTime:0.007469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927339 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11927339 ORDER BY `unit` DESC [ RunTime:0.016880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11927339 LIMIT 2 [ RunTime:0.017497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927339 ORDER BY `minOrder` ASC [ RunTime:0.014531s ]
select * from pdf where partno='210-83-624-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.013732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11927253 LIMIT 4 [ RunTime:0.014339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927253 ORDER BY `minOrder` ASC [ RunTime:0.010823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11927253 ORDER BY `unit` DESC [ RunTime:0.012061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11927253 LIMIT 2 [ RunTime:0.013200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927253 ORDER BY `minOrder` ASC [ RunTime:0.001248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11927228 LIMIT 4 [ RunTime:0.006222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927228 ORDER BY `minOrder` ASC [ RunTime:0.008668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11927228 ORDER BY `unit` DESC [ RunTime:0.007800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11927228 LIMIT 2 [ RunTime:0.006318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927228 ORDER BY `minOrder` ASC [ RunTime:0.004494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11927124 LIMIT 4 [ RunTime:0.012379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927124 ORDER BY `minOrder` ASC [ RunTime:0.002751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11927124 ORDER BY `unit` DESC [ RunTime:0.008369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11927124 LIMIT 2 [ RunTime:0.017715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11927124 ORDER BY `minOrder` ASC [ RunTime:0.003374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926984 LIMIT 4 [ RunTime:0.004020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926984 ORDER BY `minOrder` ASC [ RunTime:0.013881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926984 ORDER BY `unit` DESC [ RunTime:0.009414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926984 LIMIT 2 [ RunTime:0.019543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926984 ORDER BY `minOrder` ASC [ RunTime:0.018460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926929 LIMIT 4 [ RunTime:0.005970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926929 ORDER BY `minOrder` ASC [ RunTime:0.009128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926929 ORDER BY `unit` DESC [ RunTime:0.028164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926929 LIMIT 2 [ RunTime:0.007830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926929 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926866 LIMIT 4 [ RunTime:0.008458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926866 ORDER BY `minOrder` ASC [ RunTime:0.013277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926866 ORDER BY `unit` DESC [ RunTime:0.006400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926866 LIMIT 2 [ RunTime:0.010141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926866 ORDER BY `minOrder` ASC [ RunTime:0.006347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926850 LIMIT 4 [ RunTime:0.010025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926850 ORDER BY `minOrder` ASC [ RunTime:0.003559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926850 ORDER BY `unit` DESC [ RunTime:0.011437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926850 LIMIT 2 [ RunTime:0.012310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926850 ORDER BY `minOrder` ASC [ RunTime:0.003961s ]
select * from pdf where partno='210-83-314-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.003758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926820 LIMIT 4 [ RunTime:0.007377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926820 ORDER BY `minOrder` ASC [ RunTime:0.002391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926820 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926820 LIMIT 2 [ RunTime:0.006322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926820 ORDER BY `minOrder` ASC [ RunTime:0.002261s ]
select * from pdf where partno='210-87-422-41-001101' and brandshort='Preci-Dip' limit 1 [ RunTime:0.002952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926686 LIMIT 4 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926686 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926686 ORDER BY `unit` DESC [ RunTime:0.002208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926686 LIMIT 2 [ RunTime:0.004380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926686 ORDER BY `minOrder` ASC [ RunTime:0.006247s ]
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.000600s ]