SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001728s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000830s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001973s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.21' ) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001266s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000347s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000228s ]
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.000402s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002049s ]
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.000473s ]
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.009341s ]
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.006860s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15714 LIMIT 4 [ RunTime:0.003323s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15714 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15714 ORDER BY `unit` DESC [ RunTime:0.001054s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15714 LIMIT 2 [ RunTime:0.006968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15714 ORDER BY `minOrder` ASC [ RunTime:0.002456s ]
select * from pdf where partno='LBWA1UZ1GC-901' and brandshort='MURATA' limit 1 [ RunTime:0.003774s ]
select foldpath,foldpath2,filename from pdf_file where id=2146538 limit 1 [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LBWA1UZ1GC-901' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.004422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15713 LIMIT 4 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15713 ORDER BY `minOrder` ASC [ RunTime:0.002134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15713 ORDER BY `unit` DESC [ RunTime:0.003215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15713 LIMIT 2 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15713 ORDER BY `minOrder` ASC [ RunTime:0.001190s ]
select * from pdf where partno='2-1658527-2' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-1658527-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15712 LIMIT 4 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15712 ORDER BY `minOrder` ASC [ RunTime:0.001492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15712 ORDER BY `unit` DESC [ RunTime:0.004578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15712 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15712 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
select * from pdf where partno='EMVE101ARA101MKE0S' and brandshort='CHEMI-CON' limit 1 [ RunTime:0.001654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EMVE101ARA101MKE0S' OR `brand` LIKE 'CHEMI-CON%' ) ) LIMIT 1 [ RunTime:0.001120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15711 LIMIT 4 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15711 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15711 ORDER BY `unit` DESC [ RunTime:0.003929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15711 LIMIT 2 [ RunTime:0.007247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15711 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='CY8C5287AXI-LP095' and brandshort='INFINEON' limit 1 [ RunTime:0.003233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY8C5287AXI-LP095' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.012231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15710 LIMIT 4 [ RunTime:0.001080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15710 ORDER BY `minOrder` ASC [ RunTime:0.008089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15710 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15710 LIMIT 2 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15710 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='RC0603JR-070RL' and brandshort='YAGEO' limit 1 [ RunTime:0.002579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0603JR-070RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15709 LIMIT 4 [ RunTime:0.006347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15709 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15709 ORDER BY `unit` DESC [ RunTime:0.003003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15709 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15709 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='BQMTESTER' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.003407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BQMTESTER' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.004229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15708 LIMIT 4 [ RunTime:0.001698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15708 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15708 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15708 LIMIT 2 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15708 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='MCT0603R223KCT' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.002049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCT0603R223KCT' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.004044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15707 LIMIT 4 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15707 ORDER BY `minOrder` ASC [ RunTime:0.001232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15707 ORDER BY `unit` DESC [ RunTime:0.000558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15707 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15707 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='MCMF0W4FF4701A50' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCMF0W4FF4701A50' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.004591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15706 LIMIT 4 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15706 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15706 ORDER BY `unit` DESC [ RunTime:0.001665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15706 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15706 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='C1608X7R1C474K080AC' and brandshort='TDK' limit 1 [ RunTime:0.002121s ]
select foldpath,foldpath2,filename from pdf_file where id=1917933 limit 1 [ RunTime:0.002003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1608X7R1C474K080AC' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.006794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15705 LIMIT 4 [ RunTime:0.000848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15705 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15705 ORDER BY `unit` DESC [ RunTime:0.002155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15705 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15705 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
select * from pdf where partno='502578-1200' and brandshort='MOLEX' limit 1 [ RunTime:0.002035s ]
select foldpath,foldpath2,filename from pdf_file where id=766578 limit 1 [ RunTime:0.001238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '502578-1200' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.007418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15704 LIMIT 4 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15704 ORDER BY `minOrder` ASC [ RunTime:0.002305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15704 ORDER BY `unit` DESC [ RunTime:0.000545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15704 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15704 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
select * from pdf where partno='SZH-002T-P0.5' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.001513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZH-002T-P0.5' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.001392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15703 LIMIT 4 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15703 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15703 ORDER BY `unit` DESC [ RunTime:0.003736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15703 LIMIT 2 [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15703 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
select * from pdf where partno='3296W-1-102LF' and brandshort='BOURNS' limit 1 [ RunTime:0.004164s ]
select foldpath,foldpath2,filename from pdf_file where id=711416 limit 1 [ RunTime:0.004834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3296W-1-102LF' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.004669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15702 LIMIT 4 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702 ORDER BY `minOrder` ASC [ RunTime:0.003527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15702 ORDER BY `unit` DESC [ RunTime:0.000552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15702 LIMIT 2 [ RunTime:0.002226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15702 ORDER BY `minOrder` ASC [ RunTime:0.002081s ]
select * from pdf where partno='MAX4412EXK+T' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.002016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX4412EXK+T' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.002242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15701 LIMIT 4 [ RunTime:0.010827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15701 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15701 ORDER BY `unit` DESC [ RunTime:0.000543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15701 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15701 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='MCWR08X1002FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR08X1002FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.005165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15700 LIMIT 4 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15700 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15700 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15700 LIMIT 2 [ RunTime:0.002353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15700 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='RNF-100-1/16-0-STK' and brandshort='RAYCHEM - TE CONNECTIVITY' limit 1 [ RunTime:0.001627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RNF-100-1/16-0-STK' OR `brand` LIKE 'RAYCHEM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15699 LIMIT 4 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15699 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15699 ORDER BY `unit` DESC [ RunTime:0.001212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15699 LIMIT 2 [ RunTime:0.001829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15699 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='172167-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.003694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172167-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15698 LIMIT 4 [ RunTime:0.002884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15698 ORDER BY `minOrder` ASC [ RunTime:0.002302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15698 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15698 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15698 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='MAX4066CPD+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.001784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX4066CPD+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.002685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15697 LIMIT 4 [ RunTime:0.002288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15697 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15697 ORDER BY `unit` DESC [ RunTime:0.009031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15697 LIMIT 2 [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15697 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='NB3N551DR2G' and brandshort='ONSEMI' limit 1 [ RunTime:0.003151s ]
select foldpath,foldpath2,filename from pdf_file where id=529254 limit 1 [ RunTime:0.004967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NB3N551DR2G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.010679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15696 LIMIT 4 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15696 ORDER BY `minOrder` ASC [ RunTime:0.001226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15696 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15696 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15696 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
select * from pdf where partno='39-00-0038' and brandshort='MOLEX' limit 1 [ RunTime:0.002747s ]
select foldpath,foldpath2,filename from pdf_file where id=688703 limit 1 [ RunTime:0.006731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '39-00-0038' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.006287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15695 LIMIT 4 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15695 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15695 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15695 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15695 ORDER BY `minOrder` ASC [ RunTime:0.003499s ]
select * from pdf where partno='SF-1206FP250-2' and brandshort='BOURNS' limit 1 [ RunTime:0.003764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF-1206FP250-2' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.002387s ]
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.000483s ]