SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002530s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003763s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002528s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002144s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004847s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001991s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ12CA' LIMIT 1 [ RunTime:0.024658s ]
UPDATE `stock_search` SET `count` = 9786 , `updatetime` = '2026-04-28 05:09:33' WHERE `partno` = 'SMAJ12CA' [ RunTime:0.001536s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008901s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000377s ]
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.017321s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002678s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMAJ12CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.002848s ]
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 'SMAJ12CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.033911s ]
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 ('16688114','16662954','13926821','16663953','16685798','14828647','14800644','14803306','13907782','4882','16692293','16671373','16669767','14832123','14829135','14808606','14807140','14805494','14805021','13932711') ORDER BY FIELD(s.id, 16688114,16662954,13926821,16663953,16685798,14828647,14800644,14803306,13907782,4882,16692293,16671373,16669767,14832123,14829135,14808606,14807140,14805494,14805021,13932711) [ RunTime:0.044667s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688114 LIMIT 4 [ RunTime:0.012523s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688114 ORDER BY `minOrder` ASC [ RunTime:0.009809s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688114 ORDER BY `unit` DESC [ RunTime:0.002424s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688114 LIMIT 2 [ RunTime:0.008927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688114 ORDER BY `minOrder` ASC [ RunTime:0.003338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662954 LIMIT 4 [ RunTime:0.002040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662954 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662954 ORDER BY `unit` DESC [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662954 LIMIT 2 [ RunTime:0.003018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662954 ORDER BY `minOrder` ASC [ RunTime:0.001846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926821 LIMIT 4 [ RunTime:0.015793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926821 ORDER BY `minOrder` ASC [ RunTime:0.005961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926821 ORDER BY `unit` DESC [ RunTime:0.003846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926821 LIMIT 2 [ RunTime:0.011881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926821 ORDER BY `minOrder` ASC [ RunTime:0.011332s ]
select * from pdf where partno='SMAJ12CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663953 LIMIT 4 [ RunTime:0.001515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663953 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663953 ORDER BY `unit` DESC [ RunTime:0.003990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663953 LIMIT 2 [ RunTime:0.030807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663953 ORDER BY `minOrder` ASC [ RunTime:0.007443s ]
select * from pdf where partno='SMAJ12CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685798 LIMIT 4 [ RunTime:0.012515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685798 ORDER BY `minOrder` ASC [ RunTime:0.012259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685798 ORDER BY `unit` DESC [ RunTime:0.001241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685798 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685798 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828647 LIMIT 4 [ RunTime:0.005223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828647 ORDER BY `minOrder` ASC [ RunTime:0.027829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828647 ORDER BY `unit` DESC [ RunTime:0.012128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828647 LIMIT 2 [ RunTime:0.014433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828647 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800644 LIMIT 4 [ RunTime:0.008082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800644 ORDER BY `minOrder` ASC [ RunTime:0.013736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800644 ORDER BY `unit` DESC [ RunTime:0.007114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800644 LIMIT 2 [ RunTime:0.008315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800644 ORDER BY `minOrder` ASC [ RunTime:0.006530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803306 LIMIT 4 [ RunTime:0.005077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803306 ORDER BY `minOrder` ASC [ RunTime:0.000818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803306 ORDER BY `unit` DESC [ RunTime:0.024956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803306 LIMIT 2 [ RunTime:0.001951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803306 ORDER BY `minOrder` ASC [ RunTime:0.006965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907782 LIMIT 4 [ RunTime:0.025373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907782 ORDER BY `minOrder` ASC [ RunTime:0.007766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907782 ORDER BY `unit` DESC [ RunTime:0.017130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907782 LIMIT 2 [ RunTime:0.049254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907782 ORDER BY `minOrder` ASC [ RunTime:0.005198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4882 LIMIT 4 [ RunTime:0.023563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4882 ORDER BY `minOrder` ASC [ RunTime:0.020435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4882 ORDER BY `unit` DESC [ RunTime:0.011757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4882 LIMIT 2 [ RunTime:0.029258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4882 ORDER BY `minOrder` ASC [ RunTime:0.002966s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ12CA' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.008609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692293 LIMIT 4 [ RunTime:0.003998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692293 ORDER BY `minOrder` ASC [ RunTime:0.018762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692293 ORDER BY `unit` DESC [ RunTime:0.007991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692293 LIMIT 2 [ RunTime:0.007960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692293 ORDER BY `minOrder` ASC [ RunTime:0.005437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671373 LIMIT 4 [ RunTime:0.002278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671373 ORDER BY `minOrder` ASC [ RunTime:0.001412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671373 ORDER BY `unit` DESC [ RunTime:0.000913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671373 LIMIT 2 [ RunTime:0.000587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671373 ORDER BY `minOrder` ASC [ RunTime:0.000239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669767 LIMIT 4 [ RunTime:0.004946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669767 ORDER BY `minOrder` ASC [ RunTime:0.016583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669767 ORDER BY `unit` DESC [ RunTime:0.018969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669767 LIMIT 2 [ RunTime:0.018584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669767 ORDER BY `minOrder` ASC [ RunTime:0.002355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832123 LIMIT 4 [ RunTime:0.009558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832123 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832123 ORDER BY `unit` DESC [ RunTime:0.010682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832123 LIMIT 2 [ RunTime:0.025348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832123 ORDER BY `minOrder` ASC [ RunTime:0.012903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829135 LIMIT 4 [ RunTime:0.002009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829135 ORDER BY `minOrder` ASC [ RunTime:0.006235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829135 ORDER BY `unit` DESC [ RunTime:0.015213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829135 LIMIT 2 [ RunTime:0.010753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829135 ORDER BY `minOrder` ASC [ RunTime:0.006108s ]
select * from pdf where partno='SMAJ12CAHE3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808606 LIMIT 4 [ RunTime:0.005597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808606 ORDER BY `minOrder` ASC [ RunTime:0.009443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808606 ORDER BY `unit` DESC [ RunTime:0.009194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808606 LIMIT 2 [ RunTime:0.009568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808606 ORDER BY `minOrder` ASC [ RunTime:0.003804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807140 LIMIT 4 [ RunTime:0.011030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807140 ORDER BY `minOrder` ASC [ RunTime:0.003959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807140 ORDER BY `unit` DESC [ RunTime:0.004690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807140 LIMIT 2 [ RunTime:0.021798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807140 ORDER BY `minOrder` ASC [ RunTime:0.006720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805494 LIMIT 4 [ RunTime:0.011083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805494 ORDER BY `minOrder` ASC [ RunTime:0.002692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805494 ORDER BY `unit` DESC [ RunTime:0.006326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805494 LIMIT 2 [ RunTime:0.001783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805494 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805021 LIMIT 4 [ RunTime:0.001920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805021 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805021 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805021 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805021 ORDER BY `minOrder` ASC [ RunTime:0.008743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932711 LIMIT 4 [ RunTime:0.003429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932711 ORDER BY `minOrder` ASC [ RunTime:0.017602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932711 ORDER BY `unit` DESC [ RunTime:0.006434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932711 LIMIT 2 [ RunTime:0.002997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932711 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMAJ12CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.003549s ]