SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002259s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000535s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001935s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.103' ) [ RunTime:0.003828s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000964s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005630s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001094s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ24CA' LIMIT 1 [ RunTime:0.005900s ]
UPDATE `stock_search` SET `count` = 16707 , `updatetime` = '2026-06-02 01:57:30' WHERE `partno` = 'SMBJ24CA' [ RunTime:0.002337s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000381s ]
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.000673s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007072s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ24CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.007334s ]
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 'SMBJ24CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.009210s ]
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 ('30251307','30241388','30241161','30237299','30237050','30236835','30230766','30230730','30230555','30228714','30217824','30210048','30195539','30194208','30186873','30181638','30175650','30172472','16683403','16683174') ORDER BY FIELD(s.id, 30251307,30241388,30241161,30237299,30237050,30236835,30230766,30230730,30230555,30228714,30217824,30210048,30195539,30194208,30186873,30181638,30175650,30172472,16683403,16683174) [ RunTime:0.008266s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30251307 LIMIT 4 [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30251307 ORDER BY `minOrder` ASC [ RunTime:0.001863s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30251307 ORDER BY `unit` DESC [ RunTime:0.001285s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30251307 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30251307 ORDER BY `minOrder` ASC [ RunTime:0.003170s ]
select * from pdf where partno='SMBJ24CAHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012932s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30241388 LIMIT 4 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30241388 ORDER BY `minOrder` ASC [ RunTime:0.001207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30241388 ORDER BY `unit` DESC [ RunTime:0.004441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30241388 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30241388 ORDER BY `minOrder` ASC [ RunTime:0.003393s ]
select * from pdf where partno='SMBJ24CAHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30241161 LIMIT 4 [ RunTime:0.002270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30241161 ORDER BY `minOrder` ASC [ RunTime:0.006555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30241161 ORDER BY `unit` DESC [ RunTime:0.003981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30241161 LIMIT 2 [ RunTime:0.001245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30241161 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='SMBJ24CAHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30237299 LIMIT 4 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30237299 ORDER BY `minOrder` ASC [ RunTime:0.007623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30237299 ORDER BY `unit` DESC [ RunTime:0.005810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30237299 LIMIT 2 [ RunTime:0.013999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30237299 ORDER BY `minOrder` ASC [ RunTime:0.007070s ]
select * from pdf where partno='SMBJ24CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30237050 LIMIT 4 [ RunTime:0.012021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30237050 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30237050 ORDER BY `unit` DESC [ RunTime:0.010967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30237050 LIMIT 2 [ RunTime:0.004735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30237050 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='SMBJ24CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30236835 LIMIT 4 [ RunTime:0.001668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30236835 ORDER BY `minOrder` ASC [ RunTime:0.001167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30236835 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30236835 LIMIT 2 [ RunTime:0.005752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30236835 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='SMBJ24CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30230766 LIMIT 4 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30230766 ORDER BY `minOrder` ASC [ RunTime:0.005425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30230766 ORDER BY `unit` DESC [ RunTime:0.012404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30230766 LIMIT 2 [ RunTime:0.003605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30230766 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='SMBJ24CA-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30230730 LIMIT 4 [ RunTime:0.006984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30230730 ORDER BY `minOrder` ASC [ RunTime:0.001426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30230730 ORDER BY `unit` DESC [ RunTime:0.000580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30230730 LIMIT 2 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30230730 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='SMBJ24CA-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30230555 LIMIT 4 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30230555 ORDER BY `minOrder` ASC [ RunTime:0.002103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30230555 ORDER BY `unit` DESC [ RunTime:0.005387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30230555 LIMIT 2 [ RunTime:0.001226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30230555 ORDER BY `minOrder` ASC [ RunTime:0.002482s ]
select * from pdf where partno='SMBJ24CAQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.003818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.003116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30228714 LIMIT 4 [ RunTime:0.004746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228714 ORDER BY `minOrder` ASC [ RunTime:0.007484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30228714 ORDER BY `unit` DESC [ RunTime:0.001548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30228714 LIMIT 2 [ RunTime:0.003726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228714 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='SMBJ24CAHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.006726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30217824 LIMIT 4 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30217824 ORDER BY `minOrder` ASC [ RunTime:0.012422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30217824 ORDER BY `unit` DESC [ RunTime:0.016040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30217824 LIMIT 2 [ RunTime:0.006459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30217824 ORDER BY `minOrder` ASC [ RunTime:0.006203s ]
select * from pdf where partno='SMBJ24CA-7P' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA-7P' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.001115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30210048 LIMIT 4 [ RunTime:0.009983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30210048 ORDER BY `minOrder` ASC [ RunTime:0.020876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30210048 ORDER BY `unit` DESC [ RunTime:0.001257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30210048 LIMIT 2 [ RunTime:0.005931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30210048 ORDER BY `minOrder` ASC [ RunTime:0.001939s ]
select * from pdf where partno='SMBJ24CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.005083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.010612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30195539 LIMIT 4 [ RunTime:0.003536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30195539 ORDER BY `minOrder` ASC [ RunTime:0.007706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30195539 ORDER BY `unit` DESC [ RunTime:0.002888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30195539 LIMIT 2 [ RunTime:0.005546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30195539 ORDER BY `minOrder` ASC [ RunTime:0.001479s ]
select * from pdf where partno='SMBJ24CAH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.007248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.006744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30194208 LIMIT 4 [ RunTime:0.007932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194208 ORDER BY `minOrder` ASC [ RunTime:0.012347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30194208 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30194208 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194208 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
select * from pdf where partno='SMBJ24CA-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.005207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.017601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30186873 LIMIT 4 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30186873 ORDER BY `minOrder` ASC [ RunTime:0.004157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30186873 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30186873 LIMIT 2 [ RunTime:0.005098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30186873 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
select * from pdf where partno='SMBJ24CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.001097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30181638 LIMIT 4 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30181638 ORDER BY `minOrder` ASC [ RunTime:0.000865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30181638 ORDER BY `unit` DESC [ RunTime:0.000370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30181638 LIMIT 2 [ RunTime:0.003660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30181638 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='SMBJ24CAJ' and brandshort='WeEn Semiconductors' limit 1 [ RunTime:0.002100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CAJ' OR `brand` LIKE 'WeEn Semiconductors%' ) ) LIMIT 1 [ RunTime:0.000714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30175650 LIMIT 4 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30175650 ORDER BY `minOrder` ASC [ RunTime:0.001840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30175650 ORDER BY `unit` DESC [ RunTime:0.003741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30175650 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30175650 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
select * from pdf where partno='SMBJ24CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30172472 LIMIT 4 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30172472 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30172472 ORDER BY `unit` DESC [ RunTime:0.000944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30172472 LIMIT 2 [ RunTime:0.005359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30172472 ORDER BY `minOrder` ASC [ RunTime:0.006167s ]
select * from pdf where partno='SMBJ24CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.007272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ24CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.002127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683403 LIMIT 4 [ RunTime:0.011553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683403 ORDER BY `minOrder` ASC [ RunTime:0.008936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683403 ORDER BY `unit` DESC [ RunTime:0.005589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683403 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683403 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683174 LIMIT 4 [ RunTime:0.006380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683174 ORDER BY `minOrder` ASC [ RunTime:0.003089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683174 ORDER BY `unit` DESC [ RunTime:0.007881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683174 LIMIT 2 [ RunTime:0.004201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683174 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ24CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000433s ]