SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001706s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000539s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001225s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.43' ) [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001011s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000230s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 22 [ RunTime:0.000172s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (132,133,134,135,136,137,138,139,140,141) [ RunTime:0.000210s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001911s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `status` <> 2 AND `categoryid` IN (132,133,134,135,136,137,138,139,140,141) ) [ RunTime:0.000583s ]
SELECT `s`.`id`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `status` <> 2 AND `categoryid` IN (132,133,134,135,136,137,138,139,140,141) ) ORDER BY `id` DESC LIMIT 100,20 [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13977 LIMIT 4 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13977 ORDER BY `unit` DESC [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13977 LIMIT 2 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='IRLML6402TRPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.000720s ]
select foldpath,foldpath2,filename from pdf_file where id=1098092 limit 1 [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRLML6402TRPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976 LIMIT 4 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13976 ORDER BY `unit` DESC [ RunTime:0.000178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13976 LIMIT 2 [ RunTime:0.000191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976 ORDER BY `minOrder` ASC [ RunTime:0.000170s ]
select * from pdf where partno='IRFD9024PBF' and brandshort='VISHAY' limit 1 [ RunTime:0.000638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRFD9024PBF' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13975 LIMIT 4 [ RunTime:0.000211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13975 ORDER BY `minOrder` ASC [ RunTime:0.000203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13975 ORDER BY `unit` DESC [ RunTime:0.000176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13975 LIMIT 2 [ RunTime:0.000170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13975 ORDER BY `minOrder` ASC [ RunTime:0.000168s ]
select * from pdf where partno='IRF520NPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.000828s ]
select foldpath,foldpath2,filename from pdf_file where id=601762 limit 1 [ RunTime:0.000274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF520NPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13974 LIMIT 4 [ RunTime:0.000219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13974 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13974 ORDER BY `unit` DESC [ RunTime:0.000169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13974 LIMIT 2 [ RunTime:0.000168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13974 ORDER BY `minOrder` ASC [ RunTime:0.000165s ]
select * from pdf where partno='IRLML2402TRPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.000595s ]
select foldpath,foldpath2,filename from pdf_file where id=1102283 limit 1 [ RunTime:0.000268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRLML2402TRPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13973 LIMIT 4 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13973 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13973 ORDER BY `unit` DESC [ RunTime:0.000174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13973 LIMIT 2 [ RunTime:0.000166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13973 ORDER BY `minOrder` ASC [ RunTime:0.000165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRLML2803TRPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13731 LIMIT 4 [ RunTime:0.000164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13731 ORDER BY `minOrder` ASC [ RunTime:0.000171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13731 ORDER BY `unit` DESC [ RunTime:0.000177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13731 LIMIT 2 [ RunTime:0.000201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13731 ORDER BY `minOrder` ASC [ RunTime:0.000197s ]
select * from pdf where partno='IXFN80N50' and brandshort='IXYS SEMICONDUCTOR' limit 1 [ RunTime:0.000657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IXFN80N50' OR `brand` LIKE 'IXYS SEMICONDUCTOR%' ) ) LIMIT 1 [ RunTime:0.000210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13295 LIMIT 4 [ RunTime:0.000203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13295 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13295 ORDER BY `unit` DESC [ RunTime:0.000169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13295 LIMIT 2 [ RunTime:0.000191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13295 ORDER BY `minOrder` ASC [ RunTime:0.000201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IPF050N10NF2SATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13125 LIMIT 4 [ RunTime:0.000167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13125 ORDER BY `minOrder` ASC [ RunTime:0.000184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13125 ORDER BY `unit` DESC [ RunTime:0.000172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13125 LIMIT 2 [ RunTime:0.000164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13125 ORDER BY `minOrder` ASC [ RunTime:0.000176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP3630ARZ-R7' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13037 LIMIT 4 [ RunTime:0.000207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13037 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13037 ORDER BY `unit` DESC [ RunTime:0.000180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13037 LIMIT 2 [ RunTime:0.000162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13037 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
select * from pdf where partno='SCT4062KW7TL' and brandshort='ROHM' limit 1 [ RunTime:0.000699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SCT4062KW7TL' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.000215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12940 LIMIT 4 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12940 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12940 ORDER BY `unit` DESC [ RunTime:0.000169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12940 LIMIT 2 [ RunTime:0.000167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12940 ORDER BY `minOrder` ASC [ RunTime:0.000201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ISZ230N10NM6ATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12934 LIMIT 4 [ RunTime:0.000181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12934 ORDER BY `minOrder` ASC [ RunTime:0.000192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12934 ORDER BY `unit` DESC [ RunTime:0.000193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12934 LIMIT 2 [ RunTime:0.000204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12934 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM3J356R,LF(T' OR `brand` LIKE 'TOSHIBA%' ) ) LIMIT 1 [ RunTime:0.000173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12928 LIMIT 4 [ RunTime:0.000194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928 ORDER BY `minOrder` ASC [ RunTime:0.000168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12928 ORDER BY `unit` DESC [ RunTime:0.000168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12928 LIMIT 2 [ RunTime:0.000168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12928 ORDER BY `minOrder` ASC [ RunTime:0.000166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TK100L60W,VQ(O' OR `brand` LIKE 'TOSHIBA%' ) ) LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12921 LIMIT 4 [ RunTime:0.000200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12921 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12921 ORDER BY `unit` DESC [ RunTime:0.000195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12921 LIMIT 2 [ RunTime:0.000167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12921 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2N7002KQBZ' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.000177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12767 LIMIT 4 [ RunTime:0.000168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12767 ORDER BY `unit` DESC [ RunTime:0.000206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12767 LIMIT 2 [ RunTime:0.000166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12767 ORDER BY `minOrder` ASC [ RunTime:0.000167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BUK7S0R5-40HJ' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.000185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765 LIMIT 4 [ RunTime:0.000165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765 ORDER BY `minOrder` ASC [ RunTime:0.000158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12765 ORDER BY `unit` DESC [ RunTime:0.000169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12765 LIMIT 2 [ RunTime:0.000174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765 ORDER BY `minOrder` ASC [ RunTime:0.000202s ]
select * from pdf where partno='IRF9640STRRPBF' and brandshort='VISHAY' limit 1 [ RunTime:0.000436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF9640STRRPBF' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.000225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12742 LIMIT 4 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12742 ORDER BY `unit` DESC [ RunTime:0.000177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12742 LIMIT 2 [ RunTime:0.000162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTMTSC4D3N15MC' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741 LIMIT 4 [ RunTime:0.000219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741 ORDER BY `minOrder` ASC [ RunTime:0.000179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12741 ORDER BY `unit` DESC [ RunTime:0.000167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12741 LIMIT 2 [ RunTime:0.000165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741 ORDER BY `minOrder` ASC [ RunTime:0.000164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTD600N80S3Z' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.000172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740 LIMIT 4 [ RunTime:0.000171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740 ORDER BY `minOrder` ASC [ RunTime:0.000167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740 ORDER BY `unit` DESC [ RunTime:0.000178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740 LIMIT 2 [ RunTime:0.000162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740 ORDER BY `minOrder` ASC [ RunTime:0.000167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTBLS1D7N08H' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.000176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12723 LIMIT 4 [ RunTime:0.000166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12723 ORDER BY `minOrder` ASC [ RunTime:0.000172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12723 ORDER BY `unit` DESC [ RunTime:0.000176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12723 LIMIT 2 [ RunTime:0.000167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12723 ORDER BY `minOrder` ASC [ RunTime:0.000164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSS169IXTSA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12669 LIMIT 4 [ RunTime:0.000168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12669 ORDER BY `minOrder` ASC [ RunTime:0.000168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12669 ORDER BY `unit` DESC [ RunTime:0.000174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12669 LIMIT 2 [ RunTime:0.000170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12669 ORDER BY `minOrder` ASC [ RunTime:0.000166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DMP1005UFDF-7' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.000194s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 AND `categoryid` IN (132,133,134,135,136,137,138,139,140,141) ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000301s ]