SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002936s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004719s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003017s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.202' ) [ RunTime:0.003780s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001300s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011636s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.008547s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TLP521-4' LIMIT 1 [ RunTime:0.012173s ]
UPDATE `stock_search` SET `count` = 17336 , `updatetime` = '2026-06-01 08:24:21' WHERE `partno` = 'TLP521-4' [ RunTime:0.006486s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000768s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001927s ]
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.005846s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002985s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'TLP521-4%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.005473s ]
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 'TLP521-4%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.021988s ]
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 ('25650929','25650920','25650912','25650905','25650904','25650876','25650872','25650786','25650762','25650754','18694095','18694092','18694083','18694022','18694016','18694012','18694011','18693930','18693900','18693882') ORDER BY FIELD(s.id, 25650929,25650920,25650912,25650905,25650904,25650876,25650872,25650786,25650762,25650754,18694095,18694092,18694083,18694022,18694016,18694012,18694011,18693930,18693900,18693882) [ RunTime:0.052349s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650929 LIMIT 4 [ RunTime:0.005148s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650929 ORDER BY `minOrder` ASC [ RunTime:0.003129s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650929 ORDER BY `unit` DESC [ RunTime:0.032188s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650929 LIMIT 2 [ RunTime:0.016439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650929 ORDER BY `minOrder` ASC [ RunTime:0.013351s ]
select * from pdf where partno='TLP521-4BLSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.028123s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4BLSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.026974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650920 LIMIT 4 [ RunTime:0.041567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650920 ORDER BY `minOrder` ASC [ RunTime:0.022353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650920 ORDER BY `unit` DESC [ RunTime:0.019657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650920 LIMIT 2 [ RunTime:0.009491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650920 ORDER BY `minOrder` ASC [ RunTime:0.009074s ]
select * from pdf where partno='TLP521-4GBG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.008336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4GBG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.005505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650912 LIMIT 4 [ RunTime:0.002704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650912 ORDER BY `minOrder` ASC [ RunTime:0.003715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650912 ORDER BY `unit` DESC [ RunTime:0.003596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650912 LIMIT 2 [ RunTime:0.018392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650912 ORDER BY `minOrder` ASC [ RunTime:0.013097s ]
select * from pdf where partno='TLP521-4GRSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.002794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4GRSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650905 LIMIT 4 [ RunTime:0.002704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650905 ORDER BY `minOrder` ASC [ RunTime:0.020360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650905 ORDER BY `unit` DESC [ RunTime:0.026407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650905 LIMIT 2 [ RunTime:0.021252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650905 ORDER BY `minOrder` ASC [ RunTime:0.011458s ]
select * from pdf where partno='TLP521-4GBSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.017645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4GBSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.010765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650904 LIMIT 4 [ RunTime:0.006585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650904 ORDER BY `minOrder` ASC [ RunTime:0.003051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650904 ORDER BY `unit` DESC [ RunTime:0.010105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650904 LIMIT 2 [ RunTime:0.012252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650904 ORDER BY `minOrder` ASC [ RunTime:0.014128s ]
select * from pdf where partno='TLP521-4G' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.013936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4G' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.021559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650876 LIMIT 4 [ RunTime:0.049922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650876 ORDER BY `minOrder` ASC [ RunTime:0.018742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650876 ORDER BY `unit` DESC [ RunTime:0.010741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650876 LIMIT 2 [ RunTime:0.002468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650876 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
select * from pdf where partno='TLP521-4GRG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.004055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4GRG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.003727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650872 LIMIT 4 [ RunTime:0.003520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650872 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650872 ORDER BY `unit` DESC [ RunTime:0.007810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650872 LIMIT 2 [ RunTime:0.016025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650872 ORDER BY `minOrder` ASC [ RunTime:0.018097s ]
select * from pdf where partno='TLP521-4SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.005436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.002855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650786 LIMIT 4 [ RunTime:0.001655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650786 ORDER BY `minOrder` ASC [ RunTime:0.005547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650786 ORDER BY `unit` DESC [ RunTime:0.004480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650786 LIMIT 2 [ RunTime:0.012479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650786 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='TLP521-4BL' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.007096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4BL' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650762 LIMIT 4 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650762 ORDER BY `minOrder` ASC [ RunTime:0.010873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650762 ORDER BY `unit` DESC [ RunTime:0.008211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650762 LIMIT 2 [ RunTime:0.007636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650762 ORDER BY `minOrder` ASC [ RunTime:0.016549s ]
select * from pdf where partno='TLP521-4' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.000971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25650754 LIMIT 4 [ RunTime:0.028343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650754 ORDER BY `minOrder` ASC [ RunTime:0.010633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25650754 ORDER BY `unit` DESC [ RunTime:0.010676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25650754 LIMIT 2 [ RunTime:0.003012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25650754 ORDER BY `minOrder` ASC [ RunTime:0.003408s ]
select * from pdf where partno='TLP521-4GB' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.000866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLP521-4GB' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.007289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694095 LIMIT 4 [ RunTime:0.027475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694095 ORDER BY `minOrder` ASC [ RunTime:0.012856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694095 ORDER BY `unit` DESC [ RunTime:0.008122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694095 LIMIT 2 [ RunTime:0.002637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694095 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694092 LIMIT 4 [ RunTime:0.002910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694092 ORDER BY `minOrder` ASC [ RunTime:0.020065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694092 ORDER BY `unit` DESC [ RunTime:0.018445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694092 LIMIT 2 [ RunTime:0.005033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694092 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694083 LIMIT 4 [ RunTime:0.003632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694083 ORDER BY `minOrder` ASC [ RunTime:0.003205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694083 ORDER BY `unit` DESC [ RunTime:0.011502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694083 LIMIT 2 [ RunTime:0.010218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694083 ORDER BY `minOrder` ASC [ RunTime:0.009662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694022 LIMIT 4 [ RunTime:0.017438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694022 ORDER BY `minOrder` ASC [ RunTime:0.005767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694022 ORDER BY `unit` DESC [ RunTime:0.002779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694022 LIMIT 2 [ RunTime:0.007629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694022 ORDER BY `minOrder` ASC [ RunTime:0.012864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694016 LIMIT 4 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694016 ORDER BY `minOrder` ASC [ RunTime:0.012405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694016 ORDER BY `unit` DESC [ RunTime:0.016217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694016 LIMIT 2 [ RunTime:0.007868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694016 ORDER BY `minOrder` ASC [ RunTime:0.012192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694012 LIMIT 4 [ RunTime:0.029790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694012 ORDER BY `minOrder` ASC [ RunTime:0.017167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694012 ORDER BY `unit` DESC [ RunTime:0.015560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694012 LIMIT 2 [ RunTime:0.015039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694012 ORDER BY `minOrder` ASC [ RunTime:0.003485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694011 LIMIT 4 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694011 ORDER BY `minOrder` ASC [ RunTime:0.015803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694011 ORDER BY `unit` DESC [ RunTime:0.039303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694011 LIMIT 2 [ RunTime:0.012167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694011 ORDER BY `minOrder` ASC [ RunTime:0.008644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693930 LIMIT 4 [ RunTime:0.004472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693930 ORDER BY `minOrder` ASC [ RunTime:0.020436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693930 ORDER BY `unit` DESC [ RunTime:0.009555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693930 LIMIT 2 [ RunTime:0.016602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693930 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693900 LIMIT 4 [ RunTime:0.010817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693900 ORDER BY `minOrder` ASC [ RunTime:0.001897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693900 ORDER BY `unit` DESC [ RunTime:0.003176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693900 LIMIT 2 [ RunTime:0.016909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693900 ORDER BY `minOrder` ASC [ RunTime:0.015368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693882 LIMIT 4 [ RunTime:0.030321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693882 ORDER BY `minOrder` ASC [ RunTime:0.002514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693882 ORDER BY `unit` DESC [ RunTime:0.008168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693882 LIMIT 2 [ RunTime:0.005231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693882 ORDER BY `minOrder` ASC [ RunTime:0.002616s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'TLP521-4%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000291s ]