SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002603s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001630s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004559s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.93' ) [ RunTime:0.002582s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002013s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005238s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002422s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ30CA' LIMIT 1 [ RunTime:0.003152s ]
UPDATE `stock_search` SET `count` = 17524 , `updatetime` = '2026-06-02 18:57:53' WHERE `partno` = 'SMBJ30CA' [ RunTime:0.005381s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002296s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001390s ]
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.002504s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002222s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ30CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.017820s ]
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 'SMBJ30CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008626s ]
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 ('30155094','16663449','16664805','30096463','30090004','30089972','30156512','16663673','16664807','30153651','30144679','16663332','14800911','14799148','16666596','30090312','13912886','30096521','14800828','30097909') ORDER BY FIELD(s.id, 30155094,16663449,16664805,30096463,30090004,30089972,30156512,16663673,16664807,30153651,30144679,16663332,14800911,14799148,16666596,30090312,13912886,30096521,14800828,30097909) [ RunTime:0.012127s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30155094 LIMIT 4 [ RunTime:0.000819s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30155094 ORDER BY `minOrder` ASC [ RunTime:0.006319s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30155094 ORDER BY `unit` DESC [ RunTime:0.012136s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30155094 LIMIT 2 [ RunTime:0.004003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30155094 ORDER BY `minOrder` ASC [ RunTime:0.002718s ]
select * from pdf where partno='SMBJ30CAL0S0CK' and brandshort='NextGen Components' limit 1 [ RunTime:0.001914s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CAL0S0CK' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.001248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663449 LIMIT 4 [ RunTime:0.009668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663449 ORDER BY `minOrder` ASC [ RunTime:0.001405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663449 ORDER BY `unit` DESC [ RunTime:0.010263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663449 LIMIT 2 [ RunTime:0.002281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663449 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664805 LIMIT 4 [ RunTime:0.002757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664805 ORDER BY `minOrder` ASC [ RunTime:0.001594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664805 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664805 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664805 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30096463 LIMIT 4 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096463 ORDER BY `minOrder` ASC [ RunTime:0.002520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30096463 ORDER BY `unit` DESC [ RunTime:0.002123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30096463 LIMIT 2 [ RunTime:0.002158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096463 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='SMBJ30CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30090004 LIMIT 4 [ RunTime:0.009938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30090004 ORDER BY `minOrder` ASC [ RunTime:0.005353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30090004 ORDER BY `unit` DESC [ RunTime:0.000696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30090004 LIMIT 2 [ RunTime:0.000917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30090004 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='SMBJ30CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.011975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30089972 LIMIT 4 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30089972 ORDER BY `minOrder` ASC [ RunTime:0.001013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30089972 ORDER BY `unit` DESC [ RunTime:0.002582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30089972 LIMIT 2 [ RunTime:0.001774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30089972 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='SMBJ30CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30156512 LIMIT 4 [ RunTime:0.011655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30156512 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30156512 ORDER BY `unit` DESC [ RunTime:0.002847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30156512 LIMIT 2 [ RunTime:0.002880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30156512 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='SMBJ30CA' and brandshort='MDD' limit 1 [ RunTime:0.001513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.011256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663673 LIMIT 4 [ RunTime:0.008147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663673 ORDER BY `minOrder` ASC [ RunTime:0.000736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663673 ORDER BY `unit` DESC [ RunTime:0.002609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663673 LIMIT 2 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663673 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664807 LIMIT 4 [ RunTime:0.001491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664807 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664807 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664807 LIMIT 2 [ RunTime:0.002395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664807 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30153651 LIMIT 4 [ RunTime:0.002136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30153651 ORDER BY `minOrder` ASC [ RunTime:0.002000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30153651 ORDER BY `unit` DESC [ RunTime:0.002529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30153651 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30153651 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='SMBJ30CAS6-EVL' and brandshort='Venkel' limit 1 [ RunTime:0.000879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CAS6-EVL' OR `brand` LIKE 'Venkel%' ) ) LIMIT 1 [ RunTime:0.011166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30144679 LIMIT 4 [ RunTime:0.002235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30144679 ORDER BY `minOrder` ASC [ RunTime:0.005395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30144679 ORDER BY `unit` DESC [ RunTime:0.005399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30144679 LIMIT 2 [ RunTime:0.002360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30144679 ORDER BY `minOrder` ASC [ RunTime:0.004545s ]
select * from pdf where partno='SMBJ30CAS6-EVL-CT' and brandshort='Venkel' limit 1 [ RunTime:0.001094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CAS6-EVL-CT' OR `brand` LIKE 'Venkel%' ) ) LIMIT 1 [ RunTime:0.002068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663332 LIMIT 4 [ RunTime:0.001199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663332 ORDER BY `minOrder` ASC [ RunTime:0.001649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663332 ORDER BY `unit` DESC [ RunTime:0.002479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663332 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663332 ORDER BY `minOrder` ASC [ RunTime:0.001555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800911 LIMIT 4 [ RunTime:0.001103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800911 ORDER BY `minOrder` ASC [ RunTime:0.005232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800911 ORDER BY `unit` DESC [ RunTime:0.002875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800911 LIMIT 2 [ RunTime:0.003874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800911 ORDER BY `minOrder` ASC [ RunTime:0.003483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799148 LIMIT 4 [ RunTime:0.004540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799148 ORDER BY `minOrder` ASC [ RunTime:0.001037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799148 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799148 LIMIT 2 [ RunTime:0.001358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799148 ORDER BY `minOrder` ASC [ RunTime:0.004861s ]
select * from pdf where partno='SMBJ30CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666596 LIMIT 4 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666596 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666596 ORDER BY `unit` DESC [ RunTime:0.002213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666596 LIMIT 2 [ RunTime:0.003516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666596 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30090312 LIMIT 4 [ RunTime:0.005153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30090312 ORDER BY `minOrder` ASC [ RunTime:0.003290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30090312 ORDER BY `unit` DESC [ RunTime:0.005818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30090312 LIMIT 2 [ RunTime:0.001821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30090312 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
select * from pdf where partno='SMBJ30CAQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CAQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912886 LIMIT 4 [ RunTime:0.004757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912886 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912886 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912886 LIMIT 2 [ RunTime:0.003505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912886 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30096521 LIMIT 4 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096521 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30096521 ORDER BY `unit` DESC [ RunTime:0.000698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30096521 LIMIT 2 [ RunTime:0.001794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096521 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
select * from pdf where partno='SMBJ30CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800828 LIMIT 4 [ RunTime:0.004993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800828 ORDER BY `minOrder` ASC [ RunTime:0.001322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800828 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800828 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800828 ORDER BY `minOrder` ASC [ RunTime:0.001203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30097909 LIMIT 4 [ RunTime:0.014806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30097909 ORDER BY `minOrder` ASC [ RunTime:0.003783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30097909 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30097909 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30097909 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
select * from pdf where partno='SMBJ30CA-TR' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.001290s ]
select foldpath,foldpath2,filename from pdf_file where id=422287 limit 1 [ RunTime:0.007699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ30CA-TR' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.007375s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ30CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001791s ]