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.051580s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002669s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.028266s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003152s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.020325s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003015s ]
SELECT * FROM `stock_search` WHERE `partno` = '5015' LIMIT 1 [ RunTime:0.017439s ]
UPDATE `stock_search` SET `count` = 11881 , `updatetime` = '2026-04-25 13:43:28' WHERE `partno` = '5015' [ RunTime:0.041174s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.039072s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.066355s ]
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.052794s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001616s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '5015%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.063340s ]
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 '5015%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 80,20 [ RunTime:0.052898s ]
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 ('11611560','11611238','11611220','11608516','11608315','11603644','11603405','11603157','11603133','11603009','11602802','11602723','11602499','11602015','11601605') ORDER BY FIELD(s.id, 11611560,11611238,11611220,11608516,11608315,11603644,11603405,11603157,11603133,11603009,11602802,11602723,11602499,11602015,11601605) [ RunTime:0.234754s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611560 LIMIT 4 [ RunTime:0.051722s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611560 ORDER BY `minOrder` ASC [ RunTime:0.022003s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611560 ORDER BY `unit` DESC [ RunTime:0.116674s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611560 LIMIT 2 [ RunTime:0.096037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611560 ORDER BY `minOrder` ASC [ RunTime:0.041841s ]
select * from pdf where partno='5015912611' and brandshort='Molex' limit 1 [ RunTime:0.051509s ]
select foldpath,foldpath2,filename from pdf_file where id=852979 limit 1 [ RunTime:0.075489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611238 LIMIT 4 [ RunTime:0.051209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611238 ORDER BY `minOrder` ASC [ RunTime:0.050744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611238 ORDER BY `unit` DESC [ RunTime:0.051472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611238 LIMIT 2 [ RunTime:0.051337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611238 ORDER BY `minOrder` ASC [ RunTime:0.050844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611220 LIMIT 4 [ RunTime:0.063866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611220 ORDER BY `minOrder` ASC [ RunTime:0.024371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611220 ORDER BY `unit` DESC [ RunTime:0.050948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611220 LIMIT 2 [ RunTime:0.035083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611220 ORDER BY `minOrder` ASC [ RunTime:0.027655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11608516 LIMIT 4 [ RunTime:0.061721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608516 ORDER BY `minOrder` ASC [ RunTime:0.155527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11608516 ORDER BY `unit` DESC [ RunTime:0.041587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11608516 LIMIT 2 [ RunTime:0.038633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608516 ORDER BY `minOrder` ASC [ RunTime:0.012661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11608315 LIMIT 4 [ RunTime:0.019433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608315 ORDER BY `minOrder` ASC [ RunTime:0.018677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11608315 ORDER BY `unit` DESC [ RunTime:0.034938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11608315 LIMIT 2 [ RunTime:0.103859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608315 ORDER BY `minOrder` ASC [ RunTime:0.050972s ]
select * from pdf where partno='5015913011' and brandshort='Molex' limit 1 [ RunTime:0.051036s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.050609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603644 LIMIT 4 [ RunTime:0.050927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603644 ORDER BY `minOrder` ASC [ RunTime:0.138899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11603644 ORDER BY `unit` DESC [ RunTime:0.077617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11603644 LIMIT 2 [ RunTime:0.083691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603644 ORDER BY `minOrder` ASC [ RunTime:0.032741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603405 LIMIT 4 [ RunTime:0.052391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603405 ORDER BY `minOrder` ASC [ RunTime:0.112041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11603405 ORDER BY `unit` DESC [ RunTime:0.132310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11603405 LIMIT 2 [ RunTime:0.100917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603405 ORDER BY `minOrder` ASC [ RunTime:0.037136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603157 LIMIT 4 [ RunTime:0.058060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603157 ORDER BY `minOrder` ASC [ RunTime:0.054535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11603157 ORDER BY `unit` DESC [ RunTime:0.050917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11603157 LIMIT 2 [ RunTime:0.052889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603157 ORDER BY `minOrder` ASC [ RunTime:0.063100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603133 LIMIT 4 [ RunTime:0.039930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603133 ORDER BY `minOrder` ASC [ RunTime:0.033960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11603133 ORDER BY `unit` DESC [ RunTime:0.018689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11603133 LIMIT 2 [ RunTime:0.063402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603133 ORDER BY `minOrder` ASC [ RunTime:0.069269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11603009 LIMIT 4 [ RunTime:0.021989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603009 ORDER BY `minOrder` ASC [ RunTime:0.016848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11603009 ORDER BY `unit` DESC [ RunTime:0.040277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11603009 LIMIT 2 [ RunTime:0.031373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11603009 ORDER BY `minOrder` ASC [ RunTime:0.039608s ]
select * from pdf where partno='5015917011' and brandshort='Molex' limit 1 [ RunTime:0.042787s ]
select foldpath,foldpath2,filename from pdf_file where id=852984 limit 1 [ RunTime:0.060517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11602802 LIMIT 4 [ RunTime:0.051509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602802 ORDER BY `minOrder` ASC [ RunTime:0.051039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11602802 ORDER BY `unit` DESC [ RunTime:0.050936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11602802 LIMIT 2 [ RunTime:0.079753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602802 ORDER BY `minOrder` ASC [ RunTime:0.035447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11602723 LIMIT 4 [ RunTime:0.076528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602723 ORDER BY `minOrder` ASC [ RunTime:0.050539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11602723 ORDER BY `unit` DESC [ RunTime:0.032453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11602723 LIMIT 2 [ RunTime:0.053342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602723 ORDER BY `minOrder` ASC [ RunTime:0.021488s ]
select * from pdf where partno='5015912011' and brandshort='Molex' limit 1 [ RunTime:0.153306s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.106090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11602499 LIMIT 4 [ RunTime:0.055484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602499 ORDER BY `minOrder` ASC [ RunTime:0.077028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11602499 ORDER BY `unit` DESC [ RunTime:0.042865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11602499 LIMIT 2 [ RunTime:0.092327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602499 ORDER BY `minOrder` ASC [ RunTime:0.034664s ]
select * from pdf where partno='5015914011' and brandshort='Molex' limit 1 [ RunTime:0.016068s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.028547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11602015 LIMIT 4 [ RunTime:0.053619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602015 ORDER BY `minOrder` ASC [ RunTime:0.088967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11602015 ORDER BY `unit` DESC [ RunTime:0.066571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11602015 LIMIT 2 [ RunTime:0.052405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602015 ORDER BY `minOrder` ASC [ RunTime:0.026589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11601605 LIMIT 4 [ RunTime:0.003540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601605 ORDER BY `minOrder` ASC [ RunTime:0.008956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11601605 ORDER BY `unit` DESC [ RunTime:0.006395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11601605 LIMIT 2 [ RunTime:0.047892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601605 ORDER BY `minOrder` ASC [ RunTime:0.019443s ]
select * from pdf where partno='5015915011' and brandshort='Molex' limit 1 [ RunTime:0.049378s ]
select foldpath,foldpath2,filename from pdf_file where id=852982 limit 1 [ RunTime:0.009570s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '5015%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.024281s ]