SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001983s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000484s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001451s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.006455s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001228s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000230s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001308s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ12A' LIMIT 1 [ RunTime:0.005826s ]
UPDATE `stock_search` SET `count` = 10804 , `updatetime` = '2026-04-28 06:57:00' WHERE `partno` = 'SMAJ12A' [ RunTime:0.001999s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003180s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001186s ]
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.001444s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002243s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMAJ12A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.028337s ]
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 'SMAJ12A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.108428s ]
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 ('14801827','13904278','16671395','13904274','13910313','13907987','13905538','13905639','16687712','14799503','16687367','14799729','14814753','13927494','16663707','13905858','14827907','13928543','14812715','14801644') ORDER BY FIELD(s.id, 14801827,13904278,16671395,13904274,13910313,13907987,13905538,13905639,16687712,14799503,16687367,14799729,14814753,13927494,16663707,13905858,14827907,13928543,14812715,14801644) [ RunTime:0.090089s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801827 LIMIT 4 [ RunTime:0.019358s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801827 ORDER BY `minOrder` ASC [ RunTime:0.026190s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801827 ORDER BY `unit` DESC [ RunTime:0.004668s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801827 LIMIT 2 [ RunTime:0.012795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801827 ORDER BY `minOrder` ASC [ RunTime:0.011283s ]
select * from pdf where partno='SMAJ12A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.022046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904278 LIMIT 4 [ RunTime:0.014967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904278 ORDER BY `minOrder` ASC [ RunTime:0.009542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904278 ORDER BY `unit` DESC [ RunTime:0.026487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904278 LIMIT 2 [ RunTime:0.002311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904278 ORDER BY `minOrder` ASC [ RunTime:0.004649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671395 LIMIT 4 [ RunTime:0.004441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671395 ORDER BY `minOrder` ASC [ RunTime:0.002768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671395 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671395 LIMIT 2 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671395 ORDER BY `minOrder` ASC [ RunTime:0.007323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904274 LIMIT 4 [ RunTime:0.002964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904274 ORDER BY `minOrder` ASC [ RunTime:0.001193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904274 ORDER BY `unit` DESC [ RunTime:0.004469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904274 LIMIT 2 [ RunTime:0.002060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904274 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='SMAJ12A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910313 LIMIT 4 [ RunTime:0.002431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910313 ORDER BY `minOrder` ASC [ RunTime:0.001825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910313 ORDER BY `unit` DESC [ RunTime:0.002114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910313 LIMIT 2 [ RunTime:0.004191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910313 ORDER BY `minOrder` ASC [ RunTime:0.005642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907987 LIMIT 4 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907987 ORDER BY `minOrder` ASC [ RunTime:0.003238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907987 ORDER BY `unit` DESC [ RunTime:0.000766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907987 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907987 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905538 LIMIT 4 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905538 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905538 ORDER BY `unit` DESC [ RunTime:0.002852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905538 LIMIT 2 [ RunTime:0.004103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905538 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905639 LIMIT 4 [ RunTime:0.001292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905639 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905639 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905639 LIMIT 2 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905639 ORDER BY `minOrder` ASC [ RunTime:0.002321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687712 LIMIT 4 [ RunTime:0.008292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687712 ORDER BY `minOrder` ASC [ RunTime:0.004573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687712 ORDER BY `unit` DESC [ RunTime:0.004469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687712 LIMIT 2 [ RunTime:0.010241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687712 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799503 LIMIT 4 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799503 ORDER BY `minOrder` ASC [ RunTime:0.004029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799503 ORDER BY `unit` DESC [ RunTime:0.015105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799503 LIMIT 2 [ RunTime:0.024208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799503 ORDER BY `minOrder` ASC [ RunTime:0.006205s ]
select * from pdf where partno='SMAJ12A-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.020007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687367 LIMIT 4 [ RunTime:0.024484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687367 ORDER BY `minOrder` ASC [ RunTime:0.053498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687367 ORDER BY `unit` DESC [ RunTime:0.017959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687367 LIMIT 2 [ RunTime:0.022217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687367 ORDER BY `minOrder` ASC [ RunTime:0.029579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799729 LIMIT 4 [ RunTime:0.018515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799729 ORDER BY `minOrder` ASC [ RunTime:0.009561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799729 ORDER BY `unit` DESC [ RunTime:0.035119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799729 LIMIT 2 [ RunTime:0.020525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799729 ORDER BY `minOrder` ASC [ RunTime:0.004672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814753 LIMIT 4 [ RunTime:0.015343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814753 ORDER BY `minOrder` ASC [ RunTime:0.017739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814753 ORDER BY `unit` DESC [ RunTime:0.009800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814753 LIMIT 2 [ RunTime:0.014909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814753 ORDER BY `minOrder` ASC [ RunTime:0.043217s ]
select * from pdf where partno='SMAJ12A-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.033099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13927494 LIMIT 4 [ RunTime:0.010835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927494 ORDER BY `minOrder` ASC [ RunTime:0.003142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13927494 ORDER BY `unit` DESC [ RunTime:0.007344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13927494 LIMIT 2 [ RunTime:0.015816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927494 ORDER BY `minOrder` ASC [ RunTime:0.003709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663707 LIMIT 4 [ RunTime:0.106074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663707 ORDER BY `minOrder` ASC [ RunTime:0.048052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663707 ORDER BY `unit` DESC [ RunTime:0.054427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663707 LIMIT 2 [ RunTime:0.026667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663707 ORDER BY `minOrder` ASC [ RunTime:0.008170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905858 LIMIT 4 [ RunTime:0.009872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905858 ORDER BY `minOrder` ASC [ RunTime:0.042488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905858 ORDER BY `unit` DESC [ RunTime:0.004081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905858 LIMIT 2 [ RunTime:0.008802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905858 ORDER BY `minOrder` ASC [ RunTime:0.007421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827907 LIMIT 4 [ RunTime:0.028144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827907 ORDER BY `minOrder` ASC [ RunTime:0.003493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827907 ORDER BY `unit` DESC [ RunTime:0.009879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827907 LIMIT 2 [ RunTime:0.015555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827907 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928543 LIMIT 4 [ RunTime:0.015909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928543 ORDER BY `minOrder` ASC [ RunTime:0.006266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928543 ORDER BY `unit` DESC [ RunTime:0.010214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928543 LIMIT 2 [ RunTime:0.035732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928543 ORDER BY `minOrder` ASC [ RunTime:0.035853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812715 LIMIT 4 [ RunTime:0.013064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812715 ORDER BY `minOrder` ASC [ RunTime:0.003143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812715 ORDER BY `unit` DESC [ RunTime:0.012409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812715 LIMIT 2 [ RunTime:0.000924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812715 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801644 LIMIT 4 [ RunTime:0.001179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801644 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801644 ORDER BY `unit` DESC [ RunTime:0.007799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801644 LIMIT 2 [ RunTime:0.011043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801644 ORDER BY `minOrder` ASC [ RunTime:0.001394s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMAJ12A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.017541s ]