SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002010s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001399s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002108s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.21' ) [ RunTime:0.000735s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001977s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000291s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000271s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000222s ]
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.000372s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002164s ]
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.000365s ]
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 640,20 [ RunTime:0.009042s ]
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 ('15614','15613','15612','15611','15610','15609','15608','15607','15606','15605','15604','15603','15602','15601','15600','15599','15598','15597','15596','15595') ORDER BY FIELD(s.id, 15614,15613,15612,15611,15610,15609,15608,15607,15606,15605,15604,15603,15602,15601,15600,15599,15598,15597,15596,15595) [ RunTime:0.011325s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15614 LIMIT 4 [ RunTime:0.005241s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15614 ORDER BY `minOrder` ASC [ RunTime:0.019306s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15614 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15614 LIMIT 2 [ RunTime:0.001390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15614 ORDER BY `minOrder` ASC [ RunTime:0.007518s ]
select * from pdf where partno='LM336D-2-5' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.003486s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM336D-2-5' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.006401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15613 LIMIT 4 [ RunTime:0.007653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15613 ORDER BY `minOrder` ASC [ RunTime:0.004135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15613 ORDER BY `unit` DESC [ RunTime:0.002931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15613 LIMIT 2 [ RunTime:0.005378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15613 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
select * from pdf where partno='E4009-ORANGE' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.002544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'E4009-ORANGE' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.001947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15612 LIMIT 4 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15612 ORDER BY `minOrder` ASC [ RunTime:0.002140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15612 ORDER BY `unit` DESC [ RunTime:0.010178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15612 LIMIT 2 [ RunTime:0.007212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15612 ORDER BY `minOrder` ASC [ RunTime:0.013249s ]
select * from pdf where partno='08053C475KAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.014156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '08053C475KAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.022568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15611 LIMIT 4 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15611 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15611 ORDER BY `unit` DESC [ RunTime:0.002301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15611 LIMIT 2 [ RunTime:0.002655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15611 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
select * from pdf where partno='1812GC822KAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.009462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1812GC822KAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.008701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15610 LIMIT 4 [ RunTime:0.013662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15610 ORDER BY `minOrder` ASC [ RunTime:0.004081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15610 ORDER BY `unit` DESC [ RunTime:0.003356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15610 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15610 ORDER BY `minOrder` ASC [ RunTime:0.002116s ]
select * from pdf where partno='7-87499-2.' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.003093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7-87499-2.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.004147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15609 LIMIT 4 [ RunTime:0.019457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15609 ORDER BY `minOrder` ASC [ RunTime:0.020102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15609 ORDER BY `unit` DESC [ RunTime:0.011686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15609 LIMIT 2 [ RunTime:0.003902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15609 ORDER BY `minOrder` ASC [ RunTime:0.013263s ]
select * from pdf where partno='HIP4086ABZT' and brandshort='RENESAS' limit 1 [ RunTime:0.006683s ]
select foldpath,foldpath2,filename from pdf_file where id=1375712 limit 1 [ RunTime:0.007904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HIP4086ABZT' OR `brand` LIKE 'RENESAS%' ) ) LIMIT 1 [ RunTime:0.029681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15608 LIMIT 4 [ RunTime:0.002991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15608 ORDER BY `minOrder` ASC [ RunTime:0.006924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15608 ORDER BY `unit` DESC [ RunTime:0.005192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15608 LIMIT 2 [ RunTime:0.008902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15608 ORDER BY `minOrder` ASC [ RunTime:0.005781s ]
select * from pdf where partno='108-0902-001' and brandshort='JOHNSON - CINCH CONNECTIVITY' limit 1 [ RunTime:0.011330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108-0902-001' OR `brand` LIKE 'JOHNSON - CINCH CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.014199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15607 LIMIT 4 [ RunTime:0.008567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15607 ORDER BY `minOrder` ASC [ RunTime:0.004578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15607 ORDER BY `unit` DESC [ RunTime:0.012010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15607 LIMIT 2 [ RunTime:0.001340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15607 ORDER BY `minOrder` ASC [ RunTime:0.009590s ]
select * from pdf where partno='4245C' and brandshort='KEYSTONE' limit 1 [ RunTime:0.015269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4245C' OR `brand` LIKE 'KEYSTONE%' ) ) LIMIT 1 [ RunTime:0.010090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15606 LIMIT 4 [ RunTime:0.001945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15606 ORDER BY `minOrder` ASC [ RunTime:0.008683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15606 ORDER BY `unit` DESC [ RunTime:0.003976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15606 LIMIT 2 [ RunTime:0.004316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15606 ORDER BY `minOrder` ASC [ RunTime:0.000852s ]
select * from pdf where partno='B32922C3334M000' and brandshort='EPCOS' limit 1 [ RunTime:0.001677s ]
select foldpath,foldpath2,filename from pdf_file where id=860513 limit 1 [ RunTime:0.003755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B32922C3334M000' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15605 LIMIT 4 [ RunTime:0.011749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15605 ORDER BY `minOrder` ASC [ RunTime:0.002011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15605 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15605 LIMIT 2 [ RunTime:0.005140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15605 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='MF-NSMF020-2' and brandshort='BOURNS' limit 1 [ RunTime:0.008983s ]
select foldpath,foldpath2,filename from pdf_file where id=595703 limit 1 [ RunTime:0.007398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MF-NSMF020-2' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.017228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15604 LIMIT 4 [ RunTime:0.005114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15604 ORDER BY `minOrder` ASC [ RunTime:0.002852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15604 ORDER BY `unit` DESC [ RunTime:0.006230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15604 LIMIT 2 [ RunTime:0.009260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15604 ORDER BY `minOrder` ASC [ RunTime:0.003003s ]
select * from pdf where partno='MAX16550BGPN+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.004772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX16550BGPN+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.003395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15603 LIMIT 4 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15603 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15603 ORDER BY `unit` DESC [ RunTime:0.012816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15603 LIMIT 2 [ RunTime:0.004916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15603 ORDER BY `minOrder` ASC [ RunTime:0.005205s ]
select * from pdf where partno='MAX489ECPD+' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.002645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX489ECPD+' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.000917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15602 LIMIT 4 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15602 ORDER BY `minOrder` ASC [ RunTime:0.001989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15602 ORDER BY `unit` DESC [ RunTime:0.003000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15602 LIMIT 2 [ RunTime:0.005933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15602 ORDER BY `minOrder` ASC [ RunTime:0.003079s ]
select * from pdf where partno='MMA8451QR1' and brandshort='NXP' limit 1 [ RunTime:0.001959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMA8451QR1' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.004673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15601 LIMIT 4 [ RunTime:0.005761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15601 ORDER BY `minOrder` ASC [ RunTime:0.002460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15601 ORDER BY `unit` DESC [ RunTime:0.007619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15601 LIMIT 2 [ RunTime:0.008063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15601 ORDER BY `minOrder` ASC [ RunTime:0.005098s ]
select * from pdf where partno='D02154' and brandshort='DURATOOL' limit 1 [ RunTime:0.001469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D02154' OR `brand` LIKE 'DURATOOL%' ) ) LIMIT 1 [ RunTime:0.001531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15600 LIMIT 4 [ RunTime:0.007802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15600 ORDER BY `minOrder` ASC [ RunTime:0.000862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15600 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15600 LIMIT 2 [ RunTime:0.010505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15600 ORDER BY `minOrder` ASC [ RunTime:0.003137s ]
select * from pdf where partno='PCA9539APW,118' and brandshort='NXP' limit 1 [ RunTime:0.003134s ]
select foldpath,foldpath2,filename from pdf_file where id=1452223 limit 1 [ RunTime:0.002585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA9539APW,118' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.010068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15599 LIMIT 4 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15599 ORDER BY `minOrder` ASC [ RunTime:0.007491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15599 ORDER BY `unit` DESC [ RunTime:0.003161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15599 LIMIT 2 [ RunTime:0.002178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15599 ORDER BY `minOrder` ASC [ RunTime:0.002804s ]
select * from pdf where partno='PMEG100T050ELPE-QZ' and brandshort='NEXPERIA' limit 1 [ RunTime:0.011649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMEG100T050ELPE-QZ' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.012327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15598 LIMIT 4 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15598 ORDER BY `minOrder` ASC [ RunTime:0.008126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15598 ORDER BY `unit` DESC [ RunTime:0.000797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15598 LIMIT 2 [ RunTime:0.002097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15598 ORDER BY `minOrder` ASC [ RunTime:0.001240s ]
select * from pdf where partno='SQ2308CES-T1_GE3' and brandshort='VISHAY' limit 1 [ RunTime:0.004713s ]
select foldpath,foldpath2,filename from pdf_file where id=1922553 limit 1 [ RunTime:0.008950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SQ2308CES-T1_GE3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.015691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15597 LIMIT 4 [ RunTime:0.001130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15597 ORDER BY `minOrder` ASC [ RunTime:0.000823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15597 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15597 LIMIT 2 [ RunTime:0.017369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15597 ORDER BY `minOrder` ASC [ RunTime:0.003634s ]
select * from pdf where partno='MAX3222EEWN+T' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.001910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX3222EEWN+T' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.005178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15596 LIMIT 4 [ RunTime:0.004918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15596 ORDER BY `minOrder` ASC [ RunTime:0.001336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15596 ORDER BY `unit` DESC [ RunTime:0.001794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15596 LIMIT 2 [ RunTime:0.003551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15596 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='IAUT300N08S5N012ATMA2' and brandshort='INFINEON' limit 1 [ RunTime:0.002492s ]
select foldpath,foldpath2,filename from pdf_file where id=1522908 limit 1 [ RunTime:0.000432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IAUT300N08S5N012ATMA2' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.010885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15595 LIMIT 4 [ RunTime:0.002837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15595 ORDER BY `minOrder` ASC [ RunTime:0.006991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15595 ORDER BY `unit` DESC [ RunTime:0.006827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15595 LIMIT 2 [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15595 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='REC3-0505SRW/H4/A' and brandshort='RECOM POWER' limit 1 [ RunTime:0.008480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0505SRW/H4/A' OR `brand` LIKE 'RECOM POWER%' ) ) LIMIT 1 [ RunTime:0.004775s ]
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.000544s ]