SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002110s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009267s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002460s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.62' ) [ RunTime:0.003382s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002818s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010847s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001564s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ6.5A' LIMIT 1 [ RunTime:0.019761s ]
UPDATE `stock_search` SET `count` = 15295 , `updatetime` = '2026-06-03 08:43:20' WHERE `partno` = 'SMBJ6.5A' [ RunTime:0.020580s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005918s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.007128s ]
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.008436s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001711s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ6.5A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.025991s ]
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 'SMBJ6.5A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.010938s ]
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 ('4302','17103','16085','30404302','30392568','30266951','30261343','30238899','30238896','30236845','30236844','30231303','30227492','30226043','30224978','30224338','30223168','30222692','30221332','30220373') ORDER BY FIELD(s.id, 4302,17103,16085,30404302,30392568,30266951,30261343,30238899,30238896,30236845,30236844,30231303,30227492,30226043,30224978,30224338,30223168,30222692,30221332,30220373) [ RunTime:0.047327s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4302 LIMIT 4 [ RunTime:0.009819s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.030171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4302 ORDER BY `minOrder` ASC [ RunTime:0.008964s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4302 ORDER BY `unit` DESC [ RunTime:0.024485s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4302 LIMIT 2 [ RunTime:0.009274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4302 ORDER BY `minOrder` ASC [ RunTime:0.038742s ]
select * from pdf where partno='SMBJ6.5A' and brandshort='UMW' limit 1 [ RunTime:0.048256s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.046069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17103 LIMIT 4 [ RunTime:0.044083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17103 ORDER BY `minOrder` ASC [ RunTime:0.050225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17103 ORDER BY `unit` DESC [ RunTime:0.053435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17103 LIMIT 2 [ RunTime:0.080347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17103 ORDER BY `minOrder` ASC [ RunTime:0.027361s ]
select * from pdf where partno='SMBJ6.5A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.051839s ]
select foldpath,foldpath2,filename from pdf_file where id=422167 limit 1 [ RunTime:0.048620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.080203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16085 LIMIT 4 [ RunTime:0.048844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16085 ORDER BY `minOrder` ASC [ RunTime:0.033698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16085 ORDER BY `unit` DESC [ RunTime:0.056777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16085 LIMIT 2 [ RunTime:0.062244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16085 ORDER BY `minOrder` ASC [ RunTime:0.043728s ]
select * from pdf where partno='SMBJ6.5A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.028942s ]
select foldpath,foldpath2,filename from pdf_file where id=422167 limit 1 [ RunTime:0.000426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.043161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30404302 LIMIT 4 [ RunTime:0.064886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30404302 ORDER BY `minOrder` ASC [ RunTime:0.057633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30404302 ORDER BY `unit` DESC [ RunTime:0.102349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30404302 LIMIT 2 [ RunTime:0.055220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30404302 ORDER BY `minOrder` ASC [ RunTime:0.012280s ]
select * from pdf where partno='SMBJ6.5A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.079174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.029018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30392568 LIMIT 4 [ RunTime:0.081727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30392568 ORDER BY `minOrder` ASC [ RunTime:0.072901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30392568 ORDER BY `unit` DESC [ RunTime:0.046549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30392568 LIMIT 2 [ RunTime:0.108513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30392568 ORDER BY `minOrder` ASC [ RunTime:0.076865s ]
select * from pdf where partno='SMBJ6.5A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.053969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.049744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30266951 LIMIT 4 [ RunTime:0.043856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30266951 ORDER BY `minOrder` ASC [ RunTime:0.037695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30266951 ORDER BY `unit` DESC [ RunTime:0.017602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30266951 LIMIT 2 [ RunTime:0.027697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30266951 ORDER BY `minOrder` ASC [ RunTime:0.007066s ]
select * from pdf where partno='SMBJ6.5A-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.065240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.036838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30261343 LIMIT 4 [ RunTime:0.050922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30261343 ORDER BY `minOrder` ASC [ RunTime:0.028981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30261343 ORDER BY `unit` DESC [ RunTime:0.059890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30261343 LIMIT 2 [ RunTime:0.030268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30261343 ORDER BY `minOrder` ASC [ RunTime:0.041165s ]
select * from pdf where partno='SMBJ6.5AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.037183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.065417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30238899 LIMIT 4 [ RunTime:0.045311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30238899 ORDER BY `minOrder` ASC [ RunTime:0.060698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30238899 ORDER BY `unit` DESC [ RunTime:0.094065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30238899 LIMIT 2 [ RunTime:0.035319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30238899 ORDER BY `minOrder` ASC [ RunTime:0.026390s ]
select * from pdf where partno='SMBJ6.5AHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.047353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.032955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30238896 LIMIT 4 [ RunTime:0.032076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30238896 ORDER BY `minOrder` ASC [ RunTime:0.048782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30238896 ORDER BY `unit` DESC [ RunTime:0.017361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30238896 LIMIT 2 [ RunTime:0.040770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30238896 ORDER BY `minOrder` ASC [ RunTime:0.024653s ]
select * from pdf where partno='SMBJ6.5AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.058296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30236845 LIMIT 4 [ RunTime:0.006743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30236845 ORDER BY `minOrder` ASC [ RunTime:0.023852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30236845 ORDER BY `unit` DESC [ RunTime:0.034136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30236845 LIMIT 2 [ RunTime:0.018350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30236845 ORDER BY `minOrder` ASC [ RunTime:0.007349s ]
select * from pdf where partno='SMBJ6.5AHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.028303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.022719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30236844 LIMIT 4 [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30236844 ORDER BY `minOrder` ASC [ RunTime:0.021980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30236844 ORDER BY `unit` DESC [ RunTime:0.012603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30236844 LIMIT 2 [ RunTime:0.003967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30236844 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
select * from pdf where partno='SMBJ6.5AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30231303 LIMIT 4 [ RunTime:0.038662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30231303 ORDER BY `minOrder` ASC [ RunTime:0.031562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30231303 ORDER BY `unit` DESC [ RunTime:0.038839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30231303 LIMIT 2 [ RunTime:0.011180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30231303 ORDER BY `minOrder` ASC [ RunTime:0.015286s ]
select * from pdf where partno='SMBJ6.5AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.023487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.019044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30227492 LIMIT 4 [ RunTime:0.007467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30227492 ORDER BY `minOrder` ASC [ RunTime:0.041626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30227492 ORDER BY `unit` DESC [ RunTime:0.052828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30227492 LIMIT 2 [ RunTime:0.006725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30227492 ORDER BY `minOrder` ASC [ RunTime:0.022158s ]
select * from pdf where partno='SMBJ6.5A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30226043 LIMIT 4 [ RunTime:0.040340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30226043 ORDER BY `minOrder` ASC [ RunTime:0.034212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30226043 ORDER BY `unit` DESC [ RunTime:0.036336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30226043 LIMIT 2 [ RunTime:0.071762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30226043 ORDER BY `minOrder` ASC [ RunTime:0.026287s ]
select * from pdf where partno='SMBJ6.5AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.086852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.067925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30224978 LIMIT 4 [ RunTime:0.036460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30224978 ORDER BY `minOrder` ASC [ RunTime:0.050600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30224978 ORDER BY `unit` DESC [ RunTime:0.023253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30224978 LIMIT 2 [ RunTime:0.009665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30224978 ORDER BY `minOrder` ASC [ RunTime:0.010913s ]
select * from pdf where partno='SMBJ6.5AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.051992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.036754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30224338 LIMIT 4 [ RunTime:0.064930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30224338 ORDER BY `minOrder` ASC [ RunTime:0.054600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30224338 ORDER BY `unit` DESC [ RunTime:0.016291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30224338 LIMIT 2 [ RunTime:0.035535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30224338 ORDER BY `minOrder` ASC [ RunTime:0.007696s ]
select * from pdf where partno='SMBJ6.5AQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.037483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.011953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30223168 LIMIT 4 [ RunTime:0.025478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30223168 ORDER BY `minOrder` ASC [ RunTime:0.012398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30223168 ORDER BY `unit` DESC [ RunTime:0.014075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30223168 LIMIT 2 [ RunTime:0.018857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30223168 ORDER BY `minOrder` ASC [ RunTime:0.003526s ]
select * from pdf where partno='SMBJ6.5A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.025028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30222692 LIMIT 4 [ RunTime:0.051787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30222692 ORDER BY `minOrder` ASC [ RunTime:0.032793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30222692 ORDER BY `unit` DESC [ RunTime:0.007002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30222692 LIMIT 2 [ RunTime:0.019305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30222692 ORDER BY `minOrder` ASC [ RunTime:0.002394s ]
select * from pdf where partno='SMBJ6.5AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.028434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30221332 LIMIT 4 [ RunTime:0.002584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30221332 ORDER BY `minOrder` ASC [ RunTime:0.013176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30221332 ORDER BY `unit` DESC [ RunTime:0.008872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30221332 LIMIT 2 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30221332 ORDER BY `minOrder` ASC [ RunTime:0.008889s ]
select * from pdf where partno='SMBJ6.5AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30220373 LIMIT 4 [ RunTime:0.005754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30220373 ORDER BY `minOrder` ASC [ RunTime:0.003800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30220373 ORDER BY `unit` DESC [ RunTime:0.012721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30220373 LIMIT 2 [ RunTime:0.003915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30220373 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='SMBJ6.5AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.014900s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ6.5A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.018221s ]