SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001998s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000590s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001391s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.51' ) [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000937s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000188s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 8 [ RunTime:0.000337s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (33,34,35,36) [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002130s ]
SELECT `s`.`id`,`s`.*,`u`.`company`,`t`.`name` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( ( `status` = 1 OR `status` = 3 OR `status` = 4 OR ( `status` = 2 AND `expiretime` > '2025-10-06 11:08:16' ) ) AND `categoryid` IN (341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,10 [ RunTime:2.091458s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4155 LIMIT 4 [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4155 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4155 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4155 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4155 ORDER BY `minOrder` ASC [ RunTime:0.000191s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NSI45030AT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.006606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3641 LIMIT 4 [ RunTime:0.000210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3641 ORDER BY `minOrder` ASC [ RunTime:0.000192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3641 ORDER BY `unit` DESC [ RunTime:0.000186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3641 LIMIT 2 [ RunTime:0.000183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3641 ORDER BY `minOrder` ASC [ RunTime:0.000176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ASSR-1510-003E' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5311 LIMIT 4 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5311 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5311 ORDER BY `unit` DESC [ RunTime:0.000539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5311 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5311 ORDER BY `minOrder` ASC [ RunTime:0.000185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEFD4300' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.006010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10835 LIMIT 4 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10835 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10835 ORDER BY `unit` DESC [ RunTime:0.000302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10835 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10835 ORDER BY `minOrder` ASC [ RunTime:0.000183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VN330SPTR-E' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7852 LIMIT 4 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7852 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7852 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7852 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7852 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VEMD2523SLX01' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.006946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 176 LIMIT 4 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 176 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 176 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 176 LIMIT 2 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 176 ORDER BY `minOrder` ASC [ RunTime:0.000185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BPW21R' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.006232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4079 LIMIT 4 [ RunTime:0.000256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4079 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4079 ORDER BY `unit` DESC [ RunTime:0.000260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4079 LIMIT 2 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4079 ORDER BY `minOrder` ASC [ RunTime:0.000162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VEMD2020X01' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.005813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3643 LIMIT 4 [ RunTime:0.000198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3643 ORDER BY `minOrder` ASC [ RunTime:0.000157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3643 ORDER BY `unit` DESC [ RunTime:0.000158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3643 LIMIT 2 [ RunTime:0.000153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3643 ORDER BY `minOrder` ASC [ RunTime:0.000145s ]
select * from pdf where partno='ASSR-3210-003E' and brandshort='BROADCOM' limit 1 [ RunTime:0.000585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ASSR-3210-003E' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496 LIMIT 4 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496 ORDER BY `minOrder` ASC [ RunTime:0.000187s ]
select * from pdf where partno='VEMD4110X01' and brandshort='VISHAY' limit 1 [ RunTime:0.000995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VEMD4110X01' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.006580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2122 LIMIT 4 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2122 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2122 ORDER BY `unit` DESC [ RunTime:0.000259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2122 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2122 ORDER BY `minOrder` ASC [ RunTime:0.000192s ]
select * from pdf where partno='553-0112F' and brandshort='DIALIGHT' limit 1 [ RunTime:0.001358s ]
select foldpath,foldpath2,filename from pdf_file where id=1116832 limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '553-0112F' OR `brand` LIKE 'DIALIGHT%' ) ) LIMIT 1 [ RunTime:0.000685s ]
SELECT `id`,`brand`,`package` FROM `stock` WHERE ( ( `status` = 1 OR `status` = 3 OR `status` = 4 OR ( `status` = 2 AND `expiretime` > '2025-10-06 11:08:16' ) ) AND `categoryid` IN (341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375) ) ORDER BY `id` DESC LIMIT 10000 [ RunTime:2.713894s ]
SELECT COUNT(*) AS think_count FROM `stock` WHERE ( ( `status` = 1 OR `status` = 3 OR `status` = 4 OR ( `status` = 2 AND `expiretime` > '2025-10-06 11:08:16' ) ) AND `categoryid` IN (341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375) ) [ RunTime:1.736258s ]