SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001112s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002970s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001892s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001633s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000379s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000764s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000242s ]
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.000543s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001347s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` = 4 AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.005613s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` = 4 AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 540,20 [ RunTime:0.006844s ]
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 ('15714','15713','15712','15711','15710','15709','15708','15707','15706','15705','15704','15703','15702','15701','15700','15699','15698','15697','15696','15695') ORDER BY FIELD(s.id, 15714,15713,15712,15711,15710,15709,15708,15707,15706,15705,15704,15703,15702,15701,15700,15699,15698,15697,15696,15695) [ RunTime:0.011681s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15714 LIMIT 4 [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15714 ORDER BY `minOrder` ASC [ RunTime:0.005981s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15714 ORDER BY `unit` DESC [ RunTime:0.002221s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15714 LIMIT 2 [ RunTime:0.003296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15714 ORDER BY `minOrder` ASC [ RunTime:0.001660s ]
select * from pdf where partno='LBWA1UZ1GC-901' and brandshort='MURATA' limit 1 [ RunTime:0.003009s ]
select foldpath,foldpath2,filename from pdf_file where id=2146538 limit 1 [ RunTime:0.003402s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LBWA1UZ1GC-901' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.006851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15713 LIMIT 4 [ RunTime:0.001759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15713 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15713 ORDER BY `unit` DESC [ RunTime:0.000202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15713 LIMIT 2 [ RunTime:0.007059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15713 ORDER BY `minOrder` ASC [ RunTime:0.002062s ]
select * from pdf where partno='2-1658527-2' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.004548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-1658527-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15712 LIMIT 4 [ RunTime:0.004988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15712 ORDER BY `minOrder` ASC [ RunTime:0.003474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15712 ORDER BY `unit` DESC [ RunTime:0.012637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15712 LIMIT 2 [ RunTime:0.002111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15712 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
select * from pdf where partno='EMVE101ARA101MKE0S' and brandshort='CHEMI-CON' limit 1 [ RunTime:0.002425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EMVE101ARA101MKE0S' OR `brand` LIKE 'CHEMI-CON%' ) ) LIMIT 1 [ RunTime:0.001899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15711 LIMIT 4 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15711 ORDER BY `minOrder` ASC [ RunTime:0.003954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15711 ORDER BY `unit` DESC [ RunTime:0.002425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15711 LIMIT 2 [ RunTime:0.007002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15711 ORDER BY `minOrder` ASC [ RunTime:0.013328s ]
select * from pdf where partno='CY8C5287AXI-LP095' and brandshort='INFINEON' limit 1 [ RunTime:0.004532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY8C5287AXI-LP095' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.011387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15710 LIMIT 4 [ RunTime:0.002790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15710 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15710 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15710 LIMIT 2 [ RunTime:0.005440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15710 ORDER BY `minOrder` ASC [ RunTime:0.007137s ]
select * from pdf where partno='RC0603JR-070RL' and brandshort='YAGEO' limit 1 [ RunTime:0.004633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0603JR-070RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.016159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15709 LIMIT 4 [ RunTime:0.002976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15709 ORDER BY `minOrder` ASC [ RunTime:0.000868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15709 ORDER BY `unit` DESC [ RunTime:0.001058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15709 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15709 ORDER BY `minOrder` ASC [ RunTime:0.000161s ]
select * from pdf where partno='BQMTESTER' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.001419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BQMTESTER' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.003880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15708 LIMIT 4 [ RunTime:0.002201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15708 ORDER BY `minOrder` ASC [ RunTime:0.002155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15708 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15708 LIMIT 2 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15708 ORDER BY `minOrder` ASC [ RunTime:0.000167s ]
select * from pdf where partno='MCT0603R223KCT' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCT0603R223KCT' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.001466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15707 LIMIT 4 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15707 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15707 ORDER BY `unit` DESC [ RunTime:0.000254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15707 LIMIT 2 [ RunTime:0.001212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15707 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
select * from pdf where partno='MCMF0W4FF4701A50' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCMF0W4FF4701A50' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.002653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15706 LIMIT 4 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15706 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15706 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15706 LIMIT 2 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15706 ORDER BY `minOrder` ASC [ RunTime:0.000156s ]
select * from pdf where partno='C1608X7R1C474K080AC' and brandshort='TDK' limit 1 [ RunTime:0.001732s ]
select foldpath,foldpath2,filename from pdf_file where id=1917933 limit 1 [ RunTime:0.006019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1608X7R1C474K080AC' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.009577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15705 LIMIT 4 [ RunTime:0.005742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15705 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15705 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15705 LIMIT 2 [ RunTime:0.003791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15705 ORDER BY `minOrder` ASC [ RunTime:0.002276s ]
select * from pdf where partno='502578-1200' and brandshort='MOLEX' limit 1 [ RunTime:0.005153s ]
select foldpath,foldpath2,filename from pdf_file where id=766578 limit 1 [ RunTime:0.002066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '502578-1200' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15704 LIMIT 4 [ RunTime:0.002424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15704 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15704 ORDER BY `unit` DESC [ RunTime:0.008403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15704 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15704 ORDER BY `minOrder` ASC [ RunTime:0.000167s ]
select * from pdf where partno='SZH-002T-P0.5' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.004521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZH-002T-P0.5' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.000950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15703 LIMIT 4 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15703 ORDER BY `minOrder` ASC [ RunTime:0.004017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15703 ORDER BY `unit` DESC [ RunTime:0.020217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15703 LIMIT 2 [ RunTime:0.004570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15703 ORDER BY `minOrder` ASC [ RunTime:0.009734s ]
select * from pdf where partno='3296W-1-102LF' and brandshort='BOURNS' limit 1 [ RunTime:0.010147s ]
select foldpath,foldpath2,filename from pdf_file where id=711416 limit 1 [ RunTime:0.015393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3296W-1-102LF' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.024505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15702 LIMIT 4 [ RunTime:0.011492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702 ORDER BY `minOrder` ASC [ RunTime:0.026441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15702 ORDER BY `unit` DESC [ RunTime:0.016735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15702 LIMIT 2 [ RunTime:0.007255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702 ORDER BY `minOrder` ASC [ RunTime:0.003089s ]
select * from pdf where partno='MAX4412EXK+T' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.027281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX4412EXK+T' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.022323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15701 LIMIT 4 [ RunTime:0.007180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15701 ORDER BY `minOrder` ASC [ RunTime:0.008201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15701 ORDER BY `unit` DESC [ RunTime:0.047973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15701 LIMIT 2 [ RunTime:0.007140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15701 ORDER BY `minOrder` ASC [ RunTime:0.020193s ]
select * from pdf where partno='MCWR08X1002FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.025034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR08X1002FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.005732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15700 LIMIT 4 [ RunTime:0.006019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15700 ORDER BY `minOrder` ASC [ RunTime:0.045338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15700 ORDER BY `unit` DESC [ RunTime:0.019969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15700 LIMIT 2 [ RunTime:0.007756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15700 ORDER BY `minOrder` ASC [ RunTime:0.012532s ]
select * from pdf where partno='RNF-100-1/16-0-STK' and brandshort='RAYCHEM - TE CONNECTIVITY' limit 1 [ RunTime:0.004230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RNF-100-1/16-0-STK' OR `brand` LIKE 'RAYCHEM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.007341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15699 LIMIT 4 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15699 ORDER BY `minOrder` ASC [ RunTime:0.011156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15699 ORDER BY `unit` DESC [ RunTime:0.017185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15699 LIMIT 2 [ RunTime:0.005237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15699 ORDER BY `minOrder` ASC [ RunTime:0.002703s ]
select * from pdf where partno='172167-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.003134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172167-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15698 LIMIT 4 [ RunTime:0.002683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15698 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15698 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15698 LIMIT 2 [ RunTime:0.003338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15698 ORDER BY `minOrder` ASC [ RunTime:0.001586s ]
select * from pdf where partno='MAX4066CPD+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.009718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX4066CPD+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.002634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15697 LIMIT 4 [ RunTime:0.004165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15697 ORDER BY `minOrder` ASC [ RunTime:0.009992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15697 ORDER BY `unit` DESC [ RunTime:0.003490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15697 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15697 ORDER BY `minOrder` ASC [ RunTime:0.002781s ]
select * from pdf where partno='NB3N551DR2G' and brandshort='ONSEMI' limit 1 [ RunTime:0.005933s ]
select foldpath,foldpath2,filename from pdf_file where id=529254 limit 1 [ RunTime:0.015731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NB3N551DR2G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.011371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15696 LIMIT 4 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15696 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15696 ORDER BY `unit` DESC [ RunTime:0.004112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15696 LIMIT 2 [ RunTime:0.001544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15696 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='39-00-0038' and brandshort='MOLEX' limit 1 [ RunTime:0.002086s ]
select foldpath,foldpath2,filename from pdf_file where id=688703 limit 1 [ RunTime:0.001346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '39-00-0038' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15695 LIMIT 4 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15695 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15695 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15695 LIMIT 2 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15695 ORDER BY `minOrder` ASC [ RunTime:0.003176s ]
select * from pdf where partno='SF-1206FP250-2' and brandshort='BOURNS' limit 1 [ RunTime:0.001564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF-1206FP250-2' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.002134s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` = 4 AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.004488s ]